>We copy data from one table to another using:
>insert into TBL1 select * from TBL 2;
>The current database hangs and the process never finish when copying >huge
>tables (around 25million rows). Looking at the processlist it states that
>the process stays in \"closing table\" or \"wait on cond
1) After I did the above is the server running or not? I believe I need to do a NET
START MySql
And if so, is there a way to make this a service that starts up when my box comes up?
You do need to do a NET START MYSQL, but since you are using NET commands mysql IS
installed as a service and sh
\"As I understand it, and I confess I am not totally sure I do, sql injection is more
of a problem in your page code than what database (/version) you run.\"
Absolutely. As I show at http://www.vbmysql.com/articles/sqlinjection.html SQL
Injection is a flaw in the front-end code, and you are at