The DELETE statement is used to delete records from a table. you can delete records from a table using the SQL DELETE statement. It is typically used in conjugation with the WHERE clause to delete only those records that matches specific criteria or condition. Syntax : DELETE FROM table_nameWHERE some_column = some_value ; Implementation of the Delete Query … Read more
Introduction : MySQL is the most popular Open Source Relational SQL database management system. MySQL is one of the best RDBMS being used for developing web-based software applications. It is commonly deployed as part of the LAMP stack (which stands for Linux, Apache, MySQL, and PHP) and, as of this writing, is the most popular open-source database in the world. Prerequisites : A Linux … Read more
What is XML : XML is stand for (Extensible Markup Language) is a mark up language. It is designed to store transmitting, and reconstructing arbitrary data. The XML standard is a flexible way to create information formats and electronically share structured data via the public internet, as well as via corporate networks.XML does not define … Read more
Define Binary logs : In MySQL, the changes that occur within the database are logged simultaneously. The binary log is a set of log files that contain information about data modifications made to a MySQL server instance. The log is enabled by starting the server with the –log- bin option. The MySQL Bin Log (Binary Logs) … Read more
Select : Select Data From a MySQL Database The SELECT statement is used to select data from one or more tables The SQL SELECT command is used to fetch data from the MySQL database. You can use this command at mysql> prompt as well as in any script like PHP. Syntax : Columns are the column names … Read more
MySQL String Functions : MySQL string functions manipulate the character string data effectively. The following table indicates each of the functions with a brief description: Name Description CONTACT Concatenate two or more strings into a single string INSTR Return the position of the first occurrence of a substring in a string ASCII Returns the ASCII … Read more
VARCHAR Datatype: Varchar is a datatype in SQL that holds characters of variable length. This data type stores character strings of up to 255 bytes in a variable-length field. If the length of the string is less than set or fixed-length then it will store as it is without padded with extra blank spaces. The … Read more
INSERT : The INSERT INTO statement is used to add new records to a MySQL table . Syntax : NSERT INTO table_name (column1, column2, column3,…)VALUES (value1, value2, value3,…) PHP MySQL INSERT Query : SQL query using the INSERT INTO statement with appropriate values, after that we will execute this insert query through passing it to the PHP Mysqli_query function to insert … Read more
MySQL SELECT Statement : The select statement is used to select data from a database. The SELECT statement in MySQL is used to fetch data from one or more tables. We can retrieve records of all fields or specified fields that match specified criteria using this statement. Syntax : SELECT column1, column2, …FROM table_nameWHERE condition; You can use one or more tables separated by … Read more
SQL INSERT INTO Statement : The SQL INSERT INTO Statement is used to add new rows of data to a table in the database. SQL INSERT statement inserts one or more rows of data into a table. You can also see INSERT written as INSERT INTO, but both behave the same. The inclusion of INTO is optional in most variants of SQL Syntax … Read more