RE: Result ordering

instead of > SELECT name, (CASE WHEN bar = 34 THEN 0 ELSE 1 END) AS rank> FROM foo> WHERE > bar = 34> OR baz > 100> ORDER BY rank ASC, baz DESC> LIMIT 5; you can use order the query evaluation to perform inner subquery first select distinct foo.name,foo.bar,baz.bar from foo where exists (selec

RE: Vexing permissions issue with partitioned CREATE TABLE

2008-12-05 at 16:41 -0500, Brad Heintz wrote: > > > > > > Thanks, Martin, but that's not it. As I mentioned in my email, I'm running > > as MySQL root user with all priv bits set. I tried your suggestion anyway, > > but no c

RE: What files to install for Windows

Jerry is correct you are better off using the pre-packaged installer from the MySQL distro for the most part you are downloading (binaries) from some site creating a MYSQL_HOME environment variable to point to home folder for MySQL unzipping/uncompressing the distro to the MYSQL_HOME folder make

RE: Can a JOIN statement do this?

Happy New Year Mike- JOIN USING(colId) and or JOIN ON(table1.colId=table2.colIdentifier) will preserve the use of Indexes which is faster LIKE casts off Indexes and does a FTS HTH Martin Any recommendations on non-PHP Forum Software for Apache? __

RE: How to Use Cascade Delete Properly

If you're not going to Cascade Delete you'll need to change ON DELETE CASCADE clause to ON DELETE SET NULL e.g. change FOREIGN KEY(id_b) REFERENCES b(id) ON DELETE CASCADE TO FOREIGN KEY(id_b) REFERENCES b(id) ON DELETE SET NULLhttp://dev.mysql.com/doc/refman/5.0/en/delete.html Martin

RE: VC++ 2008 / MySQL debug / Unhandled exception

if Memory serves the LIBCMTD.lib library that you're excluding IS the MultiThreaded Library? Generally if you can run it thru debug you can get the CodeStack and InstructionPointer which will at least point to the exact location where it abended Saludos Cordiales desde EEUU!Martin

RE: timeout

from a purely network point of view PING works if ICMP traffic is allowed do a tracert and find out which intervening node is rerouting the traffic you might have something funky on the routing tables Martin __ Disclaimer and confidentiality note Eve

RE: how can trace stored procedure usage?

Jim- you can try to port Oracles utldtree.sql Caveat Emptor: Hasnt been worked on since 92 and is VERY buggy! Martin Gainty __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of

RE: Certification Feedback?

Dan- I would concentrate on SQL certification first To know package foo does bar method for MySQL is a good extra tool to have in your toolbelt but more important for the bigger companies to be able to use your skillset for MySQL AND DB2 AND Oracle Martin ___

RE: Trying to work out why a join query is so slow

UNION all does a cartesian join ..maxiumum number of results will be delivered SELECT * FROM sites INNER JOIN sites.userid = users.ID; -- INNER JOIN users ON sites.userid = users.ID --ALSO put (hopefully UNIQUE indexes) on sites.userid and users.id Martin __

RE: grabbing even addresses?

Jason try select ADDRESS FROM FUBAR_TABLE WHERE MOD(TO_ NUMBER(SUBSTR(ADDRESS,1,instr(ADDRESS,' ',1))),2) =0; SUBSTR(ADDRESS,1,INSTR(ADDRESS,'',1)) 1232 Main 1234 Main HTH Martin _

RE: WHERE vs. ON

ON condition uses the same columnname from both source and target tables whereas any column expressions can go in the WHERE clause... Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official

RE: MySQL View

My current understanding of the delta between Views and Temporary Tables Views are read only results from 1 or more tables ..in Oracle they are stored in TEMP tablespace http://www.psoug.org/reference/views.html Temporary Tables are tables which are created/updated/inserted and exist only for t

RE: InnoDB: Thousands of Tables or Hundreds of Databases?

I vote for 1 table per TableType this will keep your DB schema consistent with Architecture Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is

RE: How can avoid 2 selects and 2 while? SOLVED

Jose- preface the product_id column with table ID e.g. table_1.product_id table_2.product_id or use the alias assigned to tableName Saludos Cordiales desde EEUU Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachm

RE: DB crashing while dumping

Jason- can we see the schema and a few data rows for `soapware_charts_xmldocumentitems` says something about invalid pointers? Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official busine

RE: Left join does not work with Count() as expected

these results --- if.id f.cnt fm.id fm.cnt -- - -- --- 1 1NULL 0 2 22 2 Martin Gainty __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates

RE: && vs AND

there is no && character matrix supported in the SQL92 spec located at http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt also there is no Truth Table for && but there IS a truth table for AND conditionals. Martin __ Disclaimer and confident

RE: Enumerate MySQL Servers?

will you be supporting clusters? if not you can scan for listeners on 3306 HTH Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confiden

RE: why is this happening?

what does the master db show for processlist ? master_mysql>show processlist ? Martin __ Disclaimer and confidentiality note This message is confidential and may be privileged. If you are not the intended recipient, we kindly ask you to please inf

RE: why is this happening?

Jim can you verify the process is quiesced from MySQL (master) mysql>SHOW PROCESSLIST ? Martin __ Disclaimer and confidentiality note This message is confidential and may be privileged. If you are not the intended recipient, we kindly ask you to p

RE: Error -1

SELECT bunch_of_columns FROM bunch_of_tables WHERE MATCH (memos.note_text) AGAINST ('frog' IN NATURAL LANGUAGE MODE); You may want to consider implementing lucene for search engine capability http://lucene.apache.org/java/docs/ ? Martin __

RE: Search based where claused and stored proc

Ben- did'nt see your solution? Martin __ Disclaimer and confidentiality note This message is confidential and may be privileged. If you are not the intended recipient, we kindly ask you to please inform the sender. Any unauthorised dissemination

RE: IN vs. OR on performance

basically the same criteria as IN vs EXISTS from http://decipherinfosys.wordpress.com/2007/01/30/in-vs-exists/ select from TABLE_A where col1 in (Select col2 from TABLE_B) VS Select from TABLE_A where exists (select 1 from Table_B where Table_B.col2 =

RE: AMD64

MySQL converts MYSQL_TYPE_LONG to float before storing http://dev.mysql.com/doc/refman/5.1/en/c-api-prepared-statement-datatypes.html you may want to consider FIXED size datatypes for that requirement e.g. unsigned long *length HTH Martin __ Verzich

RE: Newbie ... Schema details listing

in information_schema.tables e.g. SELECT AUTO_INCREMENT from information_schema.tables where WHERE TABLE_NAME = "Products" AND TABLE_SCHEMA = "bs3578"; Viel Gluck, Martin __ Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerku

RE: 1135: Can't create a new thread (errno 35); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug

Jörg mgai...@martini ~ FGIN.sh 35 | fgrep errno find: File system loop detected; `/usr/include/gnome-xml/libxml' is part of the same file system loop as `/usr/include/gnome-xml'. /usr/include/apr-1/apr_errno.h:806:#define SOCEWOULDBLOCK (SOCBASEERR+3 5)/* Operation would blo

RE: Slow connecting to MySQL from Windows App

please follow my earlier suggestion and place long_query_time=NumberOfSecs min_examined_row_limit=MinNumberOfRowsToExamine in my.cnf or my.ini start mysqld --log-slow-queries[=file_name] documentation available at http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html Shalom Martin Gainty

RE: Creation date

that is one weird opening statement select * from information_schema.tables where table_name='DATABASE_NAME.TABLENAME'; Martin "May the Schwartz be with you" -- Spaceballs __ Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung/Note

RE: Still going in cicrles

starting MYSQL %MYSQL_HOME%\bin>mysqld --log-output=FILE --log-error=MySQL.log --result-file=results.log --perform some minor operation mysql -u username -p root DBNAME mysql>show databases; mysql>use database; mysql>show tables; please display the results of these operations of %MYSQL_HOME%\da

RE: Still going in cicrles

providing accurate information would've helped the op in this situation i agree! thanks, Martin __ Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité This message is confidential. If you should not

RE: Native Function

linking to the server code and calling server functions with libmysqld.a (instead of linking in client code from libmysqlclient.a) HTH Martin Gainty there is also a way to accomplish this with an Oracle Function calling external methods but we should wait until after the merger for that

RE: mysql not able to import mysqldump file

Neil- http://wiki.seas.harvard.edu/geos-chem/index.php/Floating_point_math_issues so a value this large or small would only be true for 8byte double datatype Curious as to what the original Table/Column datatype is hth Martin __ Jogi és Bizalmassági

RE: Date Time

mysql> select sysdate() from DUAL; +-+ | sysdate() | +-+ | 2009-05-21 17:37:13 | +-+ i would get the proprt format is i could CONVERT_TZ to work can you get CONVERT_TZ to work ? Martin Gai

RE: Date Time

; +-+ | d | +-+ | 2009-05-21 03:15:28 | +-+ most of us have contacts in europe who dont use EDT,CDT,MDT or PDT so i *was hoping* to get confirmation on CONVERT_TZ(date,from_tz,to_tz) works? Thanks, Martin Gainty ___

RE: Question about Maria readers/writers

only if you are implementing INNODB Transactional Storage Engine MySQL uses table-level locking for MyISAM, MEMORY and MERGE tables, page-level locking for BDB tables, and row-level locking for InnoDB tables. http://dev.mysql.com/doc/refman/5.0/en/internal-locking.h

RE: Mistake #sql-9c8_21' (errno: 150)

no puedo ver la disposición atada del esquema de la exhibición de la imagen. .please de la tabla relevante y crear la tabla, cree las declaraciones del índice Saludos Cordiales desde EEUU! Martin GMT+5(por la semana) __ Verzicht und Vertraulichkeitanm

RE: I need some example

cannot help with implementation details unless we see your DB schema e.g. mysql>use DB mysql>show tables msqyl>desc table1 mysql>desc table2 Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Die

RE: contributing to mysql ..

mysql docs could use a translation to Swahili (if you speak/read and write Swahili) ? thanks! Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der

RE: AW: AW: creating databases in different folders

Maschinenbordbücher sind sicher, selbst wenn die Vorrichtung, die das Verzeichnis enthält, verloren ist. arbeitet dieses nicht für Nichtdämon? (raten Sie bitte) Martin Gainty __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich

RE: Why doesn't mySQL stop a query when the browser tab is closedL

transaction that tries to access a row that is locked by another InnoDB transaction will hang for at most this many seconds before issuing the following error: //there are also driver specific timeouts available for ODBC/JDBC drivers HTH Martin Gainty

RE: Ordering an IN query

FIELD(ORDINAL_POSITION,23,18); Shalom Martin Gainty __ Note de déni et de confidentialité Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéd

RE: Thread safe queries with multiple connections

mg>hopefully quick comments > Date: Sun, 7 Jun 2009 04:41:20 -0600 > Subject: Thread safe queries with multiple connections > From: buf...@biffco.net > To: mysql@lists.mysql.com > > I think my question is whether the data in MYSQL_RES and MYSQL_ROW data > structures are sufficiently independent

RE: Best approach for DB-based event logging?

Nigel/Marcus/Johann mg>hopefully quick answer > > nigel wood wrote: > > > > Here's a rough table stucture. The indexes in events tables would be > > TargetId. mg>there would be need to be a 1:1 correspondence between mg>TargetId index and Username..all of your other tables would need to know

RE: Table problem

run a quick df >df Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. J

RE: Slow query Performance

when my.ini has query-cache-type = 1 setting the query results are placed in cache on first read second and consequent reads reference resultset from cache http://www.databasejournal.com/features/mysql/article.php/3110171/MySQLs-Query-Cache.htm Martin Gainty Confucius say "Big Dog in

RE: JOomla Administrator

its possible a single thread language such as PHP would'nt handle your situation..have you tried to recode your application in Java? in the meanwhile please post your stacktrace Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de dé

RE: Basic SQL Query Help Needed

SELECT * FROM ORDER o INNER JOIN ORDER_LINE_ITEMS o_l ON (o.id=o_l.id) Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene

RE: Database design - help

(URL Table) (CATEGORY TABLE)URL_ID1->1 URL.URL_ID CATEGORY.CATEGORY_ID1<---1CATEGORY_IDURL_TEXT 1 ↓ 1 SUBCAT.CATEGORY_ID SUBCAT.SUBCAT_TEXT this is labour-intensive work

RE: incremental name search?

TABLE user MODIFY Host char(60) NOT NULL default '', MODIFY User char(16) NOT NULL default '', ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; # much better: USE Database SET character_set_client = utf8; CREATE Martin Gainty ___

RE: Unable To Remove User

Grant he is trying to login as that user then drop the user he logged in as Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger

RE: Passwords not working

someone probably installed mysql for DHCP address e.g 192.168.fu.bar then as luck would have it the IP address changed if you pull all network connections everyone on that box should be able to access mysql Salutations de l'état du chômage Martin G

RE: Open Tables

between tables should always be unique and may involve concatenated columns the most famous example is OrderLine Item which consists of OrderID from Order-Header and OrderLineItemID i hope this addresses your requirement Martin Gainty __ Verzicht und

RE: SQL Question

s=99; else $affectedrows = $execute->affectedrows($myquery); } http://www.tizag.com/perlT/perlmysqlquery.php (notice the site is written in PHP) Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nac

