this is autohotkey script about mysql
;MYSQL===============================
; 语法补齐
:*:mysql/::mysql -u root -p {enter}
:*:sng::set names gbk;{enter}
::cd m::cd C:\Software\phpStudy\MySQL\bin
:*:s*::SELECT * FROM `;{left 1}
:*:desc::DESCRIBE `;{left 1}
; 显示/创建:数据库/表
:*:sd/::SHOW DATABASES; {enter}
:*:st/::SHOW TABLES; {enter}
:*:cd/::CREATE DATABASE IF NOT EXISTS `;{left 1}
:*:ct/::CREATE TABLE IF NOT EXISTS `;{left 1}
;创建保存日志
:C*:\T::\T C:\Software\phpStudy\MySQL\mysql1.txt
;大小写转换----------
; 关键字
::use::USE; {left 2}
::into::INTO
::from::FROM
::where::WHERE
::text::TEXT
::show::SHOW
::alter::ALTER
::table::TABLE
::rename::RENAME
::database::DATABASE
::warnings::WARNINGS
::unsigned::UNSIGNED
::drop::DROP; {left 2}
; 数据类型
:*:tinyint::TINYINT `
:*:int::INT `
::char::CHAR
:*:varchar::VARCHAR(){left 1}
; 增、删、改、查
:*:insert::INSERT INTO `
:*:delete::DELETE `
:*:update::UPDATE `
:*:select::SELECT `