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

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 multithreading

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 some tables, joins and where-criterias group by rt.team_id order by avg_score desc; which gives:

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 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

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

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 through

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 the error in

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: 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/mysql To

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 increment

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_count` smallint(5) unsigned NOT NULL default '0

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 text_column

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

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

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

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 - internet )

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 direction. I think the use of a UNION statement should allow

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 on id1

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 test:

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), it's

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:

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

-- Philippe Poelvoorde COS Trading Ltd. +44.(0)20.7376.2401 ---BeginMessage--- Hi, Good day! I read the forum in this link http://archives.neohapsis.com/archives/mysql/2005-q2/1532.htmland 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 ??

/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 unsubscribe:http

Re: Subquery returns more than 1 row (1242)

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 index on (FK_ORG,Year). ) -- Philippe

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

cast and numeric conversion

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: cast and numeric conversion

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://lists.mysql.com/mysql To unsubscribe

Re: Query Help

') 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:http://lists.mysql.com/[EMAIL

Re: mysql 5.0.10 compilation error

] 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: 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: Query Combining tables

| .. 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 archives: http://lists.mysql.com

Re: default collation char

' 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

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: Question about BLOB

by 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: mysql and c

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

? 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.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

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

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 archives: http

Re: telnet localhost 3306 Connection refused

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 General Mailing List For list

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

/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: why donn't work mysql_real_connect

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/mysql/mysql.sock) -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing

Re: 4.1.x with php-4.3.x

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 COS Trading Ltd. -- MySQL

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 Trading

Re: mysql_init

). -- 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]

Triggers

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 General Mailing List For list archives: http

Re: alter table - add a column

-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: 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's the statement

Re: INSERT DELAYED and 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: when to use Indexes

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 list archives: http://lists.mysql.com/mysql To unsubscribe:http

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. -- MySQL General Mailing List For list archives: http

Re: Storing in HEX format.

); 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: Performance problems through gateway

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 list archives: http://lists.mysql.com/mysql

Re: SELECT problem and QUESTION OF SPEED

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://lists.mysql.com/[EMAIL PROTECTED] -- Philippe Poelvoorde COS

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

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

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://lists.mysql.com/[EMAIL

Re: Remove 1st 3 Chars

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: Underline or minus sign ?

in 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: backup a database

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.mysql.com/mysql

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

]); (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 list archives: http

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

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 basis wil be easier. -- Philippe

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: snip I reckon, it's a bit hidden in the middle : Starting with MySQL 4.0.4, you can also

Re: Multi Table Delete in 3.23.47

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: 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) (BFROM

Re: Multi Table Delete in 3.23.47

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'm happy to write a perl script just

Re: Mygrating from 3.23 to 4.1

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/mysql To unsubscribe:http

Re: Using libmySQL with C/C++

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: deadlock with innodb

, 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 General Mailing List For list archives: http

Re: CSV storage engine

, 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

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 everything

Re: deadlock with innodb

) 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 PROTECTED] wrote

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://lists.mysql.com/mysql

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 markets; ERROR 1217 (23000

deadlock with innodb

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 archives: http

Re: Queries inside UDF

sguazt sguazt wrote: Hi! From: Philippe Poelvoorde [EMAIL PROTECTED] Reply-To: 'mysql@lists.mysql.com ' 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 the same

Re: Queries inside UDF

program. 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 ?

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. -- MySQL General Mailing List

Re: CASE statement and version 4.1.x

...) -- 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 General Mailing List

Re: Switching to InnoDB turns out dissapointing

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]

alter table return error

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: 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

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, -- Philippe

Re: Images to MySql Database in PHP or JAVA

-- 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 remove the closed connections

::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 Mailing List For list

Re: last_insert_id

-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 unsubscribe:http

Re: MySQL upgrading

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: !! Help with query: Where Date = MAX(Date)

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://lists.mysql.com/mysql To unsubscribe

Re: Question: InnoDB transaction and table changes

) ENGINE=InnoDB DEFAULT CHARSET=latin1 | ++-+ 1 row in set (0.00 sec) -- Philippe Poelvoorde COS Trading Ltd. +44.(0)20.7376.2401 -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: can a subquery be used in an insert

(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 ??? -- Philippe Poelvoorde COS Trading Ltd

Re: can a subquery be used in an insert

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 unsubscribe:http

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

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 General Mailing List

Re: primary key performance

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 List For list archives

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.mysql.com

  1   2   >