RE: Customers with no recent orders?

any column used in any group functions such as SUM needs to be requested in select column e.g. select foo from table where sum(foo)=1.00 Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist

missing ttydefaults.h

In file included from readline.c:54: readline/readline.h:70:29: sys/ttydefaults.h: No such file or directory any clue where i can locate? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist

RE: missing ttydefaults.h

no i havent ..any clues as to location of kernel headers? (apologies for the newbie question) Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der

RE: Happy Christmas

Guten Tag/Bonjour/Hello Pete Haben Sie ein gutes Weihnachten/Ayez bon Noël/Have a good Christmas Staaten von Amerika/Etats Unis/United States of America Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

RE: how things get messed up

i agree with jerry put date/timestamps on each record..(that way you know when the record was created/modified) Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten

RE: Tokutek Acquires Oracle

short of exxon there is no other entity that comes close to acquiring Oracle Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger

DATE_FORMAT parameter question

++ | 11-Oct-09 | +--------+ 1 row in set (0.00 sec) any ideas on what I am doing wrong with format string to produce desired DD-MON-YY format? Many Thanks, Martin Gainty __

RE: DATE_FORMAT parameter question

(Agradecimentos para o conselho) Eu espero que o homem responsável parará a chuva e permitirá a todos nós a oportunidade de dessecar e apreciar a luz do sol Obrigado! Martin Gainty __ Por favor não altere/interrompa ou altere esta transmissão

