Hello gurus,
Please allow me to request for help with the table below.
mysql> select * from relay_ip;
+-+++-+-+
| rei_aid | rei_uname | rei_domain | rei_ip | rei_ts
| |
+--
At 11/02/2002 05:21, Paul DuBois wrote:
>At 4:10 +0700 2/11/02, Steven Haryanto wrote:
>>i believe since 3.23.39 it should not be?
>
>BDB and MyISAM tables have different properties with respect to
>AUTO_INCREMENT behavior.
i see, so this is an "undocumented feature" (i haven't seen this
in http
At 21:30 -0800 2/10/02, Jeremy Zawodny wrote:
>On Sun, Feb 10, 2002 at 10:01:45PM -0600, Paul DuBois wrote:
>> At 18:07 -0800 2/10/02, Jeremy Zawodny wrote:
>> >On Sun, Feb 10, 2002 at 02:53:53PM -0500, Matthew Dougherty wrote:
>> >> If I use a REGEXP query on an indexed column using something
On Sun, Feb 10, 2002 at 10:01:45PM -0600, Paul DuBois wrote:
> At 18:07 -0800 2/10/02, Jeremy Zawodny wrote:
> >On Sun, Feb 10, 2002 at 02:53:53PM -0500, Matthew Dougherty wrote:
> >> If I use a REGEXP query on an indexed column using something like:
> >> Field REGEXP '^A|^B|^C'
> >>
> >> Will
At 18:07 -0800 2/10/02, Jeremy Zawodny wrote:
>On Sun, Feb 10, 2002 at 02:53:53PM -0500, Matthew Dougherty wrote:
>> If I use a REGEXP query on an indexed column using something like:
>> Field REGEXP '^A|^B|^C'
>>
>> Will MySQL use the index like it would if I used Field LIKE 'A%' or
>> Field
> Hello MySQL users
>
> I was wondering if one of you could advise me on the best solution to a
> problem I'm having - I'm sure this has been done before but haven't found
> anything in the archives.
>
> Basically the problem I am having is how best to handle multiple values for
> a specific col
hi i´m starting with linux and i want to install the daemon of mysql...
please help.
i all ready read the documentation and the man pages but i dont understand ...
help
_
Do You Yahoo!?
Get your free @yahoo.com address at http:/
I'm trying to update a database. Here's the query that's not working. Is
there another way of doing it or is this impossible with MySQL?
Thanks,
-Ed
update SiteIndex
set
SiteIndex.Visitors = Pages.Visitors
where
SiteIndex.Title = Documents.Titl
OK.
By the way - why is it trying to strip 2 digits in a row? I'm sure there was
a reason.
Cheers,
Ian Collins.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 3:05 PM
To: Ian Collins
Cc: Mysql (E-mail)
Subject: Re: mysqlhotcopy in 4.0.1
On Sun, Feb 10, 2002 at 02:53:53PM -0500, Matthew Dougherty wrote:
> If I use a REGEXP query on an indexed column using something like:
> Field REGEXP '^A|^B|^C'
>
> Will MySQL use the index like it would if I used Field LIKE 'A%' or
> Field LIKE 'B%' or FIeld LIKE 'C%' ??
It will not.
Regular
On Mon, Feb 11, 2002 at 03:04:47PM +1300, Ian Collins wrote:
> In mysqlhotcopy, function copy_files, there is a line,
>
> my @non_raid = grep { $_ !~ m:\d\d/: } @$files;
>
> (dont you just love perl?).
>
> If the database name in question is, for example, testone_750, a
> perfectly legal databa
In mysqlhotcopy, function copy_files, there is a line,
my @non_raid = grep { $_ !~ m:\d\d/: } @$files;
(dont you just love perl?).
If the database name in question is, for example, testone_750, a perfectly
legal database name (??), then no files get copied! and the mysqlhotcopy
fails.
I presum
On Monday, 11. February 2002 01:54, [EMAIL PROTECTED] wrote:
> Dear Sir,
>
> I want to install MySQL. The operating system used is Mac OS X. I have
> downloaded MySQL from www.mysql.com. I would be grateful if you could
> supply some tip regarding how to install mysql with Mac OS X. Thanks a
> lot
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
>
> So I need your help with field testing of my code. For those of you
> who are wondering why you should - this will help us stabilize 4.0 a
> lot of faster, and not only replication, but also the general SQL
> features. So if you de
Li, try
http://www.entropy.ch/software/macosx/mysql/
then its very easy!!
regards,
Andreas
On Montag, Februar 11, 2002, at 01:54 Uhr, [EMAIL PROTECTED] wrote:
> Dear Sir,
>
> I want to install MySQL. The operating system used is Mac OS X. I have
> downloaded MySQL from www.mysql.com. I w
Dear Sir,
I want to install MySQL. The operating system used is Mac OS X. I have
downloaded MySQL from www.mysql.com. I would be grateful if you could
supply some tip regarding how to install mysql with Mac OS X. Thanks a
lot.
Sincerely,
Li Sha
Simon Fraser University, Canada
-
>Date: Sun, 10 Feb 2002 16:06:55 -0800
>To: [EMAIL PROTECTED]
>From: tj marlin <[EMAIL PROTECTED]>
>Subject: Re: Quick SQL design help
>
>the SET data type comes to mind. there is a limitation of 64 for the set
>size.
>
>ciao
>
>At 05:23 AM 2/10/02 +, you wrote:
>>Hello MySQL users
>>
>>I wa
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Trond Eivind Glomsrød writes:
>> Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
>>
>> There is a slight difference between advanced, non-standardized
>> tuning/backup/load-balancing like that and core SQL functionalit
Jim,
I'd like to help, but I dont answer questions directly. Please post your
question to the mysql mailing list in future. I have crossposted this to the
list.
kind regards,
Mark Maunder.
Jim Chivas wrote:
> Mark:
>
> I work in a School where the teachers want to use mysql.
>
> A while back
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Trond Eivind Glomsrød writes:
>> "Vernon A Webb" <[EMAIL PROTECTED]> writes:
>>
>> > Anyone know the difference between MySQL and PostgreSQL?
>>
>> PostgreSQL has a lot of features MySQL don't have yet (transactions
hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Albert Chin writes:
>>
>> $ grep SIZEOF_LONG config.h
>> #define SIZEOF_LONG 8
>> #define SIZEOF_LONG_LONG 8
>>
>> $ grep SIZEOF_LONG incldue/my_config.h
>> #define SIZEOF_LONG 8
>> #define SIZEOF_LONG_LONG 8
>>
>>
At 4:10 +0700 2/11/02, Steven Haryanto wrote:
>i believe since 3.23.39 it should not be?
BDB and MyISAM tables have different properties with respect to
AUTO_INCREMENT behavior.
>
>mysql> create table t1_b(i int unsigned primary key auto_increment,
>j int) type=bdb;
>mysql> create table t1_m(i
I don't actually see the error message in the output you sent. but I found a
similar problem yesterday and have the following work around:
= myisamchk.c 1.69 vs edited =
*** /tmp/myisamchk.c-1.69-20535 Thu Feb 7 17:21:33 2002
--- edited/myisamchk.c Sat Feb 9 22:48:57 2002
On Sun, Feb 10, 2002 at 10:24:30PM +0100, Fournier Jocelyn [Presence-PC] wrote:
> Hi,
>
> In myisamchk.c replace the following line :
>
>if (argument && *argument == '0')
> DBUG_POP();
> else
> DBUG_PUSH(argument ? argument : "d:t:o,/tmp/myisamchk.trace");
>
> by
>
> if
Hi,
In myisamchk.c replace the following line :
if (argument && *argument == '0')
DBUG_POP();
else
DBUG_PUSH(argument ? argument : "d:t:o,/tmp/myisamchk.trace");
by
if (argument && *argument == '0')
{
DBUG_POP();
}
else
{
DBUG_PUSH(argument ?
On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote:
> Dear MySQL users,
>
> I have just pushed my latest changes in the replication code in our
> 4.0 development tree, which change the slave to use two threads -
> I/O thread that gets the data from the master and logs it, and SQL
> thre
i believe since 3.23.39 it should not be?
mysql> create table t1_b(i int unsigned primary key
auto_increment, j int) type=bdb;
mysql> create table t1_m(i int unsigned primary key
auto_increment, j int) type=myisam;
mysql> insert into t1_bdb(j)values(0);
mysql> insert into t1_bdb(j)values(0);
my
Hello, I have a temp table setup with a mediumblob in it. I am using a C
program to pull information out of the database. However, my problem is
that when the message is greater then around 10k it dies. If it is less
then 10k it works without any problems. I know other people have pulled
more
Hi,
It works!
Thanks very much for your great help.
I'm a newbie in SQL and I'll study more your examples.
Thanks again,
Nuno Teixeira
On Sat, Feb 09, 2002 at 07:52:15PM -0500, Butch Bean wrote:
| I changed it...
| they were | AND relAB.B='a1' in the other exampl
I am trying to configure MySQL to run on a WinME operating system that will
eventually be transferred to a Win98 operating system.
I am having problems with the InnoDB startup. The error I keep getting is
that it "Cannot initialize InnoDB as 'innodb_data_file_path' is not set." I
do want to be a
You can do the following to remove duplicates:
- create table foo as select distinct cols from
table_name_containing_duplicates;
- drop table_name_containing_duplicates;
- alter table foo rename to table_name_containing_duplicates;
Done.
Now, make a primay key for the new table!! -- this will a
If I use a REGEXP query on an indexed column using something like:
Field REGEXP '^A|^B|^C'
Will MySQL use the index like it would if I used Field LIKE 'A%' or Field LIKE
'B%' or FIeld LIKE 'C%' ??
I could not find this info in the manual.
Thanks in advance
Matthew Dougherty
Consultant:
Hi,
You can try to use ALTER IGNORE TABLE syntax :
ALTER IGNORE TABLE your_table ADD UNIQUE(Id);
Regards,
Jocelyn Fournier
- Original Message -
From: "Rich" <[EMAIL PROTECTED]>
To: "MySql" <[EMAIL PROTECTED]>
Sent: Sunday, February 10, 2002 5:31 PM
Subject: Duplicate Records
> How do
Has anyone seen benchmarks of JDBC vs ODBC vs DBI ?
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: "Rich" <[EMAIL PROTECTED]>; "MySql" <[EMAIL PROTECTED]>
Sent: Sunday, February 10, 2002 2:30 PM
Subject: Re: Duplicate Records
> Rich,
>
> > How does one go about removing on
Rich,
> How does one go about removing one of two identical records in a MySQL
> database? My mistake in an earlier database was not applying a unique
> number to each record (1, 2, 3, ---). I know it's possible to use the
> DISTINCT operator to show only one of the identical records in a resul
X-Bounce-Reason: SQL, query, odbc 1) [EMAIL PROTECTED] is not subscribe to
list or 2) Unsubscription methods did not remove user from list. List Admin, please
investigate MLM software logs, you may need to update MLM to newer version
-
Hi!
InnoDB is a MySQL table type which adds transactions, row level locking, and
foreign key constraints to MySQL.
InnoDB is included in the MySQL-Max-3.23.48, MySQL-4.0, and MySQL-Max-4.0
distributions of MySQL. These can be downloaded from http://www.mysql.com.
For more information about InnoD
On Mon, Feb 11, 2002 at 01:31:03AM +0800, Benny Chen wrote:
% I have backed up my data in server A and copied to /var/lib/mysql/my_db in
% server B where my_db is the name of database. I can see my_db in left column
% of phpMyAdmin 2.2.3 in my browser, but when I try to browse my data, I get
%
Hi!
I have a couple of small comments to Sinisa answer.
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Skriniar Gregor writes:
>> Dear all,
>>
>> I experienced some problems with using MySQL API:
>> My problem is that if I don't use database a long time it is disconn
I have backed up my data in server A and copied to /var/lib/mysql/my_db in
server B where my_db is the name of database. I can see my_db in left column
of phpMyAdmin 2.2.3 in my browser, but when I try to browse my data, I get
the error message " can't find file: ./my_db/my_table.frm (errno :1
First off,
You would need to add an "id" field, then set it to a primary key, then
set it to "auto_increment"
This will order them correctly
-Original Message-
From: Rich [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 10, 2002 10:31 AM
To: MySql
Subject: Duplicate Records
How does
How does one go about removing one of two identical records in a MySQL
database? My mistake in an earlier database was not applying a unique
number to each record (1, 2, 3, ---). I know it's possible to use the
DISTINCT operator to show only one of the identical records in a result,
but that
Hi all,
could someone help me? I'm looking for one quick answer. I've code
like this
$result = mysql_query("SELECT FROM ...");
$rows = mysql_fetch_array($result);
Problem is, when the result have no rows. I receive an error message
from MySQL on the second line, which is OK. My questi
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
> * If you want to do it this very moment, read the instructions at
>http://www.mysql.com/doc/I/n/Installing_source_tree.html and install a
> pre-release 4.0.2 MySQL on your test server. You may also wait until 4.0.2
is
> released, but in that case, replication in 4.0.2 may have a bug you cou
> Last week on Slashdot there was an article where the CEO of Google mentioned he
> uses DRAM (solid state disk arrays) rather than hard drives for the indexes and
> arrays because of the magnitude of difference in speed they provide.
>
> There's your 10^6 difference in speed (or part of it).
>
>
On Friday 08 February 2002 06:14 pm, James Montebello wrote:
> Distribution is how Google gets its speed. You say clustering won't
> solve the problem, but distributing the indicies across many processors
> *is* going to gain you a huge speed increase through sheer parallelism.
True, but not
Hi!
MySQL 3.23.48 is now released
This version fixes some small bugs, and for most people there should
not be any big reason to upgrade.
Changes in release 3.23.48
--
* Changed to use `autoconf' 2.52 (from `autoconf' 2.13)
* Fixed bug in complicated join with `c
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
sql
Hi all
I've just set up and the latest problem I have getting started is that
'Access denied for user: apache@localhost' msg.
How can I put that right?
- --
Nick Wilson
Tel:+45 3325 0688
Fax:+45 3325 0677
Web:www.explodingnet.com
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> John Heitmann writes:
>> Thanks for the quick response.
>>
>> > > select t1.*, t2.name from t1, t2 where t2.id=t2_id;
>> >
>> > The above is actually expected behaviour, as you are not doing a join
>> > at all, but a
Martin,
there is a bug in 4.0.1 which can make a foreign key definition to fail in
an assertion failure in dict0crea.c, if you have set default-character-set
to something else than latin1 in my.cnf.
Harald Fuchs reported the bug on this mailing list a couple of days ago, and
the bug is now fixed
Hi
It would be great if anyone could help me with a problem in mySQL.
I have 3 tables to describe attributes for a product database.
e.g.
attribute_type:
++--+--+
| id | name | unit |
++--+--+
| 1 | height | cm |
| 2 | width| cm |
Greetings
> i an doing my assignment using mysql to establish a database!!
> i already create the table and insert the data,
> but i don't know how to create a export file,
> anyone can help me!!
Check out the online manual (4.8.5 mysqldump, Dumping Table Structure and Data), or
take a look a
Hello James,
> Basically the problem I am having is how best to handle multiple values for
> a specific column, in this case the values in question are coming from an
> HTML SELECT MULTI box processed by PHP.
>
> The way I have been doing this so far is to have a delimited value stored
> in a var
54 matches
Mail list logo
