My SQL Syntax

show databases;  //to show all databases in mysql

use [database name];   //to use database/get in to database

show tables; //show all tables inside database;

create table [table name] (collumn);  //to make a table in mysql

ex : create table biodata(no int,nama varchar(40), umur int);

desc [table name]; //to show collumn of table and its variable type

insert into [table name] value (value);

ex : insert into biodata value('1','izoel','22');

alter table [table name] add column [column name and type];

alter table [table name] drop column [column name];

alter table [table name] add column [column name and type] first;