hpastetwo

SQL STATEMENTS

author
PF
age
344 days
language
sql
1
2
3
4
5
6
sqlite> CREATE TABLE friends(name CHAR(50) , age INTEGER , job CHAR(100) , title CHAR(100) , id INTEGER PRIMARY KEY);
sqlite> INSERT INTO friends values('St0rM' , 100 , 'Programmer' , 'Senior pyshco' , 0);
sqlite> INSERT INTO friends values('Striker' , 100 , 'Programmer' , 'Saint' , 1);
sqlite> select * from friends;
St0rM|100|Programmer|Senior pyshco|0
Striker|100|Programmer|Saint|1