Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
MC170402209
CREATE DATABASE MC170402209 CREATE TABLE Customer ( custID int primary key not null, custName varchar(255) not null, custAddress text not null, Email text not null, ); CREATE TABLE Catagory ( catID int primary key not null, custName varchar(255) not null, InitailRate int not null, ); CREATE TABLE S_ervices ( serID int primary key not null, serTitle varchar(255) not null, serDescription varchar(255) not null, serCharges int not null, ); CREATE TABLE Food_Item ( ItemID int primary key not null, ItemName varchar (255) not null, ItemDescription varchar(255) not null, ); CREATE TABLE Menu ( MenuID int primary key not null, no_of_servings int not null, quantity int not null, no_of_items int not null, ); CREATE TABLE Venue ( venueID int primary key not null, V_location varchar (255) not null, city varchar (255) not null, capacity int not null, V_description varchar (255) not null ); CREATE TABLE E_vent ( eID int primary key not null, eDATE date not null, TimeSlot time not null, ); insert into Venue ( venueID, V_location, city, capacity, V_description) values ( '002', 'multan', 'multan', '120', 'not available currently') select * from Venue;
run
|
edit
|
history
|
help
0
QLDT DB
Xml Shredding
Recursive cte (common table expression)
STACK
1512081 QUAN LY DE TAI
Finding Row Wise Max Value From Table
Manish SQL
SQL HW 1 Appline
customers
variables and table variables inside a cursor loop