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
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
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
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
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
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
Hi,
I started with lasso 3.x & FMP, jumped to lasso 8.5 with SQLlite (and loved
it), now need to work with MySQL and Laso 8.6 (on Mac mini with Snow Leopard
server 10.6.7 ). I am not a programmer but quite familiar with the traditional
encoding when using lasso. Now the question:
I created
thank you,
raymond
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 28, 2006 16:07
To: Jacob, Raymond A Jr; mysql@lists.mysql.com
Subject: Re: Sorry for the dumb question how do I fix table is full?
I agree it's not very clear. I think Br
least me on how to
increase the max_rows.
Could you give me an example?
Thank you
raymond
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 28, 2006 15:38
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Sorry for the dumb question how d
uettner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 28, 2006 12:43
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Sorry for the dumb question how do I fix table is full?
Raymond, can you post the output of
SHOW TABLE STATUS LIKE 'data';
that should show how big your tabl
ail.
http://jeremy.zawodny.com/blog/archives/000796.html
http://dev.mysql.com/doc/refman/5.0/en/full-table.html
- Original Message -
From: "Jacob, Raymond A Jr" <[EMAIL PROTECTED]>
To: "Dan Buettner" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, June 28, 2006 3:01 P
12:43
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Sorry for the dumb question how do I fix table is full?
Raymond, can you post the output of
SHOW TABLE STATUS LIKE 'data';
that should show how big your table is and how big it can be...
Dan
On 6/28/06, Jacob, Raym
Raymond, can you post the output of
SHOW TABLE STATUS LIKE 'data';
that should show how big your table is and how big it can be...
Dan
On 6/28/06, Jacob, Raymond A Jr <[EMAIL PROTECTED]> wrote:
Environment: Freebsd 6.0
Mysql : mysql Ver 14.7 Distrib 4.1.18, for porbld-freebsd6.0 (i386)
usin
Environment: Freebsd 6.0
Mysql : mysql Ver 14.7 Distrib 4.1.18, for porbld-freebsd6.0 (i386)
using 5.0
On the client, I get /var/log/messages, I get the errors:
kernel: 9643D22706C
and
database: mysql_error: The table 'data' is full SQL=INSERT INTO data
(sid,cid,data_payload) VALUES"
I hav
Василий Петров 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
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 name))
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
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 tried: INSERT INTO
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
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
-> 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 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 in commands and it just does another -> What is that?
Thank you,
> -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
> 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
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
t: Friday, September 21, 2001 2:36 PM
Subject: Dumb Question...
> Okay, I know this is an RTFM question, but I tried, and I couldn't find
> it in the online manual.
>
> I was looking at the /var/lib/mysql directory today, where all my
> databases are, and I noticed a bunch of
Okay, I know this is an RTFM question, but I tried, and I couldn't find
it in the online manual.
I was looking at the /var/lib/mysql directory today, where all my
databases are, and I noticed a bunch of -bin files. What /are/
those, and are they something I need to be concerned about?
--
Matthew
27 matches
Mail list logo
