Puppy Linux Discussion Forum Forum Index Puppy Linux Discussion Forum
Puppy HOME page : puppylinux.com
"THE" alternative forum : puppylinux.info
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

The time now is Mon 24 Nov 2014, 01:43
All times are UTC - 4
 Forum index » Off-Topic Area » Programming
creating tables in php leads to errors in phpmyadmin....
Post new topic   Reply to topic View previous topic :: View next topic
Page 1 of 1 [3 Posts]  
Author Message
sayhello_to_the_world

Joined: 24 Dec 2012
Posts: 43

PostPosted: Wed 06 Aug 2014, 07:06    Post subject:  creating tables in php leads to errors in phpmyadmin....  

what is dificult in creating this tables...

Code:
CREATE TABLE `pois` (
  `id` bigint(20) unsigned NOT NULL,
  `lat` float(10,7) NOT NULL,
  `lon` float(10,7) NOT NULL,
  PRIMARY KEY (`id`)
)

CREATE TABLE `pois_tag` (
  `poisid` int(11) NOT NULL DEFAULT '0',
  `tagname` varchar(45) NOT NULL DEFAULT '',
  `tagvalue` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`poisid`,`tagname`)
)


i get back the following error ;

Code:

MySQL meldet: Dokumentation
#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 'CREATE TABLE `pois_tag` (
  `poisid` int(11) NOT NULL DEFAULT '0',
  `tagname`' at line 8

many thanks for any and all help
Back to top
View user's profile Send private message 
ebisu

Joined: 25 Sep 2013
Posts: 42

PostPosted: Wed 06 Aug 2014, 07:14    Post subject:  

Just another crosspost from our OpenSuse friend
http://www.linuxforums.org/forum/newbie/202365-creating-tables-php-leads-errors-phpmyadmin.html
Back to top
View user's profile Send private message 
technosaurus


Joined: 18 May 2008
Posts: 4376

PostPosted: Wed 06 Aug 2014, 16:36    Post subject:  

Programming is in the Off-Topic Area, so here is a little table humor, that I hope you find funny rather than eye-opening.



Any particular reason it looks like you are using backticks instead of single quotes??? That could be it, but then again I never felt the need to use backticks.

_________________
Web Programming - Pet Packaging 100 & 101
Back to top
View user's profile Send private message 
Display posts from previous:   Sort by:   
Page 1 of 1 [3 Posts]  
Post new topic   Reply to topic View previous topic :: View next topic
 Forum index » Off-Topic Area » Programming
Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.0426s ][ Queries: 11 (0.0033s) ][ GZIP on ]