Repair/add spatial index on a spatial column

h the same parameter set to 30GB, I still have the "repair by keycache" issue. So this is not likely a temp file size limitation. If I add an index on another column of my 18M records table, "repair using sort" works. I am using mysql 5.0.32 Thanks! Etienne

Help about a db

Hi all, I have the following data Users : user(varchar), entreprise_1(int), entreprise_2(int) Entreprise: idx(int, prim, auto_incr), code(varchar) some users have one entreprise, and some two. if I decide that 'no entreprise x' is coded with entreprise_x=0, i have obviously a problem with

Exportation

Hi, I have a question concerning the portability of the files of the database. Is there a way to export the content of a database from PC (win or *NIX) to Mac ? Great thanks -- Mélet Pierre-Etienne -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Updating a table column using other columns

Greetings, I would like to know if MySQL allows some way to do "UPDATE SomeTable SET SomeColumn=(SELECT SomeExpression FROM SomeTable, SomeOtherTable WHERE SomeTable.ForeignKey=SomeOtherTable.PrimaryKey);" Although I had some ideas (like sending SELECT result to a file, deleting table SomeTable

Join Query Help

= dnID or eaDn2ID=d nID) and eaDn2ID is not null; ++ | dnName | ++ | dj b | | dj c | ++ 2 rows in set (0.00 sec) I'm off to bed, pleaseee help me on this one, I can't finish my event calendar without dealing with those.. Regards, Etienne

Re: MySQL Searchable Mailing List Archive now up.

th NS, different for every version, even if all the tags are ok As for email spamming, you are right, since it's taken from a database. Unless the archive was called e-may, I think we might not have to protect the emails beyond leaving them outside of static webpages:-) Etienne Robert Alexa

Re: MySQL Searchable Mailing List Archive now up.

