Title: CREATE TABLE statement failed
Last modified: March 22, 2021

---

# CREATE TABLE statement failed

 *  [dtuzhilin](https://wordpress.org/support/users/dtuzhilin/)
 * (@dtuzhilin)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/create-table-statement-failed/)
 * Hi Peter,
    table cretion fails with error message that dislpays SQL statement
   cutted around 210 symbol. Workaround to create smaller table with 1-2 columns
   and adding columns one by one is a little bit boring. Could you fix that please?
 * Regards, Dmitry.

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

 *  Thread Starter [dtuzhilin](https://wordpress.org/support/users/dtuzhilin/)
 * (@dtuzhilin)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/create-table-statement-failed/#post-14219809)
 * my fault – maxlength was empty. I would suggest to have a default values for 
   maxlenth to simplify table creation. For example 255 for varchar and 13,2 for
   decimal.
 * Regards, Dmitry
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/create-table-statement-failed/#post-14220226)
 * Hi Dmitry,
 * I know this issue, I was working on it tonight! 🙂 I’ll try to improve this for
   the next version…
 * Thank you for your input,
    Peter

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

The topic ‘CREATE TABLE statement 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/)

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