MySQL Cheat Sheet.graffle
connecting to a database #mysql[-hhostname][-uusername][-ppassword][dbname] importing data backup a database #mysqldbname<dbdump le.sql #mysqldump[-options]dbname[>dump le.sql] TINYINT[(digits)][unsigned|zero ll] 256 BIT,BOOL,BOOLEAN synonyms for tinyint(1) SMALLINT[(digits)][unsigned|zero ll] 65,536 MEDIUMINT[(digits)][unsigned|zero ll] 16,777,216 INT,INTEGER[(digits)][unsigned|zero ll] 4,294,96
Column Types [NATIONAL] CHAR(M) [BINARY] [NATIONAL] VARCHAR(M) [BINARY] BIGINT[(M)] [UNSIGNED] [ZEROFILL] BIT BLOB BOOL CHAR DATE DATETIME DECIMAL[(M[,D])] [ZEROFILL] DOUBLE PRECISION[(M,D)] [ZEROFILL] DOUBLE[(M,D)] [ZEROFILL] ENUM('value1','value2',...)
Column Types [NATIONAL] CHAR(M) [BINARY] [NATIONAL] VARCHAR(M) [BINARY] BIGINT[(M)] [UNSIGNED] [ZEROFILL] BIT BLOB BOOL CHAR DATE DATETIME DECIMAL[(M[,D])] [ZEROFILL] DOUBLE PRECISION[(M,D)] [ZEROFILL] DOUBLE[(M,D)] [ZEROFILL] ENUM('value1','value2',...) FLOAT(precision) [ZEROFILL] FLOAT[(M,D)] [ZEROFILL] INT[(M)] [UNSIGNED] [ZEROFILL] INTEGER[(M)] [UNSIGNED] [ZEROFILL] LONGBLOB LONGTEXT MEDIUMBL
MySQL Cheat Sheet
Selecting a database: mysql> USE database; Listing databases: mysql> SHOW DATABASES; Listing tables in a db: mysql> SHOW TABLES; Describing the format of a table: mysql> DESCRIBE table; Creating a database: mysql> CREATE DATABASE db_name; Creating a table: mysql> CREATE TABLE table_name (field1_name TYPE(SIZE), field2_name TYPE(SIZE)); Ex: mysql> CREATE TABLE pet (name VARCHAR(20), sex CHAR(1), bi
VisiBone
Good education: permission to work. Good memory: power to achieve. It's with big feelings that I shut this down. VisiBone products are no longer for sale. There are multiple reasons, and I do some 'splainin in a blog post . Short version: qiki is what's next. I made stuff to help you remember and use what you've learned about making web sites. Or if you were just a little adventurous, clues to wha
MySQL Cheat Sheet - Cheat Sheets - Added Bytes
The MySQL cheat sheet is designed to act as a reminder and reference sheet, listing useful information about MySQL. It includes a list of the available functions in MySQL, as well as data types. It also includes a list of MySQL functions available in PHP, and a list of useful sample queries to select data from a database. A description of what is on the cheat sheet follows, or if you are impatient
バックエンド系(Apache・PHP・MySQL)のチートシート
Apache、PHP、MySQL、CVS、Subversionなどのサイト制作のバックエンド系のチートシートのまとめです。 各チートシートのリンクは、下記の「チートシートのポータルサイト」より収集しました。 Apacheのチートシート PHPのチートシート MySQLのチートシート CVS・Subversionのチートシート チートシートのポータルサイト Apacheのチートシート Apache 1.3 Quick Reference Card mod_rewrite Cheat Sheet htaccess Cheatsheet PHPのチートシート PHP Cheat Sheet PHP Cheat Sheet PHP 4 Quick Reference Card PHP Cheat Sheet Smarty cheat sheet PHP 4 Reference Card(PDF)
1
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
処理を実行中です
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
