http://www.mysql.com/truncate
- Rich
From: Fabio Bernardo <[EMAIL PROTECTED]>
To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
Subject: empty a table
Date: Tue, 10 Jun 2003 18:32:57 -0300
Hi there, Im a new user
Whats the statemant to empty a table... I mean
I dont wanna delete one or two rows ..
Are there any open-source database front-ends that have similar
functionality to MS Access? We're currently using Access with tables
linked
to MySQL, but find it leaves something to be desired when it comes to
stability and license flexibility. We'd really like to move to something
open-source.
Hi,
if (stop < start, stop, CONCAT(stop, '+++'))
should do the trick.
- Rich
hello dear all,
i need to make a select on mysql with IF funcion:
if ('stop' <'start', stop, '+++')
where start and stop are timestamps.
and [+++] is an error char.
Actually my select result are:
+--+--
Is there a way to put a database offline? So doing i could work on it with
myisamchk being sure that mysqld cannot touch the files... and no
corruptions should happen!
I have heard of people doing stuff with locking tables so no-one can write
to them, flushing them to close the files, then runnin
Hi,
Hi all
I've recently moved a database to MySQL from MSSQL, and am running it on
a Windows 2000 Server.
Can anybody advise me on the best method for running regular maintenance
tasks (i.e. optimize and analyze)?
First, I would question that you even need to optimize and analyze "on a
regular
"Mojtaba Faridzad" <[EMAIL PROTECTED]> wrote:
> I'm learning MySQL and I got two question:
>
> 1) As I know, MySQL has a buffer to keep the last records which have
been retreived. So if I run a query two times, the second time will be
faster. How can I temporarly stop this service? because I want
Has anyone else tried this? I got 8/10. Going to the exam next week;
I suppose that's a good sign :-)
http://www.mysql.com/certification/selftest/core/index.php
- Rich
_
The new MSN 8: advanced junk mail protection and 2 months FREE*
I take this to mean that you want to installations of MySQL operating on
the
same data. That, I believe, could get quite messy, if it's even possible.
I don't see why it should be a problem. Data files are binary compatible
between
OS's, and by definition, one instance of mysqld will be shut dow
t the
list once again with a "sorry, wrong subject" though...
- Rich
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "rich johnson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, 10 June, 2003 04:57
Subject: Storin
Hi List,
This is my first mail in this list and thanks in advance.
Does anyone know what version of Mysql has Unicode support for full text
searching? I have a database with information in four languages
(english, german, greek and spanish) in unicode and I would like to do
full text searching.
You
Hi,
Short question: I understand that MySQL in some circumstances
may decide that it's faster to do a full table scan rather than use
the index to look up values.
But I miss some information on *when* this happens. Is there some
way, short of reading the source code, that one can get some more
det
11 matches
Mail list logo