RE: DATE_FORMAT parameter question

Hi Carsten thanks for providing mysql support at 846pm kobenhavn time (on a fridag no less) I will DEFINITELY check this out Takk! Martin Gainty __ Note de déni et de confidentialité Ce message est confidentiel et peut être privilégié

RE: Getting Array to display on SELECT

RGB encoding? sorry..thats for graphic designers Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich

RE: Database Quotas

Tim- if MYSQL attempts to insert more bytes than what is available on disk you will get 28 ENOSPC No space left on device http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html does this help? Martin Gainty __ Verzicht und

RE: Database Quotas

ented Disk Architectures does this conform to your understanding? Martin Gainty __ Please do not alter/modify or disrupt this transmission. Thank You > Date: Fri, 21 May 2010 07:21:22 -0700 > From: t...@soe.ucsc.edu > To: mgai...@hotmail.com > CC:

RE: Security issues

-schedule-for-glassfish-556/ Does this help? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um

RE: Master - master replication

Hello Carl MySQL advertises an encryption package using the ENCRYPT('hello') but to date i have'nt find any information on where to download and configure the encrpytion package did you look at http://www.critotech.com ? Martin Gainty _

RE: Master - master replication

decrypter at the other end will decrypt the received rows and construct import/update statements to MYSQL ? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der

