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