MYSQL NOTES
To download MYSQL V5.7 CLICK HERE Dbms-database management system r-relational by e.f.codd data is different from information mysql is not case sensitive for keywords Commands : show databases; show tables; use <database name>; create database <database name>; drop table <table name>; drop database <database name>; create database if not exists database_name create table <table name> no semicolon press enter (<column name> <data type> default "default value <quotes as per data type>", <column name> <data type> not null primary key, <column name> <data type> check(col_name >100) ); # column name no spaces #create from existing table: Create table table2_name // a select query in table 1.eg Select * from table 1 where marks>90; describe <table name> ;describe or desc # desc-show the structure of database insert into <table name> #no semicolon press enter values(data1,data2,data3...);