+ 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.
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
+ 2
thanks
+ 2
let 's see example
Create Database class;
Use class;
Create Table student_record(roll_no int(4), first_name varchar(20));
+ 1
tq