Description:
MySQL RDBMS technical discussions.
|
|
|
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";
|
|
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 »
|
|
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 »
|
|
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 »
|
|
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 »
|
|
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 »
|
|
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 »
|
|
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 »
|
|
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
|
|
Japanese Video Busty - Japan Sucks
|
| |
============================== ============================== ============= ========= Click here for private Japan Video! ========= VVVVVVVVVVVVVVVVVVVVVVVVVVVVVV VVVVVVVVVVVVVVVVVVVVVVVVVVVVVV VVVVVVVVVVVV ========= ENTER HERE: ========= ========= [link]... more »
|
|
|