SQL validation

[Reason7194]

Hey everyone, would anyone like to share a good resource for learning about sql validation? Validation is my next project that is why I am asking.

[thetan]

Validation can mean any number of things. You're going to have to be more concise with what you're looking for.

As for as validating an actual SQL statement, if it runs, it's valid in terms of syntactical validity. If you want to see some insight into what that query is doing under the hood (seeing if it's using the indexes you set up for it, or doing full table scans etc) then you would pass the SQL statement through the EXPLAIN command.

Determining the validity of the outcome of a SQL statement, you could run it against a test data set in a typical unit testing scenario.

However, like i said, your question is vague, please clarify.

[Reason7194]

Ah sorry, what I meant was checking if a variable was true with the database. I'm not sure if I explained it any better, but in any case I figured out what I was originally asking.

Thanks

[thetan]

Code: Select all

SELECT * FROM some_table AS t1 WHERE t1.someCol = 'someVal'


The very nature of this question makes me question the approach you're taking in learning SQL.

[Reason7194]

Well, the way I am learning is just by finding what I need on the website I use for my projects. If I don't know how to do something, I usually go to w3schools, phpacademy channel, google, or the local library until I can figure out the problem I am having.