| tit | ter | id |
| "insert into img(nam,cat,img) values('$q','sld','$str$q.webp');" | lite | | |
| select sum(d) from p4 where rowid between 67 and 112; | sum | | |
| dont use * in bash;q2="select tit,cat,kur from det where cat='$q'" | lite | | |
| lite | | |
| where rowid between 1 and 9; | bet | | |
| .mode csv; .import res/usr.csv usr | csv | | |
| select usr from swp where prg='joe2' and usr!='キャラ' | sqlite | | |
| sep=$(sqlite3 db/swp.db "select st from swp) | sqlite | | |
| let g:csv_no_conceal = 1 | vim | | |
| select tit is null; | null | | |
| CREATE TABLE song__mv AS SELECT * FROM song__tv WHERE 0; | sqlite | | |
| echo 'SELECT * FROM $1' | mysql -B -uname -ppass songdb > csv/$1.csv | mysql | | |
| $ mysqladmin -u root password newpass | mysql | | |
| WARNING: The host '' could not be looked up with resolveip. | mysql | | |
| remove specific types | sqlite | | |
| ALTER TABLE db.tbl ADD COLUMN col1; | sqlite | | |
| update scr1 | sqlite | | |
| delete scr using EOF | sqlite | | |
| change column values | sqlite | | |
| ORDER BY column1 | sqlite | | |
| mysql backup ex1 | mysql | | |
| where is my.cnf? - /etc/mysql/my-medium.cnf | mysql | | |
| mysqldump -t -T --fields-terminated-by=',' | mysql | | |
| select node title where vid from node table | sqlite | | |
| table taxonomy_vocabulary > sqlite3 .schema | sqlite | | |
| cant import primary key | mysql | | |
| mv file with date prefix -> mv raks01.db $(date | youtube | | |
| starting another activity | mysql | | |
| import csv | sqlite | | |
| dump csv - sqlite | sqlite | | |
| create table sql | mysql | | |
| create database ex1 | sqlite | | |
| delete data from users table | sqlite | | |
| reset password | mysql | | |
| install mysql for slacko | mysql | | |