have to always click it:-) (I'm lay) You could add some javascript so that the range is celected when something is entered in the from or to fields my 2 cents #2 is not a big thing, but #1 is pretty important against spam and spam bots. Etienne Robert Alexander wrote: > > Hi e

Re: sub selects

no, but you can acheive the same results please consult the manual http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html Etienne Joel Wickard wrote: > > can you perform sub selects in mysql? > > - > Before

Re: MySql forum or newsgroup

n you have question, you have separate areas (installation, query problem, design problems, innoDB problem, let's say) and you can do specific searches. You can also have email notice when a reply is made to a thread you started asking a question. my 2 cents... Etienne Philip Molter wrote: &

Re: possible bug?

anti spam words: database,sql,query,table you can first put it here to be sure it's a bug be specific, showing table definitions, query that is not working please provide OS, mySQL version, any relevant information Etienne "Karl J. Stubsjoen" wrote: > > database,sql,q

Re: MySql forum or newsgroup

If benjamin and all other "gurus" read/post on the webforum, sure I'd like it, since it's not easy to manage hundreds of emails a day... Etienne Jason Rowski wrote: > > Hi, > > I willing to build and host a free mySQL discussion > forum/newsgroup for the

Re: [PHP] Performance

reconnect each time you want to prepare/execute something! I'm only coding perl so I don't know php at all, but I'm sure you can stay connected for at least all the time the same script is running... so many websites uses mysql/php... Etienne markus|lervik wrote: > > On Thu, 2

Re: MySQL on Win2000

I never used any kind of ODBC and can connect to mySQL with the mysql.exe from c:/mysql/bin/ also with perl/apache locally installed I can make perl script to play intop the DB without even thinking about ODBC my 2 cents Etienne Miguel Angel Solórzano wrote: > > At 14:51 13/12/2001

Re: SELECT'ing only 1st matching row

If you are using perl/DBI you can usee my @row = $dbh->fetchrow_array() instead of the usual while()... it will only take the first row returned. Etienne Ron Jamison wrote: > > Tack on a "LIMIT 1" on the end of your query to limit the returned rows to > 1. &g

Re: MySQL on Win2000

sql> so on.. when you press enter it gives a new line, when you put a ; and press enter it sends the query! Etienne Alex Shi wrote: > > Hello, > > I installed MySQL 3.23.46 on Windows2000. The mysql-nt started > on Windows startup, and MysqlAdmin is also running well. I tried

[OT] mod_perl and last_insert_id() (Was: sequence and nextval)

me db handle for the next perl script asking a connection? If this is the case than I magine last_insert_id will always return the good value.. sorry if this is mod_perl related Etienne "Carsten H. Pedersen" wrote: > > > Thanks, but how secure is this. Is it possible for two

Re: Performance

Bon apràs-midi René, Well keeping a connection alive is way better on performance.. that is why, under mod_perl, it keeps the connections alive. You should connect at the beginning of the script, and always use that same database handle for the script run. Then close it. Etienne René Fournier

[OT] When to un-normalize

ould have SELECT artistCity FROM artists WHERE artistNAME = "foo" OR artistAKA = "foo" Which would disable the index searching because of the OR right? Please give some advises!!! Etienne -- Etienne Marcotte Specifications Management - Quality Control Impe

Re: Best Free Web Panel for mySQL

http://www.gossamer-threads.com/scripts/mysqlman/index.htm I think they have what you are looking for Etienne David Jourard wrote: > > Hi, > > Could someone recommend the best perl web panel to maintain the databases > and tables for mysql. > > Something similar to p

Re: [OT] A News Group Perhaps.

takes to get the info is annoying :) my 2 cents Etienne Kelly Firkins wrote: > > I would vote in favor of using vbulletin (www.vbulletin.com) it's got forums > for talk like this, web-based, and runs off of the MySQL server as a > back-end. An example in action is vbulletin itself or

Re: find_in_set syntax

| skills_ma1,skills_ma3,skills_ma5 | | 7 | skills3,skills4,skills5,skills6 | skills_ma1,skills_ma2,skills_ma3,skills_ma5,skills_ma6 | ++-+--------+ 3 rows in set (0.00 sec) Tadam you can't use the "WHERE col_name & value" ehrne you have more than one SET

Re: ADV: Dear Future Millionaire:

How come this passed the spam filter? Which word it had that was on the "mandatory words" list ? There is no sql, query, database in the text... Etienne Bege John wrote: > > I'll make you a promise. READ THIS E-MAIL TO THE END! - follow what it says to the >letter

Re: [OT] A News Group Perhaps.

s done you should receive only wanted informations. My 2 cents Etienne Tony Buckley wrote: > > Hi Matt, > > I am sure this has been said before so my apologies if I bore! > > Most mail clients let you setup rules. For the mySQL list I automatically > redirect all messa

Re: find_in_set syntax

Can you provide your table description? You have two set colums? One called res_skills and one called res_skills_ma ? Etienne Wiliam Stephens wrote: > > Hi > > Can anyone tell me what is wrong with the MySQL FIND_IN_SET function? Well, > I'm using the following: >

Re: mysql round problem

. you'll be ok with a epsilon 2 > digits smaller since you're sure that it won't affect the 4th digit > after the . > > Etienne > > Shankar Unni wrote: > > > > Etienne Marcotte wrote: > > > > > maybe you can add a small value to be sure i

Re: mysql round problem

maybe you can add a small value to be sure it rounds up. select round(9.065+.001,2); Always add 1 at the digit after the one you want to keep:) so 9.065 can also be a variable... Etienne Shankar Unni wrote: > > Attila Soki wrote: > > > selec

Re: mysql round problem

est digit.. at the end of multiple calculations you generate bigger errors. Sometimes one can say, you alternate when having middle values, once you go up, once down... Sometimes it's better to go up, for money calculations, etc This is getting off topic anyways Etienne Dibo Chen wrote: >

Re: Index of SET Field

| 2 | Whales,South | ++--+ 2 rows in set (0.00 sec) But i don't suggest this one! HTH Etienne Wiliam Stephens wrote: > > Hi > > Thanks for your reply. > > I've got the field "res_places_sl". It's a SET field that consists of the &

Re: Index of SET Field

