SQL QUERY to MYSQL

[neha prajapati]

Hi

I'm using this query in sqlserver and need same query in mysql .. i'm new in mysql .. please help me out to solve this query..

DECLARE @sql AS nvarchar(max)
set @sql=''
set @sql='Select * From('
SELECT @sql = @sql + N'
SELECT Lead_id,DOB,EP,NMI,POT,ID,IDno,IDexpiry,Pension_Card,Pension_Expiry,Pension_Form,Solar_Form FROM ['+ SCHEMA_NAME(schema_id) +'].[' + name + ']
UNION ALL '
FROM information_schema.`TABLES` T where table_name like 'Custom%'
SELECT @sql = SUBSTRING(@sql, 0, len(@sql)-9)
print @sql