ql _ sqlite - dwisianto/dwisianto Wiki

ToDo

ToC

sqlitetutorial

.tables
.databases show databases
use myDataBase
create table myTable( name VARCHAR(5), age INT );
insert into myTable(name,age) values ('abc',123);

Create Table

Insert Row

Drop Table

Alter Table

CREATE TABLE company(
com_id text(4),
com_name text(15)
);



INSERT INTO artists (name)
VALUES
	("Buddy Rich"),
	("Candido"),
	("Charlie Byrd");
	

SELECT
	ArtistId,
	Name
FROM
	artists
ORDER BY
	ArtistId DESC;

Tutorial1

Tutorial2