- 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
642 Views
Let’s say the current date is 2019-08-03. Now, we will see an example and create a table −mysql> create table DemoTable840(DueDate datetime); Query OK, 0 rows affected (0.66 sec)Insert some records in the table using insert command −mysql> insert into DemoTable840 values('2019-08-9'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable840 values('2019-07-5'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable840 values('2019-08-10'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable840 values('2019-07-13'); Query OK, 1 row affected (0.10 sec)Display all records from the table using select statement −mysql> select *from DemoTable840;This will produce the ... Read More
62 Views
To set specific record ordering, use ORDER BY LIKE. Let us first create a table−mysql> create table DemoTable808(Value varchar(100)); Query OK, 0 rows affected (0.61 sec)Insert some records in the table using insert command −mysql> insert into DemoTable808 values('smith'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable808 values('Adamsmith'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable808 values('Carolsmith'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable808 values('smithJohn'); Query OK, 1 row affected (0.16 sec)Display all records from the table using select statement −mysql> select *from DemoTable808;This will produce the following output −+------------+ ... Read More
3K+ Views
Let us first create a table −mysql> create table DemoTable807( ClientId int NOT NULL AUTO_INCREMENT PRIMARY KEY, ClientName varchar(100), ClientCountryName varchar(100) ); Query OK, 0 rows affected (0.64 sec) Insert some records in the table using insert command −mysql> insert into DemoTable807(ClientName, ClientCountryName) values('Chris', 'UK'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable807(ClientName, ClientCountryName) values('David', 'AUS'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable807(ClientName, ClientCountryName) values('Robert', 'US'); Query OK, 1 row affected (0.74 sec) mysql> insert into DemoTable807(ClientName, ClientCountryName) values('Mike', 'ENG'); Query OK, 1 row affected (0.14 sec)Display all records ... Read More
129 Views
To match partially, use LIKE operator. Let us first create a table −mysql> create table DemoTable806( StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentName varchar(100), StudentSubject varchar(100) ); Query OK, 0 rows affected (0.57 sec)Insert some records in the table using insert command −mysql> insert into DemoTable806(StudentName, StudentSubject) values('Chris', 'Java in Depth With Data Structure'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable806(StudentName, StudentSubject) values('Robert', 'Introduction to MySQL'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable806(StudentName, StudentSubject) values('Bob', 'C++ in Depth With Data Structure And Algorithm'); Query OK, 1 row affected ... Read More
3K+ Views
Let us first create a table −mysql> create table DemoTable805(LoginDate datetime); Query OK, 0 rows affected (0.63 sec)Insert some records in the table using insert command −mysql> insert into DemoTable805 values('2019-01-31 12:45:20'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable805 values('2017-11-01 10:20:30'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable805 values('2016-03-12 04:10:00'); Query OK, 1 row affected (0.35 sec) mysql> insert into DemoTable805 values('2018-12-24 05:01:00'); Query OK, 1 row affected (0.13 sec)Display all records from the table using select statement −mysql> select *from DemoTable805;This will produce the following output −+---------------------+ | LoginDate ... Read More
314 Views
For this, you need to use ORDER BY to order records. With that use RAND() to get random records and LIMIT 5 since we want to display only 5 random records.Let us first create a table −mysql> create table DemoTable773 (StudentId int); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command −mysql> insert into DemoTable773 values(100); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable773 values(200); Query OK, 1 row affected (0.87 sec) mysql> insert into DemoTable773 values(300); Query OK, 1 row affected (1.59 sec) mysql> insert into DemoTable773 values(400); Query OK, ... Read More
181 Views
To find alternative records from a table, you need to use the OR condition as in the below syntax −select *from yourTableName where yourColumnName=yourValue1 OR yourColumnName=yourValue2…...N;Let us first create a table −mysql> create table DemoTable772 ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Name varchar(100), Age int ); Query OK, 0 rows affected (0.76 sec)Insert some records in the table using insert command −mysql> insert into DemoTable772(Name, Age) values('Chris', 21); Query OK, 1 row affected (0.28 sec) mysql> insert into DemoTable772(Name, Age) values('Robert', 26); Query OK, 1 row affected (0.19 sec) ... Read More
74 Views
Use BETWEEN to find the date and time between joining and relieving date. NOW() is used to get the current date and time for comparison.Let us first create a table −mysql> create table DemoTable771 ( Joiningdate datetime, Relievingdate datetime ); Query OK, 0 rows affected (1.15 sec)Insert some records in the table using insert command −mysql> insert into DemoTable771 values('2016-01-21', '2016-09-23'); Query OK, 1 row affected (0.27 sec) mysql> insert into DemoTable771 values('2019-01-21', '2019-09-23'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable771 values('2017-04-01', '2018-12-31'); Query OK, 1 row affected (0.20 sec) ... Read More
991 Views
Let us first create a table −mysql> create table DemoTable770 ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Value int ); Query OK, 0 rows affected (0.65 sec)Insert some records in the table using insert command −mysql> insert into DemoTable770(Value) values(10); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable770(Value) values(90); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable770(Value) values(160); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable770(Value) values(450); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable770(Value) values(560); Query OK, 1 row affected ... Read More
3K+ Views
To set country code to phone numbers would mean to concatenate. You can use CONCAT() for this.Let us first create a table −mysql> create table DemoTable769 (MobileNumber varchar(100)); Query OK, 0 rows affected (0.54 sec)Insert some records in the table using insert command −mysql> insert into DemoTable769 values('8799432434'); Query OK, 1 row affected (0.24 sec) mysql> insert into DemoTable769 values('9899996778'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable769 values('7890908989'); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable769 values('9090898987'); Query OK, 1 row affected (0.20 sec)Display all records from the table using select statement −mysql> ... Read More