INSTRUCTION |
EXPLANATION |
sqlite3 asist.db |
Conect database asist.db |
.tables |
show tables |
create table (one int, two varchar(250)); |
create table |
.quit |
exit |
drop table [nameTable]; |
drop table |
select * from [nameTable] where [nameColumn] in (1,2) |
Select rows with [nameColumn] equal 1 or 2. Same as mysql. |
delete from [nameTable] where [nameColumn] in (1,2) |
Delete rows with [nameColumn] equal 1 or 2. Same as mysql. Truncate don’t exists |
.read fichero.sql |
Execute an sql file. Make sure all sequences are correct for sqlite. |