RE: Master - master replication

mg>zoom down to walters question(s) > Hi Carl, > > On Mon, May 24, 2010 at 13:42, Carl wrote: > > 1. Is the data visible during transmission? > > Not sure what you mean there? mg>he means if someone was sharking the line would they be able to see Financial Information / HealthInformation th

RE: Security issues

tervals RSA implements an alternate encryption algorithm with an alternate keysize RSA issues smart cards which contain sufficient biometric information to authenticate you (and pass the authentication token to the OS) does this help? Martin Gainty ___

RE: Security issues

Good Morning Rob- I agree with you that security is a very serious topic and should be addressed as such Please read security alert page listed at tech-resources http://dev.mysql.com/tech-resources/articles/security_alert.html I hope this addresses your question, Martin Gainty

RE: Strange errors / messages on slave server

> In less technical terms, if the master goes faster than the slave, the slave > will puke. MG>then the master will have to teach the slave MG>is the master the entrenched bureacucrat or is that the slave? > > Regards, > > Jerry Schwartz > Global Information Incorporated > 195 Farmington

RE: Best way to purge old records from a huge table?

2 | 2 | 2006-09-05 | | 3 | 3 | 2006-09-06 | +++-+ 2 rows in set (0.00 sec) hth Martin Gainty __

RE: query help

