Teddy

I have the following table:

+--------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+----------------+
| WORK_UNIT_ID | int(11) | NO | PRI | NULL | auto_increment |
| UNIT_NAME | varchar(20) | YES | | NULL | |
| BUILDING | varchar(20) | YES | | NULL | |
| FLOOR | varchar(10) | YES | | NULL | |
+--------------+-------------+------+-----+---------+----------------+
原帖地�: TechSpott - Computer and technology forums http://www.techspott.com//showthread.php?p=8093

I used the following insert statement and receive the following error:

mysql> INSERT into work_unit_t (UNIT_NAME, BUILDING, FLOOR) VALUES (`Cardiology
', `Main', `3');
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 'Main'
, `3rd Floor')' at line 1

syntax seems correct to me. any ideas?