Re: query question: updating between 2 tables

2006/9/19, Peter Van Dijck <[EMAIL PROTECTED]>: Hi all, trying to figure out if there is a query I can use for this, or if I have to write a php script to loop tru each row... table1: entryid int(11) itemid int(11) table2: object_id int(11) The situation is: table2.objectid is populated w

Re: MySQL C API: dedicated per-connections in the mutlithreading program

2006/9/8, Andrew W. Nosenko <[EMAIL PROTECTED]>: Sorry, but documentation on the MySQL C API say nothing about many interesting questions. The one of them: is it safe (or unsafe) to use non-MT client library (libmysqlclient.*, as opposite to the MT-aware libmysqlclient_r.*) for the multithreadin

Re: SQL subqueries and JOIN conditions

2006/9/4, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: Hello all, I need to perform an SQL statement over 5 different tables, with complex request. To do so, i'm using subqueries. SELECT ... FROM (SELECT .WHERE) as T1 LEFT JOIN (SELECT .WHERE) as T2 WHERE . The problem is that on

Re: IN & ANY subqueries

2006/9/5, Ben Lachman <[EMAIL PROTECTED]>: So possibly a better solution would be to create a temporary table and then do a subquery on that table? yes. Or do a : SELECT id FROM t1 WHERE name LIKE '%s1%' OR name LIKE %'s2%' OR name LIKE '%s3%' but depending on your data, a table may be the way

Re: SQL order by BUG?

2006/9/6, Jørn Dahl-Stamnes <[EMAIL PROTECTED]>: I get the following query: select rt.team_id,count(p.race_id) as cnt,sum(p.points) as sum_score,sum(p.points) / count(p.race_id) as avg_score from group by rt.team_id order by avg_score desc; which gives: +-+--+---+--

Mysql and solaris upgrade

Hi, I need to upgrade a server from Solaris 8 to Solaris 10. There is one MySQL server running on it, (the binary mysql-standard-4.1.15-sun-solaris2.8-sparc from mysql.com), do I need to upgrade MySQL as well ? (to mysql-standard-4.1.x-sun-solaris2.10-sparc ?) -- MySQL General Mailing List For l

Re: mysqldump and table exclusion

2006/4/25, Kishore Jalleda <[EMAIL PROTECTED]>: > > There is an option to ignore tables from being dumped > > > > --ignore-table=db_name.tbl_name Excellent :-) My man page is not up-to-date, and wasn't showing it. thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

mysqldump and table exclusion

Hi, I've read the manual, but it seems there is not the option I'm looking for. I would like to dump all tables but one. Is that possible ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Stumped again by joins

2006/4/25, Chris Sansom <[EMAIL PROTECTED]>: > At 15:56 +0200 25/4/06, Barry wrote: > >And you don't see any misdone queries when you echo them, right? > >Hope you checked that. > > Hi Barry > > I was wrong about its being a PHP issue: it's > definitely a MySQL error. I realised I hadn't > handled

Re: Accumilating Blog Comments

2006/4/25, -Patrick <[EMAIL PROTECTED]>: > $query_rsComments = sprintf("SELECT id_com WHERE idart_com=%s ORDER BY > date_com ASC", $KTColParam1_rsComments); > > > can anyone see what Im trying to do here? basically, I want to match the > id_com with an idart_com to produce a value and report back t

Re: Why does this query takes a lot of time

2006/4/22, abhishek jain <[EMAIL PROTECTED]>: > Dear Friends, > I have two table joined by the followng query, the problem is this simple > query takes a lot of time greater than 10 mins depending on the number of > records, Pl. help me find out the reason: > Table 1: > id_key primary and auto incr

Re: bug in simple select, what is going on?

Hi, > mysql> select * from user_todo_german_english where wordid = '86851' and > posn = '1' and pos = 'm' AND mb_id='curious'; > +-++--+--+-+ > | mb_id | wordid | posn | pos | date_col| > +-++--+--+-

Re: newbie optimization question

Hi, 2006/4/20, Adam Wolff <[EMAIL PROTECTED]>: > Hi. I'm new to database optimization and I have a couple of questions. > > I have a table like this: > > +++-+-+ > | id | fullname | email | user_id | > +++-

