- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Found 4219 Articles for MySQLi
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
121 Views
Find NULL values using the IS NULL and update the new values using MySQL UPDATE and SET −update yourTableName set yourColumnName=yourValue where yourColumnName IS NULL;Let us first create a table −mysql> create table DemoTable768 ( Clientid int NOT NULL AUTO_INCREMENT PRIMARY KEY, ClientName varchar(100), ClientAge int ); Query OK, 0 rows affected (0.47 sec)Insert some records in the table using insert command −mysql> insert into DemoTable768(ClientName, ClientAge) values('John', 23); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable768(ClientName, ClientAge) values(NULL, 26); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable768(ClientName, ClientAge) values('Carol', 28); ... Read More
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
2K+ Views
For this, you can use LPAD() and pad a value on the left.Let us first create a table −mysql> create table DemoTable767 (Value varchar(100)); Query OK, 0 rows affected (1.40 sec)Insert some records in the table using insert command −mysql> insert into DemoTable767 values('4'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable767 values('5'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable767 values('6'); Query OK, 1 row affected (0.39 sec) mysql> insert into DemoTable767 values('1'); Query OK, 1 row affected (0.10 sec)Display all records from the table using select statement −mysql> select *from DemoTable767;This will ... Read More
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
1K+ Views
For this, you need to perform concatenation using CONCAT().Let us first create a table −mysql> create table DemoTable766 (Name varchar(100)); Query OK, 0 rows affected (0.65 sec)Insert some records in the table using insert command −mysql> insert into DemoTable766 values('John'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable766 values('Sam'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable766 values('Carol'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable766 values('David'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable766 values('Bob'); Query OK, 1 row affected (0.12 sec)Display all records from the table ... Read More
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
61 Views
For this, you need to cast the varchar value to INTEGER.Let us first create a table −mysql> create table DemoTable765 (ItemPrice varchar(200)); Query OK, 0 rows affected (0.52 sec)Insert some records in the table using insert command −mysql> insert into DemoTable765 values('567.00'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable765 values('1089.00'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable765 values('540.00'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable765 values('788.00'); Query OK, 1 row affected (0.39 sec)Display all records from the table using select statement −mysql> select *from DemoTable765;This will produce the ... Read More
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
586 Views
For this, you can use GROUP_CONCAT().Let us first create a table −mysql> create table DemoTable764 ( ProductId int, ProductPrice int ); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert command −mysql> insert into DemoTable764 values(101, 10000); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable764 values(102, 1090); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable764 values(103, 4000); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable764 values(102, 3450); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable764 values(101, 20000); Query OK, 1 row ... Read More
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
596 Views
To get result from multiple select statements, use UNION ALL. Following is the syntax −select yourValue1 AS anyColumnName UNION ALL select yourValue2 AS yourColumnName . . . . NLet us implement the above syntax in order to return enumeration of numbers in different rows −mysql> select 100 AS Number UNION ALL select 1000 AS Number UNION ALL select 10000 AS Number UNION ALL select 100000 AS Number UNION ALL select 1000000 AS Number UNION ALL select 10000000 AS Number UNION ALL select 100000000 AS Number UNION ALL select 1000000000 AS Number;This will produce the following output -+------------+ | Number | +------------+ | 100 | | 1000 | | 10000 | | 100000 | | 1000000 | | 10000000 | | 100000000 | | 1000000000 | +------------+ 8 rows in set (0.00 sec)
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
7K+ Views
To select last two rows, use ORDER BY DESC LIMIT 2.Let us first create a table −mysql> create table DemoTable763 ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, FirstName varchar(100) ); Query OK, 0 rows affected (0.57 sec)Insert some records in the table using insert command −mysql> insert into DemoTable763(FirstName) values('John'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable763(FirstName) values('Sam'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable763(FirstName) values('Carol'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable763(FirstName) values('David'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable763(FirstName) ... Read More
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
552 Views
For this, you can use LIKE operator with OR condition.Let us first create a table −mysql> create table DemoTable762 (Title text); Query OK, 0 rows affected (0.54 sec)Insert some records in the table using insert command −mysql> insert into DemoTable762 values('Introduction to Java'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable762 values('MySQL is a RDBMS'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable762 values('Data Structure and Algorithm in Java'); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable762 values('Data Structure and Algorithm in C and C++'); Query OK, 1 row affected (0.18 ... Read More
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
355 Views
The strings (column values) begun with a character and rest of the string has numbers. We want the sum of these numbers −J230 A130s C13For this, use SUBSTRING() function along with SUM().Let us first create a table −mysql> create table DemoTable761 (Price varchar(100)); Query OK, 0 rows affected (0.62 sec)Insert some records in the table using insert command −mysql> insert into DemoTable761 values('J230'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable761 values('A130'); Query OK, 1 row affected (0.70 sec) mysql> insert into DemoTable761 values('C13'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable761 values('D456'); Query ... Read More
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
151 Views
Let us first create a table −mysql> create table DemoTable760 ( ClientId int, ClientId2 int ); Query OK, 0 rows affected (0.79 sec)Insert some records in the table using insert command −mysql> insert into DemoTable760 values(100, 200); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable760 values(100, 200); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable760 values(300, 400); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable760 values(300, 400); Query OK, 1 row affected (0.26 sec) mysql> insert into DemoTable760 values(100, 200); Query OK, 1 row affected (0.23 sec) mysql> insert ... Read More