Explain how can we create mysql tables for storage of data
Answers
Answered by
0
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)
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)
Similar questions