I need a little help in constructing an order tracking database. We've
decided to use MySQL mostly because it's the best supported database out in
the wild. Does anyone have an example of an order tracking datamap? A link
to a site with the basic flowchart would be a great help. The application is
Dear all,
Here I have a query...
my table looks like this :
code size
1n3j 14
1n3j 32
1n3j 37
1n9j 14
1n9j 32
1n9j 14
1nm4 14
1nm4 37
1nm4 32
1nmi14
1nmi14
1oo314
1oo314
1oo414
1oo414
I want to select those
On Tue, 20 Jan 2004, Todd Burke wrote:
Is there any way to disable replication of all temp tables using
replicate-ignore-table or some other means? The names of the temp tables
are generated randomly by a script. Thanks
If you could have all temporary tables starting with tmp or something
Mikel,
what about playing with the autocommit setting?
I guess you use the mysql client for the restore, so you could set
autocommit off and perform a commit yourself every 1 rows or so.
In our case this boosts recovery by a factor of 5 to 10.
Regards,
Frank.
Mikel - schrieb:
I
Ratna Rajesh Thangudu said:
my table looks like this :
code size
1n3j 14
1n3j 32
1n3j 37
1n9j 14
1n9j 32
1n9j 14
1nm4 14
1nm4 37
1nm4 32
1nmi14
1nmi14
1oo314
1oo314
1oo414
1oo414
I want to select those rows with 'size' 14, 32
Noamn wrote:
Judging by some of the comments posed on this list, I wonder whether the
following statements are true:
1. There is no point having an index on a field if that field can only have
a few values
Not for query speed reasons. There may be other reasons
(uniqueness for instance), but for
Hi.
Try to set character set to other not latin1 with MySQL 5 (windows
binary) it not work can some one tell me how to do this.
Thanks
Dr.K
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Drop the 'sex_index'
Basically when you have few unique values in a column
indexing it doesn't always help.
I setup this table with the 1,000,000 random entries
and query time is nearly the same for your 2 queries
below.
CREATE TABLE sex (
id int(11) unsigned NOT NULL auto_increment,
sex
hi,
i am trying to install Mysql in RH-9.I follow your
instructions .But when i typed
./configure --prefix=/usr/local/mysql
after some screens it displays
Starting mysqld daemonwith databases
from/usr/local/src/mysql-standard-4.0.17-pc-linux-i686/data
040121 11:55:41 mysqld ended
after
On Wednesday 21 January 2004 10:20, naga rajan wrote:
hi,
i am trying to install Mysql in RH-9.I follow your
instructions .But when i typed
Since you have RedHat, might I suggest that you use the RPM versions, which
are pre-compiled and should set everything up properly for you.
--
MySQL
Hi!
I'm using Visual Foxpro 6.0 for develop my application whitch is connected to
MySQL 4.1 via MyODBC (3.2.51) driver. I'm using several methods in my
program to monitor server state and switch from one server to another if
server or connection failure occurs. There is one big problem about
hi, I had just installed mysql RPM in RedHat-9.
It doesn't shows any errors but what nextstep i have
to do work with mysql.
Yahoo! India Mobile: Download the latest polyphonic ringtones.
Go to http://in.mobile.yahoo.com
--
On Wednesday 21 January 2004 10:56, naga rajan wrote:
hi, I had just installed mysql RPM in RedHat-9.
It doesn't shows any errors but what nextstep i have
to do work with mysql.
RT(f)M:
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Unix_post-installation
Pretty
Kittiphum Worachat [EMAIL PROTECTED] wrote:
Try to set character set to other not latin1 with MySQL 5 (windows
binary) it not work can some one tell me how to do this.
If you want to set character set on the server level, you should start mysqld with
--default-character-set option:
Hello,
I have a client using a already made calendar component on my server...
The problem seems to be the SQL code.
This code works (i believe) with an MS Access or MS SQL server DB...
MySQL version is 3.23.58
The code is:
SELECT *
FROM events
WHERE day(theDate) = '#dayVal#' and
Hi all,
I have an application that works fine with MySQL 3.23 and the C API (everything on
Linux and only on Linux).
I need now to support unicode (I mean chinese, japanese, russian... all kind of
characters) so I am converting the application to use wchar_t and wstring instead of
char and
function can b used, but value parameter seems syntactically wrong, check
that.
'#session.month#' to '$month'
which is the language,u r using anyway?
- Original Message -
From: Yves Arsenault [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004 6:37 PM
Subject:
Thanks for your response,
I'm using ColdFusion along side of MySQL to server dynamic content to some
websites.
When I run the page that this code is in, I get an SQL syntax error:
Syntax error or access violation: You have an error in your SQL syntax near
'(theDate) = '31' and month(theDate) =
root can only connect through localhost until GRANTed permissions over
the network.
Leave off the '-h inglewood'.
If you have not set the password yet, then you also should leave off the
'-p' option.
[EMAIL PROTECTED] wrote:
This is a new install of mysql 3.23 on a SuSE8.0 Box. I installd
Yves Arsenault wrote:
SELECT *
FROM events
WHERE day(theDate) = '#dayVal#' and month(theDate) = '#session.month#'
and year(theDate) = '#session.year#'
Can the day() function be used in this way in the WHERE statement?
Yes, but only from version 4.1.1
Use DayOfMonth() or preferably Extract()
On Wed, 21 Jan 2004, Yves Arsenault wrote:
Thanks for your response,
I'm using ColdFusion along side of MySQL to server dynamic content to some
websites.
When I run the page that this code is in, I get an SQL syntax error:
Syntax error or access violation: You have an error in your SQL
I'm testing backup and restore on MySQL 5.0. I did mysqldump first and
then dropped a table and a stored procedure on purpose. After doing
'mysql -h host -u user -p database dump-file', the dropped table could
be restored back in the database. But the dropped procedure stayed
missing.
How
Hi All
I have the following situation:
the DB has three tables 'users', 'links' and 'searches'. Each table has a
common key named 'userid'
What I want to do is, for each user in the 'lguser' table I'd like to count
the number of corresponding records in EACH of the 'lghyperlink' and
'lgsearch'
Hi,
since MySQL stores stored procs in mysql db you need to make backup of
mysql db.
But it would be nice to have a possibility to make backup of stored procs in
readable format.
Best regards,
Mikhail.
- Original Message -
From: Bing Du [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
I am using tables INNODB.
After one query, the MySQL does not liberate the LOCK, and when I try to
execute same query it appears the message.
#1205 - Lock wait timeout exceeded; Try restarting transaction
whait urgently one helps. thanks, Bruno
--
MySQL General Mailing List
For list
Sorry for the newbie question.
[Begin]$Groveling_non-programmer_string_of_excuses[End]. I imported a
bunch of records into a table. One of the fields came through bracketed
in double quotes, e.g., field data. I want remove the double quotes
but not the data bracketed within. E.g., field data to
Stored procedure versioning/backup/restoring has always been a pain in the butt for
all dbs that support them. What is done 9/10 times is the sql script that creates
them is stored, versioned, and used for backup...
now a 'show create stored procedure blah_blah' function would be nice... ;)
Ah, I forgot to dump the 'mysql' db. Thanks so much, Mikhail, for waking
me up :).
Bing
Hi,
since MySQL stores stored procs in mysql db you need to make backup of
mysql db.
But it would be nice to have a possibility to make backup of stored procs
in
readable format.
Best regards,
* compuserve aka Bill Stennett
I have the following situation:
the DB has three tables 'users', 'links' and 'searches'. Each table has a
common key named 'userid'
This does not match the table/column names you describe below... are you
trying to confuse us? ;)
What I want to do is, for each
I'll set up those parameters in my.cnf and try again the recovery from the
dump file. I'll hope these changes make faster the recovery.
Thanks again Heikki,
Mikel
P.S. Do you recommend the innodb hot backup tool, does it do faster than the
other options, or is a combination of both?
From:
I am getting a syntax error from MySQL when executing the following
query (names substituted):
Delete From Table1 WHERE Related_ID IN (SELECT Related_ID FROM Table2
WHERE Another_ID='1');
What is going wrong?
My guess is that the SELECT is considered a subquery, but how else do
you get the
As to the direct question of two servers accessing the same file via SAN, I
don't know. But here is an option we are using.
I have two Linux Servers, a Web Server and SQL server. Our web server
resides on both the internal external networks (two nics), with some
firewall software installed
In the last episode (Jan 19), [EMAIL PROTECTED] said:
Could someone please tell me if tyhe following is possible or if a solution
accomplishing the same thing is available?
I would like to build a database using two MySQL servers accessing
the same physical file on a common Drive attached to
The one major design spec, my management has requested, is lack of TCP/IP
connectivity between the two servers using the data. One network is
completely isolated from the outside world/internet, however we are trying
to find a secure way to allow outside users to query historical data that
* Zaxpaw
I am getting a syntax error from MySQL when executing the following
query (names substituted):
Delete From Table1 WHERE Related_ID IN (SELECT Related_ID FROM Table2
WHERE Another_ID='1');
What is going wrong?
Version 3.x does not support sub-selects.
My guess is that the SELECT
you should be able to use STR_REPLACE.
update 02093_xdir_links SET title = REPLACE(*,,title);
hth
jeff
Bob Cohen
you should be able to use STR_REPLACE.
DOH. Sorry, there is NO STR_REPLACE its just REPLACE.
jd
update 02093_xdir_links SET title = REPLACE(*,,title);
hth
jeff
Bob Cohen
[EMAIL PROTECTED]To:
[EMAIL
I'm try to write a query that will return the number of times a specified
character appears in a string (I want known how many times the character M
appears), but I cannot seem to figure out how to do that. The select
statement is the following:
SELECT structure_aa_sequence from structure where
Thanks for the suggestion but unfortunately this seems to produce the
product of the two tables `lghyperlink` and `lgsearch`. e.g. if user bill
and 10 entries in `lghyperlinks` and 15 entries in `lgsearch` then what is
returned is
username clicks searches
==
bill
Hello,
For some time we've been running MySQL (from 4.0.1 to 4.0.17) on Redhat (v. 7.2
9.0). We use our linux server for one thing: MySQL server.
We are far from linux experts, so Redhat made sense, particularly the ease of
installation and the bugfixes via up2date. Now that Redhat is
i've never used MT, but this kinda sounds as if you dont have the DBI
installed:
$ perl -MCPAN -eshell
install DBI
cheers,
M.
tait sanders wrote:
hi all,
not sure if this is the appropriate place to post this -- so please
point me in the right direction if not here...
I have a G4 with
Openna.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004 11:55 AM
To: [EMAIL PROTECTED]
Subject: Redhat Alternatives for MySQL
Hello,
For some time we've been running MySQL (from 4.0.1 to 4.0.17) on Redhat
(v. 7.2 9.0). We
you should be able to use STR_REPLACE.
DOH. Sorry, there is NO STR_REPLACE its just REPLACE.
jd
update 02093_xdir_links SET title = REPLACE(*,,title);
Thank you very much for responding. Sorry to be dense but will this SQL
find only those records with data in the TITLE field
wow, one post, two mistakes. how right you are. sorry.
update 02093_xdir_links SET title = REPLACE(\,,title);
you may/may not need to escape the .
hth
Jeff
Thanks for your input on all points. Let me explain my suggested setup
first and then tell me if it still seems absurd.
Point 1: We have an isolated network performing critical functionality.
This network has absolutely no connectivity to the outside world/internet
Point 2: Data from this
SuSE Pro. Automatic online updates/bugfixes. Cheap. Only pay for the
support you need. I've been running MySQL on SuSE for 18+mths with no
problems, and SuSE in general for about 3 yrs for allsorts of thing.
Steve
[EMAIL PROTECTED] wrote:
Hello,
For some time we've been running MySQL (from
At 12:17 PM -0600 1/21/04, Joseph S Brunzelle wrote:
I'm try to write a query that will return the number of times a specified
character appears in a string (I want known how many times the character M
appears), but I cannot seem to figure out how to do that. The select
statement is the
Hello!
If you live in europe or in the states you can get SuSE 9, for 79$ the
box, i recently spent cristhmas in the states and see SuSE boxes every
where i went i even saw suse boxes in wallmart :s
SuSE is quite a nice choice IMHO.
On Wed, 2004-01-21 at 14:49, Ferguson, Michael wrote:
Mikel,
- Original Message -
From: Mikel - [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004 7:19 PM
Subject: Re: Too slow recovering mysqldump files
I'll set up those parameters in my.cnf and try again the recovery from the
dump file.
Hi,
I've learned from fabFORCE.net that DB Designer 4 is bought by MySQL AB. Could any one
from MySQL AB please comment on the new acquisition and shed some light on integration
plans with MySQLCC?
Thanks.
Hassan
Hello Heikki,
Thank you for your reply and your explanation. It clarifies things and explains some
of the
unexpected behavior I've observed (such as my own inability to insert to the gap after
locking it).
In general, is there a place where I can find a good discussion on the various locks
I need a little help in constructing an order tracking database. We've
decided to use MySQL mostly because it's the best supported database out in
the wild. Does anyone have an example of an order tracking datamap? A link
to a site with the basic flowchart would be a great help. The application is
Hi,
I am trying to find out that if I have a table without any Foreign keys and
I am doing a lot of Inserts to it, should the performance be different if I
have indexes or not? If I don't have any indexes, shouldn't I expect the
performance for the Inserts to be better than it would be if I
* Hassan Shaikh
Which one of the following statements is more efficient?
SELECT * FROM COUNTRY WHERE LEFT(CNNAME,1)='B';
Or
SELECT * FROM COUNTRY WHERE CNNAME LIKE 'B%';
The second statement will normally be the most effective, because the server
don't need to perform a function on the
Balazs Rauznitz wrote:
However when the 'sex' column is involved:
mysql select count(*) from sex where id459000 and id =46 and sex = 'M';
+--+
| count(*) |
+--+
| 504 |
+--+
1 row in set (5.09 sec)
Any way to make this faster ?
Well, MySql can only use 1 index
Does anyone know if this or mycc has been compiled for Mac OS X?
On Wednesday, January 21, 2004, at 10:40 AM, Hassan Shaikh wrote:
Hi,
I've learned from fabFORCE.net that DB Designer 4 is bought by MySQL
AB. Could any one from MySQL AB please comment on the new acquisition
and shed some
* Bill - compuserve
Thanks for the suggestion but unfortunately this seems to produce the
product of the two tables `lghyperlink` and `lgsearch`.
Yes, sorry about that.
[...]
Any other suggestions gratefully received - maybe this has to be
done in two queries and the data manipulated in the
Chuck Gadd said:
Balazs Rauznitz wrote:
mysql select count(*) from sex where id459000 and id =46
and sex = 'M'; +--+
| count(*) |
+--+
| 504 |
+--+
1 row in set (5.09 sec)
Any way to make this faster ?
Well, MySql can only use 1 index per table to
In the last episode (Jan 21), Steve Edberg said:
At 12:17 PM -0600 1/21/04, Joseph S Brunzelle wrote:
I'm try to write a query that will return the number of times a
specified character appears in a string (I want known how many
times the character M appears), but I cannot seem to figure
You could just use the benchmark function?
select BENCHMARK(1000, 'dfsfsdfs' like 'F%' ) /* 0.45 sec. */
select BENCHMARK(1000, 'dfsfsdfs' between 'F' and 'Fzzz' ) /* 0.55
sec. */
select BENCHMARK(1000, left('dfsfsdfs',1)='F' ) /* 0.79 sec. */
The times go up a little if the
Hi,
How to see all tables in connected database?
thx -seena
-
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
\u database
SHOW TABLES
Joshua Thomas
Network Operations Engineer
PowerOne Media, Inc.
tel: 518-687-6143
[EMAIL PROTECTED]
---
Ninety percent of this game is half mental.
- Yogi Berra
---
-Original Message-
From: Seena Blace [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 21,
mysql SHOW TABLES;
Hope this helps.
~~Nick
--- On Wed 01/21, Seena Blace [EMAIL PROTECTED] wrote:
From: Seena Blace [mailto: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Wed, 21 Jan 2004 13:03:51 -0800 (PST)
Subject: SELECT
Hi,brHow to see all tables in connected database?brthx
I need to get total number of all rows in a table and also select some
rows from the same table. I know how to do this
using two queries, but was wondering if there is any way to do it in one
query (one trip to the database).
Thanks,
-Jalil
--
MySQL General Mailing List
For list archives:
Alex,
- Original Message -
From: Zeltser, Alex [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, January 21, 2004 10:28 PM
Subject: RE: InnoDB locking 'non-existence' of a row
Hello Heikki,
Thank you for your reply and your explanation. It clarifies things and
Grzegorz Paszka [EMAIL PROTECTED] wrote:
Hi.
I use MySQL 4.0.17 from rpm.
When I want insert new row by perl script to one of my table I get such error :
DBD::mysql::st execute failed: Duplicate entry '- Modified the spec file provided by
...' for key 3
Table looks :
mysql desc
* ed aka emierzwa at micron.com
You could just use the benchmark function?
select BENCHMARK(1000, 'dfsfsdfs' like 'F%' ) /* 0.45 sec. */
select BENCHMARK(1000, 'dfsfsdfs' between 'F' and 'Fzzz' ) /* 0.55
sec. */
select BENCHMARK(1000, left('dfsfsdfs',1)='F' ) /* 0.79 sec. */
I
thanks for taking the time to look
best
bill
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 21 January 2004 20:19
To: [EMAIL PROTECTED]
Cc: Bill - compuserve
Subject: Re: select count from three tables
* Bill - compuserve
Thanks for the suggestion but
I'm on WinXP, 2.6ghz. mysqld-nt Alpha 4.1.2
Either way, I was surprised to see the like to be in the top
performers and left() to be last.
Ed
---
* ed aka emierzwa at micron.com
You could just use the benchmark function?
select BENCHMARK(1000, 'dfsfsdfs' like
Roger Baklund wrote:
Either way, I was surprised to see the like to be in the top
performers and left() to be last.
I suppose the LIKE operator is optimized for the case when it begins with a
constant:
mysql select BENCHMARK(1000, 'dfsfsdfs' like '%F%' );
1 row in set (3.43 sec)
MySql will
Thanks for your fast response, I'll adjust the autocommit parametr, too, and
I'll will let you know if this improves the restore of my data base.
Greetings
Mikel
From: Heikki Tuuri [EMAIL PROTECTED]
To: Mikel - [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Too slow recovering mysqldump
* Chuck Gadd
Roger Baklund wrote:
Either way, I was surprised to see the like to be in the top
performers and left() to be last.
I suppose the LIKE operator is optimized for the case when it
begins with a constant:
mysql select BENCHMARK(1000, 'dfsfsdfs' like '%F%' );
1 row in
I run alter today on table with 380,000 records. 'Alter' was adding
column to the table. It took 10 minutes and server load went up to
15.
alter table info add column interactive_email enum('on','off') NOT NULL
default 'on';
Here comes my questions:
#1 If I kill the process after it was running
* jalil
I need to get total number of all rows in a table and also select some
rows from the same table. I know how to do this
using two queries, but was wondering if there is any way to do it in one
query (one trip to the database).
From version 4 you can use the SQL_CALC_FOUND_ROWS option
At 05:34 PM 1/21/2004, you wrote:
I run alter today on table with 380,000 records. 'Alter' was adding
column to the table. It took 10 minutes and server load went up to
15.
alter table info add column interactive_email enum('on','off') NOT NULL
default 'on';
Here comes my questions:
#1 If I
This example is simplified. I hope you understand
Each table has one field called ID which is an integer and is the primary key
Table 1
List of Programs
1
2
3
4
5
6
7
8
9
10
Table 2
Programs members have joined
1
5
8
Here is the scenario. I want to compare the values in table
I believe this would work
select table1.* table1 left join table2 on (table1.id=table2.id) where
tab2.id not null
The left join will match the values together. Null values are inserted
where matches are not made. Since 4 will not make a match null values
will be put in place of the table2
Thanks for good explnation.
Some more questions:
#1Does 'update' also create temporary table?
#2What happend with old table after alter?
From: mos [EMAIL PROTECTED]
To: Mike Mapsnac [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Kill alter table process? Date: Wed, 21 Jan 2004 19:12:07
SELECT * FROM tableone WHERE value NOT IN (SELECT column FROM tabletwo)
;
On Wed, 2004-01-21 at 15:26, Randy Johnson wrote:
This example is simplified. I hope you understand
Each table has one field called ID which is an integer and is the
primary key
Table 1
List of
At 09:04 PM 1/21/2004, you wrote:
Thanks for good explnation.
Some more questions:
#1Does 'update' also create temporary table?
Definitely not. Otherwise if an Update changed a single row it would have
to create a temporary table, and of course it doesn't do that. Boy,
wouldn't that be slow.bg
I would like to install MySQL on a Solaris 8(SPARC) system without the need to have
'root' previliges.
I've installed it into my own directory (ie./home/my_place/) with any problems. I'm
able to run'mysql_install_db and 'mysqld_safe' also without any problems.
BUT when I try to run something
You can find a number of good starting point data
models here:
http://www.databaseanswers.com/data_models
You might also check out some of the applications on
sites like www.hotscripts.com and www.sourceforge.net
to see how they have structured their database for
similar projects. (or maybe you
We have a problem to have a long life for the temporary table on innodb
mode. We create the table, but after some minutes of inactivity the sistem
drops the table. My.ini in as follow. Which is the parameter to correct the
problem ?
Tks
Massimi
-
# Example mysql config file.
#
Ok, I've read the release notes, the manual, the threads on this
mailing list, installed/removed/re-installed about 5 times, tried
4.0.1, 4.1, 5.0, and I can't get MySQL to run on my Mac (dual-proc
867MHz, 768MB RAM). When I run configure, it tells me everything is
hunky-dory and that I
84 matches
Mail list logo