i would monitor the performance on outer-join to determine if your server pegging cpu,disk i/o or memory when executing te outer-join then perhaps populating a temp table (and deleting the non-matching records..those records which will be considered in transaction) as joerg suggested i was

RE: Select w/ group by question

> Date: Wed, 14 Jul 2010 10:25:22 -0400 > Subject: Select w/ group by question > From: smulle...@gmail.com > To: mysql@lists.mysql.com > > I'm having trouble formulating a query to gather the following data. I can > do this via a script, but now it is more or less just bothering me if there

RE: How to become a DBA on MySQL

ask program coordinator gary his address is sav...@champlain.edu My understanding is that oracle may offer some DBA courses in the future Keep us apprised Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

RE: Why is MySQL always linked to PHP?

MySQL is written in C if your requirement is to write extension packages for MySQL then use the OS specific C compiler to write the functions deferring to MySQL staff to handle your other questions Martin Gainty __ Verzicht und

RE: query results group/summed by interval

if your interval is 5 change: sum(calls) from calls group by 5 * floor(seconds/5) to sum(calls) from calls group by floor(seconds/5) Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist

RE: query results group/summed by interval

if your interval is 5 change: sum(calls) from calls group by 5 * floor(seconds/5) to sum(calls) from calls group by floor(seconds/5) Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist

RE: from excel to the mySQL

Vaz please do not insert bogus display names into the email display name (such as Vaz when your real name is haidarpesebe) most responsible mail-admins wont tolerate this type of spoofing or any type of email spoofing and if your name is VAZ use the email address created for VAZ instead of h

RE: Practical connection limits MySQL 5.1/5.5

i agree with harald if you're using Java you should consider pooling your database connections with DBCP http://commons.apache.org/dbcp/ feel free to ping me for implementation details takk, Martin __ Note de déni et de confidentialité Ce message

RE: mysql deal with specail character problem

