dbs

tit	ter	id
mysql --defaults-extra-file=my.cnf	my
ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_new_password';	my
sudo mysql_secure_installation; sudo mysql	my
update pla set boo=1, dat=?, tx=? where adr=?	update
catch(e){i.cl(e.message)}	er
datetime('now', 'localtime');	date
.mode csv	sqlite
null value:select rowid from linux where type is null;	sql
.mode list .import res/mer.sql mer	sqlite
.mode list - values delimited by "\|"	sqlite
SELECT date('now','start of year','+9 months','weekday 2');	date
123abc - invalid	sqlite
insert date loop	insert
date integer not null unique	date
date modifiers - orders matter	date
SELECT date('now','start of month','+1 month','-1 day');	date
where rowid between 7 and 45	between
select *,rowid from mer where sku not like (?)	sqlite
sync > async ? - better-sqlite3	lite
gcc test.c -l sqlite3	sqlite
SELECT datetime('now', 'localtime');	date
SELECT datetime('now','+9 hours');	date
.output res/pid.csv - export csv	csv
SELECT * FROM tbl ORDER BY id DESC LIMIT 1	sqlite
IN = multiple values in WHERE	sql
delete from pid where not rowid in (62,61);	sql
delete from pid where NOT rowid=62;	sql
const Sequelize = require('sequelize');	sequelize
select rowid from tbl order by rowid desc;	sqlite
insert obj -> use json	sqlite
db.run('INSERT INTO pid (name, age) VALUES (?, ?)', [values['name'], values['age']]));	sqlite
create table jol(num integer default 0 not null);	sqlite
install mongo	mongo
select by id	sqlite
create unique index title_index on node(title);	sql
expected 11 columns of data but found 9 - csv import error	csv
INNER JOIN tbl	join
SELECT distinct song__tv.title,song__tv.song	select
.dump tbl	sqlite
.separator , .mode csv .import csv/6.csv jas	csv
char(10) - 10 characters	mysql
mysqldump -u root -p pass songdb > bk/songdb.sql	mysqldump
proper pdo mysql	mysql
DROP COLUMN column_name	mysql
install mysql	mysql
mb db setup	mb
postgres -D /usr/local/pgsql/data	postgres
mbslave install	mb
insert into test values('a', 'b')	sqlite
sqlite3.verbose()	sqlite