473,385 Members | 1,934 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

From Oracle to MySql

Hello,

I use to work with Oracle for several years. Now, I must work with MySql.

I would like to know, if possible, how to "transfer" this command from
oracle to a new command mysql:

ORACLE:
select * from users where name like '&1' --> this line is in the script
"name_user"
I do (at the prompt) ==> @name_user SMITH

MYSQL:
select * from users where name= ?????
--> I don't know how to "transfer" the similar for '&1'

Does anybody could help me, please?

Thank you.
--
Nath (from France)
Jul 19 '05 #1
0 1633

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Mitch | last post by:
Here is the basic scenario: - Configuration data is gathered from Oracle servers then ftp'd to my apache / mysql server. - The apache / mysql server receives the datafile from the Oracle...
4
by: Mark Wilson CPU | last post by:
A colleague has written a prototype program in PHP, using a MySQL database. It's a relatively simple app, with a restricted set of mysql commands used (see below). The MySQL DB is being replaced...
133
by: jonathan | last post by:
hey all, I realize that this question might pop up from time to time, but I haven't seen it a while and things might of changed, so - Right now (July 2004) how does mysql stand up in...
2
by: James Alexander Starritt | last post by:
I also posted similarly in mailing.database.mysql I have created a rather large (60 table database) website dealio in PHP that works with MS SQL Server, Oracle, MySQL and presumably any other...
4
by: Jan Olsen | last post by:
We're planning an SQL-based solution, possibly mySQL for Windows or Linux. But some in the organization might favor Oracle. Are there any particular pitfalls of using mySQL instead of Oracle? ...
3
by: Robert | last post by:
Is there a tool/site that converts MySQL DDL scripts/statements to Oracle ? thanks
7
by: Dave Hammond | last post by:
Hi All, I'd like to have indexed search capability on column A, column B, or columns (A,B) for a given table. According to the MySQL manual, a multi-column index of (A,B) will provide "leftmost...
4
by: riskhan | last post by:
Hi friends I am developing a PHP program with support of MySQL and Oracle. I like to copy table data from MySQL to Oracle. MySQL table contains more than 250000 records. When i starts running...
3
by: Jayachandra | last post by:
Hi to all, I am a VB Programmer. I used Oracle as my backend. But now I want to migrate from Oracle to mysql. Can I ? Becoz, I heard that this is Open source. So need not to register from...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.