Here we are going to show how you can use FIND_IN_SET in where clause for searching records. Sometime we store comma separated data in column and want to get records where particular value exist in column. In this situation we use Search Records Using FIND_IN_SET. Below is sample table with data CREATE TABLE `student` ( …
Here we show how you can use multiple count() with different conditions in single MySql query. Below is sample table with data — — Table structure for table `student` — CREATE TABLE `student` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `subject` varchar(255) NOT NULL, `address` varchar(255) NOT NULL, `gender` varchar(255) NOT NULL, `class` …
Multiple Counts With Different Conditions In Single MySQL Query Read More »
Here we will show how you can get the last inserted id of a MySQL table using different ways. First we are preparing the sample data. We will be creating a table user_info with some data. Below is sample table . — — Table structure for table `user_info` — CREATE TABLE `user_info` ( `id` int(11) NOT …
Here we show how you can drop a column from table in MySQL. Sometime, we not need a particular column of table. So, we delete this column from the table. Syntax: ALTER TABLE table_name DROP COLUMN column_name; First we create a sample table with data. CREATE TABLE `employees` ( `employee_id` int(11) NOT NULL, `employee_name` varchar(100) …
Here we show how you remove N characters from last of the column value help of SUBSTRING() and CHAR_LENGTH() methods. Below is sample table with data — — Table structure for table `user_info` — CREATE TABLE `user_info` ( `id` int(11) NOT NULL, `name` varchar(20) DEFAULT NULL, `email` varchar(255) NOT NULL, `age` int(11) NOT NULL ) …
Here we show how you can display only even or odd values rows in MySql. Sometime we need to display alternative records from MySql table. Below is a sample table with data CREATE TABLE `student` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `subject` varchar(255) NOT NULL, `address` varchar(255) NOT NULL, `gender` varchar(255) NOT …
Sometime we need to copy one table data to another table. Here we show how you can copy one table data to another table using MYSQL Query. First, we create two tables one table populated with data and other table is empty. Below are sample tables. /* First table with data */ — — Table …
Here, we are going to see how to retrieve and display nth records from a MySql database table using an SQL query. MySQL provides OFF SET value allows us to specify which row to start from retrieving data, like if we want to get records starting from 4th row, then the offset will be 3. …
Here we write a SQL Query for retrieve Max and Min salary with employees name in MySql. First we create a sample table with data. — — Table structure for table `employees` — CREATE TABLE `employees` ( `employee_id` int(11) NOT NULL, `employee_name` varchar(100) NOT NULL, `salary` int(11) NOT NULL, `department` varchar(50) NOT NULL ) ENGINE=InnoDB …
Max And Min Salary Of Employees With Employee Name In MySql Read More »
MySql delete(remove) duplicate rows(records) We will show you how to remove duplicate rows in a MySql. First we will create a table with some duplicate records. Below show a sample table image with duplicate records. Here we run a query to know how many name column repeated. SELECT *,count(name) AS dup_rows FROM `user_info` GROUP BY …
