Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

create table query in mysql

//Create database table mysql
// Note for id always set it to auto-increment (AI)
 CREATE TABLE `database_name`.`new_table_name` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `first_name` VARCHAR(45) NOT NULL,
  `last_name` VARCHAR(45) NOT NULL,
  `title` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`id`, `first_name`, `last_name`, `title`));
Source by gist.github.com #
 
PREVIOUS NEXT
Tagged: #create #table #query #mysql
ADD COMMENT
Topic
Name
4+1 =