CITAL SQL Script 1 2 3 4 5 6 7 create table customers ( id INTEGER , name text , age INTEGER ) ; insert into customers values ( 1 , "sital" , 2 ) ; SELECT * FROM customers ; Save Documentation SQL development If you're new to SQL, you can learn more from this course: SQL . Creating tables CREATE TABLE customers (id INTEGER PRIMARY KEY, name TEXT, age INTEGER, weight REAL); Many data types CREATE TABLE customers (id INTEGER PRIMARY KEY, age INTEGER); Using primary keys See also: specifying defaults , using foreign keys . For more details, see the following: SQLite reference for CREATE . Inserting data INSERT INTO customers VALUES (73, "Brian", 33); Inserting dat...
Comments
Post a Comment