SQL

insert multiple values into one column sql

INSERT INTO Data ( Col1 ) VALUES
('Hello'),
('World');

how to insert multiple values in a single column in sql

mysql> insert into InsertMultipleDemo(UserRole) values('Admin'),('Author'),('Driver'),('Guest');
Query OK, 4 rows affected (0.17 sec)
Records: 4 Duplicates: 0 Warnings: 0