Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
MySQL Articles
Page 224 of 355
MySQL query to insert row with date?
Let us first create a table −mysql> create table DemoTable( EmployeeId int NOT NULL AUTO_INCREMENT PRIMARY KEY, EmployeeName varchar(100), JoiningDate date ); Query OK, 0 rows affected (0.48 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(EmployeeName, JoiningDate) values('Chris', '2019-01-21'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable(EmployeeName, JoiningDate) values('Robert', '2016-12-01'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable(EmployeeName, JoiningDate) values('Mike', '2015-03-12'); Query OK, 1 row affected (0.12 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following output −+------------+--------------+-------------+ ...
Read MoreInserting data into a new column of an already existing table in MySQL?
Let us first create a table −mysql> create table DemoTable( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Name varchar(100) ); Query OK, 0 rows affected (0.47 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(Name) values('John'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable(Name) values('Bob'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable(Name) values('Adam'); Query OK, 1 row affected (0.28 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following output −+----+------+ | Id | Name | +----+------+ | 1 | ...
Read MoreWhat is "SELECT TRUE" in MySQL?
The statement SELECT TRUE returns 1 if a row match. Let us first create a table −mysql> create table DemoTable(Name varchar(100)); Query OK, 0 rows affected (0.54 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('Robert'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable values('David'); Query OK, 1 row affected (0.12 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following output −+--------+ | Name | +--------+ | Chris | | Robert ...
Read MoreHow to display coming Sunday's date for all the date records in MySQL?
Let us first create a table −mysql> create table DemoTable(GetSundayDate date); Query OK, 0 rows affected (0.44 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('2019-08-07'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable values('2018-09-05'); Query OK, 1 row affected (0.22 sec) mysql> insert into DemoTable values('2019-09-12'); Query OK, 1 row affected (0.17 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following output −+---------------+ | GetSundayDate | +---------------+ | 2019-08-07 | | 2018-09-05 | | 2019-09-12 | +---------------+ 3 rows in ...
Read MoreConvert varchar to unsigned integer in MySQL
To convert varchar to unsigned integer, use CAST() function. Let us first create a table −mysql> create table DemoTable868(Amount varchar(100)); Query OK, 0 rows affected (0.51 sec)Insert some records in the table using insert command −mysql> insert into DemoTable868 values('781'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable868 values('990'); Query OK, 1 row affected (0.25 sec) mysql> insert into DemoTable868 values('1002'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable868 values('560'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable868 values('890'); Query OK, 1 row affected (0.26 sec) mysql> insert into DemoTable868 values('9890'); ...
Read MoreHow to get the top 3 salaries from a MySQL table with record of Employee Salaries?
For this, use LIMIT and OFFSET. Let us first create a table −mysql> create table DemoTable867(EmployeeSalary int); Query OK, 0 rows affected (0.64 sec)Insert some records in the table using insert command −mysql> insert into DemoTable867 values(63737); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable867 values(899833); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable867 values(23644); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable867 values(89393); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable867 values(534333); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable867 values(889322); Query OK, 1 ...
Read MorePerform SUM and SUBTRACTION on the basis of a condition in a single MySQL query?
For this, use CASE statement and set for both SUM and SUBTRACTION. Let us first create a table −mysql> create table DemoTable866( Status varchar(100), Amount int ); Query OK, 0 rows affected (0.63 sec)Insert some records in the table using insert command −mysql> insert into DemoTable866 values('ACTIVE', 50); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable866 values('INACTIVE', 70); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable866 values('INACTIVE', 20); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable866 values('ACTIVE', 100); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable866 ...
Read MoreWhat does parenthesis mean in MySQL SELECT (COLNAME)?
The SELECT(COLNAME) means, we are creating an alias for that column. Let us see an example and create a table −mysql> create table DemoTable865( FirstName varchar(100), LastName varchar(100) ); Query OK, 0 rows affected (0.77 sec)Insert some records in the table using insert command −mysql> insert into DemoTable865 values('Chris', 'Brown'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable865 values('Adam', 'Smith'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable865 values('David', 'Miller'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable865 values('Carol', 'Taylor'); Query OK, 1 row affected (0.15 sec)Display all records ...
Read MoreReturn only the non-empty and non-null values from a table and fill the empty and NULL values with the corresponding column values in MySQL?
Let us first create a table −mysql> create table DemoTable839( StudentFirstName varchar(100), StudentLastName varchar(100) ); Query OK, 0 rows affected (0.69 sec)Insert some records in the table using insert command −mysql> insert into DemoTable839 values('Chris', 'Brown'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable839 values('', 'Taylor'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable839 values(NULL, 'Taylor'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable839 values('Adam', 'Smith'); Query OK, 1 row affected (0.12 sec)Display all records from the table using select statement −mysql> select *from DemoTable839;This will produce the following ...
Read MoreHow can I create a MySQL table with a column with only 3 possible given values?
For this, use the ENUM data type. Let us first create a table −mysql> create table DemoTable838(Color ENUM('RED','GREEN','BLUE')); Query OK, 0 rows affected (0.67 sec)Insert some records in the table using insert command −mysql> insert into DemoTable838 values('RED'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable838 values('Green'); Query OK, 1 row affected (0.64 sec) mysql> insert into DemoTable838 values('Blue'); Query OK, 1 row affected (0.88 sec)Display all records from the table using select statement −mysql> select *from DemoTable838;This will produce the following output −+-------+ | Color | +-------+ | RED | | GREEN | | BLUE | +-------+ 3 rows in set (0.00 sec)
Read More