What is the SQL query for creating a table?

[Clint]

Hi friends, I am Clint. Still I am busy with my project work. I wish to develop back end of my project using SQL. But, I have some confusions. I have posted my doubt in the webpage of research paper services reviews.

[suhanarai]

Create table tab name(col name type,
col 2 type());

[adlerdale]

Creating a basic table involves naming the table and defining its columns and each column's data type.
Syntax:
CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, ..... columnN datatype, PRIMARY KEY( one or more columns ));

[fortemusiceducation]

CREATE TABLE MyGuests (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
reg_date TIMESTAMP
)