RE: Find the biggest blobs

Did you try: select blob_field from blob_table order by length(blob_field) DESC limit 1 Regards, Artem > -Original Message- > From: Roland Carlsson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 01, 2005 10:02 AM > To: mysql@lists.mysql.com > Subject: Find the biggest blobs > > > H

RE: How do I Put a 'Literal' Value in a Report Column?

see 12.2 Control Flow functions of MySQL manual select name, if(adopted=0,'N','Y') from animal; > -Original Message- > From: Sue Cram [mailto:[EMAIL PROTECTED] > Sent: Monday, February 07, 2005 2:58 AM > To: mysql@lists.mysql.com > Subject: How do I Put a 'Literal' Value in a Report Colu

RE: InnoDB engine as default for an entire database

default-storage-engine=INNODB in [mysqld] section of the config file will make InnoDB default for a server. > -Original Message- > From: symbulos partners [mailto:[EMAIL PROTECTED] > Sent: Friday, January 28, 2005 8:03 AM > To: mysql@lists.mysql.com > Subject: InnoDB engine as default for

RE: Installing MySql 4.1

I had similar problem after incomplete removal MySQL 4.0.x which left dead service named MySQL that points to non-existing path c:\mysql. I changed the windows service name for MySQL 4.1 to MySQL41, and it works fine. Also you can try to execute mysqld from command line to see any extra details:

RE: Cascade problem now error:

#x27;); > > > > CREATE TABLE MENU_GROUP_REL ( > > menu_type varchar(200), > > data_id int NOT NULL, > > display_name varchar(250), > > link varchar(250), > > ) type=INNODB; > > > > ALTER TABLE MENU_GROUP_REL ADD CONSTRAINT PK_MENU_GROUP_REL > FOREIGN K

RE: drop table is written to bin-log, load table is NOT - why????

Hello Lutz, I was not aware of this behavior of the master server. Maybe somebody with more insight can explain. If the traffic volume is so important I would turn on compression on the master-slave connection to reduce network traffic. I think it is slave_compressed_protocol=1 option in the [m

RE: cascade on delete problem

Hello Scott, Make sure your tables are InnoDB type: CREATE TABLE table_name ( table_def ...) ENGINE=InnoDB; If you have default MyISAM tables, it won't work because they don't support foreign keys. > -Original Message- > From: Scott Purcell [mailto:[EMAIL PROTECTED] > Sent: Thursday, J

RE: error in your SQL syntax

Try Query Browser ( http://dev.mysql.com/downloads/query-browser ) for building queries for MySQL. Regards, Artem > -Original Message- > From: Daniel Sousa [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 26, 2005 11:18 AM > To: [EMAIL PROTECTED] > Cc: mysql@lists.mysql.com > Subjec

RE: drop table is written to bin-log, load table is NOT - why????

Hello Lutz, As far as I know, binlog records only DML and DDL statements, and LOAD TABLE FROM MASTER is not the one. For selective replication I would check startup options --replicate-do-* and --replicate-wild-*. See http://dev.mysql.com/doc/mysql/en/replication-options.html for details. Also

RE: Serious bug (or my foolishness) with alter table and InnoDB

Works fine on WinXP 4.1.8. Only generates warning: mysql> show warnings; +-+--+--+ | Level | Code | Message | +-+--+--

RE: adding a large file to a database....

Did you try to increase max_allowed_packet in server config to 5M, for example. The default size is 1M and it is less then the size of your file (1.5M). Artem > -Original Message- > From: J.R. Bullington [mailto:[EMAIL PROTECTED] > Sent: Monday, January 24, 2005 11:45 AM > To: mysql@list

RE: Undo function?

Hello, If you define table type as InnoDB, you can use transactions (see the link below). You will need set AUTOCOMMIT=0, and after you can issue COMMIT or ROLLBACK at the end of query or session to submit or cancel a transaction. I don't think you can use transactions for mysql system tables b

RE: sub query is extermely slow

Check ALTER statement in MySQL doc. It explains how to add/modify an index after a table has been created. > -Original Message- > From: sam wun [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 19, 2005 10:00 AM > Cc: mysql@lists.mysql.com > Subject: Re: sub query is extermely slow >

RE: Replication Slave I/O Thread won't start on 4.1.8

> > - make sure log-bin is enabled on both master and slave > (looks like it is not present in the slave config) > > Why is log-bin needed on the slave? I thought the master logs changes > and the slave reads those changes and updates it's copy. Why should > the slave also log changes it is makin

RE: Replication Slave I/O Thread won't start on 4.1.8

- make sure log-bin is enabled on both master and slave (looks like it is not present in the slave config) - check replication account permissions on the master. I don't remember details, but you can find required permissions in the docs on mysql web site, or doc file in mysql installation direc

RE: Understanding MySQL column type SET

I have v.4.0.4b max nt, and I have the same result, even more: mysql> INSERT INTO settest SET chain="A,C"; ERROR 1062: Duplicate entry 'A,C' for key 1 mysql> INSERT INTO settest SET chain="C,A"; ERROR 1062: Duplicate entry 'A,C' for key 1 mysql> but mysql> SELECT * FROM settest WHERE FIND_IN_SET

RE: DBI Connect Fails after 20,000 record inserts/updates

Do you connect/disconnect before/after every insert? -Original Message- From: Dallas Engelken [mailto:dallase@;nmgi.com] Sent: Thursday, October 24, 2002 9:52 AM To: [EMAIL PROTECTED] Subject: DBI Connect Fails after 20,000 record inserts/updates I am trying to parse an email log databas

null join bug variation?

Description: Probably it's variation of recent bug with null joins, but just in case I want to post it here because result depends on values inserted into tables, even if these values are not participating in join. After data insert with nulls the same query will produce different result after ad

RE: Selecting appointment whose 3 minutes later then now()

select * from appointment a where a.adatetime < now() - interval 3 minute; read user manual date/time functions. it's all there with examples. -Original Message- From: Prabu Subroto [mailto:prabusubroto@;yahoo.com] Sent: Thursday, October 24, 2002 9:21 AM To: [EMAIL PROTECTED] Subjec

RE: normalization question

Hi! I don't understand problem. Car can belong to only one Dealer, and one Dealer can have many Cars, therefore DealerID should be in Car table. Also Car can be only one Model, but there are many Cars the same Model. It looks quite normal to put ModelID into Car table, and I don't see any possib

RE: Insert default Date

You can use TIMESTAMP field for this. It's automatically assigned current date if you don't insert anything in this field type or insert null. -Original Message- From: Arthur [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 7:56 AM To: MYSQL Subject: Insert default Date Hello

RE: NULL sometimes joins to NULL

It looks like a bug. I was able to repeat it and I had different results for the same join depending on when index was added and values of actual data in tables. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 6:33 PM To: [EMAIL PRO

RE: Help with Sum(), newbie

select sum(first) from example; should work. Artem -Original Message- From: Kevin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 10:36 PM To: [EMAIL PROTECTED] Subject: Help with Sum(), newbie OK. Maybe I'm expecting too much of myself, but I can't figure out what I am