PHP Developer Channel :: 討論園地

mysql> create table hotel (hotelNo varchar(5) primary key, name varchar(5) not n
ull, address varchar(5) not null);
Query OK, 0 rows affected (0.20 sec)

mysql> desc hotel;
+---------+------------+------+-----+---------+-------+
| Field   | Type       | Null | Key | Default | Extra |
+---------+------------+------+-----+---------+-------+
| hotelNo | varchar(5) | NO   | PRI |         |       |
| name    | varchar(5) | NO   |     |         |       |
| address | varchar(5) | NO   |     |         |       |
+---------+------------+------+-----+---------+-------+
3 rows in set (0.05 sec)

mysql> create table room (hotelNo varchar(5) primary key, roomNo varchar(5) not
null, type varchar(5) not null, price varchar(5) not null);
Query OK, 0 rows affected (0.06 sec)

mysql> desc room;
+---------+------------+------+-----+---------+-------+
| Field   | Type       | Null | Key | Default | Extra |
+---------+------------+------+-----+---------+-------+
| hotelNo | varchar(5) | NO   | PRI |         |       |
| roomNo  | varchar(5) | NO   |     |         |       |
| type    | varchar(5) | NO   |     |         |       |
| price   | varchar(5) | NO   |     |         |       |
+---------+------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> set foreign_key_checks=0;
Query OK, 0 rows affected (0.00 sec)

mysql> create table booking(hotelNo varchar(5) primary key, guestNo varchar(5) not null,
dateFrom varchar(5) not null, dateTo varchar(5) not null, roomNo varchar(5), index (roomNo),
foreign key(roomNo) references room(roomNo));
ERROR 1005 (HY000): Can't create table '.\kyrt\booking.frm' (errno: 150)