Hi,
as you know, MD5 and SHA1 are more or less broken so I guess it is time
to think about including other hash-functions in MySQL. First of all it
would be sensible to include SHA256 / SHA512, because they are designed
a bit different to SHA1 and though are more safe. Another issue is to
include
On Wed, 8 Mar 2006 10:12:22 - [EMAIL PROTECTED] wrote:
snip one column select query
but I have two other filters which may or may not be chosen. (area, and
interest).
$query = SELECT * FROM $table_name WHERE sname LIKE '$search_string%' AND
area='area' AND interest='interest' ORDER
Hi all,
Is there any possibility to convert and store a shape file into the
mysql database like postgis feature in postgres.If there any please give me
the steps how to convert or the link that consists of this documentation.
Thanks in advance,
Regards,
venu.
yes.
on linux it is possible to convert shp files you have to use libmygis
avaliable at http://jcole.us/software/libmygis/
shann
___
Halloween Humour: Why did Dracula divorce his wife after 800 years?
postmaster.co.uk
This is a question onto defining foreign keys in a relational database.
Foreign keys are featured by the InnoDB engine and therefore all three
tables of the database use it:
1. `friends` main table
2. `relation` deploys a simple relation between rows of the main table,
'1-2' means '1 is
Hello Andreas,
You're not telling us what version of MySQL you're using,
so I'll have to give it a shot in the dark ...
mysql SHOW CREATE TABLE friends\G
*** 1. row ***
Table: friends
Create Table: CREATE TABLE `friends` (
`id`
1) Sorry for not giving you the version:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
*mysql SELECT VERSION();
+---+
| VERSION() |
+---+
| 5.0.17-nt |
+---+*
1 row in set (0.00 sec)
2) Further, please note that the following output, of
I have 3 tables
Table 1: user(id, name, surname)
Table 2: crime(id, detail)
Table 3: user_crime(id, user_id, crime_id)
Table 1
1, OKAN, ARI
Table 2
1, detail 1
2, Detail 2
Table 3
1, 1, 1
1, 1, 2
So user 1 takes 2 crime from crime table...
I want to receive info with 1 query: I need name
Andreas Krüger wrote:
1) Sorry for not giving you the version:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
*mysql SELECT VERSION();
+---+
| VERSION() |
+---+
| 5.0.17-nt |
+---+*
1 row in set (0.00 sec)
snip
InnoDB Status after
Hi, we have a db with myisam and a single innodb table. 2 separate
processes are inserting data into the myisam tables and the innodb table at
the same time. We have noticed an issue where commits to the innodb table
appear to be delayed until the process inserting into the myisam tables is
OKAN ARI wrote:
I have 3 tables
Table 1: user(id, name, surname)
Table 2: crime(id, detail)
Table 3: user_crime(id, user_id, crime_id)
Table 1
1, OKAN, ARI
Table 2
1, detail 1
2, Detail 2
Table 3
1, 1, 1
1, 1, 2
So user 1 takes 2 crime from crime table...
I want to receive info with 1
Thanks Michael, that' s the problem. Syntactically my attempt was
correct. Only I had the *value '1' in the only row that table
`friends`contains, whereas table `category`was still empty*. (I was
about creating the database for sample purposes.) When I tried to create
the FOREIGN KEY out of
Using this code I get this error message.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL
result resource in /usr/local/www/data/mls_verifyemail.php on line
49
What code should I use to check if the update worked or not?
$query = UPDATE members SET email_verified='X' WHERE
Perhaps reading the manual would be a good start at
http://us3.php.net/manual/en/function.mysql-num-rows.php
It clearly states
Retrieves the number of rows from a result set. This command is only
valid for SELECT statements. To retrieve the number of rows affected by
a INSERT, UPDATE, or DELETE
All ready read that and its clear as mud.
It tells you update is different but gives no example.
I asked in my post what should I code for checking the result of a
update.
-Original Message-
From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 12, 2006
looks a bit strange to me.
$result = mysql_query($query) or die('Query couldn\'t
executed:'.mysql_error());
please try something like this:
// build the query - (that's OK)
$query = UPDATE members SET email_verified='X' WHERE
logon_id=' .$logonid. ';
// send the query to the server - save
I recently discovered that all my websites were wrecked. I spent several hours
trying to troubleshoot it, until I finally discovered that my database was
missing. I asked my webhost about it, and they told me they deactivated it
because it was overwhelming the server.
Someone told me
Maybe I need to read the copy of php pocket reference I have
to David - LOL.
Keith
On Sun, 12 Mar 2006 [EMAIL PROTECTED] wrote:
To: mysql@lists.mysql.com
From: [EMAIL PROTECTED]
Subject: Re: Checking for good update
looks a bit strange to me.
$result = mysql_query($query) or
Is this a free hosting package David B?
That's a bit naughty I think - just removing your database
without warning you about it first. At least you would have
had time to make a backup copy.
Keith
In theory, theory and practice are the same;
In practice they are not.
On Sun, 12 Mar 2006,
[EMAIL PROTECTED] wrote:
Is this a free hosting package David B?
That's a bit naughty I think - just removing your database
without warning you about it first. At least you would have
had time to make a backup copy.
* * * * *
I'm paying $50 a month, and I was blown away when they
At 04:27 PM 3/12/2006, David Blomstrom wrote:
I recently discovered that all my websites were wrecked. I spent several
hours trying to troubleshoot it, until I finally discovered that my
database was missing. I asked my webhost about it, and they told me they
deactivated it because it was
David,
Who was the ISP? Maybe they'd like some free advertising. :)Ha! I'd
better wait until April 1, when I hope to have a new home.
I've actually been promoting this webhost since I've been with them. They
just flaked out very badly all of a sudden. Coincidentally, they had a
Maybe I have the overall logic wrong.
I don't do a select query first to see if that record is there.
I just try to update it.
If the logonid key in the update request is on the table, the record
does get updated. I can verify that using phpmyadmin.
When the logonid key in the update request
fbsd_user wrote:
Using this code I get this error message.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL
result resource in /usr/local/www/data/mls_verifyemail.php on line 49
What code should I use to check if the update worked or not?
Your second line does just that.
[EMAIL PROTECTED] wrote:
looks a bit strange to me.
$result = mysql_query($query) or die('Query couldn\'t
executed:'.mysql_error());
please try something like this:
Why? There's nothing wrong with the above statement.
// build the query - (that's OK)
$query = UPDATE members SET
Hello Ryan. I am more of a developer than a MySQL administrator. Hence, I
would always favour applications logging query errors rather than being
dependent on MySQL to generate a log for me. Of course, I may be wrong.
You could write a query execution function, say exec_mysql_query(...) in one
of
26 matches
Mail list logo