cookiejar
asked on
Insert statment too many values error when inserting comma delimited string.
When I try running the following insert statements, I encounter too many values error
Is it because of the comma delimited string?
If so, what syntax do I use to make this one string?
insert into g_values
(g_value_id,
name,
data_type,
value,
description,
min_value,
max_value,
allow_local,
allow_user,
synchronize)
values
('A1',
'DATA_FLAG',
'STRING',
'MAC','PC','EDSON','LOGITE CH',
'List of itmess.',
'1',
'255',
'N',
'N',
'N'
)
Is it because of the comma delimited string?
If so, what syntax do I use to make this one string?
insert into g_values
(g_value_id,
name,
data_type,
value,
description,
min_value,
max_value,
allow_local,
allow_user,
synchronize)
values
('A1',
'DATA_FLAG',
'STRING',
'MAC','PC','EDSON','LOGITE
'List of itmess.',
'1',
'255',
'N',
'N',
'N'
)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
try this
insert into g_values
(g_value_id,
name,
data_type,
value,
description,
min_value,
max_value,
allow_local,
allow_user,
synchronize)
values
('A1',
'DATA_FLAG',
'STRING',
'MAC,PC,EDSON,LOGITECH',
'List of itmess.',
'1',
'255',
'N',
'N',
'N'
)
I should also point out that those are all individual single quotes. No double quotes used.
Open in new window