Basic MySQL Terminal Commands

To start MySQL monitor;

mysql -u root -p

Other commands;

show databases;
use enter_database_name_here;
show tables;
describe enter_table_name_here;

Show data from a particular column in a table;

SELECT enter_column_name_here FROM enter_table_name_here;

Update the data in a particular column in a table;

UPDATE enter_table_name_here SET enter_column_name_here = ‘enter_new_value_here’ WHERE id =’enter_id_here’;

Internet Explorer on Mac

If you’re designing a website you really have to design for Internet Explorer, as a lot of people still use it. The main versions would be IE6 and IE7, with IE8 not too far away.

My method now is to design first for Firefox and Safari. If things look good on these browsers, they are likely to be good on Opera as well. Then, i make tweaks to fit IE7, i’ve not yet started developing for IE8 as it is still in beta. IE7 has its quirks, but it is not too difficult to get things looking similar or exactly the same as it would on Firefox and Safari. IE6 is another story all together. It is painful trying to get CSS to look the way you want on this browser. IE6 has a number of bugs and ‘bug fixes’ or hacks that are well documented on the web.

But having said that, if you want to adjust your website design to fit Internet Explorer whilst on a Mac, without having to move over to a Windows PC – there are a few options that could make things easier.

Option 1:

Use Parallels.

http://www.parallels.com

Parallels basically lets you install a version of Windows on your Mac. You can then install and use any Windows software on your Mac. Windows XP is probably a better bet than Windows Vista. The reason being that there are some known issues getting IE6 to work on Vista. If you install XP, you will get IE6 as standard, but you can upgrade to IE7. You can then install the Multiple_IE software which will give you IE versions 3 to 6:

http://tredosoft.com/Multiple_IE

You could probably also use Firefox and get a multiple IE plugin (these plugins need Windows, and won’t work on Mac Firefox):

https://addons.mozilla.org/en-US/firefox/addon/1419

Parallels costs about US$79.99.

Option 2:

UseVMware Fusion.

http://www.vmware.com/products/fusion/

This lets you run a ‘Virtual PC’ on your Mac, i don’t know much about this, but cost is also about US$79.99

Option 3:

Use ie4osx.

http://www.kronenberg.org/ies4osx/

This lets you use IE5 to 7. It does not require Parallels or VMware Fusion. It is FREE. And it is dead simple to install. Unforunately it is supposed to be a bit buggy with IE7, but hopefully that will change soon. This is the option i chose as IE6 is what i need to test the most, and is the hardest to code right.

Hope this helps someone.