# SQL syntax error

**URL:** <https://forum.kirupa.com/t/sql-syntax-error/124745>\
**Category:** Uncategorized\
**Created:** [October 6, 2004, 1:10pm UTC](https://forum.kirupa.com/t/sql-syntax-error/124745 "2004-10-06T13:10:14Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![SilentMind](https://avatars.discourse-cdn.com/v4/letter/s/a183cd/32.png) [@SilentMind](https://forum.kirupa.com/u/SilentMind)\
**Post date:** [October 6, 2004, 1:10pm UTC](https://forum.kirupa.com/t/sql-syntax-error/124745/1 "2004-10-06T13:10:14Z")

</div>

Hi, again. 😊  
Im doing this mysql driven shoutbox, everything has gone right, untill now.  
I did the database, and now i have to do the table, it looks like this:

> CREATE TABLE ‘shoutbox’(  
> 'id’INT( 12 ) NOT NULL AUTO\_INCREMENT ,  
> 'username’VARCHAR( 25 ) NOT NULL ,  
> 'email’VARCHAR( 25 ) NOT NULL ,  
> 'message’TEXT NOT NULL ,  
> 'date’VARCHAR( 15 ) NOT NULL ,  
> 'ip’VARCHAR( 25 ) NOT NULL ,  
> PRIMARY KEY ( ‘id’ )

And I get this error:

> [font=Courier New]#1064 - 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 '‘shoutbox’( 'id’INT( 12 ) NOT NULL AUTO\_INCREMENT ,  
> 'user[/font]

So I went to the manual, to see the error #1064, and it says this:

> Error: 1064 SQLSTATE: 42000 (ER\_PARSE\_ERROR) Message: %s near ‘%s’ at line %d

Would be very appriciated if someone could help me, solve this error! 🙂