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
MySQLi Articles
Page 222 of 341
MySQL Stored procedure won't fetch the whole table?
You can use SELECT *FROM yourTableName in stored procedure. Let us first create a table −mysql> create table DemoTable654 ( StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentFirstName varchar(100) ); Query OK, 0 rows affected (0.70 sec)Insert some records in the table using insert command −mysql> insert into DemoTable654(StudentFirstName) values('John'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable654(StudentFirstName) values('Sam'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable654(StudentFirstName) values('Mike'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable654(StudentFirstName) values('Robert'); Query OK, 1 row affected (0.12 sec)Display all records from the table using ...
Read MoreHow to change order of items in MySQL?
To change order of items in MySQL, use ORDER BY alias name. Let us first create a table −mysql> create table DemoTable653 (Product1Amount int, Product2Amount int); Query OK, 0 rows affected (0.42 sec)Insert some records in the table using insert command −mysql> insert into DemoTable653 values(400, 250); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable653 values(500, 300); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable653 values(40, 400); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable653 values(200, 450); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable653 values(50, 20); Query ...
Read MoreSearch record with a specific value in MySQL using LIKE or REGEXP?
Let us first create a table −mysql> create table DemoTable651 (Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Value varchar(100)); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command −mysql> insert into DemoTable651(Value) values('Title'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable651(Value) values('course'); Query OK, 1 row affected (0.26 sec) mysql> insert into DemoTable651(Value) values('subject'); Query OK, 1 row affected (0.20 sec)Display all records from the table using select statement −mysql> select *from DemoTable651;This will produce the following output −+----+---------+ | Id | Value | +----+---------+ | 1 | ...
Read MoreMySQL query to count the number of times a specific integer appears in a column for its corresponding value in another column
For this, use aggregate function COUNT(). Let us first create a table −mysql> create table DemoTable650 (Value1 int, Value2 int); Query OK, 0 rows affected (0.83 sec)Insert some records in the table using insert command −mysql> insert into DemoTable650 values(100, 500); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable650 values(100, 500); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable650 values(100, 500); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable650 values(100, 500); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable650 values(200, 500); Query OK, 1 row affected (0.12 sec)Display ...
Read MoreDisplay records from MySQL stored Procedure with IF...THEN...END IF statements
Let us first create a table −mysql> create table DemoTable643 (ClientId int); Query OK, 0 rows affected (0.86 sec)Insert some records in the table using insert command −mysql> insert into DemoTable643 values(1000); Query OK, 1 row affected (0.19 sec)Display all records from the table using select statement −mysql> select *from DemoTable643;This will produce the following output −+----------+ | ClientId | +----------+ | 1000 | +----------+ 1 row in set (0.00 sec)Here is the query to MySQL stored procedure with IF THEN END IF −mysql> DELIMITER // mysql> CREATE PROCEDURE IF_DEMO(argument int) BEGIN DECLARE firstArgument int; DECLARE ...
Read MoreGet employee name from a specific company using MySQL GROUP BY?
Let us first create a table −mysql> create table DemoTable642( EmployeeId int NOT NULL AUTO_INCREMENT PRIMARY KEY, EmployeeName archar(100), EmployeeCompanyNamevarchar(100) ); Query OK, 0 rows affected (0.81 sec)Insert some records in the table using insert command −mysql> insert into DemoTable642(EmployeeName, EmployeeCompanyName) values('John', 'Google'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable642(EmployeeName, EmployeeCompanyName) values('Carol', 'Microsoft'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable642(EmployeeName, EmployeeCompanyName) values('John', 'Amazon'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable642(EmployeeName, EmployeeCompanyName) values('Carol', 'Google'); Query OK, 1 row affected (0.37 sec) mysql> insert into DemoTable642(EmployeeName, EmployeeCompanyName) values('John', 'Flipkart'); ...
Read MoreDisplay result of a table into a temp table with MySQL?
Let us first create a table −mysql> create table DemoTable1 (Id int, Name varchar(100)); Query OK, 0 rows affected (0.89 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1 values(100, 'John'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable1 values(110, 'Chris'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable1 values(120, 'Robert'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable1 values(130, 'David'); Query OK, 1 row affected (0.14 sec)Display all records from the table using select statement −mysql> select *from DemoTable1;This will produce the following output −+------+--------+ | ...
Read MoreSet special characters on values if condition is true in MySQL?
For conditions, use IF(). Let us first create a table −mysql> create table DemoTable637 (ClientId int NOT NULL AUTO_INCREMENT PRIMARY KEY, ClientName varchar(100), ClientAge int ); Query OK, 0 rows affected (0.82 sec)Insert some records in the table using insert command −mysql> insert into DemoTable637(ClientName, ClientAge) values('Chris', 23); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable637(ClientName, ClientAge) values('Robert', 24); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable637(ClientName, ClientAge) values('David', 57); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable637(ClientName, ClientAge) values('Carol', 60); Query OK, 1 row affected (0.13 sec)Display all records ...
Read MoreImplement two conditions for a single column in MySQL for null and empty value
Let us first create a table −mysql> create table DemoTable635( EmployeId int NOT NULL AUTO_INCREMENT PRIMARY KEY, EmployeeName varchar(100) ); Query OK, 0 rows affected (1.24 sec)Insert some records in the table using insert command −mysql> insert into DemoTable635(EmployeeName) values('John'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable635(EmployeeName) values('Sam'); Query OK, 1 row affected (0.27 sec) mysql> insert into DemoTable635(EmployeeName) values(''); Query OK, 1 row affected (0.38 sec) mysql> insert into DemoTable635(EmployeeName) values(null); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable635(EmployeeName) values('David'); Query OK, 1 row affected (0.22 sec)Display all records from the ...
Read MoreMySQL query to display ranks of multiple columns?
For this, use FIND_IN_SET() method. Let us first create a table −mysql> create table DemoTable634 (FirstName varchar(100), Marks int, Age int); Query OK, 0 rows affected (0.69 sec)Insert some records in the table using insert command −mysql> insert into DemoTable634 values('John', 60, 23); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable634 values('Chris', 80, 21); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable634 values('Robert', 70, 24); Query OK, 1 row affected (0.22 sec)Display all records from the table using select statement −mysql> select *from DemoTable634;This will produce the following output −+-----------+-------+------+ | FirstName | Marks ...
Read More