Need SQL Statements Help?

Question

Ok here is my problem. Im in the process of learning SQL and iv been going over SQL statements, but how do I use the statements? How do i put them in a HTML page or any type of page? How can i get them to work?
And if you need a better idea of what kind of statements im talking about just go here http://www.w3schools.com/SQl/sql_update.asp

Answer 1

You need an application to run SQL like MySQL or Oracle. If you're just starting out then I would suggest trying some SQL queries in Microsoft Access first.

Answer 2

What SQL database do you have? SQL is just the query language. You need a database that understands the SQL language to be able to use it, for example, MySQL, Oracle Database, Microsoft SQL Server, etc. SQL is the language that lets you talk to your database to add data, change or delete data, etc.



After installing and setting up your SQL database, you can then use SQL to first create your database and then work with the data.



There are 3 general ways to enter SQL statements:

1. Command line. You can either enter from your computer's command/terminal window, or a custom command window installed by the database. This is the most direct and easiest way to talk to the database, ie, entering SQL statements.



2. Through some GUI interface. For those that find the command line daunting, there are GUI applications (with windows, menus, buttons, etc.) that let you enter SQL commands and do other functions with the database. For example, the MySQL GUI tools has the MySQL Query Browser.



3. Code SQL statements into your program. You do not put SQL statements right on the HTML web page, because that would be a big security flaw. You don't want people to be able to access your database and steal or destroy your data. So to access your database, you put the SQL statements into your backend application server and when a website visitor clicks on a link to bring up data from your database, that link will call you program which connects to your database and retrieces the data and writes the html page and sends that to the visitor to use. Simple server side scripting for web sites typically use PHP. Big enterprise company applications use Java.

Answer 3

Typically, a database will reside on a server somewhere. A web page wanting information from the database (which may or may not be on the same server) will format and send a server request (usually via a scripting language such as PHP in the form of an SQL statement.) The server executes the SQL (via the DBMS) to create a resultset and passes it back to the web page. The web page then has to process the resultset for display back to the user (again via the scripting language.)

Answer 4

what's the style of the reqOpen column? Is it char, varchar or boolean. no count number if that's char, then the assertion is okay, no count number if that's boolean, "definite" is a million (or -a million in some databases, e.g. get entry to) and "No" is often 0. hence: pick reqOpen From supRequest the place reqOpen <> 0

Answer 5

download wamp server

an learn how to use them in php

it's free