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