How to create tables in SQL?

Question

The class doesn't go into this topic, it teaches you the operations between tables but it doesn't teach you how to create one from the beginning and how to load the data

Answer 1

hey buddy , before creating table ... u either need to open an existing databse or create a new database & after that u can create tables inside it
create database sololearn;
use sololearn;
create table sql(plyrid varchar(10),playnam varchar (20));
//I made lesson for that , hope will be approved

Answer 2

for that u need to use Insert command
for example ::: //i am adding 2 records
//take reference from mine above comment

Insert into sql values ("a01","Gaurav");
Insert into sql values ("a02",Nico");

//to see records available

select * from sql;

//to see structure of table sql

DESC sql;
//or
DESCRIBE sql;

//hope it helps ☺👍

Answer 3

Okay, but how do you create the different columns and the data entry?

Answer 4

Thanks, it helped me a lot, but I wish there would be a topic in the SQL class so I could learn it all together