The REPEAT()
function is used to repeat a given string a certain number of times.
REPEAT(string,repeating_number)
string
: This represents the string to be repeated.repeating_number
: This specifies the number of times the string will be repeated.Let’s query the Writer
table and repeat the character b
in each book_id
once.
The following code shows how to use the REPEAT()
function in SQL:
CREATE TABLE Writer (id int,name varchar(50),gender varchar(10),state varchar(15),book_id varchar (20));-- Insert dataINSERT INTO WriterVALUES (101,'Sharon Peller','Female','Kogi','oo-01-345');INSERT INTO WriterVALUES (102,'Paul Dons','Male','Lagos','oo-01-238');INSERT INTO WriterVALUES (103,'Ameera Abedayo','Female','Imo','oo-01-103');INSERT INTO WriterVALUES (104,'Maria Elijah','Female','Lagos','oo-01-775');INSERT INTO WriterVALUES (105,'David Hassan','Male','Abuja','oo-01-788');INSERT INTO WriterVALUES (106,'Mara Disu','Female','Lagos','oo-01-924');INSERT INTO WriterVALUES (108,'Joe Smith','Male','Lagos','oo-01-245');-- QuerySELECT id,CONCAT(REPEAT('b',1),book_id) AS new_bkid, nameFROM Writer;
In the code above:
Writer
which has the columns id
, name
, gender
, state
, and book_id
.Writer
table.b
to each data point in the book_id
using REPEAT()
and then concatenate it with each book’s ID using the CONCAT()
function. Finally, we display the result.