Phpmyadmin error with syntax

Question

0.00/5 (No votes)

See more:

This has me perplexed and doesn't help that I'm having to use phpMyAdmin.

INSERT	INTO aqua_clients
			(parent_firstname)
VALUES	(SELECT meta_value FROM _YYV_frmt_form_entry_meta WHERE meta_key = 'name-4')

Error is:

#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 'SELECT `meta_value` FROM _YYV_frmt_form_entry_meta WHERE `meta_key` = 'name-4')' at line 3

What I have tried:

Googling and rewriting, but am not getting any progress. The main table has the values in one column (Meta_Value), and the field name sits in Meta_key.

I'm trying to create a After Insert that places the values in their corresponding columns as soon as they are submitted via a Wordpress form.

Posted 12-Jul-20 7:29am

Member 14887541

Updated 12-Jul-20 9:47am

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

MadMyche · Answer 1 · 2020-07-12T09:47:00

Solution 1

When you are using a SELECT to populate the values, you "skip" the VALUES syntax
MySQL :: MySQL 8.0 Reference Manual :: 13.2.6.1 INSERT ... SELECT Statement[^]

SQL

INSERT INTO aqua_clients (parent_firstname)
SELECT  meta_value
FROM    _YYV_frmt_form_entry_meta
WHERE   meta_key = 'name-4'

Posted 12-Jul-20 9:47am

MadMyche

Comments

Maciej Los 13-Jul-20 5:05am

5ed!

MadMyche 14-Jul-20 21:17pm

thank you

Phpmyadmin error with syntax

1 solution

Solution 1

Add your solution here

Preview 0

Phpmyadmin error with syntax

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us