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
Database Articles
Page 416 of 547
What 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 MoreHow to compare Year, Month and Day in a MySQL query and display matching records
For this, you can use DATE(). Let us first create a table −mysql> create table DemoTable864(DueDateTime timestamp); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert command −mysql> insert into DemoTable864 values('2019-01-10 12 −34 −55'); Query OK, 1 row affected (0.26 sec) mysql> insert into DemoTable864 values('2016-12-11 11 −12 −00'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable864 values('2015-04-01 10 −00 −00'); Query OK, 1 row affected (0.28 sec) mysql> insert into DemoTable864 values('2017-05-20 04 −40 −10'); Query OK, 1 row affected (0.17 sec)Display all records from the table using select statement ...
Read MoreReplace the empty values from a MySQL table with a specific value
Let us first create a table −mysql> create table DemoTable837(Name varchar(100)); Query OK, 0 rows affected (0.53 sec)Insert some records in the table using insert command −mysql> insert into DemoTable837 values('Chris'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable837 values(''); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable837 values('Robert'); Query OK, 1 row affected (0.08 sec) mysql> insert into DemoTable837 values(''); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable837 values('David'); Query OK, 1 row affected (1.13 sec)Display all records from the table using select statement −mysql> select *from DemoTable837;This will produce ...
Read MoreMySQL query to get the dates between range of records displaying student's Date of Birth?
For fetching records between dates, use BETWEEN. Let us first create a table −mysql> create table DemoTable863(StudentDateOfBirth date); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert command −mysql> insert into DemoTable863 values('1998-01-10'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable863 values('2000-10-15'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable863 values('2003-04-20'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable863 values('2005-12-31'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable863 values('1999-07-01'); Query OK, 1 row affected (0.27 sec)Display all records from the table using select ...
Read MoreRemove specific word in a comma separated string with MySQL
Let us first create a table −mysql> create table DemoTable836(FirstName SET('John', 'Chris', 'Adam')); Query OK, 0 rows affected (0.60 sec)Insert some records in the table using insert command −mysql> insert into DemoTable836 values('John, Chris'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable836 values('John, Chris, Adam'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable836 values('Chris, Adam'); Query OK, 1 row affected (0.25 sec) mysql> insert into DemoTable836 values('John, Adam'); Query OK, 1 row affected (0.37 sec)Display all records from the table using select statement −mysql> select *from DemoTable836;This will produce the following output −+-----------------+ | ...
Read MoreMySQL query to update only month in date?
To update only month in date, use MONTH(). Let us first create a table −mysql> create table DemoTable861(AdmissionDate date); Query OK, 0 rows affected (1.22 sec)Insert some records in the table using insert command −mysql> insert into DemoTable861 values('2019-01-21'); Query OK, 1 row affected (0.31 sec) mysql> insert into DemoTable861 values('2018-01-01'); Query OK, 1 row affected (0.49 sec) mysql> insert into DemoTable861 values('2016-01-02'); Query OK, 1 row affected (1.27 sec) mysql> insert into DemoTable861 values('2018-01-14'); Query OK, 1 row affected (0.47 sec)Display all records from the table using select statement −mysql> select *from DemoTable861;This will produce the following output −+---------------+ ...
Read MoreHow to order by the highest value from two columns in MySQL?
Let us first create a table −mysql> create table DemoTable834( Value1 int, Value2 int ); Query OK, 0 rows affected (1.50 sec)Insert some records in the table using insert command −mysql> insert into DemoTable834 values(10, 20); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable834 values(40, 50); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable834 values(20, 24); Query OK, 1 row affected (0.29 sec) mysql> insert into DemoTable834 values(30, 10); Query OK, 1 row affected (0.14 sec)Display all records from the table using select statement −mysql> select *from DemoTable834;This will produce the following ...
Read MoreHow to skip rows in MySQL?
To skip rows, use LIMIT OFFSET. Let us first create a table −mysql> create table DemoTable860( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Name varchar(100) ); Query OK, 0 rows affected (0.73 sec)Insert some records in the table using insert command −mysql> insert into DemoTable860(Name) values('Chris'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable860(Name) values('Robert'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable860(Name) values('David'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable860(Name) values('Bob'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable860(Name) values('Mike'); Query OK, 1 row ...
Read More