Want to read Slashdot from your mobile device? Point it at m.slashdot.org and keep reading!

 


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

IBM Advanced Systems Group -- a bunch of mindless jerks, who'll be first against the wall when the revolution comes... -- with regrets to D. Adams

Close