Creating a table in PHPMyAdmin is simple: just type the same name, select the number of fields and click the button. Users will be then taken to a setup screen to create or define the fields for the database. If using a PHP script to create a database, the whole process of creation and setup will be done in one command.
SYNTAX:
CREATE TABLE tablename (fieldname1 type (length),
fieldname 2 type NOT NULL AUTO_INCREMENT,
PRIMARY KEY (fieldname 2), UNIQUE (fieldname2));
Do you like this post?
