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')) Code (markup): INSERT INTO company (name, url, services_offered) VALUES('company1', 'companyurl1', VALUES('service2', 'service1')) Code (markup): INSERT INTO company (name, url, services_offered) VALUES('company1', 'companyurl1', SET('service2', 'service1')) Code (markup): 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!
Thanks. Yeah. I worked it out now. Something along the lines of: INSERT INTO company (name, url, services_offered) VALUES('company1', 'companyurl1', 'service2,service1') Code (markup):