MySQLの動作例(mysql)

foo:~/SQL$ mysql test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 36 to server version: 3.21.33b-log

Type 'help' for help.

mysql> create table aaa ( id char(4) , name char(20) );
Query OK, 0 rows affected (0.01 sec)

mysql> insert into aaa values("0001","test user");
Query OK, 1 row affected (0.00 sec)

mysql> insert into aaa values("0002","mysql user");
Query OK, 1 row affected (0.01 sec)

mysql> insert into aaa values("0003","foo bar");
Query OK, 1 row affected (0.00 sec)

mysql> select * from aaa;
+------+------------+
| id   | name       |
+------+------------+
| 0001 | test user  |
| 0002 | mysql user |
| 0003 | foo bar    |
+------+------------+
3 rows in set (0.00 sec)

mysql> select * from aaa where name like "%user";
+------+------------+
| id   | name       |
+------+------------+
| 0001 | test user  |
| 0002 | mysql user |
+------+------------+
2 rows in set (0.03 sec)

mysql> show columns from aaa;
+-------+----------+------+-----+---------+-------+
| Field | Type     | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| id    | char(4)  | YES  |     | NULL    |       |
| name  | char(20) | YES  |     | NULL    |       |
+-------+----------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> quit
Bye
foo:~/SQL$