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 204 of 355
Inserting multiple parameter values into a single column with MySQL?
To insert multiple parameter values into a single column, use the CONCAT_WS() or CONCAT(). Let us first create a table −mysql> create table DemoTable ( Name varchar(100), Age int, CountryName varchar(100), PersonInformation text ); Query OK, 0 rows affected (0.67 sec)Following is the query to insert multiple parameter values into a single column. We will do this using the same INSERT command, which is used to insert records in a MySQL table −mysql> insert into DemoTable values('John', 21, 'US', concat_ws('-', Name, Age, CountryName)); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values('Chris', 22, ...
Read MoreSelect into a user-defined variable with MySQL
For user-defined variables, we use @ in MySQL. Following is the syntax. Here, @anyVariableName is our user-defined variable −select yourColumnName into @anyVariableName from yourTableName where yourCondition;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.73 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(Name) values('Chris'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable(Name) values('Robert'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable(Name) values('David'); Query OK, 1 row affected (0.10 sec)Display all ...
Read MoreMySQL query to display columns name first name, last name as full name in a single column?
For this, use CONCAT() method in MySQL. Let us first create a table −mysql> create table DemoTable ( FirstName varchar(50), LastName varchar(50) ); Query OK, 0 rows affected (0.63 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris', 'Brown'); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable values('David', 'Miller'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable values('John', 'Doe'); Query OK, 1 row affected (0.08 sec) mysql> insert into DemoTable values('Adam', 'Smith'); Query OK, 1 row affected (0.25 sec)Display all records from the table using select statement ...
Read MoreHow to alter column type of multiple columns in a single MySQL query?
To alter column type of multiple columns in a single MySQL query, the syntax is as follows −alter table yourTableName modify column yourColumnName 1 yourDataType1, modify column yourColumnName 2 yourDataType2, . . N;Let us first create a table −mysql> create table DemoTable ( Id varchar(100), FirstName text, LastName text ); Query OK, 0 rows affected (0.52 sec)Let us check the description of table −mysql> desc DemoTable;This will produce the following output −+-----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | ...
Read MoreGet the count of two table fields in a single MySQL query?
For this, you can use the CASE statement along with SUM(). Here, we will be finding the count of Male and Female records from a column with employee gender values. Let us first create a table −mysql> create table DemoTable ( EmployeeGender ENUM('Male', 'Female') ); Query OK, 0 rows affected (0.52 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Male'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable values('Female'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values('Male'); Query OK, 1 row affected (0.10 sec) mysql> insert into ...
Read MoreWhat is the usage of "@" symbol in MySQL stored procedure?
The @ symbol in a stored procedure can be used for user-defined session variables. Let us first create a table −mysql> create table DemoTable ( StudentName varchar(50) ); Query OK, 0 rows affected (1.30 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('John Smith'); Query OK, 1 row affected (1.00 sec) mysql> insert into DemoTable values('John Doe'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable values('Chris Brown'); Query OK, 1 row affected (0.53 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following output ...
Read MoreFetch records on the basis of LastName using MySQL IN()
Let us first create a table −mysql> create table DemoTable ( FirstName varchar(100), LastName varchar(100) ); Query OK, 0 rows affected (0.83 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Adam', 'Smith'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable values('John', 'Doe'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values('John', 'Smith'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable values('Chris', 'Brown'); Query OK, 1 row affected (0.08 sec) mysql> insert into DemoTable values('Robert', 'Brown'); Query OK, 1 row affected (0.10 sec) mysql> insert ...
Read MoreMySQL query to replace only the NULL values from the table?
For this, you can use the property IS NULL for null values in MySQL. Let us first create a table −mysql> create table DemoTable ( Name varchar(100) ); Query OK, 0 rows affected (0.53 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Robert'); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable values(null); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable values('David'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values(null); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values('Robert'); Query OK, 1 ...
Read MoreDisplay the record with non-duplicate Id using MySQL GROUP BY and HAVING
Let us first create a table −mysql> create table DemoTable ( Id int, ColorName varchar(100) ); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(100, 'Red'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values(101, 'Green'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable values(101, 'Blue'); Query OK, 1 row affected (0.28 sec) mysql> insert into DemoTable values(102, 'Yellow'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable values(100, 'Purple'); Query OK, 1 row affected (0.12 sec) mysql> insert ...
Read MoreDelete last value and fix two new values (VARCHAR Numbers) in MySQL declared as VARCHAR?
Let us first create a table. Here, we have VARCHAR type for value −mysql> create table DemoTable ( Value varchar(100) ); Query OK, 0 rows affected (1.80 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('100'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable values('1244'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable values('15789'); Query OK, 1 row affected (0.18 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following output −+-------+ | Value | +-------+ | 100 | ...
Read More