全文検索:
- MySQLコマンド @02_freebsd:04_database:01_mysql
- INSERT ON *.* TO user; データベースレベル GRANT ALL ON db_name.* TO user; GRANT SELECT, INSERT ON mydb.* TO user... '; </code> ==== ユーザ名&ホストの変更 ==== <code> mysql> RENAME USER 'FROM_USER'@'192.168.0.%' TO 'TO_USER'@'192.... BLE hoge_tbl ( id int PRIMARY KEY AUTO_INCREMENT, name text ); </code> ==== テーブルのコピー ==== <code console... code> ==== テーブル名変更 ==== <code> ALTER TABLE tbl_name RENAME [TO] new_tbl_name; </code> ==== テーブル情報を表示(
- SQLiteコマンド @02_freebsd:04_database:03_sqlite
- elect * from sqlite_master; type = table name = buy tbl_name = buy rootpage = 4 sql = CREATE TABLE buy( id INTEGER PRIMARY KEY, code int, name text, price float, time int,