Sponsored by: MySQL AB
Messages
| Subject | Sender | Date |
|---|---|---|
| Re: [mysql-84] Database change management in MySQL Workbench - Hi Dan, On 15/05/2008, at 4:06 PM, Dan Makovec wrote: > Following on from last months' presentation of MySQL GUIs and our > little chat about how to manage schema changes... > > Here's a little article on how to manage said updates using MySQL | Arjen Lentz | May 15, 2008 |
| Database change management in MySQL Workbench - Following on from last months' presentation of MySQL GUIs and our little chat about how to manage schema changes... Here's a li | Dan Makovec | May 15, 2008 |
| Re: [mysql-84] Meeting details updated: MySQL User Group Brisbane - May Meeting - Preview not available | Shaun Moss | May 11, 2008 |
| Meeting details updated: MySQL User Group Brisbane - May Meeting - This month, Shaun Moss will talk on best coding/SQL practises, good habits like naming conventions and formatting. Important stuff and should provide a good basis for further discussion! (in Arjen's absence, Coen will pick up the key for the meeting | Arjen Lentz | May 9, 2008 |
| April GUI Tools URLs - SQL Yog - http://www.webyog.com/ Heidi SQL - http://www.heidisql.com/ MySQL Workbench - http://dev.mysql.com/workbench / DB Designer - http://fabforce.net/dbdesigner 4/ WWW Sql Designer - http://ondras.zarovi.cz/sql/ Turbo DB Admin - http://www.tur | Akash | May 2, 2008 |
| Re: [mysql-84] speaker and key-fetchers for Tue 13 May meeting - Hi Arjen, I can "loudly" say that I can't help as I will be in Sydney that night. Maybe I'll get to the June meeting... tis very crazy at the moment. regards Scott Arjen Lentz wrote: > Hi all, > > I heard some soft "I could do ..." ear | Scott McClintock | May 2, 2008 |
| speaker and key-fetchers for Tue 13 May meeting - Hi all, I heard some soft "I could do ..." earlier, but now I need to hear loud specific statements from a few volunteers! I'll be away for that meeting date (teaching Open Query course days in Melbourne), and so we'll need someone to pick up th | Arjen Lentz | May 2, 2008 |
| follow-up on April's GUI tools overview by Akash - Hi all, I don't think Akash has posted the URLs yet for the tools he reviewed? Anyway, I promised to follow up on the visual table design (and foreign key constraints overview) that we did like in the Flash/AJAX apps, and we wanted to see some | Arjen Lentz | May 2, 2008 |
| Re: [mysql-84] Question (join related) - Thank you very much everyone. On Thu, May 1, 2008 at 9:57 AM, Arjen Lentz wrote: > Hi Paul, Mark, > > > On 01/05/2008, at 9:33 AM, Paul Macdonnell wrote: > > > This is how I got it all working (after the hints and tips | Mark Unwin | May 1, 2008 |
| Re: [mysql-84] Question (join related) - Hi Paul, Mark, On 01/05/2008, at 9:33 AM, Paul Macdonnell wrote: > This is how I got it all working (after the hints and tips from Paul): > > SELECT f.id, f.first, s.sur > FROM firstname f > left outer join surname s on (s.id = f.id) > union > s | Arjen Lentz | May 1, 2008 |
| RE: [mysql-84] Question (join related) - This is how I got it all working (after the hints and tips from Paul): SELECT f.id, f.first, s.sur FROM firstname f left outer join surname s on (s.id = f.id) union select s.id, f.first, s.sur from firstname f right outer join surname s on (s.id | Paul Macdonnell | May 1, 2008 |
| Re: [mysql-84] Question (join related) - Thanks for the help guys. Maybe a temporary table, and a few steps would solve the problem... On Thu, May 1, 2008 at 9:27 AM, Paul Moen wrote: > Hi Mark, > > What you want is a FULL OUTER JOIN which MySQL does not have. > | Mark Unwin | May 1, 2008 |
| Re: [mysql-84] Question (join related) - Hi Mark, What you want is a FULL OUTER JOIN which MySQL does not have. http://www.xaprb.com/blog/2006/05/26/how-to-write-full-outer-join-in-mysql/ mysql> use test Database changed mysql> create table firstname (id tinyint, first varchar(20)); | Paul Moen | May 1, 2008 |
| Re: [mysql-84] Question (join related) - mysql> select * from firstname outer join surname using (id); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'outer join surname using (id)' at l | Mark Unwin | May 1, 2008 |
| Re: [mysql-84] Question (join related) - Preview not available | Shaun Moss | May 1, 2008 |
| Re: [mysql-84] Question (join related) - Nice try. i still need the other two rows... mysql> select * from firstname join surname using (id); +----+--------+-------+ | id | first | sur | +----+--------+-------+ | 2 | larry | smith | | 3 | curley | brown | +----+--------+-------+ | Mark Unwin | May 1, 2008 |
| Re: [mysql-84] Question (join related) - Preview not available | Shaun Moss | May 1, 2008 |
| Question (join related) - Hi Everybody - "Hi Dr Nick"..... I have a question - probably join related..... I have two tables - as below. mysql> select * from firstname; +----+--------+ | id | first | +----+--------+ | 1 | bob | | 2 | larry | | 3 | curley | +-- | Mark Unwin | May 1, 2008 |
| Re: [mysql-84] Full Text Search - That's it !!! Thank you Dan, very much. On Thu, Apr 24, 2008 at 8:39 AM, Dan Makovec wrote: > Actually it's not totally clear how to remove it. It does show you the > default words not indexed though. > > Do as follows: > | Mark Unwin | Apr 24, 2008 |
| Re: [mysql-84] Full Text Search - Actually it's not totally clear how to remove it. It does show you the default words not indexed though. Do as fol | Dan Makovec | Apr 24, 2008 |
| Re: [mysql-84] Full Text Search - Hi Mark, See the "stopwords" list at: | Dan Makovec | Apr 24, 2008 |
| Full Text Search - Dear Interweb.... Am trying to do a full text query using the match(col1, col2, col3) against('$search_term' in boolean mode) expression. All seems OK. I can search and retrieve rankings for the different columns, etc, etc. EXCEPT..... If I us | Mark Unwin | Apr 24, 2008 |
| Call for presenter/talk for May MySQL meeting - Hi all, I won't be there for the May meeting, teaching Open Query course days (MySQL of course) in Melbourne. So there's a few things that need taking care of: - speaker - topic - someone to pick up the room key from the libra | Arjen Lentz | Apr 10, 2008 |
| Meeting details changed: MySQL User Group Brisbane - April Meeting - This month's talk: Akash Mehta will do a review of desktop-based MySQL management applications. For the full meeting details, see the listing at http://mysql.meetup.com/84/cal endar/6407184/ | Arjen Lentz | Apr 7, 2008 |
| Re: [mysql-84] 3-way meetup - Would LOVE to hear a talk from him on Bzr (currently an SVN user).... On Fri, Mar 28, 2008 at 3:42 PM, Arjen Lentz < [address removed] > wrote: | Mark Unwin | Mar 28, 2008 |
| Re: [mysql-84] 3-way meetup - Hi Shaun On 26/03/2008, at 10:22 PM, Shaun Moss wrote: > This email has gone to 3 groups - the Brisbane Web Design group, the > Brisbane PHP Users group, and the Brisbane MySQL Users group. I was > wonder what people thought of a meetup with all 3 | Arjen Lentz | Mar 28, 2008 |
| Re: [mysql-84] 3-way meetup - Sounds great - I'm in. On Wed, Mar 26, 2008 at 10:32 PM, Arjen Lentz < [address removed] > wrote: | Mark Unwin | Mar 27, 2008 |
| Re: [mysql-84] 3-way meetup - Hi Shaun On 26/03/2008, at 10:22 PM, Shaun Moss wrote: > This email has gone to 3 groups - the Brisbane Web Design group, the > Brisbane PHP Users group, and the Brisbane MySQL Users group. I was > wonder what people thought of a meetup with all 3 | Arjen Lentz | Mar 26, 2008 |
| 3-way meetup - Hi all This email has gone to 3 groups - the Brisbane Web Design group, the Brisbane PHP Users group, and the Brisbane MySQL Users group. I was wonder what people thought of a meetup with all 3 groups together? (we can look at an overview of | Shaun Moss | Mar 26, 2008 |
| Brsisbane Joomla! User Group - meeting Tue 1 Apr 7pm - Hi all, Just a note that the first meeting of the Brisbane Joomla! User Group will be next week. This is an excellent opportunity for you to meet some of the Joomla! core team! Food and softdrink provided! Agenda: - Speaker Andrew Eddie, | Arjen Lentz | Mar 26, 2008 |
| Re: [mysql-84] MySQL User Group Brisbane - March Meeting: Joins revisited! - Apologies guys. I normally try not to miss the MySQL meetups, but I have to pick-up the second car (wife's car) I bought yesterday. So, no Meet-up for me tonight !!! See you all next month. Mark Unwin, Open-AudIT - What's On Your Network | Mark Unwin | Mar 11, 2008 |
| Re: [mysql-84] MySQL User Group Brisbane - March Meeting: Joins revisited! - Based on previous meetings, I'd lean toward the "or so" part of that answer :) Cu tonight! | Dan Makovec | Mar 11, 2008 |
| Re: [mysql-84] MySQL User Group Brisbane - March Meeting: Joins revisited! - new faces are always welcome :) | Shaun Moss | Mar 10, 2008 |
| Re: [mysql-84] MySQL User Group Brisbane - March Meeting: Joins revisited! - Hi Nathan, On 10/03/2008, at 2:30 PM, Nathan wrote: > mmm rather tempting to come along for the first time... i gather you > guys are always open to new faces? :) i was going to come once > before but never got around to it... also what time do | Arjen Lentz | Mar 10, 2008 |
| Re: [mysql-84] MySQL User Group Brisbane - March Meeting: Joins revisited! - Preview not available | Nathan | Mar 10, 2008 |
| MySQL User Group Brisbane - March Meeting: Joins revisited! - Hi fellow Brisbane MySQL user grouper: The March'08 MySQL talk details: Joins revisited! Refresh your memory on how the different types of joins work, how to best use them, and identify troublespots. If you never use joins, you're a spread | Arjen Lentz | Mar 10, 2008 |
| MySQL User Group Brisbane - February Meeting - I've updated this event. To RSVP, go to http://mysql.meetup.com/84/cal endar/6407137/ When: Tuesday, February 12, 2008 at 7:00 PM Where: Toowong Library meeting room Toow | Arjen Lentz | Jan 16, 2008 |
| Permanent web developer wanted - | Dan Makovec | Jan 14, 2008 |
| Event details: MySQL + Ruby groups Brisbane - Tuesday 11 December - This December meeting will be a combined gathering with the Brisbane Ruby/Rails Brigade! Note that we've moved back to a 7pm start, as people were having trouble making 6.30 through traffic. When: Tuesday, December 11, 2007 at 7:00 PM Wher | Arjen Lentz | Dec 6, 2007 |
| Just over a week until OSDC 2007 Brisbane! - OSDC registrations ( http://osdc.com.au ) are still open - did I mention we crossed the 200? For just $325 you get the 3 full days of the main conference (4 tracks for most of the time), including coffee/tea/ | Arjen Lentz | Nov 15, 2007 |
| Event details changed: MySQL User Group Brisbane - November Meeting - I've updated this event. Main talk: hierarchies (trees) using SQL (Arjen Lentz, Kim Hunter) Relational ways of dealing with trees and other hierarchical structures. Many apps need to use them for menus, product structure, social networking | Arjen Lentz | Nov 12, 2007 |
| OSDC 2007 Brisbane: not-so-earlybird rego finishing tonight! - Sure, OSDC registrations (http://osdc.com.au/registrati on/index.html) will remain open, but it'll cost you $30 extra from November 1st and you won't get a t-shirt... so get in quick for the better deal! Remember the evil geckos (http://arjen-lent | Arjen Lentz | Oct 31, 2007 |
| Re: [mysql-84] SQL Question - Preview not available | Paul Moen | Oct 30, 2007 |
| Re: [mysql-84] SQL Question - Thanks Morgan - that did the trick. On 10/30/07, Morgan Tocker < [address removed] > wrote: | Mark Unwin | Oct 30, 2007 |
| Re: [mysql-84] SQL Question - Preview not available | Morgan Tocker | Oct 30, 2007 |
| SQL Question - Hi Everbody, [/Dr Nick] I have two tables - t1 and t2. Both have two columns - an auto inc id (id) and a varchar name field (name). Now, t1 can have duplicates in the name field, t2 cannot. I want to count the occurrences of name in t1 | Mark Unwin | Oct 30, 2007 |
| OSDC 2007's Tutorial Program - Dear MySQL Brisbane user group members, Registrations are open for the Open Source Developers' Conference 2007: http://www.osdc.com.au/registr ation/index.html The early bird has been partially extended. Book before October 31st to save $30, and t | Arjen Lentz | Oct 25, 2007 |
| Re: [mysql-84] OSDC 2007 Program is available - earlybird reg until this Sunday - > > It might, or perhaps not. We're working on that. > Are you intending to wait with registering until after November 1st, > just to not get the shirt? ;-) > Of course not :) my housemate's girlfriend wanted dibbs on the tee if it had the koala. | Tony Adermann | Oct 12, 2007 |
| Re: [mysql-84] OSDC 2007 Program is available - earlybird reg until this Sunday - Hi Tony, On 12/10/2007, at 9:56 AM, Tony Adermann wrote: > I'm confused (how unusual), do the tutorials cost extra? Yes, $250 per half-day tutorial. The 3 day main conference is $275 all-in (teas, lunches, Wednesday dinner). So it's still an a | Arjen Lentz | Oct 12, 2007 |
| Re: [mysql-84] OSDC 2007 Program is available - earlybird reg until this Sunday - I'm confused (how unusual), do the tutorials cost extra? An does the tee have the cutesy koala on it? | Tony Adermann | Oct 11, 2007 |
| OSDC 2007 Program is available - earlybird reg until this Sunday - Dear MySQL Brisbane user group members, Registrations are open for the Open Source Developers' Conference 2007: http://www.osdc.com.au/registr ation/index.html Book before THIS SUNDAY - 14th October to save $50 and get a free conference t-shirt! | Arjen Lentz | Oct 11, 2007 |
| office space - Hi all, I'm looking for office space - basically one desk with a good Internet connection will do. If you are a business currently leasing office space (central or west preferably) and you have a spare desk, perhaps you'd like to chat with | Arjen Lentz | Oct 4, 2007 |
| Re: [mysql-84] Solicitor Recommendation - Dear all, We use Redchip as well. They | damian | Oct 3, 2007 |
| Re: [mysql-84] Solicitor Recommendation - Redchip Lawyers - (in the valley) Ian Tindale 3852 5055 | Jason Hawkins | Oct 3, 2007 |
| Re: [mysql-84] Solicitor Recommendation - Hi Mark, On 03/10/2007, at 12:01 PM, Mark Unwin wrote: > Can anyone recommend a solicitor who has IT / Software related > legal experience. I am in the process of drawing up an agreement > for some software I am selling (that I wrote) to a cust | Arjen Lentz | Oct 3, 2007 |
| Solicitor Recommendation - Hi Everyone, Can anyone recommend a solicitor who has IT / Software related legal experience. I am in the process of drawing up an agreement for some software I am selling (that I wrote) to a customer, and would like the agreement and softwar | Mark Unwin | Oct 3, 2007 |
| MySQL User Group Brisbane - October Meeting - When: Tuesday, October 9, 2007 at 6:30 PM Where: Toowong Library meeting room Toowong Village Shopping Centre, Sherwood Road, Toowong 6:30 pm start @ Toowong Library meeting room: - Quick intro round - Main pre | Arjen Lentz | Oct 2, 2007 |
| Re: [mysql-84] Topic/speaker & key pickup for meeting Tue 9 Oct 2007 - Yeah, I'll do both. -- flame On 10/2/07, Arjen Lentz < [address removed] > wrote: | flame | Oct 2, 2007 |
| Re: [mysql-84] Topic/speaker & key pickup for meeting Tue 9 Oct 2007 - Flame, That sounds great as I'd like to see examples of how other developers use MySQL in their projects. Particularly with the new features in MySQL 5, I know I could be getting more out of it. Cheers, Ryan | Ryno | Oct 2, 2007 |
| Re: [mysql-84] Topic/speaker & key pickup for meeting Tue 9 Oct 2007 - Hi Flame On 02/10/2007, at 6:32 AM, flame wrote: > I could talk about how we use MySQL in our telco project, if no one > else wants to volunteer. > I may also be able to get out and collect the key. Sounds like a plan - can you please confirm b | Arjen Lentz | Oct 2, 2007 |
| Re: [mysql-84] Topic/speaker & key pickup for meeting Tue 9 Oct 2007 - Hi Arjen, I could talk about how we use MySQL in our telco project, if no one else wants to volunteer. I may also be able to get out and collect the key. -- flame On 9/30/07, | flame | Oct 2, 2007 |
| RE: [mysql-84] Topic/speaker & key pickup for meeting Tue 9 Oct 2007 - I would enjoy hearing anything about database design or stored procedures. Thanks, Shaun -----Original Message----- From: [address removed] [mailto:[address removed]] On Behalf Of Arjen Lentz Sent: Sunday, 30 September 2007 10:33 PM To | Shaun Moss | Oct 1, 2007 |
| Topic/speaker & key pickup for meeting Tue 9 Oct 2007 - Hi all, There have been some topic suggestions for upcoming meetings, but I'd like to hear more. What do you want to learn at a MySQL monthly meeting - note that there's effectively about an hr available for the main topic. As I will be teachin | Arjen Lentz | Sep 30, 2007 |
| OSDC 2007 earlybird registration now open! - Registration for the Open Source Developers' Conference 2007 is now open. http://osdc.com.au/registratio n/ For non-presenters, the earlybird price is $275 (until October 14th), after that the full conference price is $325. All regular ti | Arjen Lentz | Sep 22, 2007 |
| Brisbane OSIA breakfast, Wednesday 26 September 8:30am Toowong library - Hi all, What: Open Source breakfast (and the breakfast is actually free as in beer) When: Wednesday 26 September, 8:30 am - 9:30 am. Where: Toowong Library meeting room, Toowong Village Shopping Centre. Sherwood Rd, Toowong, Brisbane Who&Why: | Arjen Lentz | Sep 22, 2007 |
| RE: [mysql-84] MySQL GUI for stored procs - I use MySQL Maestro. Once you've created a stored procedure and you want to make a modification to it, all you have to do is open it, change what you want and click compile. Very quick and easy. Coen -----Original Message----- From: mysql-84@meet | Coen Hyde | Sep 13, 2007 |
| RE: [mysql-84] MySQL GUI for stored procs - Thanks Paul - a free solution would naturally be preferable. I looked at MySQL AB's "MySQL GUI" but apparently they haveb't built support for stored procs yet. - perhaps the Query Browser is a solution. Cheers, Shaun -----Original Message---- | Shaun Moss | Sep 13, 2007 |
| RE: [mysql-84] MySQL GUI for stored procs - Hi, I'm also quite new to the group. I use the tools supplied by MySQL to do my stored proc programming. MySQL Query Browser (mostly just use this one for development) MySQL Administrator Should be somewhere in the dev.mysql.com site. I even trie | Paul Macdonnell | Sep 12, 2007 |
| MySQL GUI for stored procs - Hi guys I'm new to this group - have been developing with JavaScript/PHP/MySQL since about 2001. I've just started a new project and I'm working with MySQL 5.0 and PHP 5.2. I would like to use MySQL 5.0's stored procedures for this website, howeve | Shaun Moss | Sep 12, 2007 |
| Open Query - MySQL training days in Brisbane - Hi all, Open Query is Arjen Lentz' new venture, offering training and consulting for MySQL, as well as Open Source strategy advice. Arjen has a wealth of experience on these topics from his time as employee#25 at MySQL AB (2001-2007), delivering | Arjen Lentz | Sep 12, 2007 |
| Event details changed: MySQL User Group Brisbane - September Meeting - This month's MySQL meeting topic: Arjen will provide an overview of what's new and changed in MySQL 5.1, since it's past the beta stage now (moved from last month). Plus we can talk about which (other) features/fixes are of particular interest t | Arjen Lentz | Sep 9, 2007 |
| Special event combined MySQL/PHP/webdev: MySQL User Group Brisbane - August Meeting - Hi everybody, I've updated this event again. We're now going to have a special combined meeting of MySQL, PHP and web developers in Brisbane! Arjen will do a fun quiz for all who develop using PHP & MySQL. It's about good habits, security, and co | Arjen Lentz | Aug 17, 2007 |
| Re: [mysql-84] PHP Social Gathering - Preview not available | Arjen Lentz | Aug 16, 2007 |
| PHP Social Gathering - | user 2896855 | Aug 16, 2007 |
| Event details updated: MySQL User Group Brisbane - August Meeting - The meeting topic this month will be "MySQL 5.1 revisited", with a quick overview of the new features, and a discussion on when to upgrade (and when not), and what version to choose for development. When: Tuesday, August 21, 2007 at 6 | Arjen Lentz | Aug 15, 2007 |
| Event details changed: MySQL User Group Brisbane - July II Meeting - I've updated this event. For more details, see the full listing: http://mysql.meetup.com/84/cal endar/5968152/ When: Tuesday, July 31, 2007 at 6:30 PM Where: Toowong Library m | Arjen Lentz | Jul 6, 2007 |
| Toowong Library as meeting venue: info, dates, agenda - Hi all, I was able to book the Toowong Library meeting room for Tuesday evenings (not first Tuesday). For the rest of this year we are now booked for: - July 31st - August 21st - September 11th - October 9th - Nove | Arjen Lentz | Jul 6, 2007 |
| This Tuesday's MySQL user group meeting (July 3rd): server tuning - Hi fellow MySQL users You may have noticed I didn't change the agenda. Based on the excellent feedback from last month's "fundamentals of optimisation" which was mostly about schema and query design, I want to cover the server this mo | Arjen Lentz | Jul 2, 2007 |
| NEW: MySQL User Group Brisbane Mailing List via meetup - Announcing our new mailing list! It's a great new way to talk in between Meetups right from our email. This means we can discuss where to meet, what to talk about and who's bringing what without having to keep checking the Meetup.com website. T | Arjen Lentz | Apr 11, 2007 |