quantum effects on MySQL 5.0.27?

Hi everybody, We've been badly hit by a very interesting problem: an index gets into a disabled state if, during the filling up of a table containing a column having the said index, one only *looks* at the data which is being loaded! =:-o In other words I start with DROP TABLE after which I

RE: Aborting a greedy querry from the command line

On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote: Hi Chris, I've noticed that a Ctrl-C will also leave the query running (5.0.22 - Linux) and I've had to use the kill from mysqladmin or mysql client to get rid of it. Huh, that's odd, it should abort

Re: Date increment

SELECT DATE_ADD(expiredate, INTERVAL 17 DAYS) http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html Peter Lauri [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Best group member, I have a field called expiredate of type 'date'. I would like to add 17 days to the

Re: Error with PHP: undefined function: mysql_connect()

In PHP 4.1 you have to include the mysql.so extension. To do so, you have to modify php.ini, extensions section sheeri kritzer [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Sounds like the binary you used did not have PHP compiled with the MySQL libraries. If you make a phpinfo()

Re: Error with PHP: undefined function: mysql_connect()

This solution is valid, but not advisable. If you run your server in a production environment, you shouldn't allow the dl function, as your users could activate any extension Or better, add that extension runtime because otherwise it will just consume computer resources, and maybe not every PHP

Re: Best practice on table design

of. Wouldn't be better (maybe more efficient ?) to put all the 2-field tables in only table, with a separate ENUM field to separate the records on categories ? -- Cip CRD Hi Ciprian, CRD OK, I'm by no means a DB guru, so a) take this with a grain of salt CRD and b) feel free to tear it apart

Best practice on table design

| | 4 | Madrid | C| | 5 | Berlin | C| --- where central_data.type is P for people and C for cities. Do you think it is a good ideea ? -- Best regards, Ciprian Trofin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

String functions for GROUP BY clause

Is there a way to use a string concatenating function in connection with a GROUP BY clause? I mean, for a one-to-many relation (like firm-stockholders relation), to catch a structure like: firm | stocholders f_1 | s_1; s_2; s_3 f_2 | s_4; s_5 f_3 | s_6 instead of firm |

Dillema: LIKE vs MATCH - AGAINST

I'm building a financial-like web site (PHP - MySQL). I was requested to build a search engine for IT. Everything works OK, w/ the exception of a certain component. The owner of the web site will write, each day, a report for the customers. I use TEXT fields to record each section of the report

Limit queries

I have 2 tables: currencies and quotes currencies == id currency - quotes == id date id_currency value --- Index (date, id_currency - UNIQUE) In order to find the most recent value for a currency I use the following logic: 1. SELECT

mysql overhead

the overhead have on a table? Thank you, -- Ciprian [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

Re[2]: Bug or am I missing something ?

gogu 4 cip 5gogu I guess it is some sort of conflict, although it shouldn't be. -- Ciprian Un cuvant de sfarsit: If you can remain calm you just don't have all the facts. - Before posting

Bug or am I missing something ?

--- 1gogu 2alex 3gogu 4 cip 5gogu I guess it is some sort of conflict, although it shouldn't be. -- Ciprian Confucius Says: Man who fight with wife all day, get no piece at night

Self Join on temporary tables in MySQL 3.xx

of the temporary table and use it together with the original temporary table to execute the join ? -- Ciprian Ambition is a poor excuse for not having enough sense to be lazy. - Before posting, please check: http://www.mysql.com

group multiple queries.. if one fails all fail

be run? Thank you, -- Ciprian I. Acatrinei [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail

group multiple queries.. if one fails all fail

be run? Thank you, -- Ciprian I. Acatrinei [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail

unique

Hi, I am having a hard time removing the unique property from a field... I set up a field as unique now I need to allow multiple values in that field. How do I take out the unique property of that field... PS: I couldn't figure it out from http://www.mysql.com/doc/en/ALTER_TABLE.html Thank

Not unique table/alias

Hi, mysql INSERT INTO f_baldai_seq (seq, nextval) SELECT seq, nextval+1 FROM f_baldai_seq LIMIT 1; ERROR 1066: Not unique table/alias: 'f_baldai_seq' Please help. Thank's. - Before posting, please check:

Join or smth.

(PHP) but I'd like to do it SQL-style :). I guess it can be done using some sort of JOIN. -- Ciprian Always smile. It makes people wonder what you're up to. - Before posting, please check: http://www.mysql.com/manual.php

Re[2]: Join or smth.

how to solve the problem using a script language (PHP) but I'd like to do it SQL-style :). I guess it can be done using some sort of JOIN. -- Ciprian Un cuvant de sfarsit: Useless fact: Odds of being killed in a car crash are 1 in 5000

Re: returning top two values

group by curEntry.family, curEntry.member R having orderstatistic 3 R order by family, orderstatistic; -- Ciprian Ambition is a poor excuse for not having enough sense to be lazy. - Before posting, please check: http

Relations between tables....

products and the customers. How can I set up table1 to lock all the entries that are used in table2 for reference? I appreciate any answer Thank you, Ciprian - Before posting, please check: http://www.mysql.com

Re: Max 127 records

', 'sfdg', 'sg', 'fdsg', 'sfg', HO 'sg'); HO MySQL returnerede: HO Duplicate entry '127' for key 1 -- Ciprian There is no such thing as an underestimate of average intelligence. -- Henry Adams - Before posting, please

Optimization

-- Ciprian He who laughs last, thinks slowest. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail

Re: How to do regular backup in MYSQL

Now,lets say i never shut down my pc and the MySql is running all the KHC time. How can i do a regular backup (ie.every evening 9.00 pm) KHC automatically? -- Ciprian - Before posting, please check: http://www.mysql.com

The opposite of where column_name LIKE %string%

*This message was transferred with a trial version of CommuniGate(tm) Pro* Hi, I need to select from a table all the records that do not contain a certain string. Any idea how I can do this? For example if I want to select all the fields that contain the string my_string I type: $ select *

Problems with the unique properties...

*This message was transferred with a trial version of CommuniGate(tm) Pro* Hi, I have a table in my database that has one field named design_name. The design_name is varchar(200) unique. After I created the table the need appeared to have duplicates in this field. So I tried to remove the

Matrix Logic System...!!????

Hi, I am supposed to build a Matrix Logic System (or something like this) for merging to databases. I have no idea what so ever of what is a Matrix Logic System. Can anyone tell me with what this can be eaten? Thank you very much, Ciprian A.

MySQL vs Microsoft SQL

me with this. Thanks, Ciprian A. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

Re: MySQL vs Microsoft SQL

Is there something that you can do with MS SQL and you can not do with MySQL? At 04:01 PM 3/23/2001, Jeremy D . Zawodny wrote: *This message was transferred with a trial version of CommuniGate(tm) Pro* On Fri, Mar 23, 2001 at 01:09:47PM -0500, Ciprian I. Acatrinei wrote: *This message