Re: SQL QUERY to MYSQL

[neha prajapati]

During exction of this query;
set @sql = '';
SELECT @sql = @sql + 'SELECT name FROM ['+ TABLE_NAME +'] UNION ALL '
FROM information_schema.`TABLES` T where table_name like 'Custom%';
select @sql

I got this error..
Truncated incorrect DOUBLE value: 'SELECT name FROM ['
Truncated incorrect DOUBLE value: '] UNION ALL '
Truncated incorrect DOUBLE value: 'custom_70010'
Truncated incorrect DOUBLE value: 'SELECT name FROM ['
Truncated incorrect DOUBLE value: '] UNION ALL '
Truncated incorrect DOUBLE value: 'custom_70011'

Truncated incorrect DOUBLE value: 'SELECT name FROM ['
Truncated incorrect DOUBLE value: '] UNION ALL '
Truncated incorrect DOUBLE value: 'custom_70012'

Truncated incorrect DOUBLE value: 'SELECT name FROM ['
Truncated incorrect DOUBLE value: '] UNION ALL '
Truncated incorrect DOUBLE value: 'custom_70033'