All pastes #960761 Raw Edit

Someone

public text v1 · immutable
#960761 ·published 2008-03-28 13:18 UTC
rendered paste body
mysql> drop table `user`;
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE TABLE `user` (
    ->   `id` int(11) NOT NULL auto_increment,
    ->   `username` varchar(32) NOT NULL,
    ->    PRIMARY KEY  (`id`)
    ->
    -> );
Query OK, 0 rows affected (0.09 sec)

mysql>
mysql> DROP TABLE `group`;
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE TABLE `group` (
    ->   `id` int(11) NOT NULL auto_increment,
    ->   `groupname` varchar(32) NOT NULL,
    ->    PRIMARY KEY  (`id`)
    ->
    -> );
Query OK, 0 rows affected (0.07 sec)

mysql>
mysql> DROP TABLE user_group_link;
ERROR 1051 (42S02): Unknown table 'user_group_link'
mysql> CREATE TABLE user_group_link (
    ->     `id` int(11) NOT NULL auto_increment,
    ->     `user_id` int(11) NOT NULL,
    ->     `group_id` int(11) NOT NULL,
    ->      PRIMARY KEY  (`id`),
    ->     CONSTRAINT `user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
    ->     CONSTRAINT `group_id_fk` FOREIGN KEY (`group_id`) REFERENCES `group` (`id`)
    ->
    ->
    -> );
Query OK, 0 rows affected (0.08 sec)

mysql>   INSERT INTO user (usenrame) value ('pookey');
ERROR 1054 (42S22): Unknown column 'usenrame' in 'field list'
mysql>   INSERT INTO user (username) value ('pookey');
Query OK, 1 row affected (0.00 sec)

mysql>   INSERT INTO user_group_link (user_id, group_id) VALUES (1, 1);
Query OK, 1 row affected (0.00 sec)

mysql> select * from user_group_link;
+----+---------+----------+
| id | user_id | group_id |
+----+---------+----------+
|  1 |       1 |        1 |
+----+---------+----------+
1 row in set (0.00 sec)

mysql> select * from group;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group' at line 1
mysql> select * from `group`;
Empty set (0.00 sec)