Re: dumb question?

2011-07-07 Thread XL Cordemans
: From: Rik Wasmus rik.was...@grib.nl Subject: Re: dumb question? To: mysql@lists.mysql.com Date: Wednesday, July 6, 2011, 10:27 PM On Wed, 2011-07-06 at 07:15 -0700, XL Cordemans wrote: (error code) 1064 (error message) HY000 [Actual][MySQL] You have an error in your SQL syntax; check

Re: dumb question?

2011-07-07 Thread Hal�sz S�ndor
2011/07/06 23:56 -0700, XL Cordemans Goede morgen, and thank you for your suggestion. I am actually wondering if the difference between lasso 8.1 and 8.6 is so big that traditional lasso code can not be used when connecting w/ MySQL ? You mentioned ... This can be done in the server

Re: dumb question?

2011-07-06 Thread Rik Wasmus
On Wed, 2011-07-06 at 07:15 -0700, XL Cordemans wrote: (error code) 1064 (error message) HY000 [Actual][MySQL] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DMPPRuser) VALUES ('MYNAME')' at line 1

Re: dumb question?

2011-07-06 Thread Rik Wasmus
On Wed, 2011-07-06 at 16:27 +0200, Rik Wasmus wrote: On Wed, 2011-07-06 at 07:15 -0700, XL Cordemans wrote: (error code) 1064 (error message) HY000 [Actual][MySQL] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax

RE: dumb question?

2011-07-06 Thread Martin Gainty
VALUES('VALUES ARE ALWAYS SURROUNDED BY TICK MARKS UNLESS ANSI_QUOTES ARE ENABLED'); Bedankt, Martin Subject: Re: dumb question? From: rik.was...@grib.nl To: mysql@lists.mysql.com Date: Wed, 6 Jul 2011 16:39:16 +0200 On Wed, 2011-07-06 at 16:27 +0200, Rik Wasmus wrote: On Wed, 2011-07

RE: dumb question?

2011-07-06 Thread Rik Wasmus
On Wed, 2011-07-06 at 11:03 -0400, Martin Gainty wrote: Rik and Crew Please keep your replies to the list only, I don't need to double on e-mail... String values are always ticked VALUES('MYNAME') unless ANSI_QUOTES are enabled Column names are never surrounded by ticks or double quotes

Re: Dumb question (joining tables)

2004-06-17 Thread gerald_clark
wrote: I have large fact table, in which there are much ids (that are in fact foreign keys but as long as I use MyISAM engine them are not technically). So when I try to join another table (that contains text descriptions for each id from one of fact columns, so it has two fields (id (PK) and

Re: Dumb Question - Moving Data from Access to MySQL

2003-09-23 Thread Daniel Kasak
Jeremy Proffitt wrote: Dumb Question. I need to move my data from their current access database to my new MySQL server through an ODBC connection. The tables on both ends are set up identially. I have added a linked table to the access database called EXPARTAB1. The data is in EXPARTAB. I

Re: Dumb Question: Listing tables in telnet

2001-11-18 Thread denis
- is a continuatin line for your sql stamement. Remember yo conclude your statement with a semi=colon... Denis Todd Williamsen wrote: I looked all through the documentation for this and I cannot find the command for listing tables in mysql in telnet. I get this: Mysql show tables - I

Re: Dumb Question: Listing tables in telnet

2001-11-18 Thread Jason Wong
On Monday 19 November 2001 01:25, Todd Williamsen wrote: I looked all through the documentation for this and I cannot find the command for listing tables in mysql in telnet. I get this: Mysql show tables - I have no idea what the arrow does and what I am suppose to do with it. I type

Re: Dumb Question: Listing tables in telnet

2001-11-18 Thread Erik Price
Todd, The arrow is like the PS2 prompt from your shell in Unix. That is, the first line of your command says Mysql and every line thereafter is just a greater-than. This is because the mysql client is waiting for more commands. You can enter more than one command at a time this way, and not

Re: Dumb Question...

2001-09-21 Thread Matthew Simpson
Don't feel badly, I wondered the same thing! In a nutshell, they are logs, and you can delete them. You can also turn them off (I did). - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: MySQL Mailling List [EMAIL PROTECTED] Sent: Friday, September 21, 2001 2:36 PM

RE: Dumb Question...

2001-09-21 Thread Matthew Walker
PROTECTED] Subject: Re: Dumb Question... Don't feel badly, I wondered the same thing! In a nutshell, they are logs, and you can delete them. You can also turn them off (I did). - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: MySQL Mailling List [EMAIL PROTECTED] Sent

RE: Dumb Question...

2001-09-21 Thread Carsten H. Pedersen
Okay, I know this is an RTFM question, but I tried, and I couldn't find it in the online manual. Try loading the manual, then do your browsers equivalent of find in page, and search for -bin 3 or 4 searches on next occurence, and you're there I was looking at the /var/lib/mysql directory

RE: Dumb Question...

2001-09-21 Thread Carsten H. Pedersen
-Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 9:48 PM To: 'Matthew Simpson' Cc: [EMAIL PROTECTED] Subject: RE: Dumb Question... How would I go about turning them off? Yes, I know. Another RTFM question, but some