SQL Tutorial

Programming Resource Home :: Database-Tutorials :: SQL_Tutorial

Advertisement

Advertisement




SQL Tutorial
Tutorial MySql Append Codes
We use CONCAT() function to append the values of two column. 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. View Rating



SQL Tutorial
Tutorial 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. View Rating



SQL Tutorial
Tutorial SQL All Column Names
SQL All Column Names is useful when you want to see the Field, Type, Null, Key etc from the table records. View Rating



SQL Tutorial
Tutorial PHP SQL Insertion
PHP SQL Insertion is used to execute MySQL queries in PHP script. It is used to send insert query or command that adds the records to MySQL. View Rating



SQL Tutorial
Tutorial MySQL Arithmetic
Arithmetic operators are used to perform mathematical operations on two expressions to negate, add, subtract, multiply, and divide numeric values. View Rating



SQL Tutorial
Tutorial SQL Aggregate Functions
SQL Aggregate Functions is built in function that is used for the computation of records in a table. View Rating



SQL Tutorial
Tutorial 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. View Rating



SQL Tutorial
Tutorial SQL Alter Table
SQL Alter Table is used to modify the existing table definition. The modification in table relates to add columns, rename column and add primary key to the column in a table. View Rating



SQL Tutorial
Tutorial MySQL PHP Update
MySQL PHP Update uses mysql_update function ( ) that is used to update the records from table in the database. View Rating



SQL Tutorial
Tutorial MySQL PHP Query delete
Mysql PHP Query delete is used to execute Mysql function ( ) delete query from a database table. MySQL PHP Query is used to delete the records from the table 'MyTable' based on condition specified in Where Clause. 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     [>>]

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

Copyright © 2004. All rights reserved.