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 varchar
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 at
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 |
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
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 full Cartesian product.
-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!
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
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
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).
G.
* 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 could
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
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
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 disconnected and when
I
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!
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
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
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 result,
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 one of two
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 does one
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:
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
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
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
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
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);
mysql
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
thread
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 ?
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
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 int
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 you
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 functionality not
being
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 was wondering if one
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
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
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 depend
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.
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
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 database name
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
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
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 =
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
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 column, in
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 LIKE 'B%'
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 MySQL use the
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 like:
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
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
| |
48 matches
Mail list logo