api
bun
db
exp
git
lib
node
pay
 
pup
srv
test

db 52 titles

db.serialize( ()=>db.each(q,(e,r)=>i.cl(r) ) )
sqlite3
1099
INSERT INTO dat (d1) VALUES(datetime('now', 'localtime'));
sqlite
1083
SET col1 = v1, col2 = v2
sqlite
1081
DELETE FROM myTable WHERE myColumn IS NULL OR trim(myColumn) = '';
sqlite
1079
sqlite3 db/$db.db "$stm"
sqlite
1039
db.insPrj + ses.er
sqlite
1034
sqlite3 example.db 'SELECT * FROM some_table;'
scr
1020
0 (false) and 1 (true).
sqlite
881
.mode csv
sqlite
866
null value:select rowid from linux where type is null;
sql
852
.mode list .import res/mer.sql mer
sqlite
685
.mode list - values delimited by "|"
sqlite
684
SELECT date('now','start of year','+9 months','weekday 2');
date
669
123abc - invalid
sqlite
654
insert date loop
insert
653
date integer not null unique
date
652
date modifiers - orders matter
date
650
SELECT date('now','start of month','+1 month','-1 day');
date
649
where rowid between 7 and 45
range
538
select *,rowid from mer where sku not like (?)
sqlite
526
sync > async ? - better-sqlite3
lite
497
gcc test.c -l sqlite3
sqlite
470
SELECT datetime('now', 'localtime');
date
453
SELECT datetime('now','+9 hours');
date
452
.output res/pid.csv - export csv
csv
451
SELECT * FROM tbl ORDER BY id DESC LIMIT 1
sqlite
414
IN = multiple values in WHERE
sql
385
delete from pid where not rowid in (62,61);
sql
384
delete from pid where NOT rowid=62;
sql
383
const Sequelize = require('sequelize');
sequelize
378
select rowid from tbl order by rowid desc;
sqlite
364
insert obj -> use json
sqlite
361
db.run('INSERT INTO pid (name, age) VALUES (?, ?)', [values['name'], values['age']]));
sqlite
355
create table jol(num integer default 0 not null);
sqlite
350
install mongo
mongo
340
select by id
sqlite
271
create unique index title_index on node(title);
sql
260
expected 11 columns of data but found 9 - csv import error
csv
224
INNER JOIN tbl
join
196
SELECT distinct song__tv.title,song__tv.song
select
195
.dump tbl
sqlite
194
.separator , .mode csv .import csv/6.csv jas
csv
193
char(10) - 10 characters
mysql
172
mysqldump -u root -p pass songdb > bk/songdb.sql
mysqldump
171
proper pdo mysql
mysql
169
DROP COLUMN column_name
mysql
168
install mysql
mysql
167
mb db setup
mb
165
postgres -D /usr/local/pgsql/data
postgres
164
mbslave install
mb
163
insert into test values('a', 'b')
sqlite
159
sqlite3.verbose()
sqlite
21