To create a database called android.db is used the statement:
sqlite3 android.db
To create a table is used the command: create table
restaurant (id int, name varchar (30), Address varchar (30), primary key (id));
To insert data in the table is created using the command: insert into restaurant
To see the data in the table is created use the command: select * from
To increased visibility of the extracted values \u200b\u200byou must do: on headers.
on column mode select * from restaurant
To change the data of a line is used the following command:
restaurant update Sept. address = "live via the mouse 22" where id = 1;
delete from the restaurant where id = 1;
To delete a row from the table using the statement:
0 comments:
Post a Comment