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, 2003 12:04 AM Subject: MySQL <-- SQL --> Oracle > 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 > > 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 Structural > Query Language, which should be the same. But, now I know I'm wrong. > > Also, when I insert data to a table in MySQL, the values can be enclosed by > single quotes, like 'alan', In Oracle, NO WAY, you have to use double > quotes, like "alan". > > Any suggestions or advice? > > It seems I really should get a MySQL book. Which one is the best? > > > cheers, > > feng > > > > -- > 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]
