Michael Stassen wrote:
Chris wrote:
snip
select *
from customers c, issues i, customer_issues ci
where c.customerid=ci.customerid
AND ci.issueid=i.issueid;
Chris wrote:
snip
That query should be the same as this one:
select *
from customers c
inner join customer_issues ci
bruce wrote:
hi...
i changed the mysql my.cnf to provide log files. i restarted mysql, but i
don't see the log files...
any idea as to what i may have missed. i'm running FC4, mysql 4.1.
the my.cnf is:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable =
Peter South wrote:
Ok here is what I'm trying to do.
Table 1 Table 2
Table 3
Column1(id) Column2 (score) Column1(id) Column2(score)Column1(id) Column2(name)
1
bruce wrote:
chris...
hate to tell you.. .but you can have the log files set as i described..
the real issue was due to permission issues on the dir/file for the mysql
lol.. i'm not having much luck answering questions lately ;)
Thanks for letting us know about the fix.
--
MySQL General
[EMAIL PROTECTED] wrote:
Hi All,
I want to copy a table (along with its contents) from one
database to another database.
In the destination database the table doesn't exist. Please let me know,
if there is any way to do it.
mysqldump -u username -p original_databasename | mysql
Rhys Johnson wrote:
Thanks for the reply Chris
I seem to have the remote database working just as fast as the local one
after comparing the my.cnf settings. Query times have dropped from 3.6s
to 0.4s. However, now when I log in from a shell prompt remotely into
mysql it takes about 10s for my
[EMAIL PROTECTED] wrote:
Hi,
There is a problem with CPU utlization when using INNODB. The CPU
utilization goes to 100% in a dual processor solaris box. With the same
setup, myISAM uses only 60% of the CPU.
As I said before, stuff like 'count(*)' queries cannot use an index in
innodb - if
Brian E Boothe wrote:
hey guys ;
it's not Customers Per issue it's the other way around issues per
customer
i enter in Customer 1 and then down the road i wanna add a issue
associated with that customer, so goto that customer and Click Add issue
the a form Comes up and i add the issue and
CREATE FUNCTION CharValIsNumeric (v VARCHAR(15))
RETURNS boolean
BEGIN
declare i, l int(2);
set l=char_length(v);
set i=1;
while (i = l) and (substring(v,i,1) in
('1','2','3','4','5','6','7','8','9','0')) do
set i=i+1;
end while;
What if the string (v)
Daniel Kasak wrote:
Hi all.
I discovered a very strange and painful problem on a customer's system
last night.
I have built a gtk2-perl GUI front-end for accessing data in a MySQL
database. It works remarkably well on my laptop, and was working
remarkably well on their system as well, but
Daniel Kasak wrote:
Chris wrote:
I'd see if you can get logging enabled.
I will do that next visit, yes. I was pushed for time - in between 2
other commitments, and wasn't expecting problems.
When the pauses happen try a 'show process list;' and see what else
mysql is doing at the time
Daniel Kasak wrote:
Chris wrote:
Could be a simple network issue too.. are pings fast/slow?
Pings are very fast.
The reason I asked about that last one was some of the suggestions on
this page:
http://www.debuntu.org/2006/07/21/75-how-to-optimize-mysql-response-time/
OK. I've had a read
a problem if more than one person were trying to
insert a record in that table at the same time? Could that not cause
the ID to be the same for 2 records
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want
give the gifts they want
One stop wish list for any gift,
from anywhere
; but it doesn't perform the date update I want
it to perform.
Any suggestions? Thanks
-Chris
Chris Ripley
[EMAIL PROTECTED]
KOZE Radio
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Brian E Boothe wrote:
how do i do 1 to many relationship?? i have this SQL syntax i may need
to add many issues per customer so this is what i have
Please help
SELECT *
FROM
mcsdata.customers
INNER JOIN mcsdata.issues ON (mcsdata.customers.id = mcsdata.issues.id)
Neil Tompkins wrote:
The problem appears to be retrieving the data which is slow.
Are you sure it's not the actual query that's slow?
If you run the query in mysql (ie through the command prompt) is it fast?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Peter Lauri wrote:
[snip Chris]
If you want multiple customers to be associated with each issue you need
3 tables:
create table customers (customerid int auto_increment primary key,
customername varchar(255));
create table issues (issueid int auto_increment primary key, issuetitle
Peter Lauri wrote:
[snip Chris]
The 'where' clause cuts that down to only matching records between the
tables. Without the where, you'd end up with lots of rows but with the
where it will be fine.
[/snip]
Yes, it cuts it down to that number of records in the end, so the final
result set
[EMAIL PROTECTED] wrote:
Hi ,
select count(*) is painfully slow in case of innoDB when the number of
records are around 1 million. Ths select count(*) query in myISAM takes
0.01 secs and the same query in InnoDB takes around 20.15 secs.
Can anybody suggest me how to speed up this query ?
Rhys Johnson wrote:
Hello
I am running an online web shop using a MySQL (v5.0.19) backend. The web
app runs really fast whilst the MySQL database is on the local machine
(2x PIII procs, 2GB mem). However I tried moving the database onto a
dedicated database machine (2x P4 Zeon 4Gb Mem Raid5) and
data_values;
+---+++
| int_value | value2 | value3 |
+---+++
|11 | 12 | 10 |
+---+++
1 row in set (0.00 sec)
You can do like that.
--
Chris White
PHP Programmer/DBrother
Interfuel
--
MySQL General Mailing List
of tables. Are you sure you didn't
mean rows? Removing tables like will accept a table name and that's about
it, you can't run conditions for it (as far as I know..).
--
Chris White
PHP Programmer/DBloomers
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
All right, so how would one set up a select where
rows 1 and 2 are text and row 3 is a blob
and for argument sake assume jpg for the moment.
You want to select a row based on the content (image) of the jpg?
Not possible unless you pass the whole blob into mysql so it can
retrieve the
Randy Paries wrote:
Hello,
I have a table (see below) that has 111599 records in it.
When i do a query like select * from gallery_object where dir = 'dirname'
Use explain to see if it's using the index:
explain select * from
it could be that for that particular directory you have a lot
Tanner Postert wrote:
so if i have a list of records...
id name other
1 water H2O
2 water aqua
3 water liquid
so i want to select other where name = 'water'
but i want to only return 1 result, and for that result to be a random
value. is there a way to sort by rand() ?
Yes.
Funnily
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the
Problem wrote:
I use SELECT all from * ... and one row is a gif.
How do I get that gif to appear as a gif and not text?
In your connecting programming language.
Mysql doesn't know or care whether it's a gif, pdf, word doc or
Jieqi Wang wrote:
I am using WinXP, GNU Emacs 23, MySQL 5.
When I start a mysql process with `sql-mysql' in emacs, no output is
displayed in the buffer until I quit or kill the process.
After I add the following line into the initialization file of emacs,
(setq sql-mysql-options '(-C -t
MYSQL wrote:
Hi,
I recently updated to version 4.1.2 from a slightly older one like
4.1.11 or something. But I am now having a problem.
Before,this query would work fine:
Select distinctrow * from mytable order by mydatecolumn.
mydatecolumn is a column of type date.
This used to return
Mark wrote:
Dear MySQL-ers,
Using MySQL 4.1.20, I'm trying to do a complex query on a subset; well,
complex to me, that is. :)
In Perl, I'm trying to get 4 random entries from a subset WHERE processed
= '1' and columnId is unique. Like so:
$sth = $dbh-prepare (SELECT columnId FROM queue WHERE
Mark wrote:
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: maandag 14 augustus 2006 3:55
To: Mark
Cc: mysql@lists.mysql.com
Subject: Re: Random SELECT on subset
In Perl, I'm trying to get 4 random entries from a subset
WHERE processed
= '1' and columnId is unique
Chris W wrote:
By default MySQL uses port 3306 so you need to be sure that port is open
on the server, and not blocked by a firewall. You also need to be sure
the user you are trying to login as can login remotely. In the MySQL
user data base, there is a column for host which is the host
Steffan A. Cline wrote:
I have the following query:
select *,
if( season_week_date = 2006-08-16, on, off ) as stat,
sum(overall_points) as total_points
from rosters r
left join celebs c
on c.celeb_id = r.celeb_id
where
season_id=5062
and user_id=1
group by r.celeb_id
order by
ali asghar torabi parizy wrote:
hello.
i want to connect to mysql from c++ .
i examine any version or platform.
i use mysql5 and 4 in suse10 with gcc.then examine mingw and mysql5 and 4
and 3 for severeal times but i can't solve this problem.when i want to compile
examples of mysql++
André Hänsel wrote:
Hi,
I have one table with images (image_id, name, filename, vote_count) and one
table with votes (vote_id, image_id, vote_value, user_id).
I want to find the image with the lowest vote_count that a known user has
not yet voted.
For MySQL 4.0 I have the following:
SELECT
Mark wrote:
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: maandag 14 augustus 2006 4:18
To: Mark
Cc: mysql@lists.mysql.com
Subject: Re: Random SELECT on subset
Then I want to select 4 random columnIDs, but only from the
subset WHERE processed = '1' (so, from
VenuGopal Papasani wrote:
Hi,
i got a table datavalue as follows
code period value
c1 20051
c2 20052
c32006 3
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the
Problem wrote:
On Mon, Aug 14, 2006 at 10:42:50AM +1000, Chris wrote:
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the
Problem wrote:
I use SELECT all from * ... and one row is a gif.
How do I get that gif
Mark wrote:
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: maandag 14 augustus 2006 4:54
To: Mark
Cc: mysql@lists.mysql.com
Subject: Re: Random SELECT on subset
Hmm, this still does not do what I want:
SELECT columnId FROM queue WHERE processed = '1' ORDER BY RAND
Mark wrote:
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: maandag 14 augustus 2006 6:32
To: Mark
Cc: mysql@lists.mysql.com
Subject: Re: Random SELECT on subset
Thanks to you, the query has been greatly simplified, but
the result is still the same: every once
database with these
details? if
so how?
Im sorry for asking seemingly obvious questions, but some assistance
would
be greatly appreciated.
Thanks,
Sana
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want
give the gifts they want
One stop wish list for any gift,
from anywhere
Can the output of the DESCRIBE be stored somewhere ( in file)?
You can store it where-ever you like. Mysql stores it in a binary file
which you can't read (ie it's not like the my.cnf file).
I suppose the DESCRIBE query doesn't return the result set.
What are you after exactly? Using
Ratheesh K J wrote:
Helo all,
Just wanted to know when should a Table be considered for partitioning ( or
should it be archiving ).
Almost all of our tables are of Innodb type. I am looking for an estimate rather than a
Depends on situation kind of an answer.
We have few of our table swhich
Ratheesh K J wrote:
Hello all,
I have a doubt on Index Merge.
We are currently using MySQL server 4.1.11. As a part of DB management I am
currently doing an analysis on all the Tables.
While looking into the table structures, their columns and Indexes I found that
most of the tables have
Asif Lodhi wrote:
Hi,
I am replying back to my own post. Sorry, I forgot to mention that I
am using mysql client on WinXP Pro SP2 and MySQL-5.0.22 is installed
on the same machine.
Any hints as to why mysql client is showing this behavior?
The only thing you're changing is the delimiter?
James Neff wrote:
Greetings,
I need help with a select statement that finds duplicate sets of rows.
I have a table like so:
batch_data
---
ID - int (auto inc)
Record ID - int
DataValue - VarChar(99)
DataType - int
With a sample of data like this:
1 100 1122A 1
2
Brian E Boothe wrote:
hi all
Can someone provide a small project using inner and outter joins with
querys thanks alot
create table t1 (id int);
create table t2 (id int);
This will find everything that has an entry in both tables:
select * from t1 inner join t2;
This will find records that
MySQL 5, btw.
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Never trust a man who, when left alone in a room
with a tea cosy, doesn't try it on.
-- Billy Connolly
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
At 8:49 -0500 9/8/06, Dan Buettner wrote:
Chris, I'm not aware of a way to use ordinary SQL (insert, update)
for this, but the use of a stored procedure would work for you. I've
not done it with MySQL (never had a need) but did things like this
extensively with Sybase.
In rough terms:
CREATE
The Definitive Guide to MySQL 5 by
Michael Kofler (Apress) to be a good resource.
Thank you,
Vittorio
--
Chris White
PHP Programmer/DBarbaric
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to
unescape the slashes generally. Unfortunately I can't remember in PHP if
that's because of magic quotes or just the way the db has it stored. My gut
instinct is the former.
thanks for any help.
-afan
--
Chris White
PHP Programmer/DBaboon
Interfuel
--
MySQL General Mailing List
For list
On Wednesday 09 August 2006 08:37 am, Kristen G. Thorson wrote:
[ stuff here ]
kgt
I'm confused.. did you read my email? Most of what you said doesn't seem to
correlate with what I said. Can you quote the specific lines that you're
disagreeing with?
--
Chris White
PHP Programmer/DBacillus
to the respective values.
thanks
--
Chris White
PHP Programmer/DBanjo
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 8/8/06, thomas Armstrong [EMAIL PROTECTED] wrote:
Hi.
My Linux server has just restarted due to memory problems.
Browsing mySQL logs, I've found out 5,000 lines like these in less
than one hour:
--
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file:
'my_table.MYI' (errno:
On 8/8/06, Yves Goergen [EMAIL PROTECTED] wrote:
Hello,
I was just trying out the mysql_upgrade script on my MySQL 5.0 server
but it shows an error message that makes me believe it doesn't know
where to find its own data.
Here's what I did:
mysql_upgrade --basedir=/usr/local/mysql5
John wrote:
I get this error:Fatal error: Cannot redeclare class
mysql in /home/public_html/n/config.php on line 6
This is a php question, it's not a mysql problem.
Find a more appropriate mailing list/forum.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
[EMAIL PROTECTED] wrote:
what us the maximum filesize for longblobs in kb? Is there anything bigger?
That's answered in the documentation - http://dev.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
in the SQL
clause.
--
Chris White
PHP Programmer/DBaby
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.act_functl_assoc
where subj_act_id =24;
show?
Sorry about that, typo on my part, but I have tried it as above and I get
the error I mentioned.
--
Chris White
PHP Programmer/DBlinds
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
not really looking for code snippets but rather the name for this
idea and/or links so I can rtfm. :)
Thanks,
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Chris W. Parker wrote:
Hello,
I'm not sure if this is possible (or what it's called, and how to search
for it) at the db layer or if this has to be done at the application
layer... I would like to be able to delete one record in one table and
then automatically (without making an extra call
Chris mailto:[EMAIL PROTECTED]
on Monday, August 07, 2006 6:19 PM said:
Foreign keys with an on delete cascade should do it.
http://dev.mysql.com/doc/refman/5.1/en/example-foreign-keys.html
Thanks everyone!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
,
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Chris W. Parker wrote:
Hello,
Me again. Excuse for sending two questions so closely together.
I'm looking through the MySQL manual (as well as searching Google and
the PHP site's MySQL functions) trying to find out how to test an Insert
statement (or any other statement for that matter
Charlie Stanton wrote:
From: root
To: mysql@lists.mysql.com
Subject: mysqld won't start
Description:
In an attempt to upgrade to MySQL 5.0.24 it was necessary to use
rpm -e ... to remove version 5.0.22 then rpm -U ... to install
the shared,server and client modules.
When I do a
Chris White wrote:
On Monday 07 August 2006 12:13 pm, William DeMasi wrote:
I meant to have it say :
select * from c2iedm_dev2.act where act_id IN (select obj_act_id from
c2iedm_dev2.act_functl_assoc where subj_act_id =24);
What does the output of (the subselect):
select obj_act_id
from
are interested in.
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occasion!
http://thewishzone.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
David T. Ashley wrote:
On 8/6/06, Chris W [EMAIL PROTECTED] wrote:
David T. Ashley wrote:
Can I just write something like:
SELECT * FROM mytable WHERE fieldofinterestvalue ORDER BY MIN(field1,
field2) ASC;
I think this will work..
SELECT *, IF(a-b 0,a, b) as SortField
FROM table
for DB X and the Slave for DB Y AND Server B would
be the Master for DB Y and Slave for DB X. The reason I am doing this
is just for keeping a backup. Is this a bad idea? Any better ways?
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want
give the gifts they want
One stop wish
Enrique Sanchez Vela wrote:
Chris,
Replicating for the sake of backups is in general a
bad idea, since once you delete/update a record, it
will be automatically propagated to the slave server.
Replication, should be used to provide better
availabilty/load balancing but that would need
nayak_ratnadeep wrote:
Hello,
I have downloaded a code on c++ to talk to MySQL database from net which
included a file sqlplus.hh , where may I find the file?Please help me
soon.
Why have you posted this 5 times?
Did you look at the mysql website at ALL?
It took me 30 seconds to find
nayak_ratnadeep wrote:
I found in net but can't get the file. please help me..
Always reply to the list.
Here's a hint: look for C++ API in the documentation.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Daevid Vincent wrote:
I posted this as a comment on the page too, but I’m curious as to why the
top solution is off by a day or so... Is this a bug or a rounding issue or
what? Is there a way to fix the top one to work the way I expect/want it
to work? I suspect it's because (as Jack Palance
, but as a relative
novice... you know how it is. :-)
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Justice is incidental to law and order.
-- J. Edgar Hoover
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
in my
opinion is a Bad Idea(tm).
--
Chris White
PHP Programmer/DBeer
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
Thanks very much! Problem solved.
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Consider for a moment any beauty in the name Ralph.
-- Frank Zappa
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
questions can
easily be answered by a quick skim through the sql before running it. If you
believe that to be tiresome, think of how long it's going to take you to get
order from chaos when things go down.
--
Chris White
PHP Programmer/DBirth
Interfuel
--
MySQL General Mailing List
For list archives
On Friday 04 August 2006 11:26 am, Daniel da Veiga wrote:
Think better before you hit send.
Dude
--
--
Chris White
PHP Programmer/DBarn
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 8/5/06, Karl Larsen [EMAIL PROTECTED] wrote:
I am using Linux called Fedora Core 4. I had no problem getting
mysql 4 working here and liked it a lot. But when I discovered 4 doesn't
have VIEW but 5 does I have tried several RPM sets of 5 that fail for
basic reasons. The reasons are the
Ratheesh K J wrote:
Hello all,
I am required to analyze all the tables of our system. I need to know the key
parameters that should be taken into consideration for analysis. I am not speaking
about ANALYZE TABLE tbl name. I am required to manually look into all table
structures and pin point
Vittorio Zuccalà wrote:
Hello,
i'm installing an open source program based on mysql because i want to
try it.
It controls mysql's version and it wants 4.1.16 but i've 4.1.11...
Is it possible telling to mysql server to give a different number of its
version?
In other words: is there some
bruce wrote:
hi...
i have FC3/4 systems. i'm going to need to have mysql-5.0.22, but there
appears to be numerous dependencies that yum can't easily resolve from the
RPM i've found.
can i reasonably easily build mysql-5.0.22 from src for my FC3/4 systems...
the systems are pretty much standard
Arias Gonzalez, Javier wrote:
Assuming we have the following table:
CREATE TABLE test (
id INT NOT NULL,
last_name CHAR(30) NOT NULL,
first_name CHAR(30) NOT NULL,
PRIMARY KEY (id),
);
With last_name having 1,000 different values and first_name having
bruce wrote:
hi chris...
i tried that approach with MySQL-5.0.22
i did the rpmbuild -- ...
and got the rpms for mysql.
when i tried to install the mysql server rpm, it kicked out the dependency
error regading the libmysqlclient.so.14... other apps require this version
apparently.
i would
we are working on automotive traking solutions and insert our location records
into the mysql database v 4.1.20. If we want search for a particular record,
its taking too long time and mysql is identifying the queries as slow queries.
I have attached the queries.
You've posted this multiple
sqlplus
(oracle) and sql (mysql)
If you change servers it should be as simple as changing connection strings
(ie. what host). Not sure if that quite answers your question.
--
Chris White
PHP Programmer/DBranded
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
to certain custom configuration
options required), but the binaries should be the same wrt stability.
--
Chris White
PHP Programmer/DBoldSansVeraMono
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
kalin mintchev wrote:
hi all...
how can i do a query on a list of ids without doing individual queries
for each one of them?
something like:
select id,title from content where id = 100,106,109;
select id,title from content where id IN(10,20,30);
--
MySQL General Mailing List
For list
TK wrote:
My MySQL server (4.0.20, Linux) was running slowly. I checked the slow queries
log, and found many of these during the problem period:
# Time: 060730 20:44:40
# [EMAIL PROTECTED]: xxx []
# Query_time: 68 Lock_time: 0 Rows_sent: 0 Rows_examined: 2
# administrator command: Quit;
#
Penduga Arus wrote:
On 7/31/06, Peter Lauri [EMAIL PROTECTED] wrote:
What version of MySQL do you have? Depending on that, there are different
methods.
MySQL 5, can you please show me how to do it..
Did you look at the link David sent you?
(p.fee) as fee,
then MySQL doesn't know which 'fee' to look at
for fee 0.
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Remember there's a big difference between
kneeling down and bending over.
-- Frank Zappa
--
MySQL General Mailing List
For list archives: http
Starting to build a new schema, and one of the items is image storage
In the past I have always used filesystem storage.
Was wondering if I could get a conversation started on the pros/cons
of database storage verse filesystem
Thanks!
--
--
please respond to the
Asif Lodhi wrote:
Hi Chris,
On 7/28/06, Chris [EMAIL PROTECTED] wrote:
i'm trying to figure out how to allow all users on machines within my
network access to a mysql db...
with no luck..
...
Have you got mysql listening for network
chylli wrote:
chylli [EMAIL PROTECTED] writes:
Chris [EMAIL PROTECTED] writes:
Because you're adding all columns from a and b into it.
It is too slow. Has anyone better methods to do that work?
Drop the indexes on c and create them at the end.
Each row that's being added, it's updating
leo huang wrote:
hi, Chris
I'm sure it will, what makes you think it won't?
Because some paper say that when the row is deleted or update, Innodb
just make a mark that the row is deleted and it didn't delete the
rows. I can't find more information about the re-use tablespace. Can
you give me
. That's the safer bet.
--
Chris White
PHP Programmer/DBackToTheFuture
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dyego Souza Dantas Leal wrote:
I have a Dell P2800 SERVER WITH:
Red Hat AS 4 ( 64 bit machine)
6 GB of RAM
Dual Xeon DUALCORE 2.8Ghz with 2MB of L2 Cache
I will use MySQl 5.0 and InnoDB, exits a config to use all power of this
server ? the developer guys can send-me a config ?
There is
chylli wrote:
I run following command :
use db1;
insert into db2.c select a.a, a.b, a,c, b.d, b,e ... from a left join b on
(a.id=b.id);
Do you have an index on a.id and b.id ?
size of table a and table b is:
[EMAIL PROTECTED] ls -l ../db1/a.*
-rw-rw 1 mysql mysql 9230 May 10 15:41
Grass Cake wrote:
I'm still unsure about foreign keys..even after reading the doc file and
Paul Dubois 3rd edition
My doubt is...how much constraint is applied.( probably a bad
explanation)
If i have a table 'Customers' with the primary key being 'CustID'
Then i have a table 'LastVisit'
bruce wrote:
hi...
i'm trying to figure out how to allow all users on machines within my
network access to a mysql db...
i've tried:
grant access all on *.* to '*'@'%'
grant access all on *.* to '%'@'%'
grant access all on *.* to @'%'
with no luck..
What errors do you get when you try to
Dirk Bremer wrote:
I am using MySQL server 4.1.10 on Windows 2003 Server with MyISAM
tables. I have an issue where occasionally an index (MYI) file becomes
corrupted. I do not know why this occurs. To combat this issue, I tried
running the following command every half-hour:
mysqlcheck -Aamov
401 - 500 of 2034 matches
Mail list logo
