European Experts Exchange (EEE.org) :: Free Experts PHP MySql Oracle Microsoft Web SQL Delphi


Databases :: MySql :: Difference between Oracle and MySQL
By: sriniig	Date: 18/07/2003 00:00:00	Points: 250	Status: Answered Quality : Excellent
What is the Difference between Oracle and MySQL
By: ikework	Date: 18/07/2003 20:36:00		Type : Comment
lot's of, oracle has stored procedures, mysql will have it in version 5.0 of course the datatypes mysql has auto_increment columns, in oracle you have to create a sequence and an insert-trigger for that what exactly are you interested in? maik

By: ikework	Date: 18/07/2003 20:39:00		Type : Comment
varchars: ----------- mysql: varchar(1...255) oracle: varchar(1..4000) unlimited(4GB) text-fields -------------------------------- mysql: text oracle: clob <<-- handling of those is a little bit different from usual sql-inserts/updates... the scalibility of oracle is much more complex than mysql's...

By: ikework	Date: 18/07/2003 20:47:00		Type : Answer
and last but not least: mysql is open source, oracle NOT and the huge price of oracle > 10000 ? (processor-dependend ) mysql with innodb (transactions) is 400 ? for commercial use, unlimited clients

By: ikework	Date: 18/07/2003 20:57:00		Type : Comment
oops... ignore the "?" above, replace with "!" ;-))

By: ikework	Date: 18/07/2003 20:58:00		Type : Comment
and the prices are in EUR

By: ryancys	Date: 18/07/2003 21:54:00		Type : Assist
See this too: <A HREF="http://www.mysql.com/information/benchmarks.html">http://www.mysql.com/information/benchmarks.html</A>

By: VGR	Date: 18/07/2003 22:28:00		Type : Assist
ok, it's my turn now :D :D :D Oracle has a completely non-standard date format, whereas MySql supports ANSI SQL92-99 Oracle uses a proprietary function sysdate() to send current date and time Oracle know only the JOIN type "Cartesian" whereas SQL defines also INNER and CROSS, both supported by MySql (along with others, namely JOIN, STRAIGHT, OUTER, NATURAL :D ). Oracle will refuse the syntax "INNER JOIN". SQL99 defines two conversion functions, CAST and CONVERT. SQL-S defines them, but in a proprietary fashion, completely non-standard. Oracle uses proprietary functions CONVERT (totally unstandard), CHARTOROWID, HEXTORAW, TO_CHAR etc etc MySql on the other hand performs intelligent implicit type conversions so doesn't really need CAST and CONVERT :D, but offers some proprietary ones : CONV, BIN, OCT, HEX,CHAR and BINARY SQL 92 defines the date and time types YEAR, MONTH, DAY, HOUR, MINUTE, SECOND - MySql supports them all, Oracle supports none. MySql supports correctly the INTERVAL date&time operator, SQL-S does not, Oracle does not at all know it. the DATE data type in Oracle is in fact a DATETIME of ANSI SQL the TIME data type is completely unknown to Oracle SQL defines CURRENT_DATE : MySql has it, Oracle requires the use of the function DATE() SQL defines CURRENT_TIME : MySql has it, Oracle needs to use TRUNC() to extract the time part from a date SQL defines CURRENT_TIMESTAMP : MySql has it directly and indirectly via SYSDATE() and NOW(), Oracle indirectly via SYSDATE() SQL defines EXTRACT(), only MySql does support it (not DB2, nor Oracle, nor Access, nor SQL-Server) DATE arithmetic : Oracle supports no function, MySql offers DAYOFWEEK(), WEEKDAY(), DAYOFMONTH(), DAYOFYEAR(), MONTH(),DAYNAME(),MONTHNAME(),QUARTER(),WEEK(),YEAR(),YEARWEEK(),HOUR(),MINUTE(),SECOND() MySql doesn't support the SQL92 concatenation operator \|\| (it's used for boolean arrithmetic) and offers CONCAT() in stead SQL defines SUBSTRING(), MySql supports it correctly, SQL-Server supports it non-standardly (length parameter isn't facultative), Oracle defines a proprietary SUBSTR() SQL defines SOUNDEX(), only MySql and SQL-Server support it Oracle requires to add a "FROM table" clause even for SELECTing a non-table function (like current date and time, etc). "dual" has become a forced passage point. Oracle doesn't like the "AS x" aliasing scheme Oracle doesn't know RAND() Oracle doesn't support SQL's DEGREES() and RADIANS() MySql extends GROUP BY and HAVING behaviour MySql offers the very useful EXPLAIN [SELECT statement], DESCRIBE [tablename], SHOIW TABLES and SHOW DATABASES instructions, where Oracle has nothing to offer than its hundreds of "system tables" for the user to work with... regards VGR

By: maddmaster	Date: 21/07/2003 18:50:00		Type : Comment
there are too many to post all of them in here. However most notably is that mySQL was designed for web applications and Oracle is for applications that are not web based. This does not mean that you cannot use mySQL with local apps and vice versa for Oracle. With this in mind mySQL was stripped down of many function found in high end databases like stored procedure. The result is that it runs faster which is needed for web apps. IMHO Yahoo uses mySQL because of its speed you do not want Oracle to be your database system if you are going to get 1,000,000++ hits per day because of the few millisecond overhead which translate to huge amount of time if multiplied by the above number. Another significant difference is mySQL is open source so it is customizable based on your need. Oracle is not. Oracle cost a lot of money and I mean a lots of money. mySQL is free... regards, maddmaster

By: ikework	Date: 21/07/2003 19:14:00		Type : Comment
maddmaster: mysql is not free for commercial use. withou InnoDB it's about 200 EUR, with InnoDB it's 400 EUR for each server. you can connect to with as much clients you want to. there are no other dependencies like count of cpu's or something else, but it's actually not free. it's free downloadable, yes for sure, but oracle too ;-))

Do register to be able to answer

©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page! Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

Contact

page generated in 239.851000 milliseconds

Why Google AdSense ads ?

New Improved Search!