Wednesday, May 25, 2011

Useful SQL Query

- Create Database
CREATE DATABASE database_name;

- Create Table
CREATE TABLE table_name(
column_name1 type(length) option,
column_name2 type(length) option,
.
.
);

- Insert data into table
INSERT INTO table_name (column_name1, column_name2, ...) VALUES ('value1', 'value2',...);

- Get Data
SELECT columns FROM table_name;
We can add other columns or * instead of using a column to get more data.


No comments:

Post a Comment