Answers for "code to create a table in mysql"

SQL
7

create table mysql query

create table tutorials_tbl(
   tutorial_id INT NOT NULL AUTO_INCREMENT,
   tutorial_title VARCHAR(100) NOT NULL,
   tutorial_author VARCHAR(40) NOT NULL,
   submission_date DATE,
   PRIMARY KEY ( tutorial_id )
);
Posted by: Guest on August-18-2020
0

how to create a table in mysql

-- 'CREATE TABLE' followed by the name of the table. 
-- In round brackets, define the columns.
CREATE TABLE `test_table` 
(
  id INT(10) PRIMARY KEY,			
  username VARCHAR(50) NOT NULL
);
Posted by: Guest on February-18-2020
1

creating table in MySQL

#Assuming that there is a database called MyDatabase
#creates a table called TableName, with columns Name, Age, and Class
Use MyDatabase;
create table TableName(
  No. int primary key,
  Name varchar(50),
  Age int,
  Class varchar(15));
Posted by: Guest on April-20-2021

Code answers related to "code to create a table in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language