We will be a console to forfeit SQL querys. To do this, right click on the link> Execute command. Copy and paste the following SQL commands in the console, and click on the icon "Run SQL" (Ctrl + Shift + E).
Code:
create table name(id_name numeric (8) primary key, name varchar (50));
Code:
create table PROVINCE (
id_province numeric (8) primary key,
id_name numeric (8)
name varchar (50)
);
Code:
insert into countries values (1, 'India');
insert into STATE values (1, 1, 'Maharashtra');
insert into STATE values (2, 1, 'Assam');
INSERT INTO states VALUES (3, 1, 'Kerela');
insert into STATE values (4, 1, 'Orissa');
insert into STATE values (5, 1, 'Punjab');
insert into STATE values (6, 1, 'Jammu & Kashmir');
insert into STATE values (7, 1, 'Madhya Pradesh');
insert into STATE values (8, 1, 'Gujarat');
Open a SQL console (right click on the link> Execute command ...), and run the following queries (separately):
SELECT * FROM PROVINCE
select * from COUNTRY
Should return the data we just inserted.
Bookmarks