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 c

Re: dumb question?

2011-07-06 Thread XL Cordemans
gt; From: Rik Wasmus > 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 > erro

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?

2011-07-06 Thread Martin Gainty
e_name FOO 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 +02

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

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 (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 fie

Re: Dumb Question - Moving Data from Access to MySQL

2003-09-22 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 tri

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

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

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 >

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 kn

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 directo

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 Mailli

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