How to add duplicate varchar values without displaying error in MySQL?

For this, let us see an example and first create a −

mysql> create table DemoTable1409
   -> (
   -> FirstName varchar(20),
   -> UNIQUE KEY UN_FirstName(FirstName)
   -> );
Query OK, 0 rows affected (0.79 sec)

Following is the query to add duplicate varchar −

mysql> alter table DemoTable1409 drop index  UN_FirstName;
Query OK, 0 rows affected (0.40 sec)
Records: 0  Duplicates: 0  Warnings: 0

Insert some records in the table using insert −

mysql> insert into DemoTable1409 values('Chris');
Query OK, 1 row affected (0.18 sec)
mysql> insert into DemoTable1409 values('Chris');
Query OK, 1 row affected (0.11 sec)
mysql> insert into DemoTable1409 values('David');
Query OK, 1 row affected (0.09 sec)

Display all records from the table using select −

mysql> select * from DemoTable1409;

This will produce the following output −

+-----------+
| FirstName |
+-----------+
| Chris     |
| Chris     |
| David     |
+-----------+
3 rows in set (0.00 sec)

AmitDiwan

Updated on 11-Nov-2019 11:08:27

• Related Questions & Answers
• Find average on the basis of corresponding duplicate VARCHAR values in MySQL
• How to add column values in MySQL without using aggregate function?
• MySQL query to avoid displaying duplicates values?
• How to add subtotal to a table column displaying NULL in MySQL?
• Add records from corresponding duplicate values in another column with MySQL
• Resolve ERROR 1064 (42000) that occurred after using varchar (without providing the size)
• Duplicate a MySQL Database without using mysqldump?
• Why does the following error occur in MySQL: ERROR 1062 (23000): Duplicate entry?
• How to select only non - numeric values from varchar column in MySQL?
• How to add +1 to existing MySQL values?
• How to order return duplicate column values only once in MySQL?
• MySQL UNIQUE declaration to avoid inserting duplicate values?
• How to copy from clipboard using tkinter without displaying a window
• How to alter a MySQL Column from varchar(30) to varchar(100)?
• Delete last value and fix two new values (VARCHAR Numbers) in MySQL declared as VARCHAR?