Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

Geek Culture / mysql 5.0

Author
Message
Phaelax
DBPro Master
21
Years of Service
User Offline
Joined: 16th Apr 2003
Location: Metropia
Posted: 31st Mar 2005 04:34
Link
Will finally support triggers and views. I don't believe it's been released yet, unless I just can't find it, but here's an overview you can look at.
http://dev.mysql.com/doc/mysql/en/mysql-5-0-nutshell.html

Back to top
Profile PM Email Website
Richard Davey
Retired Moderator
22
Years of Service
User Offline
Joined: 30th Apr 2002
Location: On the Jupiter Probe
Posted: 31st Mar 2005 04:47
Link
http://dev.mysql.com/downloads/mysql/5.0.html

Two Worlds and in Between
Hot Metal and Methedrine
Back to top
Profile PM Email Website
Raven
19
Years of Service
User Offline
Joined: 23rd Mar 2005
Location: Hertfordshire, England
Posted: 31st Mar 2005 05:40
Link
I've been using mySql 5, or atleast trying to all week.
Bloody thing crashes each time I try a database call, but will connect, create and drop things just fine. Quite frustrating.
Back to top
Profile PM Email Website
OSX Using Happy Dude
21
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 31st Mar 2005 05:50
Link
I would like to get the embedded version working

Visit http://homepages.nildram.co.uk/~nickk/
Questions are a burden to others, answers a prison for oneself.
Back to top
Profile PM Email Website
BatVink
Moderator
21
Years of Service
User Offline
Joined: 4th Apr 2003
Location: Gods own County, UK
Posted: 31st Mar 2005 06:38
Link
Does it do subselects yet?

BatVink
Back to top
Profile PM Email
David T
Retired Moderator
22
Years of Service
User Offline
Joined: 27th Aug 2002
Location: England
Posted: 31st Mar 2005 07:00
Link
I think I read somewhere that

SELECT * FROM WHERE IN (SELECT * FROM ...)

might be in v5. Not sure though.

Get 15 new commands, all the date / time commands left out of DBPro for free!
DOWNLOAD PLUGINS HERE: http://www.davidtattersall.me.uk/ and select "DarkBasic"
Back to top
Profile PM Email Website
Richard Davey
Retired Moderator
22
Years of Service
User Offline
Joined: 30th Apr 2002
Location: On the Jupiter Probe
Posted: 31st Mar 2005 07:34
Link
Subselects have been in 4.1 for ages, let alone the 5 series.

Two Worlds and in Between
Hot Metal and Methedrine
Back to top
Profile PM Email Website
adr
21
Years of Service
User Offline
Joined: 21st May 2003
Location: Job Centre
Posted: 31st Mar 2005 08:07 Edited at: 31st Mar 2005 08:14
Link
Most importantly of all, MySQL 5.0 supports node clustering, natively. What does this mean? You can have 3 DB servers all supporting instant fail over with each other. Stick an axe through one of your servers and your DB is still available. You can repair the broken node and bring it back up without any interruption of service throughout the entire affair.

Now that rocks.

Edit --- seems like that feature was introduced in 4.1.6(ish) and it's still only for tables in memory Not so kick ass,

book is death - wife is stupid
Back to top
Profile PM Website
David T
Retired Moderator
22
Years of Service
User Offline
Joined: 27th Aug 2002
Location: England
Posted: 31st Mar 2005 08:32
Link
Quote: "Subselects have been in 4.1 for ages, let alone the 5 series."


Shame my host only has 4.0.6 (or something to that effect).

Get 15 new commands, all the date / time commands left out of DBPro for free!
DOWNLOAD PLUGINS HERE: http://www.davidtattersall.me.uk/ and select "DarkBasic"
Back to top
Profile PM Email Website
Back to top

Login to post a reply

Server time is: 2024-11-27 04:38:09
Your offset time is: 2024-11-27 04:38:09