+ 5

How to make own sql table

We are learning here of reading editing deleting but if I install SQL where would I do that without having made databases I mean what are the commands for creating how are they made.

4th Nov 2016, 4:23 PM
Sandeep Chatterjee
4 Answers
+ 2
create database database_name; use database_name; create table table_name (name int(20),...); now u have made a database and use it and the after that use database_name statement all tables that u create will be under that database
4th Nov 2016, 5:42 PM
Paul P Joby
Paul P Joby - avatar
+ 2
thanks
4th Nov 2016, 6:57 PM
Sandeep Chatterjee
+ 2
let 's see example Create Database class; Use class; Create Table student_record(roll_no int(4), first_name varchar(20));
5th Nov 2016, 8:21 AM
Thaneshwor Joshi
Thaneshwor Joshi - avatar
+ 1
tq
5th Nov 2016, 3:06 PM
Kondalu Yadav
Kondalu Yadav - avatar