correct here is the output of INFORMATION_SCHEMA.COLUMNS Create Table: CREATE TEMPORARY TABLE `COLUMNS` ( `TABLE_CATALOG` varchar(512) DEFAULT NULL, `TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '', `TABLE_NAME` varchar(64) NOT NULL DEFAULT '', `COLUMN_NAME` varchar(64) NOT NULL DEFAULT '',

RE: Запрос

(ich spreche nicht Russen) Martin __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung e

RE: Input needed...

Harald- could you re-iterate the details of the malady or error you are experiencing? danke, Martin __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich

RE: Input needed...

> From: h.rei...@thelounge.net > To: mysql@lists.mysql.com > Subject: Re: Input needed... > > Am 06.05.2011 13:26, schrieb J M: > > Config: > > > > Running on 8G Server.. Currently utilizing 7G.. running only mysql.. > > > [mysqld] > > innodb_data_home_dir = /var/lib/mysql/ > > innodb_data_file

RE: DBCP error

connection leaks will occur because of code maladies did you check your code to ensure: you are closing Statement Handles when you have finished executing the statement? you are closing Connection Handles when you have finished DML and DDL operations with the Database? ? Martin

RE: Query on wait_timeout

TRAN (or TRANSACTION) will apply an implicit lock on the table which remains until the TRAN is commit or rollback subsequent DML statements on that same table will be forced to wait UNTIL the TRAN is commit or rollback when the statement for the second update on the same table comes along there

RE: dumb question?

Rik and Crew String values are always ticked VALUES('MYNAME') unless ANSI_QUOTES are enabled Column names are never surrounded by ticks or double quotes so TABLE table_name FOO VARCHAR(30) where the INSERT statement for table table_name column FOO would look like: INSERT INTO table_name FOO VALUE

RE: Free Navicat

you will need the x86-64bit distro which contains the x86-64 bit distribution of libatkmm-1.6.so.1RPMs are error prone because they are version unaware..navicat should refactor their install to a version aware utility such as maven IMHO Martin __ Verz

RE: Hungarian Notation [Was Re: Too many aliases]

Jan- the upside is you dont have to look up a variable to know what type it is: zVariable is Null termed string bVariable is boolean nVariable is an Integer fVariable is a float dVariable is a double.. cVariable is a char Martin __ easy peasy..Shawsha

RE: Percona: Contact Details - a word on poaching

t you in the door On the other hand if you've been a full blown nazi with illegal wiretaps, strip searches and harassment you might wind up in the Hague for different circumstances. I am reminded of the platitude: United we stand..Divided we fall Bedankt, Mar

RE: Simple Email System (SES) Provider

Hi Don Your best solution is to setup your own Mail server (Preferably on SSL) http://en.wikipedia.org/wiki/Comparison_of_mail_servers Configure Open Relay to 'Off' Martin __ Jogi és Bizalmassági kinyilatkoztatás/Verzicht und Vertraulichkeitanmerkun

RE: Unresolved symbols with mysqlclient in DEBUG mode using VC++ 2010 Express

Miguel.. i do not have VC2010 but as my memory recalls the C runtime library (MSVCRT*.dll) would be the first library on %PATH% .. and all missing functions *should* be located inside the dll (e.g. __CrtSetReportFile ) can you 1) locate MSVCRT*.dll on your %PATH% 2) dumpbin -exports MSVCRT*.dll

RE: New guy

Bonjour Raymond Nous espérons que cela vaut votre temps Bon chance! Martin __ Note de déni et de confidentialitéCe message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satis

RE: About character_set_*

Unless your effort is to convert all text strings to Mainland Chinese only ...Dont forget 'Locale' http://dev.mysql.com/doc/refman/5.5/en/locale-support.html Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confi

RE: UDF writing to unix socket - segfaults?

assuming you worked out the access to network by your code permissions that means memory heap or stack is being overrun...you would be well advised to download the connect() and sendto() code from the OS vendor and toss in plenty of codeguard and debug statements and recompile and rebuild. Mit

RE: UDF writing to unix socket - segfaults?

ous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: p...@computer.org > Subject: RE: UDF writing to unix socket - segfaults? > Date: Wed, 8 Aug 2012 15:39:09 +0200 > To: mysql@lists.mysql.com > > Martin Gainty wrote: > > > assuming you worked out t

RE: trouble with perl

I know I had the same problem with PHP when mysql.dll was off my PATH..put the 2 mysql libraries on the first directory from your PATH 05/30/2008 08:17 PM 2,125,824 libmysql.dll 06/13/2012 06:31 PM34,304 php_mysql.dll be aware when things go wrong with DLL's you have no wa

RE: Machine Learning

Garot Can ypou provide any specific goal(s) on what you would like to achieve? Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so

  1   2   3   >