https://www.icyphoenix.com/viewtopic.php?f=17&t=10165
-----------------------------------
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

??  :(  :(


-----------------------------------
Informpro
Thu 05 Mar, 2020 13:12

Re: Db Query Returning &quot;Error&quot; ?
-----------------------------------
Hi mort.

This is invalid:

[code]INSERT INTO `gnu_max` ([/code]

You need to list the columns there between ( and ), or just remove that (


-----------------------------------
mort
Thu 05 Mar, 2020 14:24

Re: Db Query Returning "Error" ?
-----------------------------------
No, I'm the problem!  :P 

I left the semi-quote off the end of values.. and it won't install if any of the brackets are removed ?

Here's what works. And there isn't going to be any data - They are just for switching.  :mricy: 

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

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


-----------------------------------
mort
Thu 12 Mar, 2020 07:20

Re: Db Query Returning "Error" ?
-----------------------------------
The real Problem was [b]`max3`[/b]is SQL - where [b]max3[/b] is PHP


