Re: MySQL <-- SQL --> Oracle

2003-09-30 Thread David Griffiths
> Folks, this is funny. > > I've been using Oracle for several months, and started teaching myself MySQL > since last weekend. I'm currently using the MySQL version 3.23.49 You might want to go get the latest if you can (4.0.14). > I found something really interesting: In Oracle, I have to crea

Re: MySQL <-- SQL --> Oracle

2003-09-30 Thread Kaarel
I found something really interesting: In Oracle, I have to create the Foreign Key in order to join 2 tables. It's quite different when I deal with MySQL. I can join two tables without creating the Foreign Key. - Is this Normal? Before learning MySQL, I thought both MySQL and Orcle use Structura

Re: MySQL <-- SQL --> Oracle

2003-09-30 Thread Wang Feng
typo :( correct: in Oracle, one have to use single quotes to enclose those values which are going to be inserted. but in MySQL, doubl quotes do the job well. - Original Message - From: "Wang Feng" <[EMAIL PROTECTED]> To: "Mysql List" <[EMAIL PROTECTED]> Sent: Wednesday, October 01, 200