MySQL Database Forum

This is a multi-part message in MIME format. ------=_NextPart_000_0000_CD0408F0.A38F9734 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0001_668B5D31.EF26B96D" ------=_NextPart_001_0001_668B5D31.EF26B96D Content-Type: text/plain; charset="iso-8859-1"

I have table with 7 millions of records , i want to know if some one can help top optimize the select requests, i created the necessary indexex but some specific requests still slow. Thanks

Hello, I installed mysql server 4.1 last month. When I installed it, I set it to run as a service to start automatically. However, for some reason, that no longer occurs. I can't even see the mysql service running from services viewer in win xp. I now have to manually start mysql server each time I reboot. Can someone please tell me how I...

Are you allowed to use the following syntax in Mysql 4.0.17-nt : INSERT DELAYED IGNORE INTO `mytable` ( `ID` , `A` , `B` ) VALUES ("'.session_id().'", "2", ROUND(NOW()/10000) ); I am particularly interested in the delayed ignore. I want to make sure that no matter what, the instruction is carried out and that, due to indexes, the data is...

In my MYISAM table I have an index (Index_A) on 2 fields (Field_A, Field_B). There are millions of rows in the table. The cardinality of Index_A is 53. I think a query to count the number of rows that match a pair of values for Field_A and Field_B should execute blindingly fast (in the index count the number of leaf nodes for the B-Tree node...

I wanna update the table COMPANY from a linked field. The following is not accepted. Could anybody help me with what the command should be? Thanks a lot. UPDATE `COMPANY` SET `COMPANY`.Region_ID = ( SELECT `Area`.Region_ID FROM `AREA`

Lo group, I would like to know if it is possible to a (string) replace on existing records based on a given pattern. Let's say I have a table containing the following records (strings): Windows/98 Windows/98/Registry Windows/2000 Windows/2000/Registry

Hi, Is there a way to restrict selecting from a table.. I have problem with one check, I have select and after this insert based on the select. If it happen in one time .. I can insert incorrect information. If I do lock table SOMETABLE read; it still select and return results normaly. I'm open for suggestions :)

Hello I have a problem with my search engien, the point with it that I can find a special word in my tabel. Like if I have added in my tabel PHP RULEZ AND .NET SUX, So should I find this line in the tabel when I search on sux or and. I use MySQL 4.1.13 (xampp) http://www.apachefriends.org/ I have the Key: in the tabel (or what its...

Is there anything out there that has the functionality of these products (IE managing and editing data in your tables by either using queries or editing a table grid). I have problems with both of these products but haven't seen any other similar products out there.. Thanks!

I've got this DB. Every few minutes new data comes in and is inserted. Now and then for some reason duplicate data comes through - not a big problem - unique key. However I'd like to log the insert failures, due to dupes, but I don't want to log all of the good inserts also. What magic words do I need? Thanks

Dear Sir/Madam We have following openings with our clients in Mumbai. If you or any of your friends are interested, please mail your updated resume to us. Selected candidates will be taking interviews before 10th Oct'05 at Mumbai. 1) Software developers wherein candidates should have minimum 1 year of experience in Oracle forms & reports...

I need to install mysql 5.0 to run with 4.0. Is there a guide to doing this. I know it involves using separate directories, libraries conf files etc, but definitely have to avoid trashing the current 4.0 installation.

I installed and started MySQL on Mandriva 10.x and get an "Error" on screen after a series of "." appears. Where to look for the log?

Hello I am configuring mysql, apache and php in linux operation system. i have configured the apache and php but while configureing the mysql or trying to execute mysql from konsole a "SEGEMENTATION FALULT" is shown instead showing the mysql screen. Can anybody help me in this task

I have a database table with approx 3 million rows. There are 9 indexes on this table. The command: SHOW INDEX FROM TRAN; Returns results as expected with all indexes some valid "Cardinality" values. After a period of time or a series of events (unknown to me) the statistics for one or more indexes shows a NULL value in the cardinality.

Hi everyone, I have an Oracle trigger that writes any updates to a specified table to a file on the filesystem (using pl/sql). How can this be done using triggers in mySQL 5+? Thanks in advance for your help.

If my field has something like this: 1. dez 2. eft 3. 4. hgt 5. Is there any way to put the non-blank fields on top, sorted alphabetically A-Z, and the blank fields on bottom in whatever order?

How can I see how much disk space is being occupied by an InnoDB table? Looking into /var/lib/mysql doesn't seem to work anymore for InnoDB tables. Please tell also if there is a way to see how much space is occupied by a particular row or column of a table. Thanks

I am often faced with the dilemma of whether to use a JOIN query across three tables in order to grab a bunch of results - or whether to create another table to represent what I want. The latter is less normalised, but seems less computationally expensive to me(?). Basicially what I have is: Friend (uid1,uid2,fid) ->...

Can anyone please shed some light on the following... I have a framework that uses dynamically created tables, named using an incremental "attribute set ID", as follows: attrdata_1 attrdata_2 attrdata_3 etc, etc...

I am attempting to import a large file with data in this format: 1923158|GA|1996 Olympic Yachting Cauldron|park|Chatham|13|051 |320446N|0810502W|32.07944|- 81.08389||||||||Savannah With this command: LOAD DATA LOCAL INFILE 'C:\\PHP\\FL_DECI.txt' INTO TABLE locations2 FIELDS TERMINATED BY '|'

Hello and thanks for reading this message. I have a Virtual Learning Environment (VLE) called "moodle 1.5.2" running on a server with 1Gb of RAM and MySQL version 4.1.13-1 which has been performing fine for a couple of months. The OS is a modern Linux distro called Crux. Recently the VLE has started to be used heavily and I am now finding...

----9379157466zdit8167 Content-Type: text/html; Content-Transfer-Encoding: quoted-printable <html><head><META http-equiv=3D"Bulletin-Date" content=3D"TYPE-HTTP"><META= http-equiv=3D"Content-Language" content=3D"EN"><META http-equiv=3D"Conten= t-Type" content=3D"text/html; charset=3Dwindows-1252"><META name=3D"Langua= ge"...

I have set up a MySQL db on one server, IIS 6.0 on another. Using Frontpage I created some forms to input data. On a test page I made, I have 4 fields. First is the ID which is autonumber (I leave alone). The second is marked as TEXT, the third is MEDIUMTEXT, and the fourth is DATE. This is just an example though, the problem exists in no...