Title: CREATE TABLE Failed
Last modified: January 23, 2020

---

# CREATE TABLE Failed

 *  Resolved [mitrawings](https://wordpress.org/support/users/mitrawings/)
 * (@mitrawings)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/create-table-failed/)
 * Hye, Peter!
 * I do not know why but I am unable to create new tables. Every time I am trying
   to create a new table the plugin shows that CREATE TABLE Failed.
 * At the bottom of the page, I am getting this above-mentioned message
 * **“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 ‘NOT NULL,`dealername`
   varchar NOT NULL,`dealeremail` tinytext NOT NULL,`dealermo’ at line 1″**
 * I do not understand what I am doing wrong. Uninstalled and reinstalled the plugin
   the same result.
    BTW I am using a managed WordPress!

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/create-table-failed/#post-12358691)
 * Hi Mitra,
 * Can you click on button “Show CREATE TABLE script”, then button “copy to clipboard”
   and finally paste the create table statement into a message? Let’s check the 
   SQL first…
 * Thanks,
    Peter
 *  Thread Starter [mitrawings](https://wordpress.org/support/users/mitrawings/)
 * (@mitrawings)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/create-table-failed/#post-12358757)
 * CREATE TABLE `dealerdetails`
    (`dealerid` tinyint NOT NULL ,`gstno` tinytext 
   NOT NULL ,`orgname` varchar NOT NULL ,`dealername` varchar NOT NULL ,`dealeremail`
   tinytext NOT NULL ,`dealermobile` tinyint NOT NULL ,`dealeraddress` text NOT 
   NULL ,`dealerpincode` tinyint NOT NULL ,`note` tinytext NULL ,PRIMARY KEY (`dealerid`));
 * CREATE UNIQUE INDEX `dealerid` ON `dealerdetails` (`dealerid`);
 * Thanks for your reply. Here it goes
 *  Thread Starter [mitrawings](https://wordpress.org/support/users/mitrawings/)
 * (@mitrawings)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/create-table-failed/#post-12359054)
 * I found a way out of the issue.
    I had to add one column at a time and then save
   the table design then drop the table and finally create the table again….
 * Exhausting
    However thanks for your time
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/create-table-failed/#post-12359543)
 * Good you found a solution Mitra! 👍 Let me know I can help.
 * Best regards,
    Peter

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘CREATE TABLE Failed’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

## Tags

 * [new table](https://wordpress.org/support/topic-tag/new-table/)

 * 4 replies
 * 2 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [6 years, 3 months ago](https://wordpress.org/support/topic/create-table-failed/#post-12359543)
 * Status: resolved