Mysql Example

1. Mysql Switch CASE
   Mysql Switch Case perform one of several different actions based on several different conditions.
           
2. Mysql Check
   Mysql Check is used to check the existence of table in the database.
              
3. Mysql Decimal Datatype
   Mysql Decimal Datatype is used to specify the numeric values.
              
4. Mysql Describe
   Mysql Describe is used to describe the table Field,Type,Null etc attribute.
             
5. Mysql Else Condition
   Mysql Else Condition evaluate the statements in database to perform different actions based on different conditions.
             
6. Mysql Exists
   The Tutorial covers on 'Mysql Exists'. The section helps you to understand an example from 'Mysql Exists'.
            
7. Mysql For Loop
   Mysql For Loop are used to execute the block of code to a specified number of times till the specified condition is true.
             
8. FROM
   Mysql From specify the table from which records is retrieved.
                          
9. PHP SQL IF Statement
   This example illustrates how to use the 'if' statement in PHP when accessing the data from table in mysql database.
              
10. Mysql Insert
    Mysql Insert is used to insert the records or rows to the table.
               
11. PHP SQL Query Insert
    This example illustrates how to execute insert query in PHP application.
              
12. PHP SQL LIKE Operator
    This example illustrates how to use the like operator in sql query.
               
13. PHP SQL Login
    This Application illustrates how to create a login page where only authorized user can login and process further.
                
14. MySQL Coalesce
    In this section, you will learn about MySQL Coalesce. It selects the first non-null value of its arguments.
              
15. MySQL Connection String
    This section gives you brief description of MySQL connection string.
               
16. MySQL Cursor
    Here we are going to describe about the MySQL cursor and how to declare, open, fetch and close it. Cursor can be created inside the stored procedures, functions and triggers.
              
17. Mysql Alter Allow Null
    Mysql Alter Allow Null is used to change the Null Type of a column in a table. The Allow Null allows the null type characteristics in a column of the table.
              
18. Mysql Difference
    Mysql Difference is used to return the records that are the outcome of difference between the records in a table.
               
19. Mysql Group By
    Mysql Group By statement is conjecture term used with the aggregate functions to group the result-set by specified one or more columns.
               
20. Mysql Last
    Mysql Last is used TO limit Mysql query result that fall in a specified range. The Query is used to show the first X number of results and show a range from X-Y results.
                 
21. Mysql last record
    Mysql Last Record is used to return the last records from table 'employee1'. 
               
22. Mysql last row
    Mysql Last Row is used to return the last records from table.
               
23. Mysql left
    Mysql Left is used to return the Left String character from a String.
                 
24. Mysql Left Function
    Mysql Left Function is used to return the leftmost string character from the string.
            
25. Mysql String Length
    Mysql Length is used to return the length of the String.
            
26. Mysql Length Function
    The Tutorial already illustrate you an example to find the length of the String. Now this section of tutorial helps you to find the Length Function in Mysql.
            
27. Mysql Like Operator
    Mysql Like is used to retrieve the records on the basis of pattern matching in select query. The like comparison Operator in SQL allows you to match any single character or any arbitrary character enclosed in a single quotes.
              
28. Mysql Like Command
    Mysql Like Command is used for retrieving the records from a table on the basis of pattern matching.
               
29. Mysql Like Operator
    Mysql Like Operator is used to compare a part of string using the % wild card character.
               
30. Mysql like syntax
    Mysql Like is used to retrieve the records on the basis of pattern matching in select query.
              
31. Mysql Limit
    Mysql Limit is used to limit your query result to those which fall within a specified range.
             
32. Mysql List
    Mysql List elaborate you an Query for listing databases, tables, Procedure, columns, usernames and its password.
                
33. Mysql List Tables
    The Tutorial illustrate an example from 'Mysql  List Tables'. To understand this example we use show tables query that return the list of tables in database name 'Table_in_girish'.
              
34. Mysql Loader Control File
    Mysql Loader Control File is the mean to import a data to a plain text from Mysql database.
              
35. Mysql Loader Examples
    Mysql Loader Example is used to create the backup of data  file and then import the data text file into Mysql database. 
                 
36. Mysql Loader Tutorial
    Mysql Loaded Tutorial is used to import a data to a plain text from Mysql database.
               
