MySQL CREATE TABLE Statement
eduguru 2 Comments .... ); The column parameters specify the names of the columns of the table. The datatype parameter specifies the type of data the column can hold (e.g. varchar, 'DATE', Address, Address varchar(255), and City columns are of type varchar and will hold characters, and City: Example CREATE TABLE Persons ( PersonID int, and the maximum length for these fields is 255 characters. The empty "Persons" table will now look like this: PersonID LastName FirstName Address City, City varchar(255) ); The PersonID column is of type int and will hold an integer. The LastName, column2 datatype, column3 datatype, etc.). MySQL CREATE TABLE Example The following example creates a table called "Persons" that contains five columns: PersonID, FirstName, FirstName varchar(255), integer, LastName, LastName varchar(255), MySQL CREATE TABLE Statement, MySQL CREATE TABLE Statement The MySQL CREATE TABLE Statement The CREATE TABLE statement is used to create a new table in a database. Syntax CREATE TABLE table_name ( column1 datatype
MySQL CREATE TABLE Statement The MySQL CREATE TABLE Statement The CREATE TABLE statement is used to create a new table in a
Read more