on 12/18/2002 11:39 PM, Dan at [EMAIL PROTECTED] wrote:
http://worldcommunity.com/opensource/utilities/mysql_backup.html
I've heard great things about this script and I'm just about to start using
it myself.
Am I wrong, but it seem this script dumps each table to a separate file,
what is
hi,
i would like to create a dual master/slave replication with mysql
i think i wouldn't have any problem but i wonder how mysql manage
auto_increment id ...
how it works ?
maxime
-
Before posting, please check:
Hi,
I've been trying to import a huge .txt file into a MySql table. In the .txt file,
missing values are recorded as empty cells (it might be that there's some hidden
character instead, but I wouldn't know how to figure that out). When I LOAD DATA
INFILE, MySql writes the missing values as
Dobrý den,
quarta-feira, 18 de dezembro de 2002, 13:10:07, napsal jste:
MTB Qunfeng Dong wrote:
Another thing, with some linux system, there is a size
limit for file. MySQL seems to store each of its table
as single file. You need to choose a file system
without that limit.
MTB Just use
I'm working with MySQL 3.23.36 so, according to MySQL, Paul Dubois, New
Riders running the query:
DELETE FROM my_table_name
should reset the auto-increment value... but it doesnt'.
What SQL do I use to reset the val.
You can't believe anything that book says. The author didn't even include
http://www.mysql.com/doc/en/SET_OPTION.html
last option(s)
maybe you can do somehting with that
Gr
At 10:54 19-12-02 +, Jeff Snoxell wrote:
I'm working with MySQL 3.23.36 so, according to MySQL, Paul Dubois, New
Riders running the query:
DELETE FROM my_table_name
should reset the
MySQL may be new compared to Oracle, for example, but many other
in-use DBs are in fact fairly new designs. They just happen to be
written by* large companies you recognize every day.
Any ideas about Postgresql vs. MySQL? I have always preferred MySQL
because of the speed, but I have heard
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 18 Dec 2002, Jeremy Zawodny wrote:
But, yeah, I agree. There are better ways to do this on the mail server
side.
Yes, and it's on our list-admin's TODO to move this list to another list
server very soon. Please be patient for just a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 19 Dec 2002, Stan Sebastian wrote:
Is there any GUI for the server part of MySQL fro Windows. I mean not a
client for MySQL, like SQLyog OR MySqlFront.
Something better then the MySqlAdmin?
Have you looked at MySQLCC yet?
Hello,
Mysql server is working good for 5-10 minutes and then changes directory
to /tmp - it starts telling ERROR 1049: Unknown database 'test'.
Restarting the server helps for next 5-10 minutes. There are no errors
in error-log, query log etc.
SHOW VARIABLES still telling datadir from cnf file.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 19 Dec 2002, Dino Fabrello wrote:
Mysql server is working good for 5-10 minutes and then changes directory
to /tmp - it starts telling ERROR 1049: Unknown database 'test'.
Restarting the server helps for next 5-10 minutes. There are no
Mysql server is working good for 5-10 minutes and then changes
directory to /tmp - it starts telling ERROR 1049: Unknown database
'test'.
Restarting the server helps for next 5-10 minutes. There are no errors
in error-log, query log etc.
SHOW VARIABLES still telling datadir from cnf file.
mysqlhotcopy always worked fine with perl 5.6.1 (debian woody), but i had
to upgrade to perl 5.8 and now it croaks and dies with a segfault.
the problem exists only with mysqlhotcopy; other db-connections with
perl 5.8 and DBI/DBD::mysql are no problem.
at http://volltext.net/mysql/strace.txt
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 19 Dec 2002 [EMAIL PROTECTED] wrote:
Description:
with the latest 4.1 tree (from today) the PASSWORD() function returns random
alpha-numeric text /[a-f0-9]/
45 characters in length (which is too long for a password string).
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 18 Dec 2002, Nicholas Gaugler wrote:
Thanks, I downloaded it and it all works fine now, the whole bin
directory is statically linked.
Thanks for the confirmation! Glad it works now.
Bye,
LenZ
- --
For technical support contracts,
Hi,
The performance problem on his query was due to the missing index on join
columns.
However I was assuming using table1 INNER JOIN table2 ON condition would
have helped the optimiser to choose the tables on which it had to perform
the join.
Regards,
Jocelyn
- Original Message -
Hi!
Mark Hi,
Gary I'd like to add to the security flaw thread with my own experience.
Gary I have been hosting MySQL databases for over 2 years and on a few occasions
Gary have had user databases disappear.
Gary Last month one of my admin databases was dropped. The only user
Gary
I have a table with 17,168,035 records. I have the following column
types and I read about the following storage requirements for each
column:
(1) INT Column - Should take up 4 bytes each
(1) MEDIUMINT Column- Should take up 3 bytes each
(1) DATE Column - Should take up 3
Did you optimze the table first?
warning optimize could take long (and i think the table is locked while
doing it)
Gr,
Wico
At 08:26 19-12-02 -0500, Andrew Kuebler wrote:
I have a table with 17,168,035 records. I have the following column
types and I read about the following storage
Why isn't Seq_ID not an unsigned int? Primary key should always be
something generated by the system that has no other significance than
being a primary key. If there actually is a seq_id piece of data that
has some other significance, I wouldn't use it to link all your data.
Then you don't
Hi,
I have been searching tables based on search values which turn up tobe fine,
however the results dont reflect case sensitivity.
what i mean,
if i run following query
select field1 from table1 where name='text1';
this works fine but returns the same result set with text1 values of 'USER'
or
Hello ... my name is Brent ..and im using the latest version of mysql
on a Freebsd box with apache php3 php4. My problem is that ive set a
password for the root mysql user by doing:
/usr/local/bin/mysqladmin -u root password 'x'
then i installed phpMyAdmin ..and set the correct username
You have two choices, you can use a binary datatype for the field, or force
a binary comparison using the BINARY operator.
http://www.mysql.com/doc/en/Case_Sensitivity_Operators.html
http://www.mysql.com/doc/en/Column_types.html
query, sql
Mike
-Original Message-
From: asp52
mysql needs a few more bytes per record for its internal use.
Since you use a VARCHAR, you have dynamic length records;
this is described in the manual:
http://www.mysql.com/doc/en/Dynamic_format.html
Regards,
Joseph Bueno
Andrew Kuebler wrote:
I have a table with 17,168,035 records. I have the
Thanks,
Just worked it out with binary statement in my query.
all fine.
Would it be wise to use binary type table?
didnt try that as i wanted a flexible table of type varchar to perserve
space.
what would be its impact?
cheers.
Adamji
From: Mike Grabski [EMAIL PROTECTED]
To: 'asp52' [EMAIL
See http://www.mysql.com/doc/en/CHAR.html or
http://www.mysql.com/doc/en/BLOB.html .
If your column types are CHAR or VARCHAR insert BINARY.
If your column type is TEXT, change to BLOB.
--
You said
Hi,
I have been
You can specify a varchar field as binary, for instance: field1 varchar(50)
binary
query, sql
Mike
-Original Message-
From: asp52 [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 9:50 AM
To: Mike Grabski; [EMAIL PROTECTED]
Subject: Re: Case sensitivity
Thanks,
Just worked
When you mentioned the number of bytes, is that just the data part of the
table, or the index as well? You didn't mention if your schema was indexed
one way or another.
Cheers.
-Dana
-Original Message-
From: Joseph Bueno [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 8:44
At 09:46 19/12/02 -0500, you wrote:
Jeff Snoxell wrote:
Nope. That doesn't do it either!
I go:
TRUNCATE TABLE my_table
Are you using InnoDB tables? You'll have to do something akin to ALTER
TABLE my_table AUTO_INCREMENT=1 ... at least according to Paul ... :)
No, I'm using MyISAM I
replace missing value (NULL) as \N in your .txt file
--- Gianluca Carnabuci [EMAIL PROTECTED] wrote:
Hi,
I've been trying to import a huge .txt file into a
MySql table. In the .txt file, missing values are
recorded as empty cells (it might be that there's
some hidden character instead, but
While creating InnoDB tables, I was not able to specify a fulltext
column in the table creation sql. Is this a bug or a limitation with InnoDB
? There could be quite a few users who need FULLTEXT feature with InnoDB.
-
Before
Hi Guys,
I'm a lurker on this list but I have decided to come out of my shell for a moment. I a
previous job I was the Oracle DBA for my development team. We had a persistent problem
with Oracle corrupting the development database. Oracle had no idea with the problem
was even after I sent them
Hello, i am new in mysql. I got a problem. I try write
my C program with mysql API.I have 5 field in
table.No,Name,Phone,Date,Time. How can i take one row
where the No is bigger?
Thanks for help.
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful.
Hi,
is there an easy way to programmatically backup MySQL database tables using
Perl? My Perl code will be running on a machine remote to the MySQL server.
Ta,
Jeff
-
Before posting, please check:
Hi,
We are currently running MySQL on RedHat Linux with great
success. However, we are upgrading our Netware servers to Netware
6. I know MySQL ports to Netware 6, but I am wondering how
MySQL actually runs on Netware 6. Is there anyone out there running
MySQL on Netware 6? If so, how's
hi,
here is the problem ...
think about this :
serverR1 / serverR2 : replication servers
serverWWW : webserver
serverWWW reads/writes data from/to serverR1
serverR2 replicate serverR1 data
serverR1 crashes
serverWWW reads/writes data from/to serverR2
serverR1 (up) replicate serverR2 data
the
Hi all,
I've some problem with my Mysql servers since the beginning of this week.
I've got plenty of error like this :
Failed to connect to database: Error: Access denied for user:
´[EMAIL PROTECTED]´ to database ´DB1´
MySQL server has gone away
Error Nø1, please contact webmaster ...
In fact,
I'm a lurker on this list but I have decided to come out of my shell for a moment. I
a previous job I was the Oracle DBA for my development team. We had a persistent
problem with Oracle corrupting the development database. Oracle had no idea with the
problem was even after I sent them a copy
Hello there,
I would like to know where I can find the change log for the new versions
of MySQL.
For example, just recently .54 was released, and then .54a. There is a
ChangeLog file in the distribution, but at least to me, it is TOTALLY
incomprehensible. Isn't there a simple file that says
select * from your_table order by no desc limit 0,1
-Original Message-
From: mustakim abas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 12:07 PM
To: [EMAIL PROTECTED]
Subject: help me, please
Hello, i am new in mysql. I got a problem. I try write
my C program
On Thu, 19 Dec 2002, Deepa wrote:
While creating InnoDB tables, I was not able to specify a fulltext
column in the table creation sql. Is this a bug or a limitation with InnoDB
? There could be quite a few users who need FULLTEXT feature with InnoDB.
It's a feature :-(
FULLTEXT has not yet
On Thu, 19 Dec 2002, mustakim abas wrote:
Hello, i am new in mysql. I got a problem. I try write
my C program with mysql API.I have 5 field in
table.No,Name,Phone,Date,Time. How can i take one row
where the No is bigger?
Thanks for help.
Provided I understand your question, then I would
Jeff,
Here is a piece of my backup script. Its been modified from Unix world to
windoze world ( because at this point I
am working in that environment - seeking to return to Unix if anyone has a
gig )
=pod
=head1 Script: mysql_backup.pl
=head2
=over 4
=item 1
This script builds a db dump
When I run an INSERT. SELECT query and I am inserting the records into a
new table that has a UNIQUE key, the statement will fail as soon as it
hits a Duplicate entry error. No further entries will be inserted. The
only way I know to get around this is to pull the entire column(s) into
memory and
The way I do it is to call mysqldump.exe from perl, granted it's not the most elegant
way but it's certainly the fastest (to code). Just do:
---
# name or IP address of dbmachine
my $DB_server = localhost.localdomain.tld
# db login authorised to do db dump
my $DB_User = sa
# location and name
At 15:13 + 12/19/02, Jeff Snoxell wrote:
At 09:46 19/12/02 -0500, you wrote:
Jeff Snoxell wrote:
Nope. That doesn't do it either!
I go:
TRUNCATE TABLE my_table
Are you using InnoDB tables? You'll have to do something akin to
ALTER TABLE my_table AUTO_INCREMENT=1 ... at least
At 13:08 +0100 12/19/02, Harald Fuchs wrote:
In article [EMAIL PROTECTED],
Dyego Souza do Carmo [EMAIL PROTECTED] writes:
Dobrý den,
quarta-feira, 18 de dezembro de 2002, 13:10:07, napsal jste:
MTB Qunfeng Dong wrote:
Another thing, with some linux system, there is a size
limit for
At 23:39 -0800 12/16/02, Troy Kruthoff wrote:
Description:
Invalid reporting of date calc
How-To-Repeat:
note: SESSIONTS is TIMESTAMP type
SELECT (NOW()-SESSIONTS) FROM WEBSESSIONS;
What leads you to expect that this should yield any useful result?
At 10:35 -0500 12/19/02, Deepa wrote:
While creating InnoDB tables, I was not able to specify a fulltext
column in the table creation sql. Is this a bug or a limitation with InnoDB
? There could be quite a few users who need FULLTEXT feature with InnoDB.
It's like the manual says: FULLTEXT is
On Wednesday 18 December 2002 17:18, you wrote:
At 16:57 18-12-02 +0200, you wrote:
On Wednesday 18 December 2002 11:36, Wico de Leeuw wrote:
I've setup replication with a master-slave.
But i only want to replicate some databases so i'd put in my.cnf on the
slave (it's being used,
On Wednesday 18 December 2002 16:49, Alexis Antonakis wrote:
I posted this a few days ago, but haven't seen a reply as yet, and I'm
getting quite desperate now!!
I've managed to delete all the records in a table, well haven't we all done
it sometime!, and was wondering whether it's possible
At 8:06 -0800 12/19/02, mustakim abas wrote:
Hello, i am new in mysql. I got a problem. I try write
my C program with mysql API.I have 5 field in
table.No,Name,Phone,Date,Time. How can i take one row
where the No is bigger?
Thanks for help.
Bigger than what?
Hello.
I am setting up a quad xeon server that is dedicated for mysql. All
access will be via jdbc.
Are there any gotchas or performance bottlenecks in the configuration that
I can change to insure that the full capabilities of this hardware are
available for mysql?
Thanks!
Phillip
Neal,
- Original Message -
From: Neal Dawson [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, December 19, 2002 7:04 PM
Subject: MySQL Netware vs Linux
Hi,
We are currently running MySQL on RedHat Linux with great
success. However, we are upgrading our
Couldn't figure out what the option FOR UPDATE does in a SELECT
statement unless it's just to lock the table. Spent the last few
hours trying to get subqueries to work only to find that the reason
they're not working is not just due to my abominable syntax.
What I'm doing is getting messages
At 9:36 -0800 12/19/02, Troy Kruthoff wrote:
At 23:39 -0800 12/16/02, Troy Kruthoff wrote:
Description:
Invalid reporting of date calc
How-To-Repeat:
note: SESSIONTS is TIMESTAMP type
SELECT (NOW()-SESSIONTS) FROM WEBSESSIONS;
What leads you to expect that this
In the last episode (Dec 19), Neal Dawson said:
We are currently running MySQL on RedHat Linux with great success.
However, we are upgrading our Netware servers to Netware 6. I know
MySQL ports to Netware 6, but I am wondering how MySQL actually runs
on Netware 6. Is there anyone out there
At 15:00 -0300 12/19/02, Maximo Migliari wrote:
Hello there,
I would like to know where I can find the change log for the new
versions of MySQL.
For example, just recently .54 was released, and then .54a. There
is a ChangeLog file in the distribution, but at least to me, it is
TOTALLY
At 11:01 +0100 12/19/02, Gianluca Carnabuci wrote:
Hi,
I've been trying to import a huge .txt file into a MySql table. In
the .txt file, missing values are recorded as empty cells (it might
be that there's some hidden character instead, but I wouldn't know
how to figure that out). When I LOAD
Well, the only basis I have is personal experience from connecting to a local
MySQL database. The components I use for connecting to MySQL with Delphi does
cache the records as the server returns them. However, not all the records are
returned at once. As I said, it depends on how one connects to
I am looking at an application that will be could be potentially
writing hundreds of records a second (syslog) to a MySQL database.
I expect to reach millions of records (if not billions) in time.
I will be doing a variety of types of queries on the data which
will be anything from
At 13:08 +0100 12/19/02, Harald Fuchs wrote:
In article [EMAIL PROTECTED],
Dyego Souza do Carmo [EMAIL PROTECTED] writes:
Dobrý den,
quarta-feira, 18 de dezembro de 2002, 13:10:07, napsal jste:
MTB Qunfeng Dong wrote:
Another thing, with some linux system, there is a size
limit for
At 13:23 -0500 12/19/02, [EMAIL PROTECTED] wrote:
Well, the only basis I have is personal experience from connecting to a local
MySQL database. The components I use for connecting to MySQL with Delphi does
cache the records as the server returns them. However, not all the records are
returned at
At 12:19 -0500 12/19/02, Andrew Kuebler wrote:
When I run an INSERT. SELECT query and I am inserting the records into a
new table that has a UNIQUE key, the statement will fail as soon as it
hits a Duplicate entry error. No further entries will be inserted. The
only way I know to get around this
At 8:12 -1000 12/17/02, [EMAIL PROTECTED] wrote:
Hello all,
I have checked the mailing list and the documentation but have been
unable to find any information regarding the level of support for
MySQL on the MacOS 10.2 platform. After moving a production database
from a linux to MacOS 10.2
At 20:21 +0100 12/17/02, Csongor Fagyal wrote:
Hi,
I have two tables: one holding bids for an auction (table bids) and
one holding user data who placed the bids (users). I would like to
get the highest bid, the user who placed the bid and the number of
bids placed, so I use the following
Description:
After ugrading from MySQL-Max-3.23.53 to 3.23.54, mysqld failed to start.
Error message was:/usr/sbin/mysqld-max: unrecognized option
`--innodb_log_files_in_group=3'.
This option required for Innodb Hot backup!
How-To-Repeat:
Just upgrade MySQL-Max
On 19 Dec 2002, at 12:19, Andrew Kuebler wrote:
When I run an INSERT. SELECT query and I am inserting the records into a
new table that has a UNIQUE key, the statement will fail as soon as it
hits a Duplicate entry error.
You probably want to use INSERT IGNORE:
Greetings
What do you mean server part of MySQL. SQLyog allows you to perform almost
all operation which MySQLAdmin does except starting and shutting down a
MySQL server, which probably SQLyog will have in one of its future releases.
Insane
- Original Message -
From: Stan Sebastian
I upgraded a very high load site from 3.23.51 to 3.23.54a.
The upgrade seems to have gone fine, but some really odd
messages appeared in the error log:
InnoDB: Error: table ./m4m4sex/Pilot has no primary key in InnoDB
InnoDB: data dictionary, but has one in MySQL!
InnoDB: Error: table
Hi!
InnoDB is a MySQL table type which provides to MySQL transactions, row level
locking, foreign key constraints, and a non-free hot backup tool.
InnoDB is included in all MySQL-4.0 downloads and MySQL-Max-3.23 downloads.
You can download them from http://www.mysql.com.
MySQL AB decided to
I want to run mysqldump through a batch process, in
order to do that what prive do i need to give to the
user. It will be running as a cron job, i don't want
to give any creation or deletion authorization. Your
help will be greatly appreciated.
Regards
Arun
Select max(No) from table
Marcos Henke
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: mustakim abas [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, December 19, 2002 1:51 PM
Subject: Re: help me, please
At 8:06 -0800 12/19/02, mustakim abas wrote:
Hello, i am new
Michael,
InnoDB: Error: table ./m4m4sex/Pilot has no primary key in InnoDB
InnoDB: data dictionary, but has one in MySQL!
these messages below derive from this bug fix:
MySQL/InnoDB-3.23.54, December 12, 2002
...
Fixed a bug: ORDER BY could fail if you had not created a
primary key to a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 19 Dec 2002, Maximo Migliari wrote:
So if I just untar the new .54a release, and just copy the safe_mysqld
script to my current .54 release, it will work fine?
Yes, that is sufficient.
Or do I have to re-install everything?
No,
Yes, that's intentional - we have changed this in 4.1, but it's not
documented in the manual yet. A quote from the developer working on that
code:
So, the PASSWORD() function is now not to be used for passwords? The
problem is that I have built at least a few applications that use
PASSWORD() as
On Sunday, December 15, 2002, at 03:43 PM, Helmuth Lutz wrote:
First, from where did you install MySQL? Are you using OS X Server? If
so, MySQL came installed with your system and you shouldn't have a
problem with it. So I'm assuming you're using the client.
Does anybody have an idea:
- WHY
Have you tried looking into the REPLACE command? It basically does an
update if the record is present or an insert if it's not, but all in one
command. Since MySQL won't update a record if you are trying to update
it with data that is unchanged it should be pretty fast.
On Thursday, December
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
I guess you're not a subscriber of the MySQL Newsletter. Subscribe to it -
it's very useful!
Your question was answered a couple of days ago in ta newsletter article:
http://www.mysql.com/newsletter/2002-12/a91.html
Regards,
Iikka
On
Hi:
I know how to save a query using mysqlgui. How do I load a query?
Thanks.
EV
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
If I've got the following two tables:
CREATE TABLE password_log (
time_stamp int(11) unsigned NOT NULL default '0',
remote_host char(15) NOT NULL default '',
remote_user char(50) NOT NULL default '',
status smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY
At 8:06 -0800 12/19/02, mustakim abas wrote:
Hello, i am new in mysql. I got a problem. I try write
my C program with mysql API.I have 5 field in
table.No,Name,Phone,Date,Time. How can i take one row
where the No is bigger?
Thanks for help.
Bigger than what?
Maybe
SELECT No, Name,
On Thu, 19 Dec 2002 15:50:18 -0500, Brent Baisley wrote:
Thanks, Brent. I did read about the REPLACE command, but I only want
to change one field (a simple flag) in the main_table. With REPLACE,
I cannot even copy the rest of the fields into the new record because
it does not offer any access
Does any one have any advise about clustering and replication
with of course mysql. Are there any third party products?
Sam
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
hi, wonder if the sql gurus can help with this one. i have two tables
(simplified), tblAccounts and tblAccountsServices. tblAccounts has an ID
(PK) and an accountNumber, and tblAccountsServices has an ID (PK) and
accountID (FK to tblAccounts.ID). i want to run a query that gives me a row
for
I'm not surprised OSX is slower than Linux. Apple still has a way to go
toward fully optimizing the Unix underpinnings for their hardware. They
are also a few versions behind in the BSD they are using. I'm presuming
you have similar settings for each setup.
As for the processes you see on
btw, regarding my last post, i'm running mysql 3.23.53-max-nt...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
Hello, my name is Fabiana Garfunkel, and I´m new in MySQL developing.
I have a punctual question: I need to save a zipped file into a field of a
table. The question is:
1- is it possible to save a file into a field of a a table ?
2- if the answer is YES, which is the proper type of field for this
Well, thanks to all of your great help! I am able to
speed up the query {select count(*) from NEW_Sequence
s left join NEW_Sequence_Homolog h on s.Seq_ID =
h.Seq_ID;} from 1 min 52.61 sec down to 20.62 sec now.
The only thing I changed so far was the Seq_ID from
type varchar to bigint. The Seq_ID
I lister was kind enough to show me
echo show databases | mysql -N
But there are still some remaining questions I have been searching for
answers to for a long time. Any help appreciated,
Hello all, I have dug through the archives to no avail, the archives point
to many ways to back up your
There is not link to download the Windows version.
Any date for the Windows version to be published?
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 19 Dec 2002, Maximo Migliari wrote:
I would like to know where I can find the change log for the new versions
of MySQL.
For example, just recently .54 was released, and then .54a. There is a
ChangeLog file in the distribution, but at
Hello,
I working on a small my project to learn more about joins. I have three
tables here is what they look like
CREATE TABLE `album` (
`album_id` smallint(3) NOT NULL auto_increment,
`name` text NOT NULL,
`description` text NOT NULL,
`img_id` smallint(5) NOT NULL default '0',
PRIMARY KEY
I am looking for an expert opinion on the speed difference between fetching
related data from 2 tables with a join and fetching them in to single
selects.
The scenario is kind of the following:
SELECT a , b, c FROM table1 WHERE a='x'; # gets b='y'
SELECT b, d , e, f FROM table2 WHERE b='y';
mysql client connectiosn work fine on localhost, but connections
from other hosts on local area network fail with the following error:
ERROR 2013: Lost connection to MySQL server during query
This is an existing installation. I had mysql-3.23.33 working
and was trying to upgrade to a more
platform: windows 2000 pro, mysql default table type myIsam, non-binary
distribution (install version).
I am still getting very slow query results when I join multiple tables
together. I have been trying to figure this out for days and am at a loss. I
added an index to my cross reference
Actually, I think the behavior comes from the components used to connect
to MySQL. Delphi doesn't really care one way or the other.
Dan Cumpian
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 1:41 PM
To: [EMAIL PROTECTED]
Cc: Dan
I guess you need something like
SELECT * FROM password_log t1 LEFT OUTER JOIN exclude_log t2 ON
t1.remote_host=t2.ip_block WHERE t2.ip_block IS NULL;
I am just guessing that both tables are related through remote_host and
ip_block,
Adolfo
On Thu, 2002-12-19 at 17:31, Eric Anderson wrote:
If
i cant create SQl tables andoso cant del the tables.. it always shows
table is read only.. anyway to solve?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
anyway to solve this SQL problems?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To
1 - 100 of 110 matches
Mail list logo