37. Mysql Loop in Procedure
    Loop in Procedure is a simple loop construct that enables an repeated execution of the statement list, which consists of one or more statements.
               
38. Mysql Looping
    Looping in Mysql is a simple loop construct, that enables the repeated execution of the statement list.
             
39. Mysql Lower Case
    Mysql Lower Case is used to convert the Upper Case letter to the Lower Case.
               
40. Mysql Lpad
    Mysql Lpad is used to add the padding to the left end of the string. The Mysql Padding function will be stooped if the combination of string and the added padding reach length character.
               
41. Mysql Lpad Function
    Mysql Lpad Function is used to add padding to the left end of the string. The Function stopped the combination of string and added padding if it reached the length character.
              
42. Mysql Ltrim
    Mysql Ltrim is used to remove the left leading and trailing spaces in the string.
               
43. Mysql Math Function
    Math Function involved in Mysql when we perform some operation on mathematical operator.
             
44. Mysql Merge
    Mysql Merge Statement is used to merge the two sql statement using UNION clause. The UNION clause is used to combine the result set of any two sql queries.
              
45. Mysql Merge Statement
    Mysql Merge Statement is used to merge the two sql statement using UNION clause.The UNION clause is used to combine the result set of any two sql queries.
             
46. Mysql MidString
    Mysql MidString is used to return the string, with sub string beginning at position pos and len.
               
47. Mysql Minimum Query
    Mysql Minimum Query is useful when you want to return the minimum value record from table.
               
48. Mysql Minus
    Mysql Minus is used to see only those records from table which are not in another table.
               
49. Mysql Mod Function
    Mysql Mod Function is used to return the remainder of N divided by M.
               
50. Mysql Multiple Date Insert
    Mysql Multiple Column Insert is used to add or insert multiple data to the table.
             
51. Mysql Multiplication Columns
    Mysql Multiplication Columns is used to provide the column that is the outcome product of all the records in the respective columns of a table.
                
52. Mysql Multiply
    Mysql Multiply is used to define the product of any two or more numbers in a table.
             
53. MySQL random
    In MySQL we can get the random records by using the method RAND() of MySQL. There are two versions of RAND() function : first RAND() and second is RAND(X).
             
54. MySQL random number
    You may fall in the condition when you want to create random number for your program to process some logic, here is the solution for such condition.
             
55. MySQL random order
    In MySQL we can get the rows records in a random order by using the method RAND() of MySQL. In the following example, we will describe how you can use RAND() function to fetch records from the database.
              
56. MySQL range
    May times the programmer needs to find out some specific data which lies in the particular range of values but there is not any predefined function in MySQL.
              
57. MySQL rank
    Many times there is a need to rank the records according to some specific field values but there is not any specific method provided in the MySQL to rank the records.
              
58. MySQL Round
    ROUND() function of MySQL rounds the number to the upwards or downwards to the nearest whole number or to the specified decimal places. For getting the whole rounded number ROUND() function uses "round half up".
               
59. Mysql where
    Mysql Where returns only those records from table which are specified in the WHERE Clause.
                 
60. Mysql As
    Mysql As is used to specify the another name for the existing column and table name.The Alias Name is helpful for database that makes it easy to write and read.
             
61. MySQL by
    In the following example you will see the how to use the MySQL by. Here, we will use GROUP BY clause. It displays the data in the group of employee salary. 
            
62. MySQL Case
    If you want to implement a complex conditional construction then you can use MySQL case statement. It performs the work as programming type. 
            
63. MySQL Cast
    Here, you will learn about the MySQL CAST() function. 
              
64. MySQL Commands
    In this section, we are going to read about the mysql commands. Each statement is sent to the server for the execution by MySQL. MySQL provides lots of commands.
             
65. MySQL Case In Where Clause
    If you want to implement a complex conditional construction then you can use MySQL case statement. It performs the work as programming type.
            
66. MySQL Case Sensitive
    Here we are going to read about the MySQL case sensitivity. The case sensitive is a term that tells you to check lettercase either upper case or lower case.
              
67. MySQL Convert
    This section describes about the MySQL convert. It provides a way for converting the data of one type to another type.
             
68. MySQL Count
    This example illustrates how to use count() in MySQL database.
           
69. Mysql Create Table
    Mysql Create Table is used to create a table in database.
           
70. Mysql Current TimeStamp
    Mysql Current Timse Stamp is used to show the current time and current date in your database.
              
