Some basic SQL (structured query language) queries are regarding how to be more efficient and productive as you have to have a detailed knowledge of how to use the structure of the database for it to be useful. Queries generally involve basic formatting of the system and how to use it.
Control our any data base with the help of SQL, the professional name of SQL is SEQUEL ( Structure Query English Language)
Structure Query Language
Schema is structure you created for your tables in My SQL
Index is a data structure that improve the performance of data.
SQL means Structure Query Language, which appears in 1974. It is a static and strong type of database which allows specify several operations on it. SQL was developed by IBM.
"Delete DQL in basic computer language is used to delete rows from a table. One can choose to delete any number of rows, or all rows, while leaving the index and structure of the table intact."
SQL is short for Structured Query Language, and MySQL is a database management system, like SQL Server 2005, Oracle.An example would be other programming languages like BASIC and QBASIC where BASIC is the generic term for the BASIC programming language and QBASIC is Microsoft's version (quick BASIC) and TURBO BASIC was Borlands version.oracle supports the user defined datatypes,where as mysql not support all these types of datatypes, like user defined , and cursors like these stuff;;
using plsql sql
PL usually stands for a file extension for PERL. SQL is a database structure and querying LANGUAGE. Oracle is a software manufacturer that creates TOOLS for its own SQL database engines.
PL\SQL is an Oracle product (the PL stands for procedural language), while Sql Server most commonly refers to Microsoft SQL Server, although at one point Sybase also marketed its product as Sql Server. Microsoft and Sybase both have a procedural language feature, called T-SQL (Transact-SQL), which is similar in concept to PL\SQL, but there are significant differences in syntax and structure. An experienced developer could convert PL\SQL to T-SQL readily, but conversion would be required. It would not run without conversion.
you dont