Hi,
I am new to MySql. Could you please let me know the different migration tools
avialable for the migration of oracle 7.3 database to mysql 4.0 classic version. Out
of those which one is the best in performance and cost wise. As per my knowledge
views, stored procedures and triggers are not supported in MySql 4.0. Is it correct?.
If so, what are all the alternatives for converting the views, stored procedures and
triggers in oracle 7.3 to MySql 4.0. I will be very happy for giving me a very good
explanation on this.
Thanks,
Narasimha
-----Original Message-----
From: Bob Afifi [mailto:[EMAIL PROTECTED]
Sent: Mon 8/16/2004 10:13 PM
To: [EMAIL PROTECTED]
Cc:
Subject: Update MySQL row using URL link?
I currently update MySQL rows using phpMyAdmin.
For example, dropping the following into the
phpMyAdmin GUI:
UPDATE mysql_db SET publish = 1 WHERE Date =
'Sunday, August 15, 2004 21:04:32'
Since I get the update info in an e-mail send
whenever the form is submitted, I'd like to turn
querys like the above encoded into a URL -
bypassing phpMyAdmin - which when clicked, will
update the row.
I found this article last night: "Make SQL
Queries over HTTP with XML with VS.NET "
(http://www.aspfree.com/c/a/ASP/Make-SQL-Queries-over-HTTP-with-XML-with-VSNET/
)
"SELECT CustomerId, CompanyName FROM Customer"
http://localhost/sql?sql=select%20CustomerId,%20CompanyName%20from%20Customers%20FOR%20XML%20AUTO
=====
The above looks very much like what I have in
mind, but for MySQL. Anybody know how to do
this?
Many thanks in advance,
-Bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Confidentiality Notice
The information contained in this electronic message and any attachments to this
message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged
information. If
you are not the intended recipient, please notify the sender at Wipro or [EMAIL
PROTECTED] immediately
and destroy all copies of this message and any attachments.