71. Mysql Declare Procedure
    Mysql Declare Procedure is used to define a local variable within a procedure. The local variable are used within the procedure.
            
72. Mysql From Table
    Mysql From Table is used to specify the table from which the records is retrieved.
               
73. MySQL Order By
    Here, you will learn how to use MySQL Order By clause. The Order By clause is used for sorting the data either ascending or descending order according to user requirement.
             
74. PHP SQL Number of Rows
    To understand how to count the number of rows in a table, we have created a sql_num_rows.PHP file.
           
75. PHP SQL num rows
    In this example, we have created a num_rows.PHP file in which we executed a query to find the number of rows in the table.
               
76. PHP SQL Paging OR Pagination
    Some times the programmer needs to display a large amount of data. Displaying all data in one page in not a good idea. For this situation, pagination is the solution.
             
77. PHP SQL Login Script
    In this example, we have created a login application where we will use PHP script for validation. If the user does not fill the user name or password then the error message is displayed in the next page.
             
78. SQL Bulk Insert
    SQL Bulk Insert is performed when you insert a records  or row to a table in a bulk.
               
79. SQL Bulk Insert csv
    SQL Bulk Insert is used to import the records from csv  file to the same format table in a Mysql database.
                
80. SQL Max Count
    SQL Max Count is used to return the maximum records value of the specified column in a table.
              
81. Mysql ASC Order
    Mysql ASC Order is used to sort the result set by ascending or descending order. The Order by CLAUSE sort the result by specified column.
              
82. PHP SQL Query Where Clause
    To understand how to display the result returned  from the sql query execution, we have created whereClause.PHP page.
               
83. PHP SQL Result
    This example illustrates how to display result on the browser and how to use the result in the PHP application.
             
84. PHP SQL ORDER BY
    This example illustrates how to execute query with ORDER BY clause in the PHP application.
             
85. PHP SQL ODBC
    This example illustrates how to create an ODBC Connection for PHP application.
               
86. PHP SQL Max
    This example illustrates how to use max() function in sql.
              
87. PHP SQL Limit
    This example illustrates how to execute LIMIT operator of mysql in PHP.
              
88. PHP SQL Injection Example
    Database is the main part of any application used to store the sensitive information like user credentials, financial information etc. SQL Injection is a technique to break the security of the database of the application.
                 
89. PHP SQL Quotes and Quoting
    This example illustrates different ways to define single and double quotes in the php application with sql query.
               
90. PHP SQL Query
    This example illustrates how to create and execute the sql query in php application.
                
91. PHP SQL Output
    This example illustrates how to display the output fetched as a result of Sql query execution on the browser.
               
92. PHP SQL Null
    This example describes about handling NULL values in sql query in php.
              
93. Mysql XOR
    Mysql XOR returns you the output on the basis of condition specified in input. The output of the XOR is 0 when both the specified inputs are same.
             
94. Mysql Where Statement
    Mysql Where Statement is useful when we want to return the records on the basis of specified condition in Where Clause. The Where Clause restricts the records and select only those records specified in it.
               
95. USE
    SQL Use Query is used to see the tables in database.
                
96. UNION
    SQL Union is used to combine the query of two or more Select Statement. The Union Clause is used to return the combine set of records from two tables.
                  
97. SQL Then
    The Tutorial briefs you an example from SQL Then. To understand and grasp the example we create a function total that accept the input parameter variable a and b and returns a variable s.
               
98. SQL Select From
    SQL Select From keyword show you the records from a specified table.
                
99. SQL PHP where
    SQL PHP Where is used to built the connection between the SQL and PHP. The PHP sever side script is used to retrieve the records that meet a specific criteria from database 
                 
100. SQL PHP
     SQL PHP is used to execute the statement using the mysql_query ( ) function. The function is used to send a query or command to a MySQL connection.
                 
101. SQL PHP code
     SQL PHP code executes the statement using the mysql_query ( ) function. The function is used to send a query or command to a MySQL connection.
                 
102. SQL PHP array
     SQL PHP Array support simple dimension array. The SQL PHP Array is used to populate array from MySQL database.
                      
103. SQL get Column Name
     SQL get Column Name is used to return the Fieldnames of the table.
                          
104. SQL Backup Script
     The Tutorial illustrate an example from 'SQL Backup Script'.
               
