|
Main /
MySQLCommandsMain.MySQLCommands HistoryHide minor edits - Show changes to markup May 12, 2006, at 12:40 AM
by
- Changed lines 23-25 from:
(Use NULL for NULL)
to:
(Use NULL for NULL)
INSERT INTO users VALUES ('name', 'passwprd', 'blank', '1') May 07, 2006, at 01:49 AM
by
- Changed lines 19-23 from:
Ex: mysql> CREATE TABLE pet (name VARCHAR(20), sex CHAR(1), birth DATE);
to:
Ex: mysql> CREATE TABLE pet (name VARCHAR(20), sex CHAR(1), birth DATE);
Inserting one row at a time: mysql> INSERT INTO table_name VALUES ('MyName', 'MyOwner', '2002-08-31');
(Use NULL for NULL)
May 07, 2006, at 01:43 AM
by
- Changed lines 1-24 from:
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)); to:
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), birth DATE); May 07, 2006, at 01:41 AM
by
- Added lines 1-24:
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)); |