· 6 years ago · Jun 29, 2019, 08:48 AM
1create table if not exists cities (id integer primary key, name varchar(255) not null);
2select * from cities;
3
4CREATE TABLE IF NOT EXISTS cities (id INTEGER PRIMARY KEY, name VARCHAR(255) NOT NULL);
5SELECT * FROM cities;
6
7CREATE TABLE IF NOT EXISTS cities
8 (
9 id INTEGER PRIMARY KEY,
10 name VARCHAR(255) NOT NULL
11 );
12SELECT *
13FROM cities;