What is SQL?

[Brenton S.]

Hi all,

I have been wondering, where do you put SQL query code? Do you put it inside along with HTML code? I have searched all over the internet for tutorials and have gotten books from the library but I am still lost. If anyone could please help, I would appreciate it. Thanks in advanced.

[davide++]

Hi all.

SQL is a programming language used to manage databases: with SQL you can create objects and manipulate data, using basic commands such as INSERT, UPDATE, DELETE and SELECT.
The last feature is included in some languages or environments; for example, PRO*c is a version of C where one can uses SQL commands with C instructions to access to Oracle database.
I don't know if HTML has this "ability", but I think no, because HTML ins't a real programming language: instead, it's a document format.

[cjard]

Hi all,

I have been wondering, where do you put SQL query code? Do you put it inside along with HTML code? I have searched all over the internet for tutorials and have gotten books from the library but I am still lost. If anyone could please help, I would appreciate it. Thanks in advanced.

You would use an active technology like ASP, JSP, servlets etc.

HTML as noted is jsut a docuemnt format

You would write a program that runs on a webserver. It takes input froma web browser, and may connect to a database. It may run a query (SQL) and read the results in a tabular form. It formats the results into HTML and sends them back to the user browser.

See an ASP/JSP tutorial for more info