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

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: Sent: Friday, October 27, 2006

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 shell>show innodb status\G and

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

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 be

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 a

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

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 con

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

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 ret

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 whe

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 val

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

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 e

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 leas

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

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

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

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 everyo

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

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,

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

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

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

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 hung