Let us insert data into the table: – insert into student_sports_data values(1,'Sai','Y','Y','N','Y','Y','N','Y') Swimming enum('Y','N')/*- ENUM Datatypecolumn-*/ ![]() Table creation: – create table Student_Sports_data Let us consider a simple example of the same: – If we check the list of all users, the columns specified in the user table are mostly defined as an ENUM data type. ![]() Let us see where the ENUM is usually defined in MySQL. It has readable queries, which makes it a readable query and output.), which represent the string values because of which it has compact data storage. MySQL ENUM uses numeric indexes (1, 2, 3.Here the values for the “column_name1” and “column_name2” are one among the list specified. Let us see the syntax of how we create the column of ENUM datatype: – create tableĬolumn_name1 ENUM(value1, value2.),/ * - ENUM Data type column - * /Ĭolumn_name2 ENUM(value1, value2.),/ * - ENUM Data type column - * / ![]() In this session, we will learn about the ENUM data type with syntax along with the syntax: –
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |