like in mysql
	Assuming there are records in the bills tables where the id field is "AK2009H45", why doesn't the following statement work? select * from bills where id like "AK*45"; By monkeys paw  - 7 Nov - 9 new of 9 messages

key not used oncolum of type double...why?

Hi everybody, I have a very simple table, with one field of type double in it. I want to search for values in this column, so, I indexed it. But MySQL does not seem to use the index. If I query for a exact value, it does: ie: where col=5.3435 I get the one record which matches. But if I type col>5, I get the correct results (obviously!) but the index is no... more » By profke  - 7 Nov - 9 new of 9 messages

	Ubuntu 9.04. I can't install mysql-server.
	Hello, Sorry for my very bad english but i'm french. Well, i can't install mysql-server; I find an error : ************************** root@normal-dominique:/home/no rmal# apt-get install mysql-server Lecture des listes de paquets... Fait Construction de l'arbre des dépendances Lecture des informations d'état... Fait... more » By Dominique  - 7 Nov - 4 new of 4 messages

	insert, column name from select
	Hi all, This is what I want to do, not sure if it is possible: I'd like to run an insert where the column names inserted into are based on the results of the query, like this: create table DETEMP (product, name, quantity, DE1, DE2, DE3); insert into DETEMP (product, name, quantity, columnname)... more » By Julien Mills  - 6 Nov - 3 new of 3 messages

	USING BTREE and older MySQL
	Hello I created a database in last version of MySQL. I generated script to create tables (for this database). When I try to import this script into older version of MySQL (distributed with Fedora 8), I receive error that USING BTREE command is not understood. Here is sample table from my database: DROP TABLE IF EXISTS `estate_types`;... more » By Jivanmukta  - 5 Nov - 2 new of 2 messages

Out of memory on Windows

Hello all, sometimes I'm experiencing an out of memory error running a mysql 5.0.14 in a replica active/active environment. MySQL log suggest to increase ulimit that of course is not available under windows. There's a parameter related to memory max size? I'm trying to figure it out but all tuning parameters are related only to various buffers size.... more » By skyste-  - 5 Nov - 5 new of 5 messages

	Select syntax to find multi entries?
	If this is my data in table fruitlist with columns username & fruit Smith, lemon Anderson, orange Henly, apple Anderson, pear SELECT * FROM fruitlist ... gives me the data so I can (with some added code) write the following output "Smith chose lemon, Anderson chose orange, Henly chose apple, Anderson... more » By GarryJones  - 4 Nov - 11 new of 11 messages

	Default value for Foreign Key column, NULL or 0?
	This might be a trivial question. And I didn't find much of the discussion after googling the topic. But I am still debating of picking a default value for foreign key column to represent the non- existence of such fk. Is there any advantage between using NULL vs. using 0? What are the pros and cons? What do you guys use as a convention?... more » By Devy  - 3 Nov - 3 new of 3 messages

	last item of each day
	I have a list with entries and each entry has a timestamp. I'd like to show that last entry of each day only, for the last 30 days. How can I do this? Any help is appreciated By NickPick  - 3 Nov - 11 new of 11 messages

	Japanese Video Busty - Japan Sucks
	============================== ============================== ============= ========= Click here for private Japan Video! ========= VVVVVVVVVVVVVVVVVVVVVVVVVVVVVV VVVVVVVVVVVVVVVVVVVVVVVVVVVVVV VVVVVVVVVVVV ========= ENTER HERE: ========= ========= [link]... more » By sulfa Elliot  - 3 Nov - 1 new of 1 message