ntains a `,': mysql> SELECT FIND_IN_SET('b','a,b,c,d'); -> 2 = I don't know what exactly you're trying to acheive, but I'm pretty sure FIND_IN_SET is not what you are looking for. Can you give table descriptions and what i

Re: [OT] Undescriptive subjects.

seeking help would have an hard time finding some. I know there are already a lot of "gurus" on other mailing lists that are filtering all undescriptive topics.. so I hope my message will convince users to always use a good subject so that every possible help can be gathered! Etienne Dou

[OT] Undescriptive subjects.

#x27;m not the only one that have a little trouble handling those. Etienne p.s. this message is in no way intended to be harsh, maybe it because we are monday morning. -- Etienne Marcotte Specifications Management - Quality Control

Re: Problem

ed to one of their "strong" subject. Etienne "Phillip B. Bruce" wrote: > > Hi, > > I've downloaded mysql 3.23.46 version and currenlty runnig > solaris 2.8 relase 10/00 on intel platform. > > I'm getting the following error during the ./conf

Re: Newbie!

Please use a more descriptive subject, you have better chances to have replies (a lot filter out subjects having only "question" "newbie", etc Etienne Angel Gabriel wrote: > > Thanks for reading this. I'm new to the whole world of linux, and MySql, but > I

Re: Annoying article about MySql

done right. Etienne Admin wrote: > > I was just reading an annoying article from a user who was moving from MySql > to Postgres because of stability problems and because of problems restoring > "large" MySql data-dumps. I checked his site and it does not have the > app

Re: efficient DELETE query - 2 tables

mySQL can't do subselects afaik Etienne Harlan Feinstein wrote: > > Rory> I want to write an efficient query that will delete all records > Rory> from one table when they show up in another table (pending > Rory> shipments --> shipped shipments). I can&#x

Re: Query question

= ($sth->fetchrow_array); print "invalid login" if (param{"email"} ne $email || $active ne 'Y'); Something like that, not tested at all. HTH Etienne Steve Osborne wrote: > > I am trying to validate a user in a login form. > There are 3 things that must be t

Re: Creating MySQL table w/2 primary keys

L NOT use the index, which is not the intended result. so primary key (a,b) is ok but you need to add either unique key(b) or unique key(b,a) Etienne "A. Clausen" wrote: > > I do it all the time, just go > > primary key c (a,b) > > > A.

Re: Query and join problem with null values

0 sec) Is that what you are looking for? sorry I redone your table definitions, but you should have the same type of data for the linked keys (in thsi case you had varchar255 for zip in the peoples table and a tinyint for the zip in the city table. HTH Etienne Michaël Delorme wrote: > &

Re: Comparision

s craching after 100 connections) Read the article and the comments posted by users, so you'll have a good idea Etienne Jasvinder Singh wrote: > > Hi DB Gurus, > > I am planning to use database for one of my applications. I need to decide > between > MySQL and PostgreSQL. &

Re: Creating MySQL table w/2 primary keys

nce it's only numbers and the indexes for search in each directions are there.. HTH Etienne sherzodR wrote: > > As far as I know, you can't do tht. What you could do instead is > have one Primary Key col and make another one UNIQUE. > > I did that several times, and it doe

Re: just moved from windows to linux mysql

http://www.linux-mag.com/2001-03/mysql_01.html There ya go, you can't have it better explained, as for the user access part. For the data transfer, that I don't know Etienne Curtis Gordon wrote: > > Hi, I have just setup a dedicated linux/php/mysql dev box in my office and I

Re: Creating MySQL table w/2 primary keys

using primary key (col1, col2) makes no index on col2... which is not good if you lookup only in col2 primary key (col1), unique index (col2) don't forget to add "not null" beside your col2 definition. Etienne rc wrote: > > why not use a concatenated Primary key? &g

Re: dos prompt help

mIRC) HTH Etienne "Ward, Mark" wrote: > > Okay, got through that NULL problem. Thanks. > > My next question is regarding using the DOS prompt. At work, I'm using > Win2000. When I'm using mySQL, if I want to repeat commands, I can just > press the up key without r

Re: NULL Strings

SELECT * FROM classification WHERE level1 = "FOO" AND level2 IS NULL; IS NULL instead of = "NULL" null is not a value, it's the abscence of value Etienne "Ward, Mark" wrote: > > I don't know how this affects anything, but, I'm running the mo

Re: ANN: EMS MySQL Manager 1.22 released

TRIAL PERIOD, the user must either register the EMS MySQL Manager or remove it from his system. === I mean, It's *directly* related to mySQL. Put a filter on "OT", "Off-topic", "Ann" and you won't see them. My 2 cents, Etienne Raymond Abel wrote: >

Re: more than one possible column value

will use the (typeID,fileID) index if you are looking for the index of a particular file, it will use the index (fileID, typeID). this is for speed! HTH Etienne Erik Price wrote: > > On Tuesday, December 4, 2001, at 01:23 PM, Etienne Marcotte wrote: > > > CREATE TABLE fi

Re: more than one possible column value

g image | jpg | | bar | jpeg image | jpeg| +--++-+ 5 rows in set (0.00 sec) I hope it's what you wanted Etienne btw, if you find any mailing list ont he web for general relational DB design issues, let me know. I searched and could not find any:(

Re: ERD

http://www.datanamic.com/dezign/ it was posted today in another thread, I checked it a little. You create your table with complete definition (type, indexes, etc) and you can create the .sql to implement it into mySQL Etienne Won Lee wrote: > > Anyone know a good ERD program that wil

Re: Graphical Database Information

o are pretty neat, you can choose One, one (optional), many, many (optional) so ti draws the correct ends: ---||- or ---o|- or ---|< or ---o< But if you already have a complex DB in mySQl and want to have the graphical equivalent from a click, then I don't know and I'm curious if there

General database design

ntpromoters where epEvtID = '3') would be perfect, assuming it selects for all the occurences where epEvtID is 3 and not just the first one. Anyways, I'm pretty sure nobody went reading this far, I'd just like some input as how you're doing your things with n:n tables. A

Re: LIMIT by column return

s from the two last days where there are incvoices. I don't think he want's to use date sub from NOW() sine the two last invoice dates might be variable.. Etienne Michael Stassen wrote: > > Tom, > > Restating the problem, you want the last two from the set ordered by > i

Re: conceptual question.

I store links instead of the data. I don't know I seem to prefer a "light" database and the retreival of images/others from the server itself instead of pulling it from the database. There are a lot of debates on this, I'm only telling you what I prefer to use:) Etienne

Re: MySQL 3.23 Manual - PDF

ase of lynx and the speed of light. Regards, Thomas it's all there! Etienne "A. Clausen" wrote: > > Well there is a 4.x manual, and I know from a few months ago that there was > a 3.23 manual on the site which I foolishly decided I didn't need. Do the > develo

Re: MySQL 3.23 Manual - PDF

i have to disagree you should read it before asking us to go read it! Title is on top of each page: "MySQL Technical Reference for Version 4.0.1-alpha" I am also looking for the latest 3.xx version manual. Etienne Tony wrote: > > Image you had a product and wanted to m

Another basic question - index()

a lot, Etienne -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: date type

right Etienne Jose Gerardo Amaya Giron wrote: > > Thanks I now understand the difference. I can use a timestamp If I used a > database to log access for example I only make an insert to > the other fields and the timestamp insert the current time and date right? > > Gerardo

Re: Please redo this horrible web page

"Let's make everything as hard as is possible for the "newbies"." you'll help our newbie cause. Etienne raezor wrote: > > Let's make everything as hard as is possible for the "newbies". > > Please alphabetize or at least use some sort of da

Beginner question

to be filled (or both). I can check that in my script, just asking if we can do it in mySQL Regards, Etienne -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001

Re: Newbie Question

pages, which is obviously the fastest. This is a lot of changes to fo in the forums for that.. But If you get even more hits it will get worse so it would be worth it Imo. Etienne Phudgee wrote: > > Hi, > > I have been searching for some answeres to my problem for around 2 months >

[OT] Comments about my DB layout

estions you may have regarding the way everything works and any comments you have. Thanks a lot, Etienne -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 -

MySQL and Uniface 7.206

appreciated. Regards, Etienne. -- Etienne Baeumle, Informatics University of Berne, Faculty of Veterinary Medicine Institute of Animal Genetics, Nutrition and Housing Bremgartenstrasse 109a, CH-3012 Berne, Switzerland eMail: [EMAIL PROTECTED