RE: Hungarian collation
Hi, On Thu, 2006-10-19 at 18:02 +0300, [EMAIL PROTECTED] wrote: From: Peter Gulutzan [EMAIL PROTECTED] MySQL is looking for an authoritative, official statement which states all the current Hungarian collation rules. According to the Reference Level Description of the hungarian language (ISBN 9634206441 or the hungarian version on line: http://bme-tk.bme.hu/other/kuszob/hangok.htm ) the rules are the following: Apparently http://bme-tk.bme.hu/other/kuszob/hangok.htm is an educational site (something to do with the council of Europe) as opposed to an official standards site, if I'm understanding correctly. - The basic order of the alphabet is a á b c cs d dz dzs e é f g gy h i í j k l ly m n ny o ó ö ő p q r s sz t ty u ú ü ű v w x y z zs - For the short-long vowel pairs (a á, e é, i í, o ó, ö ő, u ú, ü ű) long = short usually, but long short if all else is equal. E.g., kád kar kár kard So far, this seems to be the opinion of a majority, although not everyone describes the rule the same way. If MySQL adopts this rule, SELECT * FROM t WHERE column1 = 'kár'; will not return rows where column1 = 'kar'. But perhaps SELECT * FROM t WHERE column LIKE 'ká%' will return rows where column1 = 'kar' - The long double consonants are sorting as if they would have been expanded. I.e., ggy as gygy, nny as nyny So 'ccs sorts with cscs' is true, i.e. ccs cds I expect that there is no rule which could apply for all LIKE searches. - Composit words are sorted according to word parts. I.e., meggyújt meglát megy meggy I don't see a way to determine what is a composite word. So MySQL would return meglát megy meggy meggyújt An alternative collation sometimes used (in libraries, and some dictionaries and lexica) is according to the basic latin alphabet, whit the accented letters having the same value as the not accented. Or anything in between. E.g., honoring the digraphs and the trigraph, but leaving the accents out of the business. I hope this helps. Yes, and thank you. I'm grateful for the help MySQL is getting on this question. We are still hoping for more responses. ImRe -- Peter Gulutzan, Senior Software Architect MySQL AB, www.mysql.com Office: +1 780 472-6838 Mobile: +1 780 904-0297 VoIP: +1 408 213-6654 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Join on nearest value
Hi, I have two tables, both containing a UNIX_TIMESTAMP column. Is it possible to join the tables on the nearest values of these columns? If no, then could anybody show me a query to circumvent this limitation? Thanks ImRe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how to retrieve a list of savepoint in mysql.
hi all,I need some one to help me with this. I have put many savepoints during the transaction in mysql andI want to have the list of all the savepoints set during the current transaction.plz help.regards,Vijay
Re: Does new Community version change C API licensing?
Kaj Arnö wrote: So: For client licensing, nothing as changed -- but stay tuned for an announcement next week! Did I miss it? It's been almost 2 weeks, and I don't see anything in the MySQL press release archive or your blog. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: utf8 importing problem
Most likely the UTF8 is still in the data base, but whatever program you are using to view it is not displaying UTF8 properly. MySQL's command line program will not, for example, even if you SET NAMES utf8. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, October 28, 2006 2:22 AM To: mysql@lists.mysql.com Subject: utf8 importing problem I use MySQL database with utf8 character set and utf8_czech_ci collation. It works well on Linux server but when I try to export the data and import into the same database but running on XP machine the utf8 is gone.Instead of a proper coding there are some strange characters. I used mysqldump --default-character-set=utf8 mimi /home/Result.sql to export data to /home/Result.sql file on Linux machine. Then I downloaded the file to my XP and here I used mysql --default-character-set=utf8 mimi Result.sql to import data. Is it correct? Any help would be appreciated L. --- End of forwarded message --- -- 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://lists.mysql.com/[EMAIL PROTECTED]
Re: Workbench
On Sunday 29 October 2006 17:43, David Thole wrote: On Oct 22, 2006, at 11:37 AM, João Cândido de Souza Neto wrote: Hi everyone. I´m using mysql workbench to design my database and am heaving a snag. How can i rename my object? It always gets the name test and i did not found where can i change its name. Thanks in advance. If you mean trying to rename a table, you should be able to double click on the name to bring up the specifics of the table. I'm using the newest version of workbench, for OSX. It should be the same for all platforms of workbench. -David Thole He is referring to the database name. I've run in to this problem too. When you create a new project, your database (schema) is named test and there appears no obvious way to rename it. j -- Joshua Kugler Lead System Admin -- Senior Programmer http://www.eeinternet.com PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Workbench
Ok, we are in the same snag. Who gets the solution firstly please, share it. Joshua J. Kugler [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] On Sunday 29 October 2006 17:43, David Thole wrote: On Oct 22, 2006, at 11:37 AM, João Cândido de Souza Neto wrote: Hi everyone. I´m using mysql workbench to design my database and am heaving a snag. How can i rename my object? It always gets the name test and i did not found where can i change its name. Thanks in advance. If you mean trying to rename a table, you should be able to double click on the name to bring up the specifics of the table. I'm using the newest version of workbench, for OSX. It should be the same for all platforms of workbench. -David Thole He is referring to the database name. I've run in to this problem too. When you create a new project, your database (schema) is named test and there appears no obvious way to rename it. j -- Joshua Kugler Lead System Admin -- Senior Programmer http://www.eeinternet.com PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Workbench
Doesn't that change when you hook up to a database? On Oct 30, 2006, at 12:56 PM, João Cândido de Souza Neto wrote: Ok, we are in the same snag. Who gets the solution firstly please, share it. Joshua J. Kugler [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] On Sunday 29 October 2006 17:43, David Thole wrote: On Oct 22, 2006, at 11:37 AM, João Cândido de Souza Neto wrote: Hi everyone. I´m using mysql workbench to design my database and am heaving a snag. How can i rename my object? It always gets the name test and i did not found where can i change its name. Thanks in advance. If you mean trying to rename a table, you should be able to double click on the name to bring up the specifics of the table. I'm using the newest version of workbench, for OSX. It should be the same for all platforms of workbench. -David Thole He is referring to the database name. I've run in to this problem too. When you create a new project, your database (schema) is named test and there appears no obvious way to rename it. j -- Joshua Kugler Lead System Admin -- Senior Programmer http://www.eeinternet.com PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: utf8 importing problem
Remember that my MySQL skills are at the beginner level; and this whole Unicode / utf8 business always gives me a headache. Any Unicode or utf8 characters with diacritical marks will look funky in DOS. Normally what I do is take my data, convert it from uft8 to utf8, and see if the results match what I originally had. I'm not sure how reliable this technique is, but it will at least recognize files which have characters that are not utf8-encoded. This is counting on the fact that PHP doesn't recognize this as a null conversion. My particular problem was that I had files that were created in Windows applications, using CP1252 encoding. I needed to get these into utf8, and wanted to test my results. I have a PHP script to do this. My translator seems to work: at least, my results look right after the translation. What disturbs me is that the translated (utf8) files also seem to be CP1252, which seems counter-intuitive. I did this awhile ago, so it may be that CP1252 has alternate encodings that are a superset of utf8 (and I've forgotten). How are you looking at the data? Try directing some of it from MySQL into a text file, and open the text file with Notepad. It will give you a choice of opening the file as ANSI, Unicode, or utf8. Try opening the file in Unicode: if it is not Unicode, then the letters with diacritical marks should look wrong (or be missing). If MySQL's engine is as blind as PHP, you can do this in SQL. The problem, as I see it, is that the engine already believes the data is UTF8 so it might not work. SELECT COUNT(*) FROM table1 WHERE CONVERT(field1 USING utf8) != field1; Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 30, 2006 1:05 PM To: Jerry Schwartz Subject: RE: utf8 importing problem Jerry, I checked the imported data ( sql file) and the data are in utf8 coding. Is there a way how to check the imported data in a table itself, to eliminate the problem in the application? Thank you for your reply L. Most likely the UTF8 is still in the data base, but whatever program you are using to view it is not displaying UTF8 properly. MySQL's command line program will not, for example, even if you SET NAMES utf8. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, October 28, 2006 2:22 AM To: mysql@lists.mysql.com Subject: utf8 importing problem I use MySQL database with utf8 character set and utf8_czech_ci collation. It works well on Linux server but when I try to export the data and import into the same database but running on XP machine the utf8 is gone.Instead of a proper coding there are some strange characters. I used mysqldump --default-character-set=utf8 mimi /home/Result.sql to export data to /home/Result.sql file on Linux machine. Then I downloaded the file to my XP and here I used mysql --default-character-set=utf8 mimi Result.sql to import data. Is it correct? Any help would be appreciated L. --- End of forwarded message --- -- 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://lists.mysql.com/[EMAIL PROTECTED]
FW: varchar vs char - update statement
I have a database with several tables that can have up to 100 000 rows there is ~100 updates every seconds and ~100 select query on the same table using locks. The update is always on the same field a varchar(15), I believe it will be recommended to change it to char(15) to improve performance of the update since the required space is not reserved with a varchar(15) type. Is this assumption right? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
prepared stmt from DBD causes segfault
distro: suse 10.1 (64-bit) MySQL server/shared/client: 5.1.11-0 (rpm) PERL: 5.8.8 DBI: 1.5.2 DBD: 3.0008 I am trying to do some benchmarks w/ w/o prepared statements but if I enable mysql_server_prepare=1 I get a segfault when I try to execute a query - the prepare seems to work or at least it doesn't cough up the hairball untill I try to execute. set mysql_server_prepare=0 and everything runs no problem... didn't see anything relevant in the archives so has anyone seen this behavior and/or have any idea(s)?
Re: prepared stmt from DBD causes segfault
nevermind: http://bugs.mysql.com/bug.php?id=20559 bummer... On 10/30/06, Sid Lane [EMAIL PROTECTED] wrote: distro: suse 10.1 (64-bit) MySQL server/shared/client: 5.1.11-0 (rpm) PERL: 5.8.8 DBI: 1.5.2 DBD: 3.0008 I am trying to do some benchmarks w/ w/o prepared statements but if I enable mysql_server_prepare=1 I get a segfault when I try to execute a query - the prepare seems to work or at least it doesn't cough up the hairball untill I try to execute. set mysql_server_prepare=0 and everything runs no problem... didn't see anything relevant in the archives so has anyone seen this behavior and/or have any idea(s)?
finding NULL records
I am trying to find records where the value of a filed is NULL. I know that there are records that have null values but the result is always an empty set. eg: select test_id from tests where test_id=NULL always returns an empty set when there are in fact records that have a null value for test_id. Is there some trick to finding null valued records in MySQL? This same sql has always worked on any other dbms I have used. thanks alan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: finding NULL records
[snip] I am trying to find records where the value of a filed is NULL. I know that there are records that have null values but the result is always an empty set. eg: select test_id from tests where test_id=NULL always returns an empty set when there are in fact records that have a null value for test_id. Is there some trick to finding null valued records in MySQL? This same sql has always worked on any other dbms I have used. [/snip] Of course this will return an empty set because you have only selected the test_id, try this; SELECT * FROM tests WHERE test_id IS NULL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: finding NULL records
On Oct 30, 2006, at 3:27 PM, Jay Blanchard wrote: [snip] I am trying to find records where the value of a filed is NULL. I know that there are records that have null values but the result is always an empty set. eg: select test_id from tests where test_id=NULL always returns an empty set when there are in fact records that have a null value for test_id. Is there some trick to finding null valued records in MySQL? This same sql has always worked on any other dbms I have used. [/snip] Of course this will return an empty set because you have only selected the test_id, try this; SELECT * FROM tests WHERE test_id IS NULL Yes, that works, but I was also trying SELECT * instead of just the key field (just a typo in the example). The problem was in the equal sign versus the 'IS' operator. Any reason why MySQL does not honor field=NULL? Seems kind of odd. alan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: finding NULL records
Alan Nilsson wrote: On Oct 30, 2006, at 3:27 PM, Jay Blanchard wrote: [snip] I am trying to find records where the value of a filed is NULL. I know that there are records that have null values but the result is always an empty set. eg: select test_id from tests where test_id=NULL always returns an empty set when there are in fact records that have a null value for test_id. Is there some trick to finding null valued records in MySQL? This same sql has always worked on any other dbms I have used. [/snip] Of course this will return an empty set because you have only selected the test_id, try this; SELECT * FROM tests WHERE test_id IS NULL Yes, that works, but I was also trying SELECT * instead of just the key field (just a typo in the example). The problem was in the equal sign versus the 'IS' operator. Any reason why MySQL does not honor field=NULL? Seems kind of odd. Sql standard says you use IS NULL. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: finding NULL records
[snip] Alan Nilsson wrote: On Oct 30, 2006, at 3:27 PM, Jay Blanchard wrote: [snip] I am trying to find records where the value of a filed is NULL. I know that there are records that have null values but the result is always an empty set. eg: select test_id from tests where test_id=NULL always returns an empty set when there are in fact records that have a null value for test_id. Is there some trick to finding null valued records in MySQL? This same sql has always worked on any other dbms I have used. [/snip] Of course this will return an empty set because you have only selected the test_id, try this; SELECT * FROM tests WHERE test_id IS NULL Yes, that works, but I was also trying SELECT * instead of just the key field (just a typo in the example). The problem was in the equal sign versus the 'IS' operator. Any reason why MySQL does not honor field=NULL? Seems kind of odd. Sql standard says you use IS NULL. [/snip] And the reason for that is because nothing is actually equal to NULL. For a field to be equal to NULL it would actually have to contain NULL, in which case it would not be actually NULL. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Finding duplicates
Suppose I have table t with fields k1, k2 and k3 that all make up the primary key. Then I have fields x, y and z. If fields x, y and z all have the same values in more than one row, there is a good chance they are duplicate records. What is the best way to list all of the rows where this condition exists? -- Chris W KE5GIX Protect your digital freedom and privacy, eliminate DRM, learn more at http://www.defectivebydesign.org/what_is_drm; Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Finding duplicates
Chris W wrote: Suppose I have table t with fields k1, k2 and k3 that all make up the primary key. Then I have fields x, y and z. If fields x, y and z all have the same values in more than one row, there is a good chance they are duplicate records. What is the best way to list all of the rows where this condition exists? Something like: select k1, k2, k3 from table group by k1, k2, k3 having count(*) 1; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Finding duplicates
Chris wrote: Chris W wrote: Suppose I have table t with fields k1, k2 and k3 that all make up the primary key. Then I have fields x, y and z. If fields x, y and z all have the same values in more than one row, there is a good chance they are duplicate records. What is the best way to list all of the rows where this condition exists? Something like: select k1, k2, k3 from table group by k1, k2, k3 having count(*) 1; I don't think I was clear, x, y, and z are not the only rows in the table and the group of k1, k2, k3 will always be unique as it is a unique primary key. -- Chris W KE5GIX Protect your digital freedom and privacy, eliminate DRM, learn more at http://www.defectivebydesign.org/what_is_drm; Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Finding duplicates
Chris W wrote: Chris wrote: Chris W wrote: Suppose I have table t with fields k1, k2 and k3 that all make up the primary key. Then I have fields x, y and z. If fields x, y and z all have the same values in more than one row, there is a good chance they are duplicate records. What is the best way to list all of the rows where this condition exists? Something like: select k1, k2, k3 from table group by k1, k2, k3 having count(*) 1; I don't think I was clear, x, y, and z are not the only rows in the table and the group of k1, k2, k3 will always be unique as it is a unique primary key. Adjust the query: select x, y, z from t group by x,y,z having count(*) 1; That will tell you which values of x,y,z you need to look at. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Hungarian collation
Hi, From: Peter Gulutzan [mailto:[EMAIL PROTECTED] MySQL is looking for an authoritative, official statement which states all the current Hungarian collation rules. According to the Reference Level Description of the hungarian language (ISBN 9634206441 or the hungarian version on line: http://bme-tk.bme.hu/other/kuszob/hangok.htm ) the rules are the following: Apparently http://bme-tk.bme.hu/other/kuszob/hangok.htm is an educational site (something to do with the council of Europe) as opposed to an official standards site, if I'm understanding correctly. Yes. There is a standard about the collation to use in libraries and bibliographies. You can find some data about it here: http://www.mszt.hu/standardsearch/detail.asp?id=007042 The definitive guide of the hungarian language is the A magyar helyesírás szabályai (ISBN 9630577356) issued by the Hungarian Academy of Sciences. An older issue (from 1985) is available for download from here (in Hungarian): http://mek.oszk.hu/01500/01547/index.phtml It describes practically the same collation rules as the Reference Level description, with an additional rule about (latin-like) letters that don't appear in the Hungarian alphabet. This is the following: These letters are sort with their unadorned version, except when all else is equal. In that case they are coming after the native variants I.e.: galamb Gärtner gáz and mosna Mošna - The basic order of the alphabet is a á b c cs d dz dzs e é f g gy h i í j k l ly m n ny o ó ö ő p q r s sz t ty u ú ü ű v w x y z zs - For the short-long vowel pairs (a á, e é, i í, o ó, ö ő, u ú, ü ű) long = short usually, but long short if all else is equal. E.g., kád kar kár kard So far, this seems to be the opinion of a majority, although not everyone describes the rule the same way. If MySQL adopts this rule, SELECT * FROM t WHERE column1 = 'kár'; will not return rows where column1 = 'kar'. But perhaps SELECT * FROM t WHERE column LIKE 'ká%' will return rows where column1 = 'kar' This sounds pretty good to me, especially that in the Hungarian language, the accent marks tend to appear disappear from words according to the suffix. - The long double consonants are sorting as if they would have been expanded. I.e., ggy as gygy, nny as nyny So 'ccs sorts with cscs' is true, i.e. ccs cds I expect that there is no rule which could apply for all LIKE searches. I think, it would be nice (again, because of certain suffix rules) if e.g., LIKE 'cs%' would also match 'ccs' - Composit words are sorted according to word parts. I.e., meggyújt meglát megy meggy I don't see a way to determine what is a composite word. So MySQL would return meglát megy meggy meggyújt I was sort of expecting this :-) ImRe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to retrieve a list of savepoint in mysql.
Hi, As of our understanding, MySQL can show whether the engines support Transactions and Savepoints. It does not list out the count or savepoints that were not deleted. But the solution for your query can be extracted from shell show engine innodb status\G or shellshow innodb status\G and also shell show warnings\G [lists all the warnings, notes, messages of the session] Thanks ViSolve DB Team. - Original Message - From: vijay bahirji [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, October 30, 2006 6:30 PM Subject: how to retrieve a list of savepoint in mysql. hi all,I need some one to help me with this. I have put many savepoints during the transaction in mysql andI want to have the list of all the savepoints set during the current transaction.plz help.regards,Vijay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Performance of different length/size datatypes
Hi, To BLOB or not to BLOB | Whether to store string in BLOB, or CHAR, or VARCHAR pls play the link: http://www.volny.cz/iprenosil/interbase/ip_ib_strings.htm Thanks ViSolve DB Team. - Original Message - From: Chris W. Parker [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, October 27, 2006 10:35 PM Subject: Performance of different length/size datatypes Hello, Originally I had this long explanation of what I'm doing and why I'm asking this question but I thought I'd just cut to the chase and ask... For a db that doesn't get a lot queries is there much of a performance difference between BLOB and VARCHAR(255)? Thanks, Chris. -- 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://lists.mysql.com/[EMAIL PROTECTED]
MSSQL NoLock vs MySQL NoLock
Hi, Just wanted to post this here to see if anyone knows the difference. In MSSQL, there is a hint which can be used to ask the DB to not lock the tables during queries and then to read un-commited/dirty data. This command is like select count(*) from MyTable nolock in MySQL, I found that I can do the same thing with the same syntax. Having read through this post in the forum, http://forums.mysql.com/read.php?60,81970,82201#msg-82201 I'm just curious to know if anyone knows that they are one and the same. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]