Question

Explain how can we create mysql tables for storage of data

Answer 1

Just Type These Query's In The Sql cli
1. Show Databases
1.1 If There Is Already A Database That You Wanna Use Then Follow Step 1.2
1.2 Use DatabaseName
1.3 show tables
1.4 If a table already exist and you wanna insert a entry into it Type :- "insert into tablename values(Values here)
1.5 Keep In Mind That The Values should Be In Order Of The Columns Else You Will Get A Error


2. If You Wanna Create A new Database Then Type :- Create database DatabaseName
3 If You Wanna Create a table then Type :-
create table tablename( Columns With Datatype)