RE: Prevalidating queries?

ome back to myisam. This is simplier. But you can also decide to take intermadiate backups when upgrading. Best Regards ---- Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Andy Pieters [mailto:[EMAIL PROTECTED] S

RE: Newbie Q - Re: Copying databases

http://dev.mysql.com/doc/mysql/en/backup.html It's better to backup with tools. You will be sure that tables are FULL-locked. Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: [EMAIL PROT

RE: Seeking advice on currency type

Here are datatypes and sizes. The problem can be storage. http://dev.mysql.com/doc/mysql/en/storage-requirements.html Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Hassan Schroeder [mailto

RE: ONLY_FULL_GROUP_BY too strict on MySQL 4.1.11

e the directory where the UNIX socket file is to be located if the directory does not exist. T... [ read more about MySQL >> ] http://www.softpedia.com/progDownload/MySQL-for-Windows-Download-2668.ht ml Best Regards -------- Mathias FATENE Hope that helps *This not an official my

RE: IN giving me a fit

Hook | +--+--+ 1 row in set (0.01 sec) Joisn are better than subqueries. Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Scott Purcell [mailto:[EMAIL PROTECTED] Sent: vendredi 29 avril 2005 20:14 To:

RE: Pessimistic Record Locking

nage total number of users. Best Regards -------- Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Scott Klarenbach [mailto:[EMAIL PROTECTED] Sent: vendredi 29 avril 2005 20:28 To: My SQL Subject: Pessimistic Record Locki

RE: order by "version number"

Hi, select a from versions order by substring_index(a,'.',-2); Best Regards -------- Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Stano Paska [mailto:[EMAIL PROTECTED] Sent: vendredi 29 avril 2005 08:21

RE: using if in select statement

Hi, you can continue playing. It's a true game :o) Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: James Black [mailto:[EMAIL PROTECTED] Sent: vendredi 29 avril 2005 02:20 To: &

RE: No error / warning when data is truncated on insertion into mysql

--- + 2 rows in set (0.00 sec) mysql> select * from toto; +--+--+ | a| b| +--+--+ | 127 | Long | < my 500 is also truncated +--+--+ 1 row in set (0.00 sec) Best Regards Mathias FATENE Hope that helps *This not an official mysql su

RE: mysql top 2 rows for each group

7 | 2 | +---++ 8 rows in set (0.00 sec) Best Regards ---- Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: mathias fatene [mailto:[EMAIL PROTECTED] Sent: jeudi 28 avril 2005 22:52 To: 'Jay Blanchard'; 

RE: mysql top 2 rows for each group

--++ | 00122 | 1 | | 00123 | 1 | | 00123 | 2 | | 00123 | 3 | | 00336 | 1 | | 00346 | 1 | | 00349 | 1 | | 00427 | 1 | | 00427 | 2 | | 00427 | 3 | +---++ 10 rows in set (0.00 sec) --

RE: Does anyone have experience?

Hi, Had you read http://dev.mysql.com/doc/mysql/en/odbc-connector.html One can't see the mysql ODBC driver in your snapshot. Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: [EMAIL PROT

RE: host info

That's it:o) Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Stanton, Brian [mailto:[EMAIL PROTECTED] Sent: mercredi 27 avril 2005 23:12 To: 'mysql@lists.mysql.com' Subject

RE: query question

Hi, If i understand : select month(entryDate) as monthPart, if (amount is nul,'',day(entryDate) ) as dayPart, amount from raindata order by dayPart, monthPart Best Regards -------- Mathias FATENE Hope that helps *This not an official mysql support answer ---

RE: Query question

Yes ten years and forgot mysql certified. I can offer i-am-a-dummy to you if you lack. I've never imagined find so bad people on the list. But i'll write to the moderator to see who is on. But i'm pleased to help people wihout naz mentality than yours. Best Regards -----

RE: Python related MySQL question

Look at db.use_result() and db.store_result() here : http://www.birgerblixt.com/doc/packages/python-mysql/MySQLdb-2.html#ss2. 2 Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Smelly Socks [mailto

RE: Index help ?

sage, machine) sould be sufficient. Best Regards ---- Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Michael Gale [mailto:[EMAIL PROTECTED] Sent: mardi 26 avril 2005 05:49 To: mysql@lists.mysql.com Subject: Index h

RE: Crosstab in Mysql

", Sum(IF (insumo_or = "Animal4", cantidad_or, 0) ) AS "Animal4", Sum(IF (insumo_or = "Animal5", cantidad_or, 0) ) AS "Animal5", Sum(IF (insumo_or = "Animal6", cantidad_or, 0) ) AS "Animal6" FROM tbl_ISv2CROriginal Group by FK_p

RE: database migration puzzle.

Hi, I hope that this link will help http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Kenneth Wagner [mailto:[EMAIL PROTECTED] Sent: mardi 26

RE: Query question

your sensitivity, but we are not speaking about the same thing. And please if you have to criticize or complete an answer, it's your right. The list is for that. If you want to speak to me as your student, this is enough. I never did it when i was teacher 11 years ago. Best Regards

RE: Query question

gards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: lundi 25 avril 2005 22:17 To: Jeff McKeon Cc: mysql@lists.mysql.com Subject: Re: Query question Jeff, Then do it w

RE: Query question

| NULL |NULL | NULL |0 | Using temporary; Using filesort | ++-++--+---+--+-+--- ---+--+-+ One or two table scans ? Best Regards ---- Mathias FATENE Hope that helps *This not an offic

RE: Query question

all RDMBS, especially with mysql (DBMS till now). Best Regards -------- Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: lundi 25 avril 2005 21:44 To: mathias fatene Cc: &#

RE: Query question

rows in set (0.00 sec) The max will be used with your datetime column. The "son" table can not be used, or joined to the mother. Best Regards -------- Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Jeff McKeon [m

RE: Converting to InnoDB?

Sorry, Alter table toto ENGINE=innodb. You don't must, you can. You can also have differents storage ENGINES in the same mysql database. With innodb, you will earn ROW level locking. Best Regards Mathias FATENE Hope that helps *This not an official mysql support a

RE: Converting to InnoDB?

Yes, but your myIsam Tables stay myisam ones. After restarting, you must change them to innodb by : Alter table toto storage=innodb. For new tables, they will have innodb storage. Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer

RE: Ordering rows whit a select from where in ( exp )

' Union SELECT field_name FROM meta WHERE id ='10' Union SELECT field_name FROM meta WHERE id ='12' Mathias Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Adria

RE: libCstd.so.1 not found while running mysql_install_db

Read 7xx Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: mathias fatene [mailto:[EMAIL PROTECTED] Sent: lundi 25 avril 2005 10:18 To: 'Anirban Karmakar'; 'mysql@lists.mysql.c

RE: libCstd.so.1 not found while running mysql_install_db

Do you have /cnem/server/bin/mysqld file ? Is it exec (6xx)? Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Anirban Karmakar [mailto:[EMAIL PROTECTED] Sent: lundi 25 avril 2005 09:12 To: mysql

RE: joining six tables by mutual column

? Best Regards -------- Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Schalk Neethling [mailto:[EMAIL PROTECTED] Sent: lundi 25 avril 2005 00:52 To: mysql@lists.mysql.com Subject: joining six tables by mutual column Greetings everyone. Hope s

RE: Replication - is there a "server lag"?

79 | | | +---+--+--+--+ 1 row in set (0.02 sec) And show slave status; When reading from slave, data can be not synchronized. If you configured log-bin, you can use mysqlbinlog to read it. Best Regards ---- Mathias FATENE Hope that helps *This

RE: setting character sets "permanently"

2 other things : 1. what is your character set when you install the mysql server ? 2. what characater set you see with "show create database" ? Best Regards -------- Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message

RE: setting character sets "permanently"

). Export/import should be a good trick. But Latin2 seems more general that latin1. Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: mathias fatene [mailto:[EMAIL PROTECTED] Sent: dimanche 24 avril 2005 22

RE: setting character sets "permanently"

Hi, Look at this : mysql> show variables like 'character%'; +--+ -+ | Variable_name| Value | +--+ -+ | character_set_client

RE: MYSQL to XML

s : #!perl -w # --- # Describe2xml # Author : Mathias FATENE # Date : 24 april 2005 # --- use DBIx::XML_RDB; my $userid='root'; my $password='**'; my $dbname='world'; my $dsn = "DBI:mysq

RE: Performance issues when deleting and reading on large table

ces/articles/mysql-set-datatype.html. Massive load is better without indexes, which are only good for selects. Mathias -Original Message- From: Jigal van Hemert [mailto:[EMAIL PROTECTED] Sent: dimanche 24 avril 2005 19:46 To: Almar van Pel; mysql@lists.mysql.com Cc: 'mathias faten

RE: Multi condition/table select

Hi, Don't you miss some relationnal definition in your table. Personnaly, I suggest in lnk : Lnk: catid=int11 primary key prodid=int 11 The key being (caid,prodid). And simplier (Normal form) : Categories: id=int 11 primary key title = varchar Product

RE: Table handler errors

Hi all, Sounds like a max heap table size reached : mysql> show variables like '%heap%'; +-+--+ | Variable_name | Value| +-+--+ | max_heap_table_size | 16777216 | +-+--+ 1 row in set (0.00 sec) if you red

RE: Performance issues when deleting and reading on large table

sql@lists.mysql.com Cc: 'Jigal van Hemert'; 'mathias fatene' Subject: RE: Performance issues when deleting and reading on large table Hi Jigal, Mathias, Thanks the time you took to reply to my issue's! I would like to clear out some things. > It's a probably a c

RE: mysql_performance

Hi all, I can see a cartesian product on the EMP table. Is this really what you're looking for. There is no column joining T2 and T3 ! Also as Peter said, you should have a lack of indexes on your tables. If you can send me your .frm,.myd and .myi files of the two tables as a zip file, I may help

RE: Performance issues when deleting and reading on large table

Hi all, Know that indexes are good for select(s), but very bad for massive insert,update and delete. If you want to do a massive delete with a cron, it's better to : * select the rows to delete (using indexes) * delete indexes * delete rows (already marked) * recreate indexes Another way if