MySQL Start Basics : Database, Table Creation and Values Insertion

Database Basics

Here you will learn that how to create database with SQL queries and how to control it. You need to learn here about

1. Database
2. Tables
3. Fields
4. Rows

How to create Database with SQL Query?
> Open  PHPMyAdmin > SQL

 CREATE DATABASE QWC  

Write Query and click GO. Now QWC database has been created.

 Query OK, 1 row affected (0.01 sec)  

Now  You need to use this database. Use this SQL query.

 USE QWC;  

Write Query and click GO. Now you are using QWC database.

Database changed

 Now you need to create tables. For tables, you need to write query as

 CREATE TABLE inform(  
 name varchar( 30 ) ,  
 age int( 2 ) ,  
 phone int( 15 ) ,  
 address varchar( 50 )  
 )  

It is like

Create Table [Table Name]( [Field Name] [Field Type] ([Field Limit]) , [-> Next Field] );

Write Query and click GO.

Query OK, 0 rows affected (0.01 sec)

Now You need to insert value. 1st you need to check that your table is selected. For value, you need to use this query as.

 INSERT INTO `inform`(`name`, `age`, `phone`, `address`)   
 VALUES ('QWC',22,03234209211,'Pakistan')  

It is like

Insert into table (colum1, colum2, colum3) values (value1, valu2, value3, value4);

But here you need to remind that you need to write CHR, Text type values within single or double quotes.