JACKCHEN99
1/16/2018 - 7:29 AM

ahk_mysql

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 `