C:\Documents and Settings\駒ヶ嶺三四郎>cd F:\mysql\bin

D\:mysql\bin>mysql -u user -p
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11 to server version: 4.0.18-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database yoyaku;
Quary OK, 1 row affected(0.00 sec)

mysql> use yoyaku
Database changed
mysql> create table yoyakuData(
    -> ID char(12) primary key,
    -> kaigiName varchar(50),
    -> project varchar(50),
    -> user varchar(20) not null,
    -> email varchar(50)
    -> );
Quary OK, 0 rows affected(0.06 sec)

mysql>

mysql> insert into yoyakuData(ID, kaigiName, project, user, email)
    -> values(200403011011, '部課長会議', '総務部', '曽根', 'sone@kaisya.co.jp');
Quary OK, 1 row affected(0.00 sec)

mysql> insert into yoyakuData(ID, kaigiName, project, user, email)
    -> values(200403011020, 'Z30連絡会議', '開発1課', '福岡', 'fukuoka@kaisya.co.jp');
Quary OK, 1 row affected(0.00 sec)

mysql> insert into yoyakuData(ID, kaigiName, project, user, email)
    -> values(200403011022, 'セミナー報告会議', '開発2課', '大野', 'oono@kaisya.co.jp');
Quary OK, 1 row affected(0.00 sec)

mysql> insert into yoyakuData(ID, kaigiName, project, user, email)
    -> values(200403011030, 'Z30連絡会議', '開発1課', '石井', 'ishii@kaisya.co.jp');
Quary OK, 1 row affected(0.00 sec)

mysql>mysql>select * from yoyakuData;
+-------------+-----------------+--------+-----+---------------------+
| ID          | kaigiName       | project| user| email               |
+-------------+-----------------+--------+-----+---------------------+
| 200403011011| 部課長会議      | 総務部 | 曽根| sone@kaisya.co.jp   |
| 200403011020| Z30連絡会議     | 開発1課| 福岡| fukuoka@kaisya.co.jp|
| 200403011022| セミナー報告会議| 開発2課| 大野| oono@kaisya.co.jp   |
| 200403011030| Z30連絡会議     | 開発1課| 石井| ishii@kaisya.co.jp  |
+-------------+-----------------+--------+-----+---------------------+
4 rows in set(0.00 sec)

mysql>