Manick Solutions

Zen Cart, MySQL, phpMyAdmin, Apache

I’m currently working on some E-commerce stuff. I’ve been learning quite a bit about Zen Cart, MySQL, phpMyAdmin, Apache.

Spent a couple of hours today upgrading from MySQL 5.0 to MySQL 5.1

It went ok.

While trying to find some quick and easy ways to import data into Zen Cart I’ve ended up looking into phpMyAdmin.

Also MySQL 5.1 seems to support CSV as a storage engine. See this post: http://dev.mysql.com/tech-resources/articles/csv-storage-engine.html

All good stuff – I’m probably going to need to refer back to that sometime hence the post – time to sleep now.

Access criteria expressions

http://office.microsoft.com/en-us/access-help/examples-of-query-criteria-HA010066611.aspx

Very useful list of query criteria expressions for retrieving records by date:

e.g. last week, last month, last 28 days