Group join one to many relationship

E-mail

Blog - SQL

Wednesday, 10 March 2010 Last Updated ( Wednesday, 10 March 2010 00:00 )

I have never tried to join data from a one to many relationship in one sql query, but today I needed to.

Apparently there was a really easy way to do this, which I found here. Post nr #:1286020 by Coopster;

Read more: Group join one to many relationship

 

Note to self: Import MySQL dumpfile

E-mail

Blog - SQL

Wednesday, 10 March 2010 Last Updated ( Wednesday, 10 March 2010 00:00 )

I wonder how many times I have searched google on how to correctly import a MySQL dumpfile through a command line.

mysql -p -h DBSERVER dbname < dbname.sql

 

Store and index IP Address in MySQL table - Faster!

E-mail

Blog - SQL

Wednesday, 10 March 2010 Last Updated ( Wednesday, 10 March 2010 00:00 )

Normally one would store an IP Address in something like a VARCHAR(15). But when you have a table with a large amount of data and you need to index this field there are a better and faster option!

Read more: Store and index IP Address in MySQL table - Faster!

 

Like this Joomla template?

As many other things on this site it is completely free! In collaboration with Midsjö AB are we releasing it into the public domain under the GNU/GPL version 2 license. You will find this template and other extensions under the Labs section then Joomla!. Good luck and happy Joomling!