105. SQL Avg Syntax
     SQL Avg Syntax is used to compute the average of the records in a table.
                
106. SQL Avg Function
     SQL Avg Function is used to compute the average records value in a column of specified table.
                             
107. SQL Aggregate Queries
     SQL Aggregate Queries show you the list of Aggregate Function that include Sum, Count, Average, Maximum, Minimum  etc.
               
108. SQL Aggregate Functions Where Clause
     SQL Aggregate Functions Where Clause return you the aggregate sum of the records based on the condition specified in Where Clause condition.
             
109. SQL Aggregate Functions List
     SQL Aggregate Functions List describe you the Aggregate Function List Queries.
                
110. SQL Aggregate Functions Where Clause
     SQL Aggregate Functions Where Clause is used to perform  various Functions like Sum, Count, Average, Maximum and Minimum.
                
111. SQL Aggregate Functions
     SQL Aggregate Functions is built in function that is used for the computation of records in a table.
                  
112. SQL Aggregate Concatenation
     SQL Aggregate Concatenation are used to perform operation on concatenation of different records from different fields.
                
113. SQL Aggregate Concatenate
     Sometimes it is required to combine the result set of  records from different fields.
               
114. PHP Mysql Group By
     PHP Mysql Group By is used to establish a relation between the PHP on the server side and Mysql database on the backend.
                 
115. PHP SQL Example
     A PHP scripting  block is executed on the server side, and the html result is sent to the browser. 
                
116. PHP SQL Die
     PHP SQL Die results when there is a connection failure. The die( ) function prints a message and exists from the current script.
                  
117. PHP SQL Connection
     PHP SQL Connection is used to access and return the records from PHP and MySQL database and vice-versa.
                               
118. PHP Mysql Database Connection
     PHP Mysql Database Connection is used to build a connection between the PHP on the server-side and Mysql on the backend.
                     
119. SQL ON
     The ON clause  is used to specify  name of the fieldname on which index is created.
                 
120. SQL Mode
     SQL Mode is a Function that returns the frequent occurring value of a numeric expression.
                 
121. SQL Indexes
     SQL uses index to find records quickly when a query is processed. Using Index can drastically enhance the performance of an application.
                
122. SQL Concat
     SQL Concat is used to combine the record set  of different fields.
             
123. SQL Average
     SQL Average, the part of Aggregate Function. SQL Average is used to compute average value of the records in a table of the database.
             
124. PHP SQL close connection
     PHP SQL close connection is used to close a connection between the PHP and SQL.
            
125. SQL Decimal
     SQL Decimal is used to specify the values in decimal datatype. The Decimal datatype can be of two types : Decimal (p) refers to floating point and Decimal fixed point (p,s).
             
126. SQL PHP
     PHP is a server side scripting language. To access the data in PHP,you must create a connection to the database.
               
127. Mysql Exists
     Mysql Exists return you only matches records of table 1 with table2. The unmatchable records are not displayed in the output of the table.
                
128. Mysql Phone Number Format
     Mysql Phone Number Format is useful when you want to return the phone number in specific format.
             
129. Mysql Permission
     Mysql Permission allows the user to connect to the database, Mysql checks and use that the particular username/ password and combination has the permission to connect.
                
130. MySQL Not Like
     MySQL Not Like returns only those set of  records from employee which are not listed in the 'where clause'.
              
131. MySQL Not In
     MySQL Not In is used to updates only those records of the table whose fields 'id' are not specified in the Where Clause.
             
132. Mysql Not
     Mysql Not is useful when you a perform Not Operation in SQL. The SQL query returns you 1 and 0,  when !o and !1 are selected in the select query.
              
133. Mysql Nested Select
     Mysql Nested Select is a SELECT query that is nested within a Select, Update, Insert or Delete SQL query.
              
134. Mysql Nested Case
     Mysql Nested Case is a Select Query that is nested inside select, update, delete and delete SQL query.
              
135. MySQL nchar
     MySQL nchar define the datatype nchar that stores fixed-length character data.
                  
136. Mysql nchar Datatype
     MySQL nchar define the datatype nchar that stores fixed-length character data.
             
137. MySQL Modulus
     MySQL Modulus refer to the remainder value obtained when a value 'a' is divided by 'b'.
             
