Mysql Create Table

Mysql Create Table is used to create a table in database.

Understand with Example

The section of Tutorial will help you to create a table in database. To grasp this example, we create a table 'Stu' with required fieldname and datatype respectively.

Create Table Stu

Create Table Stu(Id int,Name Varchar(15));

Insert values into Stu

The insert into is used to add  the records or rows to the table 'Stu'.

Insert Into Stu values(1,'Ajay');
Insert Into Stu values(2,'Bhanu');
Insert Into Stu values(4,'Rakesh');
Insert Into Stu values(5,'Santosh');
Insert Into Stu values(3,'Komal');

Table Stu

To view the detail or table records we use select Query that return you the records from table 'Stu'.

+------+---------+
| Id   | Name    |
+------+---------+
| 1    | Ajay    |
| 2    | Bhanu   |
| 4    | Rakesh  |
| 5    | Santosh |
| 3    | Komal   |
+------+---------+

Related Tags for Mysql Create Table:
c,  database,  table,  data,  asp,  ui,  io,  help,  type,  tutorial,  field,  name,  ria,  this,  create,  tab,  ie,  example,  with,  to,  datatype,  base,  exam,  require,  ld,  e,  il,  it,  section,  pe,  in,  as,  m,  es,  spec,  ase,  me,  tor,  xa,  xamp,  s,  respect,  sp,  esp,  at,  ras,  is,  ir,  ll,  iv,  mpl,  dn,  ea,  and,  tutor,  s,  s,  ri,  th,  st,  ab,  abl,  dna,  grasp,  ple,  pl,  nd,  on,  o

More Tutorials from this section

• MySQL Absolute Value
• MySQL Addition
• MySQL Add Column
• MySQL Affected Rows
• MySQL Area
• MySQL Arithmetic
• MySQL ASC
• MySQL Ascending Command
• MySQL Auto_Increment
• MySQL Boolean Value
• Mysql Switch CASE
• Mysql Check
• MySQL Converting Expression
• Mysql Decimal Datatype
• Mysql Describe
• Mysql Else Condition
• Mysql Exists
• Mysql For Loop
• Mysql From
• PHP SQL IF Statement

Ask Questions?    Discuss: Mysql Create Table  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):