Inserting a row with a set.

[blackbug]

I'm trying to remember how insert a row into a database where one of the columns is a set. I'm trying:


INSERT INTO company (name, url, services_offered)
VALUES('company1', 'companyurl1', ('service2', 'service1'))



INSERT INTO company (name, url, services_offered)
VALUES('company1', 'companyurl1', VALUES('service2', 'service1'))



INSERT INTO company (name, url, services_offered)
VALUES('company1', 'companyurl1', SET('service2', 'service1'))


And anything else I can invent :)

I've set the right values for the column when defining the table.

But I can't remember how to do it. Someone put me out of my misery, please!

[l234244]

What exactly is the SET command doing, determining the length of characters before wrapping text?

[Sham]

I think he means list of values?....

[blackbug]

:) Thanks. Yeah.

I worked it out now.

Something along the lines of:

INSERT INTO company (name, url, services_offered)
VALUES('company1', 'companyurl1', 'service2,service1')