Re: best use of index and missing values

2006/4/14, Philippe Poelvoorde <[EMAIL PROTECTED]>: > Hi, > > I have one table : > CREATE TABLE `ressources_summary` ( > `res_type` tinyint(3) unsigned NOT NULL default '0', > `res_id` int(10) unsigned NOT NULL default '0', > `comment_

Re: Query results for text with á é ö ã etc

2006/4/18, Pedro mpa <[EMAIL PROTECTED]>: > Greetings. > > I have Text fields in some tables which contain text in Portuguese with > accent characters like á, à, é, í, ú, ü, ó, ö, ç, etc. > > When I query like: > > SELECT text_column > FROM table > WHERE text_column LIKE '%maçã%' > [ or ] > WHERE t

Re: Optimizing SQL statement

2006/4/13, Puiu Hrenciuc <[EMAIL PROTECTED]>: > Hi, > > I have a table ( MyISAM, MySQL 5.0.20, FreeBSD ) containing network traffic > data : > > record_time datetime - time when recording was added > ip char(15) - ip that generated the traffic > type tinyint(3) - traffic type ( 1 - local, 2 - inte

Re: replication, sort of (5.0.18)

2006/4/13, Duzenbury, Rich <[EMAIL PROTECTED]>: > Hi all, > > I have two servers that have production data on them, and then one > server where I would like to keep an active copy of the data. > > Currently, there is a job that runs in the middle of the night that > basically does a > mysqldump --h

Re: MySQL 3 to 5 upgrade

Hi, > Yeah - I think the playground is unlikely to happen. They certainly > haven't said anything about providing such a facility. If they don't give a test machine, or don't provide a smooth migration (like installing a new server, and keeping the old one running 3.23), you should consider compl

best use of index and missing values

Hi, I have one table : CREATE TABLE `ressources_summary` ( `res_type` tinyint(3) unsigned NOT NULL default '0', `res_id` int(10) unsigned NOT NULL default '0', `comment_count` smallint(5) unsigned NOT NULL default '0', `comment_last_timestamp` timestamp NOT NULL default '-00-00 00:00:0

Re: Social Network, linking members

2006/4/8, Philippe Poelvoorde <[EMAIL PROTECTED]>: > Hi, > > 2006/4/8, Dan Buettner <[EMAIL PROTECTED]>: > > Seems like what you're looking for is a way to query your database > > more efficiently/quickly, and still find all links in either > > d

Re: Social Network, linking members

Hi, 2006/4/8, Dan Buettner <[EMAIL PROTECTED]>: > Seems like what you're looking for is a way to query your database > more efficiently/quickly, and still find all links in either > direction. > > I think the use of a UNION statement should allow this. Basically > write your query twice, joining

Re: MySQL 4.1.11 innodb cache can't be flushed after restart ?

2006/4/7, Charles Q. Shen <[EMAIL PROTECTED]>: > The OS used are Mandriva and Fedora. > > Can you explain more? > I'll make it quick, there is plenty of doc on a web that will explain this better than I can. Once you read few things from your hard drive (let's say the index file for your table), i

Re: MySQL 4.1.11 innodb cache can't be flushed after restart ?

2006/4/7, Charles Q. Shen <[EMAIL PROTECTED]>: > Hi all, > > I am running MySQL 4.1.11 with an innoDB table holding about 17GB of > records. I took a few hundreds of randomly selected records from the table > and measured the average access time: > > 1st test: average access time is 600ms > 2nd tes

Re: Slow query log

2006/4/5, Mechain Marc <[EMAIL PROTECTED]>: > Hi, > > Thank you for your answer. > But is there a chance to be able to do it one day? > I think it could be a nice feature. > You still have the option to sponsor that feature ;-D -- MySQL General Mailing List For list archives: http://lists.mysql.c

[Fwd: MySQL in C - I need help!]

-- Philippe Poelvoorde COS Trading Ltd. +44.(0)20.7376.2401 --- Begin Message --- Hi,   Good day!   I read the forum in this link http://archives.neohapsis.com/archives/mysql/2005-q2/1532.html and somehow I guess you people had tried programming MySQL in C successfully. I just hope that I can

Re: Commit needed even after a select statement ??

.mysql.com/doc/mysql/en/innodb-transaction-isolation.html try 'read uncommited', or just drop the transaction since what you are observing is perfectly normal... -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Subquery returns more than 1 row (1242)

SELECT PK_ORG FROM tbl_primary WHERE Province = 'Province1' ) What about : INSERT INTO tbl_secondary( FK_ORG, year ) SELECT PK_ORG, 2006 FROM tbl_primary WHERE Province = 'Province1'; (If you are sure the SELECT returns only one row, and that you have a UNIQUE

Re: cast and numeric conversion

eld stay blank.) I've look a bit at the documentation, but can't find anything on type promotion. Where can I find this ? http://dev.mysql.com/doc/mysql/en/cast-functions.html thank you ;) -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http:

cast and numeric conversion

ank.) I've look a bit at the documentation, but can't find anything on type promotion. Where can I find this ? -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.0 -> 4.1 lose timestamp

. Any ideas? i suppose i may just have to dump/load instead of copy files. If you dump them, and reload them, they are usually fine. If you want to retrieve the correct timestamp (as before), just do SELECT timestamp + 0 as timestamp FROM ... (for instance) -- Philippe Poelvoorde COS Trading

Re: Query Help

;Chem') AND sg.Grade = 'A'; GROUP BY s.StudentID HAVING COUNT(*) = 2; What if the student has 2 result in maths (or 2 in chemistry) ??? ;-) -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: mysql 5.0.10 compilation error

sts.mysql.com/[EMAIL PROTECTED] Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query Combining tables

| 26 | 18 | .. something like this should do it : SELECT group, count(*) as members, sum( IF(payment_type='creditcard',1,0)) as pay_by_card FROM members, payments WHERE members.memno=payments.memno -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list ar

Re: difference mysql_query and mysql_real_query

: mysql_real_query(mysql, query, strlen(query)); -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: default collation char

7; for 'blob' and any 'varchar' for 'varchar binary', as a result 'ABC' would next be different to 'abc' (but 'i' would also be different to 'e'). -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Question about BLOB

strlen(query_string); which culd lead to the broken result. http://dev.mysql.com/doc/mysql/en/mysql-real-query.html -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Question about BLOB

properly escape the data. (you don't need the ascii conversion, just the escaping) -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql and c

o your client. Why don't you just open another connection to the mysql server ? -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MAX select problem

I get a completely different and wrong answer, any ideas? Cheers, Lee I think that : http://dev.mysql.com/doc/mysql/en/example-maximum-row.html would answer you question more than I ;) -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.c

Re: SELECT by LEFT(col,1)="{letter}" ?? improvements and sarge update to 4.1

hich would uninstall the previous mysql, switch if off, install the new one, and start this one again). Still have a look at the options changes between both versions. (should not be a problem though). -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list arch

Re: telnet localhost 3306 Connection refused

port 80 ). And eventually change the logging mode for dropped paquets, that should give you a clue. -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Creating virtual rows question

+ nlmc + samp + tmc + gmc + yotmf AS total_points Use the AS keyword, not the equal/assignment operator FROM modelcup.ab_leader_board WHERE sex = 'Female' AND cup = 'kids' AND current_pos > 0 ORDER BY total_points ASC -- Philippe Poelvoorde COS Trading Ltd. -- MySQL Genera

Re: Help needed regarding MySQL-C Libraries on Linux....

'll advise you to use the mysql_config program like : /usr/local/mysql/bin/mysql_config --cflags (you didn't attach your program, so I can't see what is going on) -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.1.x with php-4.3.x

MySQL using the mysqli extension, which is more secure and provides a much better API. "much better API". If you don't use the multi-statement-feature, there's absolutely no point upgrading, all the more so you can have both of them compiled with PHP. -- Philippe Poelvoorde C

Re: why donn't work mysql_real_connect

client_flag); http://dev.mysql.com/doc/mysql/en/mysql-real-connect.html both your host _and_ unix_socket are null, this could not work if I understand well the doc. Use either "127.0.0.1" for host if networking is enable in mysql, or the full path to the unix socket (defaut /var/lib

Re: mysql_init

ch is normally easy to setup). -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql_init

i've googled and the only answer to problems like this has been to reinstall the DB perl module. Ive tried this but still get same error. any clues??? thanks in advance. Ronan Is libmysqlclient.so available in one of your LD_LIBRARY_PATH directory ? -- Philippe Poelvoorde COS Tr

Triggers

ON test FOR EACH ROW do_something; INSERT INTO test(foo) VALUES ('a'),('b'),('c'); it would trigger trigger_name for the 3 inserts, right ? Any chance to trigger trigger_name only once at the end ??? -- Philippe Poelvoorde COS Trading Ltd. -- MySQL Gene

Re: alter table - add a column

Jigal van Hemert wrote: From: "Philippe Poelvoorde" [Note, ALTER TABLE foo ADD userid integer unsigned NOT NULL auto_increment BEFORE username, ADD PRIMARY KEY(userid); does not seems to work, possibly a bug ? ] No, you forgot the DROP PRIMARY KEY ;-) well not really, that'

Re: alter table - add a column

name... thanks -bruce [EMAIL PROTECTED] -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: when to use Indexes

sion. any urls which explains all this would be helpful. http://dev.mysql.com/doc/mysql/en/mysql-optimization.html You want to read, the one on "optimizing Select" and the one on columns indexes. -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For

Re: INSERT DELAYED and NOW()

:= now(); you would spare a bit of bandwidth my 2cts. -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Storing in HEX format.

->saddr),dbsport,inet_ntoa(ip->daddr),dbdport,temp); Indeed :-) Thanks for the correction -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Storing in HEX format.

Hi, snprintf(query_length,query, "INSERT INTO idsmatch(sip,sport,dip,dport,HEX(payload))VALUES('%s',%d,'%s',%d,'%s')", inet_ntoa(ip->saddr),dbsport,inet_ntoa(ip->daddr),dbdport,temp); -- Philippe Poelvoorde COS Trading Ltd. -- MySQ

Re: Performance problems through gateway

recipient should check this e-mail and any attachments for the presence of viruses. ITT Industries accepts no liability for any damage caused by any virus transmitted by this e-mail. **** -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For

Re: SELECT problem and QUESTION OF SPEED

ne, most-recent trip/person. Any ideas? ...Rene -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://

Re: substituting a certain word in all the tinytext rows in a table using SQL command

SET field=REPLACE(field,'plop','foo'); -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: varchar(10) to decimal

ve you example results ? How did you declare your decimal column ? -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Cleaning muck out of data fields

m \d+.\d\d 10.95 but as mysql only supports regexp when matching, I reckon a regex_replace would be a great idea... any plan for that feature ? -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

Re: Remove 1st 3 Chars

7;04200'!=fieldname, '04035'!=fieldname, '04026'!=fieldname (from a yesterday proposal) i.e. I want row 1 to have fieldname=' B4079', row 2 to have fieldname='B4076', etc. Or is there any other way to list the results by the order as defined in a list specified in the query. Please don't reply saying that I should do this in the application layer as that isn't an option. Thanks for any help at all on this... Cheers, Andrew MySQL, Query -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: backup a database

existing folder (due to a wrong working directory, try "echo $PWD" in your backup.sh). I had the same pb when we setup our daily backup. my mysql version is : 4.0.17 regards rafael -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.

Re: Underline or minus sign ?

n the whole CNF file instead of underline ? no, i think it depends the option configured (..a bit confusing, I know) Gabriel -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to design effective MySQL DB for multi-user web tracker system?

one DB... It's also difficult to manage so big DB with phpMyAdmin. Can you help me? Thanks... Don't create a table per user, but instead add a field in one table to reference this user, then you will have 150 times less tables to manage, therefore logging and truncation on a monthly bas

Re: C API: Storing is easy; How do you retrieve?

slashes(myrow[0]); (providing you escape characters); then the usual C function should do the trick (fopen, fwrite...) or SELECT INTO OUTFILE (check the manual, I don't know the details ;) to store the file on the server. -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For

Re: Multi Table Delete in 3.23.47

Michael Stassen wrote: zzapper wrote: > Hi, > Final whinge: I wish the mysql website made it a little clearer which > features are recent additions, I suggested color coding. Philippe Poelvoorde wrote: I reckon, it's a bit hidden in the middle : "Starting with MySQL

Re: Multi Table Delete in 3.23.47

yourself with your favorite langage (PHP, Perl, Templeet, C...). I know it's painful... (but it's great to have it in 4.0 as well as multi-table updates) -- Philippe Poelvoorde COS Trading Ltd. Thanx Philippe that stops me scratching about looking for a non-existant solution.I'

Re: update and select question

$B2+9bJv(B wrote: (B> i use this mail first . (B> (B> i have a problem in under sql program: (B> (B> (B> UPDATE (B> NGLDENHDT (B> SET (B> EDT_HUK_FLG = :EDT_HUK_FLG (B> WHERE (B> KAI_CDE = :KAI_CDE (B> AND EDT_NUM = (SELECT MAX(EDT_NUM) (B>

Re: Multi Table Delete in 3.23.47

, C...). I know it's painful... (but it's great to have it in 4.0 as well as multi-table updates) -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mygrating from 3.23 to 4.1

heck between each version what incompatibility might hit you. and then do the upgrade (either with a mysaldump, or just by upgrading your binary) Any help would be apreciated. Warm Regards, -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Using libmySQL with C/C++

but the .dll is needed by the linker) HIMH -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Visual C++ 6.0 and MySQL

tutorial and examples? Thank you, Vicente Valero the C api is here : http://dev.mysql.com/doc/mysql/en/c.html the c++ here : http://tangentsoft.net/mysql++/ -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: TIME Difference Using 4.0.17

date_sub(CURRENT_TIMESTAMP(), interval 2 day) -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: CSV storage engine

se Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server Upscene Productions http://www.upscene.com -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: deadlock with innodb

expected behaviour, it's fine with me, but I still don't undestand why it does happen. Thanks for your help, Well, I'm sure it's a bug hidden somewhere in my apps, i've check with another connexion and it worked ;) -- Philippe Poelvoorde COS Trading Ltd. -- MySQL

Re: deadlock with innodb

Philippe Poelvoorde wrote: Gleb Paharenko wrote: Hello. What transaction isolation level do you use? By the way - there's a fresh bug related to SELECT ... FOR UPDATE: http://bugs.mysql.com/bug.php?id=9512 tx_isolation is set to : REPEATABLE-READ (which is the default) I've stripped

Re: deadlock with innodb

wo tables) If I try to do it on the command line, it works as expected. Can this be related to the libmysql library ? I'm using on the client side the version that comes with 4.0.20a for windows, and the server is a 4.1.10a (Linux). Thanks for your help, Philippe Poelvoorde <[EMAIL

deadlock with innodb

x27;t really understand why the two applications try to insert data since I've specified the FOR UPDATE in the SELECT to lock insertion of new record. Is there anything I'm mistaking ? Thanks for your help, -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list

Re: can't drop innodb table

Gleb Paharenko wrote: Hello. I think that SET FOREIGN_KEY_CHECKS = 0; could help you. Thanks, I didn't think about it. I've I dumped the DB and recreate it instead. Philippe Poelvoorde <[EMAIL PROTECTED]> wrote: Hello, I've got an innodb that I try to drop: drop table marke

can't drop innodb table

then : drop table last; ERROR 1051 (42S02): Unknown table 'last' I'm a bit lost there, how can I drop this table ? (I want to recreate it with innodb_file_per_table option afterwards) -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://list

Re: Queries inside UDF

sguazt sguazt wrote: Hi! From: Philippe Poelvoorde <[EMAIL PROTECTED]> Reply-To: "'mysql@lists.mysql.com '" To: mysql@lists.mysql.com Subject: Re: Queries inside UDF Date: Thu, 17 Mar 2005 08:22:46 + .. You can actually access a DB within a UDF, but you should do

Re: Queries inside UDF

m. Also bear in mind that it should be thread-safe ;) a way to extend udf, is ... stored procedure ? -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Better option then polling ?

ich would do the job. (just ping a particular port on a remote server, to force it update that table). As anyone been doing something like this ? At the moment we're just polling the whole table every 5 seconds (not a big table less than 500 records) -- Philippe Poelvoorde COS Trading Ltd. -- M

Re: CASE statement and version 4.1.x

l it's || not | (not sure about bit-operation...) -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL hangs

Marcin Lewandowski wrote: Hi, I've got webserver with php and mysql-4.0.22 There I've got large phpbb2. That's it. phpbb2 is known to consume ressources, if I were you i wouldn't search further... not a mysql issue afaik -- Philippe Poelvoorde COS Trading Ltd. -- MySQL Gene

Re: Switching to InnoDB turns out dissapointing

;s done by mysql. -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: alter table return error

Michael Stassen wrote: Did you try perror? ~: perror 150 Error code 150: Unknown error: 150 150 = Foreign key constraint is incorrectly formed Right, I forgot to alter one table that had a FK on this table. Thanks ;) -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For

alter table return error

any problems on any others tables (all are innoDB), all permissions seems to be fine. I don't really know where to look for hints, any ideas ? -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Images to MySql Database in PHP or JAVA

anks, -Chris -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ODBC 3.51.06 for win32

Hi, I'm looking for an older version of the ODBC connector, the 3.51.06 version for windows, but I could not get a hand on it. I'v been there : http://downloads.mysql.com/archives.php?p=myodbc-3.51 but no luck at all. Any chance someone could point me in the right direction ? Thanks, -

Re: How remove the closed connections

TDataModule_PMV::RemoveMyConnection(TMyConnection * dbConn) { if( dbConn ) { dbConn->Connected = false; delete dbConn; dbConn = 0; } } Does this mean that it will close the connection ? -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mai

Re: last_insert_id

nique-id.html btw, what do you mean by : "I managed to have my insert queries as atomic". Because if you do : INSERT it's already suppose to be atomic. HIMH. -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: MySQL upgrading

to guide ? Thanks, Helena -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Philippe Poelvoorde COS Trading Ltd. +44.(0)20.7376.2401 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Question: InnoDB transaction and table changes

BLE `foo` ( `bar` int(11) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | ++-----+ 1 row in set (0.00 sec) -- Philippe Poelvoorde COS Trading Ltd. +44.(0)20.7376.2401 -- MySQL General Ma

Re: !! Help with query: Where Date = MAX(Date)

x27;20050204') Any help much appreciated Graham have a look here : http://dev.mysql.com/doc/mysql/en/example-maximum-column-group-row.html it should be useful for you. -- Philippe Poelvoorde COS Trading Ltd. +44.(0)20.7376.2401 -- MySQL General Mailing List For list archives: http://l

Re: can a subquery be used in an insert

which is the parent comment(0 if there is no parent, or the value you give thanks to a hidden input field in your wiki), so you normally don't need that extra query. -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To un

Re: can a subquery be used in an insert

nts where sourceid=1; but querying max(idx) is a bad idea. you could get the last inserted id with the following command : SELECT last_insert_id() from comments LIMIT 1; the last_insert_id is available on a per connection basis. but why are you inserting back in comments a field from comments ??

Re: InnoDB race condition inserting into a table with a unique constraint

n two sessions run the above query and no rows are found, the second select will block until the first transaction has completed? Is there an alternative way of structuring the problem that would make this concurrently safe? Thanks, Phil -- Philippe Poelvoorde COS Trading Ltd. -- MySQL Gener

Re: primary key performance

than a varchar(50). My guest is that it use more disk seeks to retrieve all data needed in the index. So I would say that's the same about mediumint/bigint. (in all case be sure to do "optimize table your_table") -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing Li

Re: Out of memory

See what happens if you try it with the --quick option. This will prevent mysqldump from writing to memory before writing to the dump file. Hi, yes, it seems to work so far. Thanks for your quick reply. -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives

Out of memory

that I don't have any access to my.cnf on this environnement!) The last table in the dump (and not dump, it stops just after the CREATE TABLE) is not that big (less than 8Mo on disk). -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysq

  1   2   >