SCADE
> ON DELETE RESTRICT
> ) ENGINE=InnoDB;
i think error is because of referencing the same column in test1 table (ID,ID) .
try to change the column name then run the code hope ur problem will solve out
.
Abhishek choudhary,
www.tech4urhelp.blogspot.com
- Original Mes
Hi ,
count() function is a group function so use group by clause in your select
statement if you are selecting more than one column data..
here is some sample query related to help you,
select count(*) from trndisburse:
output:1467
select count(*),pkdisburseid from trndisburse_TMP m Group