Home Sql Sql-functions SQL Functions
Questions:Ask|Latest

 
 

Share on Google+Share on Google+

SQL Functions

Advertisement
Mysql Where is used to return the select records based on the condition specified in Where CLAUSE.

SQL Functions

     

  1. Mysql where
    Mysql Where is used to return the select records based on the condition specified in Where CLAUSE.
     

  2. Mysql Update
    The section in this Tutorial illustrate an example from 'Mysql Update'.To grasp this example we simply create a table 'Employee' with required fieldname and datatype respectively.
      

  3. Mysql Now Current DateTime
    The Tutorial in this section illustrate an example from 'Mysql Now Current Date Time'.
      

  4. Mysql Multiply
    The Tutorial illustrate an example from 'Mysql Multiply'.The example elaborate a query that help you to return the product of any two or more numbers in a specified table.
     

  5. 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.
      

  6. Mysql Multiple Date Insert
    Mysql Multiple Column Insert is used to add or insert multiple data to the table.
     

  7. Mysql Mod Function
    Mysql Mod Function is used to return the remainder of N divided by M.
     

  8. Mysql Minus
    Mysql Minus is used to see only those records from table which are not in another table.
      

  9. Mysql Minimum Query
    Mysql Minimum Query is useful when you want to return the minimum value record from table.
     

  10. Mysql MidString
    Mysql MidString is used to return the string, with sub string beginning at position pos and len.This is a synonym for SUB STRING( str , pos , len ) .
     

  11. 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.
     

  12. 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.
     

  13. Mysql Max Date
    Mysql Max Date is used to return the maximum  value of date from a table.
      

  14. Mysql Math Function
    Math Function involved in Mysql when we perform some operation on mathematical operator.
      

  15. Mysql Ltrim
    The Tutorial illustrate an example from 'Mysql Ltrim'.To understand this example,we create a procedure 'ABC' that include a BEGIN-END statement consists of declare variables.
      

  16. 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.
      

  17. 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.
      

  18. Mysql Lower Case
    Mysql Lower Case is used to convert the Upper Case letter to the Lower Case.
     

  19. Mysql Looping
    Looping in Mysql is a simple loop construct,that enables the repeated execution of the statement list.This include one or more statements.Each statement is terminated by a semicolon(;).
     

  20. 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.Each loop is terminated by a semicolon(;) or statement delimiter.
      

  21. 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.
     

  22. Mysql Loader Tutorial
    Mysql Loaded Tutorial is used to import a data to a plain text from Mysql database.The Plain Text is used as backup file from which the data is again imported to Loaded Employee.
     

  23. Mysql Loader Control File
    Mysql Loader Control File is the mean to import a data to a plain text from Mysql database.
      

  24. 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'.
     

  25. Mysql List
    Mysql List elaborate you an Query for listing databases,tables,Procedure,columns,usernames and its password.
      

  26. Mysql Limit
    Mysql Limit is used to limit your query result to those which fall within a specified range.
      

  27. Mysql like syntax
    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 Operator
    Mysql Like Operator is used to compare a part of string using the % wild card character.
     

  29. Mysql Like Command
    Mysql Like Command is used for retrieving the records from a table on the basis of pattern matching.
      

  30. Mysql Like Operator
    Mysql Like is used to retrieve the records on the basis of pattern matching in select query.
     

  31. 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.
     

  32. Mysql String Length
    Mysql Length is used to return the length of the String.
     

  33. Mysql Left Function
    Mysql Left Function is used to return the leftmost string character from the string.
      

  34. Mysql left
    Mysql Left is used to return the left string from the character specified in column of the table.
      

  35. Mysql last record
    Mysql Last Record is used to the return the record using order by  from table.
     

  36. Mysql last day of month
    The Tutorial illustrate an example from 'Mysql Last Day of Month'. 
      

  37. 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.
     

  38. 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.
      

  39. Mysql Difference
    Mysql Difference is used to return the records that are the outcome of difference between the records in a table.
      

  40. PHP SQL Timestamp
    In this example the PHP date() function formats a timestamp to a more readable date and time. A timestamp is the number of seconds since January 1, 1970 at 00:00:00 GMT. This is also known as the Unix Timestamp. 
     

  41. PHP SQL Array
    PHP SQL Array is the set of collection of one or more similar variable under single name. Usually we have different type of values whose datatypes are same, Array is used as substitute for those variable, which have the same datatypes and store the data as element in array.
     

  42. PHP SQL Where
    PHP SQL Where is used to modify or change the structure of  table definition based on the condition specified in Where Clause. The PHP SQL Where allows you to update the field based on the condition specified in Where Clause.
      

  43. MySQL Append String
    We use CONCAT() function to append the values of columns.
     

  44. MySQL Append Data
    'CONCAT()'
    function is used to append data to the column value. In this example, we are concatenating  the value 'sandeep' and the "studentid" column for each row of the "mca" table.
      

  45. MySQL Append Column
    Appending columns values can be performed using CONCAT() function. By this function, values of columns can be concatenated and made them a single value.
      

  46. MySql Append Codes
    In this example, we are concatenating  the value of "fname" column and the value of "lname" column for each row having value 'Programmer' in the 'designation' column of the "user" table.
     

  47. MySQL Append
    In this example, we are concatenating  the value of "first_name" column and the value of "last_name" column for each row having value 'lucknow' in the 'city' column of the "roseindia" table.
     

  48. MySQL Aggregate Function
    In this example we use the aggregate function ('COUNT', 'MIN', 'MAX', and 'SUM') in the MySQL Query. The group (aggregate) functions that operate on set of values. 
      

  49. MySQL Add Column
    MySQL Add Column tutorial explains you to add the column to the existing table. The table structure can be changed using 'Alter table' query. 
     

  50. MySQL Addition
    MySQL Addition returns you the sum value of a specific column for a group in a table. The Aggregate function sum() is used to perform the addition in SQL Query.

Advertisement

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: June 19, 2009

Related Tutorials

Ask Questions?    Discuss: SQL Functions  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
Harpreet Singh
December 1, 2011
Foreign Key

FOREIGN Key: Uniquely identified a rows/records in any another database table. A foreign key is a key used to link two tables together. This is sometimes called a referencing key. Primary key field from one table and insert it into the other table where it becomes a foreign key ie. Foreign Key is a column or a combination of columns whose values match a Primary Key in a different table. But in practic i found that it is not compulsry that reference key must be a primary key in another table tell me why
DMCA.com