Aman Raheja wrote:
Latest realease is 4.1.7 in 4.1.x but I am looking for 4.1.5 source
download.
Pointers will be helpful.
Thanks
Aman
http://downloads.mysql.com/archives.php?p=mysql-4.1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
On 07/01/2004 11:48 PM [EMAIL PROTECTED] spoke:
I have MySQL 3.23 installed, which comes with RedHat ES3. I find that
innoDB is not enabled. Anybody knows can I enable it?
Thanks,
Joseph
Recompile the binary or upgrade to one that includes it.
I don't think there is a runtime switch.
--
MySQL Gener
Moved from a PHP list to a MySQL list. :-)
On 06/30/2004 09:55 PM John W. Holmes spoke:
Bob Lockie wrote:
If I select rows with a limit clause I need to know if there are more
rows than the limit.
Either do a SELECT COUNT(*) prior to your LIMIT query to see how many
total rows there are, or use
On 06/30/2004 02:46 PM Andrew Pattison spoke:
The way I do this is within PHP is to echo the value stored in mysql_error
after each SQL statement. If you're not using PHP then this probably doesn't
help though ;-)
I'm not using PHP.
I'm loading tons of data with SQL statements from the command line
I'm running a ton of sql statements to load data.
Is there a way to not display successes:
Query OK, 1 row affected (0.02 sec)
Records: 1 Duplicates: 0 Warnings: 0
and display failures and the query statement that failed?
There are 60 000+ of these and I'd ideally like to debug the inserts
witho
On 06/21/2004 05:02 PM Brent Baisley spoke:
The opposite of the query would be a.type!='X' and there is no related
record in table b. Not sure if that is what you what
It isn't what I want because there could be other a.type other than 'X'.
Oops, that should be b.type
I need to return the a record
On 06/21/2004 04:26 PM [EMAIL PROTECTED] spoke:
I don't understand. You want every other record except .what?
By flipping the equality the way you did, you should see all of the records
where a.id = b.id (regardless of what the b.type value is) where a.type was
not 'X' which is one reasonably v
I have:
select name from a, b where a.type='X' and a.id=b.id;
I want a query to return all the rows that were NOT found by the above
query.
I can't simply do:
select name from a, b where a.type!='X' and a.id=b.id;
because there is more than one row in b for each type!='X' but there is
only one r
Luiz Rafael Culik Guimaraes wrote:
Dear Friends.
when Creating the follow table
I got an Erro when defining Column DESC(same error even if DESC is between
"")
DESC is a reserved word, try something else.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
Where is the syntax error in this?
select name from users where name like '%' and strcmp( substr(name from
1 for 3), 'abc' )=0;
Why should I use strcmp since "MySQL automatically converts numbers to
strings as necessary, and vice versa."?
--
MySQL General Mailing List
For list archives: http://
On 06/04/04 11:28 Bob Lockie spoke:
Rows matched=1 but rows changed=0. :-(
What is wrong with my query?
mysql> update records, audit_log, audit_log_records
-> set records.name=audit_log_records.name,
-> records.type=audit_log_records.type,
-> rec
Rows matched=1 but rows changed=0. :-(
What is wrong with my query?
mysql> update records, audit_log, audit_log_records
-> set records.name=audit_log_records.name,
-> records.type=audit_log_records.type,
-> records.content=audit_log_records.content,
-> records.ttl=audit_log_reco
What I really want was
mysql> update records set records.prio=2 where records.in=(select
records.id from records, audit_log, audit_log_records where
audit_log.tracker_id=audit_log_records.tracker_id and
records.id=audit_log_records.id and audit_log.operation='D' and
audit_log.completed is null)
I want to do something like this:
delete from records where records.id in (select audit_log_records.id
from audit_log_records, audit_log where
audit_log.tracker_id=audit_log_records.tracker_id and
audit_log.operation='D');
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
On 05/31/04 15:42 Donny Simonton spoke:
It depends on which version of MySQL you are using. Since you are using a
subquery, I assume you are using a fairly new version.
Delete audit_log_records from audit_log_records, audit_log where
audit_log_records.tracker_id = audit_log.tracker_id and
audit_lo
I need help with this SQL.
I want to delete all records from the 'audit_log_records' table that
have 'tracker_id' columns that are the same as those from the audit_log
table that have 'A' for the operation type.
delete from audit_log_records where tracker_id=(select tracker_id from
audit_log wh
On 05/21/04 20:40 Laercio Xisto Braga Cavalcanti spoke:
Hi all,
I'm using mysql 3.23.54 under RedHat9 trying to update a field named
pac_fone in a table named paciente with the value of a field named
ita_fone from a table named italica as follows:
Try more quotes and get the select to work:
select
I am posting this on behalf of a Gentoo user.
Does anyone know why this warning happens?
# /etc/init.d/mysql start
* Could not get dependency info for "mysql"!
* Could not get dependency info for "mysql"!
* Starting mysqld...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
On Wednesday, January 22, 2003, at 01:07 PM, Bob Lockie wrote:
I am trying to remotely connect to a MySQL database but I'm having
problems so I tried this on the same machine as the database.
Thanks, to all who replied.
I have it working.
--
Sent
I am trying to remotely connect to a MySQL database but I'm having
problems so I tried this on the same machine as the database.
It doesn't work when I give it -h but it works without.
# mysql -h 10.0.0.5 -D visitor
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
but
Jeremy Zawodny wrote:
On Mon, Nov 04, 2002 at 12:54:17AM -0500, Bob Lockie wrote:
That fixed it, thanks.
What did it use since I didn't specify an @'localhost'?
It used '%' which matches everyhing *except* localhost. The manual
explains this.
Jeremy
It
Jeremy Zawodny wrote:
On Mon, Nov 04, 2002 at 12:37:12AM -0500, Bob Lockie wrote:
Does anyone know why?
create database visitor;
grant all on visitor.* to visitor_user identified by 'visitor';
use visitor;
mysql -u visitor_user -p
I get "ERROR 1045: Access denied for user
Does anyone know why?
create database visitor;
grant all on visitor.* to visitor_user identified by 'visitor';
use visitor;
mysql -u visitor_user -p
I get "ERROR 1045: Access denied for user: 'visitor_user@localhost'
(Using password: YES)"
From Mozilla
>check for ur permissions and ownership on that file.
The ownership on the directory but the ownership on the files was incorrect.
The script fooled me into assuming everything under the directory was correct since
the directory was.
>- Original Message -
>From: "Bob L
I haven't used mysql yet.
How do I fix this error when starting it?
#/d2/usr2/local/mysql-3.23.51/bin/safe_mysqld
Starting mysqld daemon with databases from /d2/mysql_db
020730 21:36:23 mysqld ended
# more /d2/mysql_db/host.err
020730 21:36:23 mysqld started
020730 21:36:23 /d2/usr2/local/my
./safe_mysqld --user=mysqld --datadir=/db/
./safe_mysqld --user=mysqld --datadir=/db/
020401 16:55:04 mysqld started
020401 16:55:04 /d2/usr2/local/mysql/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
020401 16:55:04 mysqld ended
My unix user is called mysqld and I want dat
26 matches
Mail list logo