Title: Error during inserting data in a table using the insert form
Last modified: August 31, 2016

---

# Error during inserting data in a table using the insert form

 *  [salma_saber](https://wordpress.org/support/users/salma_saber/)
 * (@salma_saber)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/error-during-inserting-data-in-a-table-using-the-insert-form/)
 * I tried to insert data into a table in the database using this form:
 * [abase2 form=”1,insert” table=”client’s information” columns=”Name!’width:75px;’,
   Surename!’width:75px;’,E-mail!’width:125px;’,Phone!’width:75px;’,Fiscal Code!’
   width:100px;’,Invoice Number!’width:100px;’, Total Invoice!’width:50px;’, Description!’
   width:175px;’,Date!’width:50px;’$Submit” elements=”Name,Surename,E-mail,Phone,
   Fiscal Code,Invoice Number, Total Invoice, Description,Date” ack=”red” center
   =”*”  style=”font-weight: bold; background: #f5f5f5; border-collapse: separate;
   box-shadow: inset 0 1px 0 #fff; font-size: 13px; line-height: 24px; margin: 30px
   auto;”]
 * but I got this error after submit the data:
 * Couldn’t perform query (1312): SELECT AUTO_INCREMENT FROM information_schema.
   TABLES WHERE TABLE_SCHEMA = ‘database_project1’ AND TABLE_NAME = ‘`client's information`‘–
   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 ‘s information`” at line
   1.
 * can anyone help me to solve this error?
 * Thanks in advance.
 * [https://wordpress.org/plugins/abase/](https://wordpress.org/plugins/abase/)

The topic ‘Error during inserting data in a table using the insert form’ is closed
to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/abase.svg)
 * [ABASE](https://wordpress.org/plugins/abase/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/abase/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/abase/)
 * [Active Topics](https://wordpress.org/support/plugin/abase/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/abase/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/abase/reviews/)

## Tags

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

 * 0 replies
 * 1 participant
 * Last reply from: [salma_saber](https://wordpress.org/support/users/salma_saber/)
 * Last activity: [10 years, 3 months ago](https://wordpress.org/support/topic/error-during-inserting-data-in-a-table-using-the-insert-form/)
 * Status: not resolved