SQL : Creating tables in mysql

We can create table in mysql with create table command. A simple SQL for creating a table named pytable is shown below. First select the database in which the table has to be created. Here an already existing database pydatabase base is used.

mysql > use pydatabase;

After that use the following SQL

mysql> create table pytable (

pyid int not null,
pyname varchar(100) not null,
pycode char(2),
pydate date,
pynum float(8,2),

primary key (pyid) 
);

So once the table is created we will get the message

Query OK, 0 rows affected (0.08 sec)

To view the structure of the table created use the describe command.

mysql> describe pytable;
+--------+--------------+------+-----+---------+-------+
| Field  | Type         | Null | Key | Default | Extra |
+--------+--------------+------+-----+---------+-------+
| pyid   | int(11)      | NO   | PRI | NULL    |       |
| pyname | varchar(100) | NO   |     | NULL    |       |
| pycode | char(2)      | YES  |     | NULL    |       |
| pydate | date         | YES  |     | NULL    |       |
| pynum  | float(8,2)   | YES  |     | NULL    |       |
+--------+--------------+------+-----+---------+-------+
5 rows in set (0.01 sec)