SQL standard

SQL standard could be a language for accessing and manipulating databases.

What is SQL?

SQL stands for Structured query language
SQL enables you to access and manipulate databases
SQL is associate ANSI (American National Standards Institute) standard

What will SQL do?

SQL will execute queries against a database
SQL will retrieve knowledge from a database
SQL will insert records in an exceedingly database
SQL will update records in an exceedingly database
SQL will delete records from a database
SQL will produce new databases
SQL will produce new tables in an exceedingly database
SQL will produce hold on procedures in an exceedingly database
SQL will produce views in an exceedingly database
SQL will set permissions on tables, procedures, and views

SQL could be a standard – however….

Although SQL is associate ANSI (American National Standards Institute) standard, there are totally different versions of the SQL language.

However, to be compliant with the ANSI standard, all of them support a minimum of the foremost commands (such as select, UPDATE, DELETE, INSERT, WHERE) in an exceedingly similar manner.

Using SQL in Your web site

To build an internet web site that shows data from a database, you may need:

associate RDBMS information program (i.e. MS Access, SQL Server, MySQL)
To use a server-side scripting language, like PHP or ASP
To use SQL to get the data you would like
To use HTML / CSS

 

 

Latest posts by admin (see all)

More in sem3
XML Database

XML Database An XML database may be a information persistence package that enables information to be such as, and typically...

Close