rendered paste bodymysql> 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)