SELECT Statement

[malleyo]

I'm kind of new to writing SQL queries and all. I was wondering, can any changes be made to anything in a database using a SELECT statement?

[M Owen]

No.:D SELECT is not an action query ... INSERT, APPEND, UPDATE are ...

That is not quite true ... You can make tables using SELECT statements ... What do you mean by changes?

[malleyo]

I've been given permissions to do SELECT queries on the database at work, and since I don't know a whole lot about SQL queries yet, I just want to make sure that I can't harm any data in the DB by playing around with SELECT. My company has extremely important data, and while we do have several backup DB's, I don't want to take any chances... :D

[BlueGazoo]

:)

You're very safe, im sure. For one, if the data is that important, be content in knowing that they have their data backed up nicely.

Second, Select Statements alone don't change anything - you're just "selecting" various data. BUT, you can still erase the data you've selected!

Be nice to that data and the data will be nice to you :D