User % instead of * -----Original Message----- From: John ccccc [mailto:[EMAIL PROTECTED] Sent: Monday, August 22, 2005 9:48 AM To: mysql@lists.mysql.com Subject: FW: RE: MSSQL to MySQL mapping
Also mysql complaints when I use the *= syntax: select a.userID from USers a, UserGroups b where a.UserGroupID*=b.UserGroupID; Any ideas? What is the equivalent syntax for MySQL. Thank you John C> >From: "John ccccc" <[EMAIL PROTECTED]> >To: mysql@lists.mysql.com >Subject: FW: RE: MSSQL to MySQL mapping >Date: Mon, 22 Aug 2005 13:18:43 +0000 > > >I am trying to adjust sql_mode but with no success. I use MySQL Query >Browser from a remote mashine, login as root and I run set global >sql_mode='ansi'; > >Then I run MySQLCommand line client from the MySQL server and the >sql_mode is unchanged. > >I also tried to set the sql_mode in the My.ini file but it does not >seem to have any effect. We have a web application that connects to >MySQL. The applicatio written to communicate to SQL Server and the >MySQL default mode cannot interpret the sql queries. > >How do I set the sql_mode, with what tool, how do I ensure what sql >mode is currently set? > >Thank you for your help >John C > > >>From: "Arjan Hulshoff" <[EMAIL PROTECTED]> >>To: "John ccccc" <[EMAIL PROTECTED]> >>CC: <mysql@lists.mysql.com> >>Subject: RE: MSSQL to MySQL mapping >>Date: Thu, 11 Aug 2005 09:20:08 +0200 >> >> >>Have you adjusted your queries? MSSQL uses a different dialect >>(T-SQL), then MySQL uses. There are quite some difference, although >>some queries still might work. >> >>Arjan. >> >> >>-----Original Message----- >>From: John ccccc [mailto:[EMAIL PROTECTED] >>Sent: Wednesday, August 10, 2005 08:12 PM >>To: mysql@lists.mysql.com >>Subject: MSSQL to MySQL mapping >> >>We have a web based application running on IIS 5.0 using MS SQL Server >>2000 as the DBMS; we use ODBC to connect to the DB. We migrated our DB >>to MySQL and used the MySQL ODBC driver. It appears that some of the >>SQL statements that are accepted by SQL Server 2000 are not accepted >>by MySQL. Is there a mapping from MSSQL to MySQL statements? >> >>Thank you >>John C. >> >>_________________________________________________________________ >>Express yourself instantly with MSN Messenger! Download today - it's >>FREE! >>http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ >> >> >>-- >>MySQL General Mailing List >>For list archives: http://lists.mysql.com/mysql To unsubscribe: >>http://lists.mysql.com/[EMAIL PROTECTED] >> >> >> >>-- >>The information contained in this communication and any attachments is >>confidential and may be privileged, and is for the sole use of the >>intended recipient(s). Any unauthorized review, use, disclosure or >>distribution is prohibited. If you are not the intended recipient, >>please notify the sender immediately by replying to this message and >>destroy all copies of this message and any attachments. ASML is >>neither liable for the proper and complete transmission of the >>information contained in this communication, nor for any delay in its receipt. >> >>-- >>MySQL General Mailing List >>For list archives: http://lists.mysql.com/mysql >>To unsubscribe: >>http://lists.mysql.com/[EMAIL PROTECTED] >> > >_________________________________________________________________ >Don't just search. Find. Check out the new MSN Search! >http://search.msn.click-url.com/go/onm00200636ave/direct/01/ > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- 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]
