Estoy intentando crear una nueva tabla con el script:
select * from [wpdatatable id = 22] pero me lanza el siguiente error : Consulta procesada: SELECT * FROM [wpdatatable id LIMIT 10 MySQL dijo: Tiene un error en su SQL sintaxis; consulte el manual que corresponde a la versión de su servidor MySQL para conocer la sintaxis correcta para usar cerca de '[wpdatatable id LIMIT 10' en la línea 1
Ya he actualizado SQL y la tabla con la que voy a trabajar ya tiene valores.
Estoy intentando crear una nueva tabla con el script:
select * from [wpdatatable id = 22]
pero me lanza el siguiente error
: Consulta procesada: SELECT * FROM [wpdatatable id LIMIT 10
MySQL dijo: Tiene un error en su SQL sintaxis; consulte el manual que corresponde a la versión de su servidor MySQL para conocer la sintaxis correcta para usar cerca de '[wpdatatable id LIMIT 10' en la línea 1
Ya he actualizado SQL y la tabla con la que voy a trabajar ya tiene valores.
HI ISCReneJEsus,
Thank you for your purchase.
May I kindly suggest to speak in English so we can understand each other better.
As I can see from your post below you are trying to add our shortcode of the table in the query which is not possible.
You will need to see for the table ID 22 which table refers in the database( for example wp_wpdatatable_22 )
so the query should look like
SELECT * FROM wp_wpdatatable_22
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Exactly, I get the error:
Rendered query: SELECT * FROM wpdatatable id LIMIT 10
MySQL said: Table 'chainsi_cilbd.wpdatatable' does not exist
Hi ISCReneJEsus,
Let me try to explain you better and give you some example.
Let's say you have table 1 ( id of that table is for example 3) and that table is editable.
Now you want to make a new table but use that id 3 table.
Go to table ID 3 and in editing tab see which MySQL table name for editing is used for that table (attachment)
From there use that name in your query.
In this example the table name for editing is wp_wpdatatable_1
so the query for the new table should be
SELECT * FROM wp_wpdatatable_1
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables