# Mysql table

**URL:** <https://forum.kirupa.com/t/mysql-table/66502>\
**Category:** Uncategorized\
**Created:** [October 6, 2004, 1:17pm UTC](https://forum.kirupa.com/t/mysql-table/66502 "2004-10-06T13:17:34Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![tim\_j](https://avatars.discourse-cdn.com/v4/letter/t/f17d59/32.png) [@tim\_j](https://forum.kirupa.com/u/tim_j)\
**Post date:** [October 6, 2004, 1:17pm UTC](https://forum.kirupa.com/t/mysql-table/66502/1 "2004-10-06T13:17:34Z")

</div>

```php
      CREATE TABLE sites(id INT( 10 ) NOT NULL AUTO_INCREMENT ,
   username VARCHAR( 16 ) ,
    PASSWORD VARCHAR( 16 ) ,
   name VARCHAR( 50 ) ,
   email VARCHAR( 50 ) ,
   sitename VARCHAR,
   sitedescription VARCHAR( 50 ) ,
   date VARCHAR( 50 ) ,
    PRIMARY KEY ( id ) 
  ); 
   
  
    

```

```
      MySQL said: 

```

#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 ’  
sitedescription VARCHAR( 50 ) ,  
date VARCHAR( 50 ) ,  
PRIMAR  
Any idea what’s wrong help would be appreciated