Wow.  That’s about all I can say initially.  I am sure I don’t have to explain anything about Sun or MySQL to most of my visitors, and anyone that knows me already knows that I am a hardcore user and supporter of both.  I don’t know though, if this announcement is good news or not.  I think only time will tell on that one.  Really, it all will come down to what Sun decides to do with MySQL.  They have an opportunity to help MySQL grow and become even bigger … but then again, they can drop the ball and make it flounder as well.  I seem to remember a note a while back about Sun buying PostgreSQL too, I’ll have to look back and see if that ever came about, and if so, what ended up happening with it.  For now we’ll all wait and see!  Read more here …

A while back I posted an article on creating MySQL databases from the command line (see here). I am a command line junkie, and usually prefer it to a GUI. I thought I would add to that last database post by sharing how I work with MySQL, designing databases and their structure in the initial phases of application development. Keep in mind, what I am going to go over in this post is strictly for quick and easy database structure design, possibly with test data, from the command line. This is not for mangling your database after you have real data in it, or else you will mangle your data! Read the rest of this entry »

Here is a quick tip for all of my command line brothers and sisters out there. If you need to create a new MySQL database, it’s super quick and easy to do it on the command line with the mysqladmin command. Yeah, there are some GUI’s out there, but just because you have a GUI doesn’t mean it’s easier or faster. Besides, if you know how to do it via the command line, you will have a better understanding of what that GUI tool is doing, especially when it messes up.

Back to the tip, if you want to create a database named ‘mydatabase’ you would type something like this:

mysqladmin create mydatabase

See? It’s just that easy! From here, it’s easy create tables too. You can type this right into the mysql prompt, or import from a text file. I’ll have more on that coming up soon. Stay tuned!