I was lucky enough to have gotten a copy of MySQL 10 (aka MySQL X)
from the source tree before it was pulled.
The query optimizer used predictive algorithms with temporal
displacement logic, which meant that it could and did frequently
return results in negative time, before the query was
Eric Anderson wrote:
I've got a master (Master) with a MERGE table of foo_t (comprising of
bar_a, bar_b, bar_c) in database 'Igloo'.
There are 5 slaves that replicate the Igloo table, but ignore the
Igloo.foo_t table.
This setup was working fine. If the Master server crashed or had a
prb
Daniel Kasak schrieb:
Andreas Moroder wrote:
Daniel Kasak schrieb:
You won't break anything by adding a timestamp field. Trust us :)
And no, there is no way around this problem other than adding a
timestamp field.
From the 'mysql' command-line client, do:
... where DATABASE_NAME is the nam
At 06:30 PM 8/24/2006, David Hillman wrote:
On Aug 24, 2006, at 6:13 PM, Daniel Kasak wrote:
That's just how software develops. People start with the later- versioned
product, with full features and zero bugs, and progressively remove
features and add bugs, while decreasing the version number.
Andreas Moroder wrote:
> Daniel Kasak schrieb:
>> Andreas Moroder wrote:
>>
>>> Hello,
>>>
>>> when I open mysql table with access 97 using the latet mysql-odbc
>>> driver ( 3.51.12 ) I see only deleted records.
>>>
>>> What is happening ?
>>>
>>> I found many posts about this problem, but I can no
Daniel Kasak schrieb:
Andreas Moroder wrote:
Hello,
when I open mysql table with access 97 using the latet mysql-odbc
driver ( 3.51.12 ) I see only deleted records.
What is happening ?
I found many posts about this problem, but I can not, as told in this
posts, add timestamp or other fields
Andreas Moroder wrote:
> Hello,
>
> when I open mysql table with access 97 using the latet mysql-odbc
> driver ( 3.51.12 ) I see only deleted records.
>
> What is happening ?
>
> I found many posts about this problem, but I can not, as told in this
> posts, add timestamp or other fields because thi
Hello,
when I open mysql table with access 97 using the latet mysql-odbc driver
( 3.51.12 ) I see only deleted records.
What is happening ?
I found many posts about this problem, but I can not, as told in this
posts, add timestamp or other fields because this tables are used by a
applicatio
On Aug 24, 2006, at 6:13 PM, Daniel Kasak wrote:
That's just how software develops. People start with the later-
versioned
product, with full features and zero bugs, and progressively remove
features and add bugs, while decreasing the version number.
I've looked all over the web, and found
Karl Larsen wrote:
>I wrote my first VIEW in version 5 and it works just fine. It will
> be a powerful way to generate output for the Bosses. Why it was taken
> out on version 4 I have no idea.
That's just how software develops. People start with the later-versioned
product, with full feature
I wrote my first VIEW in version 5 and it works just fine. It will
be a powerful way to generate output for the Bosses. Why it was taken
out on version 4 I have no idea.
Karl Larsen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
Bummer! I was hoping that you'd see what actually gets executed
during a SHOW DATABASES, like "select * from user, table_privs where
" so you could then run an EXPLAIN on it.
For me on 5.0.21 EXPLAIN SHOW DATABASES gives me an error so no joy there.
I suspect you've got a lot more entries i
On 8/24/06, João Cândido de Souza Neto <[EMAIL PROTECTED]> wrote:
You ought to choice one of these ways:
while ($row=mysql_fetch_row($result)){
echo "$row[1] \n";
}
OR
$row = mysql_fetch_row($result);
do {
echo "$row[1] \n";
} while ($row=mysql_fetch_row($result));
"Marcelo Fabi
You ought to choice one of these ways:
while ($row=mysql_fetch_row($result)){
echo "$row[1] \n";
}
OR
$row = mysql_fetch_row($result);
do {
echo "$row[1] \n";
} while ($row=mysql_fetch_row($result));
"Marcelo Fabiani" <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED
I think there is an error in your PHP logic. The line of code before the
while will cause the first row of $result to be retrieved, and will move the
cursor. That first row will never be used because the condition inside the
while will retrieve the next record right away.
$row = mysql_fetc
Hi to all the group, I have a problem with a query using mysql
4.01+mysql+php
This is the form i use to get the data for the query:
http://www.ibtec.info/resbu.php";>
Ingrese palabra a buscar
and here is the php i use
\n";
$row = mysql_fetch_row($result);
while ($row=m
why did they change this? I reverted everything to 5.0.19 and I'm
using load data infiles again, with zero locking issues
It has always been like that.
load data infile seems to use different logic from replace delayed,
it does not lock at all
What table type do you have in each version
You still get two lines, it's just that one of the lines is blank, and the
other says, "text to the screen".
Jesse
- Original Message -
From: "Wai-Sun Chia" <[EMAIL PROTECTED]>
To: "Dan Buettner" <[EMAIL PROTECTED]>
Cc: "Jesse" <[EMAIL PROTECTED]>; "MySQL List"
Sent: Thursday, August
I've got a master (Master) with a MERGE table of foo_t (comprising of
bar_a, bar_b, bar_c) in database 'Igloo'.
There are 5 slaves that replicate the Igloo table, but ignore the
Igloo.foo_t table.
This setup was working fine. If the Master server crashed or had a
prblem for some reason, I
Hi Andreas,
On the local host using mysql database. Execute the following command at
mysql prompt:
Mysql>grant all privileges on [database_name].* to 'user'@'remote_host'
identified by 'password'
Please read more about this at
http://dev.mysql.com/doc/refman/4.1/en/grant.html or whatever versio
You ought to look at the field Host in the table Users In the db Mysql. This
field set from where this user can access. If you put a % simbol in it the
user could access from any host, or if this user can access only from on
host, you must put in this field the IP of the host.
Hope help.
"Andr
Hello,
I have a mysql DB running on a Windows XP machine.
I can access it locally via mysql command, I have also a ODBC driver
installed and the test says it works ok.
When I try to connect from a remote host via JDBC I get the error
message that this host is not allowed to access the db.
How
Yeah, my customer wasn't too pleased when his product search could only find
certain colors. ;<)
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Se
Nico, as a first stab, I would try optimizing the tables in question.
OPTIMIZE TABLE mysql.user
etc.
The one with 194,177 entries would be a good candidate for this especially.
done, but with no improvement
I wonder also if you would see something logged in the slow query log
as this happe
You might come close by using a combination of tee, select, and notee
commands. You didn't say if this was for debugging, which would tolerate a
lot of ugly, or not.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
On Thu, Aug 24, 2006 at 12:43:56AM -0400, Rhino wrote:
>
> - Original Message -
> From: "Dave Shariff Yadallee - System Administrator a.k.a. The Root of the
> Problem" <[EMAIL PROTECTED]>
> To:
> Sent: Wednesday, August 23, 2006 10:15 PM
> Subject: Chemistry search
>
>
> >Has anyone c
Hello all,
I am currently working on redesigning a database structure for online
translation utility called Entrans [1].
Entrans is quite nice piece of software, but unfortunately it has one
major design flaw: it only supports languages which have only two plural
forms and to fix this issue, a dat
Rhino wrote:
What do you mean by "mols" - molar weights?
yup... i mean, probably... ;)
And why would anyone search for anything to do with chemicals based on
smilies? How would ":-)" or symbols like that help? Or is this some
other sense of the word "smilies" than the customary Internet one
Chris wrote:
The most common "next search" becomes the "did you mean".
Yes, that might work well, but I wouldn't use it out of the box. I would
send a report to a human first to use that information instead of doing
it automatically.
Imagine someone searching for "cous" (instead of "cows")
hi
Hope there is no privilege type of REPAIR [Repair Table] supported by MySQL
Server.
use
>SHOW PRIVILEGES;
SHOW PRIVILEGES shows the list of system privileges that the MySQL server
supports. The exact list of privileges depends on the version of your server.
For the global, database, table
Vielen Dank für die Hinweise; grant ... wird mir weiterhelfen.
Gruss, Gregor.
Dominik Klein schrieb:
Guten Morgen Gregor
beim nächsten mal antworte bitte an die Liste.
Beispiel:
User "gregor" soll auf datenbank.tabelle1 nur lesend zugreifen können,
auf datenbank.tabelle2 auch schreibend.
A
31 matches
Mail list logo
