https://www.icyphoenix.com/viewtopic.php?f=17&t=10165&p=62171#p62171
-----------------------------------
mort
Tue 03 Mar, 2020 02:53

Db Query Returning "Error" ?
-----------------------------------
[b]Cancel this![/b]  :oops: 

I wanted to add some more cms/type columns and delete some other columns in config, so I'll just turn them into cms and edit the necessary files! [b]BIG JOB[/b] - but what else am I doing?  And would have to add the "new" cms/max anyway :lol: 

I'm stuck!  :x 

[code linenumbers=false]Db = PDO:

CREATE TABLE `gnu_max` (
  `max3` tinyint(1) NOT NULL DEFAULT '3',
  `max4` tinyint(1) NOT NULL DEFAULT '4',
  `max5` tinyint(1) NOT NULL DEFAULT '5',
  `max6` tinyint(1) NOT NULL DEFAULT '6',
  `max7` tinyint(1) NOT NULL DEFAULT '7',
  `max8` tinyint(1) NOT NULL DEFAULT '8',
  `max9` tinyint(1) NOT NULL DEFAULT '9',
  `max10` varchar(11) NOT NULL DEFAULT '10',
  `max20` varchar(11) NOT NULL DEFAULT '20',
  `max30` varchar(11) NOT NULL DEFAULT '30',
  `max40` varchar(11) NOT NULL DEFAULT '40',
  `max50` varchar(11) NOT NULL DEFAULT '50',
  `max60` varchar(11) NOT NULL DEFAULT '60',
  `max70` varchar(11) NOT NULL DEFAULT '70',
  `max80` varchar(11) NOT NULL DEFAULT '80',
  `max90` varchar(11) NOT NULL DEFAULT '90',
  `max100` varchar(11) NOT NULL DEFAULT '100'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;[/code]

[code linenumbers=false]INSERT INTO `gnu_max` (
VALUES (3, 4, 5, 6, 7, 8, 9, 10, 20, 30, 40, 50, 60, 70, 80, 90, 100);[/code]



It creates the TABLE Ok, but it doesn't matter how I change the VARS - int, tinyint, mediumint,  bigint, varchar, Always gets the same sort of Error? 

I've looked at the Manuals BUT I don't want to join "another" website for one question?

Error

[code linenumbers=false]SQL query:

INSERT INTO `gnu_max` (
VALUES (3, 4, 5, 6, 7, 8, 9, 10, 20, 30, 40, 50, 60, 70, 80, 90, 100)
[/code]
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'VALUES (3, 4, 5, 6, 7, 8, 9, 10, 20, 30, 40, 50, 60, 70, 80, 90, 100)' at line 2

TABLE = 17
INSERT = 17

??  :(  :(


