i recently loaded data in a table in mysql 150,000 rows added using script with load data infile
after that currently i can not do select * from table-name; it hangs. i can do select count(*) from table-name;
if some one want to take a look let me know.
it is only happening on 1 table everything else is fine.
let me know i have $10.00 for this.
13 freelancers are bidding on average $32 for this job
Hi, you trying to fetch all data at a time, that's why getting hanged. We should use limit to get data in parts. Use SELECT TOP 1000 * FROM table_name ORDER BY id