Helloo Sajhaitiss..
Really need help in creating a table and columns from the SQLquery skript in a spreadsheet for the source db.
please guide me ..
bhakkar bhakar chireko IT ko duniyama.
Thanks..
... online khojana payi halcha. CREATE statements
Try the following website..Its give easy guide and good examples:
http://www.w3schools.com/sql/
just search in youtube. One could be
https://www.youtube.com/watch?v=s6bCU_y-N0Y&list=PLsyeobzWxl7r4_oAwBFzPdMlgc0If72WK
I am also learning IT so this is only suggestion.
CREATE table employee
(firstName varchar(15),
lastName varchar(20),
age number(3),
address varchar(30),
city varchar(20),
state varchar(20));
It will create a table named "employee" where there are different variables: firstName, lastName, age, address, city and state.(these are column as your question)
hope this help
insert into employee
(firstName, lastName, age, address, city, state)
values
('Birkhe', 'dai', 65, '111 khoi k marg', 'pidit tol', 'NY');
This is how you insert data in the column that you create above.
यो sodhne मित्र ,
IT को जागिर नै सुरु गरेको हो कि भर्खर sikdai हो ? नत्र यो ता एकदम बेसिक कुरो हो नि /
Please log in to reply to this post
You can also log in using your Facebook