Jump to content

INSERT query issue


Firestorm3d

Recommended Posts

So im trying to get this insert to work

INSERT INTO astro_bases (baseID, coord, Urban, Solar, Gas, Fusion, Antimatter, Research, Metal, Crystals, Robotic, Shipyards, Orbital Shipyards, Spaceports, Command, Nanite, Androids, Economic, Terraform, Multi-Level, Orbital Base, Jump Gate, Barracks, Laser, Missile, Plasma, Ion, Photon, Disruptor, Deflection, Planetary Shield, Planetary Ring, playerID) VALUES ( 47889, 'C25:44:61:31', 24, 0, 0, 18, 10, 0, 25, 25, 20, 20, 2, 25, 18, 15, 10, 16, 19, 8, 5, 1 10, 15, 18797)

 

but it keeps hanging up at 'Shipyards, Orbital Shipyards, Spaceports, Command, Nanite, Androids, Economic, Terraform, Multi-Lev' it says.

baseID tinyint(50) No

coord varchar(50) No

Urban tinyint(25) Yes NULL

Solar tinyint(25) Yes NULL

Gas tinyint(25) Yes NULL

Fusion tinyint(25) Yes NULL

Antimatter tinyint(25) Yes NULL

Research tinyint(25) Yes NULL

Metal tinyint(25) Yes NULL

Crystals tinyint(25) Yes NULL

Robotic tinyint(25) Yes NULL

Shipyards tinyint(25) Yes NULL

Orbital Shipyards tinyint(25) Yes NULL

Spaceports tinyint(25) Yes NULL

Command tinyint(25) Yes NULL

Nanite tinyint(25) Yes NULL

Androids tinyint(25) Yes NULL

Economic tinyint(25) Yes NULL

Terraform tinyint(25) Yes NULL

Multi-Level tinyint(25) Yes NULL

Orbital Base tinyint(25) Yes NULL

Jump Gate tinyint(25) Yes NULL

Biosphere Mod tinyint(25) Yes NULL

Barracks tinyint(25) Yes NULL

Laser tinyint(25) Yes NULL

Missile tinyint(25) Yes NULL

Plasma tinyint(25) Yes NULL

Ion tinyint(25) Yes NULL

Photon tinyint(25) Yes NULL

Disruptor tinyint(25) Yes NULL

Deflection tinyint(25) Yes NULL

Planetary Shield tinyint(25) Yes NULL

Planetary Ring tinyint(25) Yes NULL

playerID tinyint(25) No

date timestamp No CURRENT_TIMESTAMP

 

that is the table im trying to insert into.

 

 

 

 

Link to comment
https://forums.phpfreaks.com/topic/115210-insert-query-issue/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.