Follow Slashdot stories on Twitter

 


Forgot your password?
Close
typodupeerror

Comment Re:Bring a database down? (Score 2, Informative) 156

by killjoe (#24461765) Attached to: Diagramming Tool For SQL Select Statements

Depends on your database. I know I have been able to bring SQL server down with a query.

Try this...

begin transaction

update rows set a=b where x=y

commit transaction.

On your workstation this could run really fast because you only have ten records. On the production database server this could crush the server if you had a few million records effected.

Slashdot Top Deals

You must realize that the computer has it in for you. The irrefutable proof of this is that the computer always does what you tell it to do.

Close