AmitDiwan has Published 781 Answers

AmitDiwan has Published 781 Answers

Extract gender values as a string when it is stored in the table as a Boolean in MySQL

MySQL MySQLi Database

Published on 03-Sep-2019 14:43:40

Let us first create a table −mysql> create table DemoTable815(Gender BOOLEAN); Query OK, 0 rows affected (0.84 sec)Insert some records in the table using insert command −mysql> insert into DemoTable815 values(true); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable815 values(false); Query OK, 1 row affected (0.16 sec) ... Read More

Add 30 days to date in a MySQL table with arrival date records

MySQL MySQLi Database

Published on 03-Sep-2019 14:35:47

Use INTERVAL to update the days for all the dates in a MySQL table column. Let us first create a table −mysql> create table DemoTable814(ArrivalDate date); Query OK, 0 rows affected (0.58 sec)Insert some records in the table using insert command −mysql> insert into DemoTable814 values('2018-12-02'); Query OK, 1 row ... Read More

Group concatenate the last name from a MySQL column and set a condition to display limited records

MySQL MySQLi Database

Published on 03-Sep-2019 14:32:44

Use GROUP_CONCAT() to perform group concatenation and set a condition. Let us first create a table −mysql> create table DemoTable813( UserId int NOT NULL AUTO_INCREMENT PRIMARY KEY, UserFirstName varchar(100), UserLastName varchar(100) ); Query OK, 0 rows affected (0.49 sec)Insert some records in the table using insert command ... Read More

How to use MySQL LIKE to create a search system and display results on the basis of keyword?

MySQL MySQLi Database

Published on 03-Sep-2019 14:28:39

To display results on the basis of keyword, use the LIKE operator as in the following syntax −select *from yourTableName where yourColumnName LIKE '%yourValue%';Let us first create a table −mysql> create table DemoTable812(Comments text); Query OK, 0 rows affected (0.61 sec)Insert some records in the table using insert command −mysql> ... Read More

Is INNODB enabled by default in MySQL?

MySQL MySQLi Database

Published on 03-Sep-2019 14:27:52

Yes, it is enabled by default from MySQL version 4.0. Here, we are using MySQL version 8.0.1 −mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.12 | +-----------+ 1 row in set (0.00 sec)Let us now check the my.ini wherein the default engine type InnoDB is visible ... Read More

Can I insert two or more rows in a MySQL table at once?

MySQL MySQLi Database

Published on 03-Sep-2019 14:25:12

Yes, we can insert two or more rows in a table at once. Following is the syntax −insert into yourTableName(yourColumnName1, yourColumnName2) values(yourValue1, yourValue2), (yourValue1, yourValue2), .........N;Let us first create a table −mysql> create table DemoTable811( StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentName varchar(100), StudentAge int ); ... Read More

MySQL query to count rows with a specific column?

MySQL MySQLi Database

Published on 03-Sep-2019 14:24:31

Let us first create a table −mysql> create table DemoTable841( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Value varchar(100) ); Query OK, 0 rows affected (0.67 sec)Insert some records in the table using insert command −mysql> insert into DemoTable841(Value) values('X'); Query OK, 1 row affected (0.19 sec) mysql> ... Read More

Implement MySQL IN for 2 columns to display only selected records

MySQL MySQLi Database

Published on 03-Sep-2019 14:22:53

Let us first create a table −mysql> create table DemoTable810( First int, Second int ); Query OK, 0 rows affected (0.73 sec)Insert some records in the table using insert command −mysql> insert into DemoTable810 values(20, 40); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable810 values(70, ... Read More

MySQL SELECT to sum a column value with previous value

MySQL MySQLi Database

Published on 03-Sep-2019 14:19:47

For this, you can use a session variable. Let us first create a table −mysql> create table DemoTable809(Price int); Query OK, 0 rows affected (0.53 sec)Insert some records in the table using insert command −mysql> insert into DemoTable809 values(40); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable809 ... Read More

Selecting rows that are older than current date in MySQL?

MySQL MySQLi Database

Published on 03-Sep-2019 14:19:19

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

1 2 3 4 5 6 7 ... 79 Next

Advertisements