Thank you again Prassad, and Dilip.
Hi!
System is Novell SBS 6.5 sp1 with Apache 2.0.48, MySQL ver. 4.0.15a,
PHP 4.2.3.
We try to define a select query that takes the values of the variables
'varKoshi' and 'varKvish' based on the following 4 tables:
'varKoshi' vv 'varKvish'
The code of insert_client.html which wasn't attached last mail:
http://www.spalha.com.br/spalha/form_client.html
Tom
From: Tom Lobato [EMAIL PROTECTED]
From: Peter Brawley [EMAIL PROTECTED]
Tom,
UPDATE command is not working for only the record that I want, but
for
all in the table.
Hello
I have been looking at planning the database strategy for openstreetmap
(http://www.openstreetmap.org).
There are several data types stored in tables with longitude and
latitude columns. Select statements work by selecting
where lat$lat1 and lat$lat2 and lon$lon1 and lon$lon2
I have
[snip]
The php and db structure and data are attacheds. Two infos: 1) Im
not a
expert 2) The code is in the beggining of the development, so are too
many
uglyness yet =)
[/snip]
Find a place online to post your code or paste it into the message (only
the relevant parts). Usually no one will
[snip]
Find a place online to post your code or paste it into the message (only
the relevant parts). Usually no one will open an attachment on a mailing
list.
[/snip]
Post the line of PHP where this query exists.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
hello,
does anybody now how mysqldump handles the actions
for 'on delete' and 'on update' ? In my Version 4.1.14
the action clauses are missing. When reimporting the
dump, how does mysql know about the 'action' when altering
the table with forein keys.
Thanks,
Nico
--
MySQL General Mailing
From: Jay Blanchard [EMAIL PROTECTED]
Find a place online to post your code or paste it into the message (only
the relevant parts). Usually no one will open an attachment on a mailing
list.
Oh Yes, sorry. In really, I indeed uploaded the files to the server
www.spalha.com.br/spalha.
Tom
Tom,
snip
Maybe a comunication trouble... Let me confirm. Are you saying that
http://www.spalha.com.br/spalha/DB_code.html
http://www.spalha.com.br/spalha/insert_client_code.html
are not the code Im having troubles? As the code Im having trouble
were some secret or so?
if ($yes){
From: Jay Blanchard [EMAIL PROTECTED]
Post the line of PHP where this query exists.
Well, I think that show
$result = mysql_query($command);
won't help us, because the $command indeed begins to be constructed 120
lines before this. Only looking the code =(
Tom
--
MySQL
I didn't look through your code very carefully. Have you confirmed (using
EXPLAIN) that your select query is using the index?
I don't much about the mysql optimizer, but it's possible that this query:
$query1=SELECT lat,lon from integer_test WHERE lat$lat1 and lat$lat2
and lon$lon1 and
Actually I think this should be an INNER JOIN -- not a LEFT JOIN.
A
On Apr 23, Adam Wolff wrote:
I didn't look through your code very carefully. Have you confirmed (using
EXPLAIN) that your select query is using the index?
I don't much about the mysql optimizer, but it's possible that
Hi Tom,
Have you tried turning on the logging on the MySQL server, and seeing exactly
what command the server is receiving - it may be different from the one (you
think) you are sending.
Quentin
-Original Message-
From: Tom Lobato [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 April 2006
Hi all -
I'm looking for a way to have a group of mysql servers that are all slaves
to a single master. That part I can do.
However, what I'd like is a way to put another server in front of the
entire cluster and have that pretend to be the mysql database, except that
it would simply
Paul Halliday wrote:
I am trying to formulate a query that will increment if a condition is true.
For example, if I do a select (just let me know if there was data on
this day, if so increment count by 1 and check the next day) where
timestamp between jan and feb.
Could you be a bit more
I am doing queries that produce a table that looks something like this:
Count | IP Address| First Seen| Last Seen | Days
5000 10.0.0.1 2005-12-102006-04-15 50*
6500 10.0.0.2 2006-04-012006-04-06 3**
*So of the 5000 events count(*)
On 4/23/06, Nick Hill [EMAIL PROTECTED] wrote:
1) I can improve performance by a factor of 2-2.5 by changing the double
lat/lon to an integer then selecting on an integer.
2) I have concluded that for each 10 fold increase in the number of
records, select queries take twice as long. For each
Alexey Polyakov wrote:
On 4/23/06, Nick Hill [EMAIL PROTECTED] wrote:
I've noticed a couple things.
1) Right now you're emulating spatial index.
2) In future, you're going to emulate partitioning.
Why do you think that doing this stuff manually is better than using
builtin capabilities?
1) I
Dependency issue, I would use RPM Package Manager.
It always solved that type of issue.
http://www.rpm.org/
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 3:17 PM
To: MySQL List
Subject: Older version MySQL
Hello,
I am attempting to
Dependency issue, I would use RPM Package Manager.
It always solved that type of issue.
http://www.rpm.org/
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 3:17 PM
To: MySQL List
Subject: Older version MySQL
Hello,
I am attempting to
Hello;
I have tried to build and install MySQL v5.0.18 on FreeBSD v6.0 RELEASE
running on AMD 64 socket 939
w/Gigabyte motherboard.
I have tried this twice and the same message occurs. Premission denied
to creat/write .pid file.
The strange thing is that I did this on another FreeBSD v6.0
Solved =)
From: Quentin Bennett [EMAIL PROTECTED]
Have you tried turning on the logging on the MySQL server, and seeing
exactly what command the server is receiving - it may be different from the
one (you
think) you are sending.
Turning on the logging on the MySQL server, I saw PHP
Solved =)
From: Quentin Bennett [EMAIL PROTECTED]
Have you tried turning on the logging on the MySQL server, and seeing
exactly what command the server is receiving - it may be different from the
one (you
think) you are sending.
Turning on the logging on the MySQL server, I saw PHP
Hi all,
I know I asked this question before and I do apologise for having to ask
again, but I have not been able to get this to work for us.
I modified the config file (there were many in the folder, not sure whether
I modified the right one) restarted the whole machine since then, but it
still
My response is mixed with your original post...
--- Jim [EMAIL PROTECTED] wrote:
Hi All,
We are unable to create functions, views and stored procs from
another
machine.
The error message is Access denied for user 'root'@'%' to database
'proplink'.
Then the user 'root' does not
Taco Fleur wrote:
Hi all,
I know I asked this question before and I do apologise for having to ask
again, but I have not been able to get this to work for us.
I modified the config file (there were many in the folder, not sure whether
I modified the right one) restarted the whole machine since
Hi, that would be version 5.0.18 - thanks
Kind regards,
Taco Fleur (Mobile 0421 851 786)
Commerce Engine Pty Ltd - Australia's leading online Payment Gateway .
Local Call 1300 859 179
Postal Address: PO Box 15118, City East Brisbane, Queensland, 4002,
Australia
Head office: 31 Valencia Court,
Nanu Kalmanovitz wrote:
Hi!
System is Novell SBS 6.5 sp1 with Apache 2.0.48, MySQL ver. 4.0.15a,
PHP 4.2.3.
We try to define a select query that takes the values of the variables
'varKoshi' and 'varKvish' based on the following 4 tables:
'varKoshi' vv 'varKvish'
Taco Fleur wrote:
Hi all,
I know I asked this question before and I do apologise for having to
ask again, but I have not been able to get this to work for us.
I modified the config file (there were many in the folder, not sure
whether I modified the right one) restarted the whole machine
In my-innodb-heavy-4G.ini I modified the following line ft_min_word_len =
3
There are a couple of .ini files in the same directory I just modified the
one that actually had the occurrence of ft_min_word_len in it.
Kind regards,
Taco Fleur
Commerce Engine Pty Ltd - Australia's leading online
Hi Prasad,
I have no my.cfn, I have a my.ini which is located at in the same directory
as the my-innodb-heavy-4G.ini
C:\Program Files\MySQL\MySQL Server 5.0
Kind regards,
Taco Fleur (Mobile 0421 851 786)
Commerce Engine Pty Ltd - Australia's leading online Payment Gateway .
Local Call 1300
31 matches
Mail list logo
