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
Articles by AmitDiwan
Page 750 of 840
How to make MySQL result set the same as specified?
For this, use MySQL FIND_IN_SET(). Let us first create a table −mysql> create table DemoTable1563 -> ( -> StudentId int, -> StudentName varchar(20) -> ); Query OK, 0 rows affected (0.52 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1563 values(1001, 'Chris'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable1563 values(1010, 'Bob'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable1563 values(1005, 'Chris'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable1563 values(1015, 'David'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable1563 ...
Read MoreSorting max to min value in MySQL
To sort from max to min value, use ORDER BY length(). Let us first create a table −mysql> create table DemoTable -> ( -> Price varchar(20) -> ); Query OK, 0 rows affected (0.92 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('80'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values('800'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable values('108'); Query OK, 1 row affected (0.50 sec) mysql> insert into DemoTable values('765'); Query OK, 1 row affected (0.14 sec)Display all records from the table using ...
Read MoreShould I name the username field in my MySQL table "name" or "user_name"?
Do not prefix table name with field name like user_name. Instead, use user or username.If you prefix table name, then there may be a chance of ambiguity, so avoid prefixing table name.Let us first create a table −mysql> create table user -> ( -> username varchar(20), -> password varchar(20) -> ); Query OK, 0 rows affected (0.66 sec)Insert some records in the table using insert command −mysql> insert into user values('John', 'J_635'); Query OK, 1 row affected (0.34 sec) mysql> insert into user values('Carol', 'Carol2212'); Query OK, 1 row affected (0.16 sec) mysql> insert into user ...
Read MoreCounting voucher value total since the beginning of the month and year in MySQL
For this, use MySQL MONTH() and YEAR() methods. Let us first create a table −mysql> create table DemoTable1562 -> ( -> VoucherValue int, -> RechargeDate date -> ); Query OK, 0 rows affected (1.40 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1562 values(149, '2019-10-21'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable1562 values(199, '2019-10-13'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable1562 values(399, '2018-10-13'); Query OK, 1 row affected (0.25 sec) mysql> insert into DemoTable1562 values(450, '2019-10-13'); Query OK, 1 row affected (0.20 sec)Display all ...
Read MoreMySQL query to fetch multiple least values?
For this, you can use a sub query along with MIN(). Let us first create a table−mysql> create table DemoTable -> ( -> Name varchar(20), -> Score int -> ); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('John', 56); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable values('John', 45); Query OK, 1 row affected (0.24 sec) mysql> insert into DemoTable values('John', 58); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable values('Chris', 43); Query OK, 1 row affected (0.15 ...
Read MoreWhat's the most efficient way to pull data from MySQL so that it is formatted with duplicate values
For this, you can use GROUP_CONCAT(). Let us first create a table −mysql> create table DemoTable1561 -> ( -> StudentName varchar(20), -> Title text -> ); Query OK, 0 rows affected (0.60 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1561 values('Adam', 'Learning Java'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable1561 values('Bob', 'Learning C'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable1561 values('Adam', 'Learning Spring and Hibernate Framework'); Query OK, 1 row affected (0.22 sec) mysql> insert into DemoTable1561 values('Carol', 'Learning MySQL from basic'); Query ...
Read MoreFix Error in MySQL syntax while creating a table column with name "index"?
You can’t use the index as a column name because it is a reserved word. For this, you need to use backticks around the column name.If you will use a reserved word as the column name, you can see the following error−mysql> create table DemoTable -> ( -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> index int -> )ENGINE=MyISAM; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int )ENGINE=MyISAM' at line 4Let us first ...
Read MoreDisplay USD currency records with the correct format in MySQL
Use FORMAT() in MySQL to display USD currency records in the correct form. Let us first create a table −mysql> create table DemoTable -> ( -> Amount DECIMAL(15, 4) -> ); Query OK, 0 rows affected (0.75 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(90948484); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(1000000000); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable values(1535353536); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable values(773646463); Query OK, 1 row affected (0.20 sec)Display all records from ...
Read MoreShuffling column values with MySQL?
To shuffle elements, you need to use ORDER BY RAND(). Let us first create a table −mysql> create table DemoTable1557 -> ( -> SubjectId int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> SubjectName varchar(20) -> ); Query OK, 0 rows affected (0.91 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1557(SubjectName) values('MySQL'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable1557(SubjectName) values('MongoDB'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable1557(SubjectName) values('Java'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable1557(SubjectName) values('C'); Query OK, 1 row affected ...
Read MoreUpdate MySQL table on INSERT command with triggers?
Let us first create a table −mysql> create table DemoTable1 -> ( -> Id int, -> FirstName varchar(20) -> ); Query OK, 0 rows affected (0.52 sec)Here is the query to create second table −mysql> create table DemoTable2 -> ( -> EmployeeId int, -> EmployeeName varchar(20) -> ); Query OK, 0 rows affected (0.51 sec)Let us now create a trigger to update MySQL table on insert command −mysql> DELIMITER // mysql> CREATE TRIGGER updateDemoOnInsert -> AFTER INSERT ON DemoTable2 -> FOR EACH ...
Read More