MYSQL INSERT not adding values to table

user_14262977 0
Viewed 80

I am using the INSERT function to try and add new values to a table. While there is no error when I run the query, it is not showing the new attributes added to the table. I have no idea why. I also have safe updates turned off. The values entered also match the value type for each column of the table.

CODE ENTERED:

INSERT INTO productlines
VALUES 
('Jet Packs', 'Futuristic flying machines that only exist in prototype.', NULL, NULL),
('Jet Skis', 'Much more realistic things that very much exist already.', NULL, NULL),
('Wheelbarrows', 'I cannot believe we actually stock these.', NULL, NULL);

SELECT *
FROM productlines;


CREATE TABLE `productlines` (
  `productLine` varchar(50) NOT NULL,
  `textDescription` varchar(4000) DEFAULT NULL,
  `htmlDescription` mediumtext,
  `image` mediumblob,
  PRIMARY KEY (`productLine`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
sql-insert mysql
1 Answers
INSERT INTO 
    [name of your **TABLE**](col1, col2, col3)#NAME OF YOUR COLUMNS
VALUES
    ('value for col1','value for col2','value for col3'),

You didn't add the column names for which you are performing the insert

user_125136930
Related