138. Mysql Mod
     Mysql Mod (a,b) is performed to return remainder  when b is divided by a.
                
139. Mysql Minus Query
     Mysql Minus Query is used to return the calculated value from subtracting the maximum value and minimum value.
              
140. Mysql Minus Operator
     Mysql Minus Query  return the calculated value from subtracting the maximum value and minimum value.
              
141. Mysql Min Max
     Mysql Min Max is useful to find the minimum and maximum records from a table.
               
142. Mysql Min Date
     Mysql Min Date is used to return the minimum date record from table Employee.
             
143. Mysql Loader Tutorial
     Mysql Loaded Tutorial is used to import a data to a plain text from Mysql database.
               
144. Mysql Find Duplicate Records
     Mysql Find Duplicate Records is used to find the duplicate Records in the table.
              
145. Mysql CSV
     The LOAD DATA INFILE statement provides you the way to import data from a plain text file into database.
               
146. MySQL Nested Example
     MySQL Nested Select is select query, that is nested inside the select, update and delete query  based on the condition specified in a Where Clause.
                 
147. MySQL Not in Example
     MySQL Not in is used to set the update of  records for only those id, which are not specified in the where Not In.
               
148. MySQL Not equal
     MySQL Not equal is used to return the set of only those records from a table based on the condition specified in the Where Clause.
                  
149. MySQL Not Records
     MySQL Not is used to return the set of record opposite to the values.
               
150. MySQL Nested Select Example
     MySQL Nested Select is select query, that is nested inside the select, update and delete query  based on the condition specified in a Where Clause.
              
151. MySQL Add Column
     MySQL Add Column is used to add the column to the existing table. The Alter table keyword is used to modify the table structure and add  keyword is used to add the new column  in a table.
             
152. MySQL Addition
     MySQL Addition returns you the sum value of the total counts in a table. The Aggregate function is used to perform the calculation in SQL Query.
               
153. MySQL Absolute Value
     MySQL Absolute Value is used to return the absolute value of a records in table. The keyword abs is used to return the absolute numerical value of a records in a table.
                 
154. MySQL Begin Transaction
     MySQL Begin Transaction is a point in which data is referenced by a connection logically or physically. The error are encountered, when all the data modification made after the begin transaction can set to rolled back to return the data to known state of consistency.
              
155. PHP SQL Variable
     PHP SQL Variable are denoted with a leading dollar sign ($). The PHP  variable includes $ con , $ update and so on.
                  
156. PHP SQL Script
     PHP SQL Script is useful to perform the operation of SQL queries in PHP. The PHP is a server side scripting language and open source software.
                  
157. PHP SQL Random
     The PHP SQL Random is used to fetch data randomly from database in PHP. The Rand ( ) clause is used to fetch the random data from table into the browser.
              
158. PHP SQL Select Where
     PHP SQL Select Where is used to provide the records from the table that meet the specific criteria and print the records on the browser.
               
159. PHP SQL Sanitize
     PHP SQL Sanitize is a kind of filter which is used to allow or disallow characters in a string.
                
160. MySQL Converting Expression
     MySQL Convert function is used to convert the data from one type to another type. The CONVERT () function helps you to take a value of one type and result a value of another type.
                
161. MySQL Boolean Value
     MySQl Boolean Value is used to display the Boolean type status of the field.
                
162. MySQL Ascending Command
     MySQL Ascending is used to return the records from a table in the ascending order. The section will provides you the mean for arranging the data of database table in ascending order.
               
163. MySQL Auto_Increment
     MySQL Auto_Increment is used to generate a unique number when a new record is added to a table. The Unique number must be Primary key field that is created automatically every time a new record is inserted in a table.
             
164. MySQL ASC
     Executing select query with order by clause returns the rows in the order of column name specified with the order by clause. By default, the data is returned in ascending order.
              
165. MySQL Arithmetic
     Arithmetic operators are used to perform mathematical operations on two expressions to negate, add, subtract, multiply, and divide numeric values.
            
166. MySQL Area
     In this example we create a procedure to find the area of rectangle. In the query below we take two double type variable l and b to be used as input to the procedure and one variable "a" to be used as an output from the procedure.
                
167. MySQL Affected Rows
     When we execute Sql query, it may affect some rows of the table. For example, executing queries like update, insert, delete. These queries displays the successful message with the number of rows affected by the query.