Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: Sybase to MySQL

by bichonfrise74 (Vicar)
on Oct 06, 2009 at 17:23 UTC ( [id://799541]=note: print w/replies, xml ) Need Help??


in reply to Sybase to MySQL

Try running the Sybase SQL and see what happens in MySQL. You might need a conversion table so that when you see this 'type' of Sybase SQL, then it needs to convert it to a MySQL equivalent before it is run in MySQL database.

Replies are listed 'Best First'.
Re^2: Sybase to MySQL
by Anonymous Monk on Oct 06, 2009 at 18:12 UTC
    Obvious differences: 
    Sybase:
SET rowcount 10
SELECT column FROM table

    [download]
    MySQL:
SELECT column FROM table
LIMIT 10

    [download]
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://799541]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others lurking in the Monastery: (4)
As of 2024-04-24 01:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found