MySQL

Programming Resource Home :: Database-Tutorials :: MySQL

Advertisement

Advertisement




MySQL
Tutorial Table Maintenance Statements
In this section we are covering the topics like ANALYZE TABLE, BACKUP TABLE, CHECK TABLE, CHECKSUM TABLE, OPTIMIZE TABLE, REPAIR TABLE, RESTORE TABLE Syntax. View Rating



MySQL
Tutorial MySQL Transactional and Locking Statements
MySQL5.0 supports local transactions by statements like START TRANSACTION, SET AUTOCOMMIT, COMMIT and ROLLBACK. Transaction means a group of SQL Statements, which executes as a unit. View Rating



MySQL
Tutorial TRIGGERS
A Trigger is a named database object which defines some action that the database should take when some databases related event occurs. Triggers are executed when you issues a data manipulation command like INSERT, DELETE, UPDATE on a table for which the t View Rating



MySQL
Tutorial CURSORS
Cursors are used when the SQL Select statement is expected to return more than one row. Cursors are supported inside procedures and functions. Cursors must be declared and its definition contains the query. The cursor must be defined in the DECLARE sectio View Rating



MySQL
Tutorial Flow Control Constructs
Flow Control Constructs include the IF, CASE, LOOP, WHILE, ITERATE, REPEAT and LEAVE constructs. They are fully implemented. View Rating



MySQL
Tutorial Writing Subqueries
A subquery can be defined as a query within a query. In other words, any query results that we reuse in another query. Subquery is known as nestee queries or subselects also. Subqueries don?t include any new functionality but the queries are more readable View Rating



MySQL
Tutorial Stored Procedures and Functions
Stored Routines (Procedures and Functions) are supported in version MySQL 5.0. Stored Procedure is a set of statements, which allow ease and flexibility for a programmer because stored procedure is easy to execute than reissuing the number of individual S View Rating



MySQL
Tutorial Views
VIEW is a virtual table, which acts like a table but actually it contains no data. That is based on the result set of a SELECT statement. A VIEW consists rows and columns from one or more than one tables. View Rating



MySQL
Tutorial Joins
Sometimes you required the data from more than one table. When you select the data from more than one table this is known as Joining. A join is a SQL query that is used to select the data from more than one table or views. View Rating



MySQL
Tutorial Data Manipulation Statements
Data Manipulation Statement is used to retrieve, insert, update and delete the records in a database. All database users will use these commands during routine operation of the database. View Rating
Page:  [<<]   1   2   3   4   5   6   7   8   9   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   31   32     [>>]

Send your comments, Suggestions or Queries regarding this site at [email protected].

Copyright © 2004. All rights reserved.