Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Users\xxx>MySQL -uroot -padmin Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.5.35 MySQL Community Server (GPL) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create database webDesignSchool; Query OK, 1 row affected (0.01 sec) mysql> use webDesignSchool; Database changed mysql> set names cp932; Query OK, 0 rows affected (0.00 sec) mysql> source C:\WEBserver\xxxxx\WebdesignSchool01.sql Query OK, 0 rows affected, 1 warning (0.00 sec) Note (Code 1051): Unknown table 'memberpersonalmaster' Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected, 1 warning (0.00 sec) Note (Code 1051): Unknown table 'contentsdata' Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected, 1 warning (0.00 sec) Note (Code 1051): Unknown table 'membermaster' Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected, 1 warning (0.00 sec) Note (Code 1051): Unknown table 'groupeventmaster' Query OK, 0 rows affected (0.01 sec) mysql> show tables; +---------------------------+ | Tables_in_webdesignschool | +---------------------------+ | contentsdata | | groupeventmaster | | membermaster | | memberpersonalmaster | +---------------------------+ 4 rows in set (0.00 sec) mysql> describe contentsdata; +-------------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------------+------+-----+---------+----------------+ | contents_id | int(10) | NO | PRI | NULL | auto_increment | | secret_key | varchar(32) | NO | | NULL | | | contents_type | varchar(15) | NO | | NULL | | | member_email | varchar(255) | NO | | NULL | | | thumbnail_imgpath | varchar(255) | YES | | NULL | | | normal_imgpath | varchar(255) | YES | | NULL | | | download_imgpath | varchar(255) | YES | | NULL | | | contents_memo | varchar(255) | YES | | NULL | | | contents_size | int(8) | YES | | NULL | | | download_count | int(10) | YES | | NULL | | | delete_flag | char(1) | NO | | 0 | | | entry_id | varchar(255) | YES | | NULL | | | entry_date | datetime | YES | | NULL | | | update_id | varchar(255) | YES | | NULL | | | update_date | datetime | YES | | NULL | | +-------------------+--------------+------+-----+---------+----------------+ 15 rows in set (0.03 sec) mysql> exit Bye C:\Users\xxx>