Hi Dan,
Thanks for the clue!
Putting `Title` = 'var_a' (or combinations of \' or ` or \` or " ) was
putting var_a as the text in the table.
Resolution is:
begin
set @Populate = CONCAT('insert into ', tableName,' set OwnerID=0, Type=1,
State=0, Title=\'', var_a ,'\';');
PREPARE populate1 from @
Hi all,
Running MySQL 5.0.22 Community on Win 2003 Server.
Can anyone give me some guidance as to what is wrong with the following SP?
It continually errors with "1054 Unknown column 'Individual' in 'field
list'. "
The SP is completing the drop table and the create table, but it is when it
comes
