Asked By
Mickhel
70 points
N/A
Posted on - 10/07/2011
Internet users and web builders and any other person some times see that type of SQL, MySQL, TSQL. Actually I do not know what is it but I think that it is some kind of a server after all I have needed to know about it. Can anybody explain what is SQL, MySQL , and TSQL ? and its uses.
Puja
Answered By
jamespop
0 points
N/A
#87388
About SQL, MySQL and TSQL
SQL: SQL stands for 'Structured Query Language'. It is a standard language designed to manage data in relational database management system on the web. SQL is an ANSI (American National Standards Institute) standard that lets you access and manipulate databases. Also it can delete records from a database and create new databases.
MySQL: It is the most popular open source relational database management system (RDBMS). MySQL is very fast, more reliable and flexible in relational database management system on the web.
T-SQL: T-SQL means 'Transaction-SQL' and it is a Microsoft's and Sybase's proprietary extension to SQL.
Hope this helps you.
Thanks.
About SQL, MySQL and TSQL
SQL stands for Structured Query Language. It is a standardized programming language intended for managing relational databases and doing different operations on the data. It was originally created back in the 70s and is regularly used by database administrators including developers writing data integration scripts as well as data analysts searching to set up and run analytical queries.
When SQL emerged in the late 70s and early 80s, it became the de facto standard programming language for relational databases. MySQL, on the other hand, is an open source relational database management system or RDBMS that is based on SQL and runs virtually on all platforms such as Microsoft Windows, UNIX, and Linux.
Though MySQL can be used in a wide range of applications, it is frequently used on web-based applications and online publishing. It is also a vital component of LAMP, an open source enterprise stack. LAMP is a web development platform that uses Linux as the operating system, MySQL as the relational database management system, Apache as the web server, and PHP as the scripting language.
TSQL or T-SQL stands for Transact-SQL. It is a set of programming extensions from Microsoft and Sybase that add several features to SQL like transaction control, row processing, declared variables, and exception and error handling. T-SQL statements are supported by Microsoft SQL Server and Sybase SQL server.
