Ok. I’ve only used a Mac for a couple days, they were certainly long days with many steep learning experiences. Here are some of my comments: On Mac OS X, you have several options to install an application. You can use pre-packaged binaries such as Universal Binary or a platform specific installable binary for your […]Read more "First impression on package mangement on Mac OS X"
Thanks to to folks at AFP548.com for the tip on my.cnf file. It worked for me beautifully.Read more "my.cnf for MySQL"
I just started looking into MySQL to Postgres migration. One of the differences between the two is LAST_INSERT_ID() for MySQL and CURRVAL(‘serial_variable’) for Postgres. Although there were many pages with examples about these, I found this page useful at explaining how to use the function. This page appears to be a good resource that lists […]Read more "MySQL to Postgres migration links"
I just gave a quick try for both eSKUeL & dbengine on Ubuntu 6.06. eSKUeL package did not install correctly. So, this isn’t really eSKUeL’s problem. Hope this works in the newer version of Ubuntu. eskuel installs. I tweaked the configuration file (/etc/dbengine.conf) and was able to access the first page at http://localhost/cgi-bin/dbengine.cgi However, it […]Read more "eSKUeL & dbengine: Web Admin interfaces for MySQL"
After reading this manual, here are a few quick notes. mysql -h localhost -u root -p create DATABASE dbname; quit mysql –user=root -p dbname < dumpfile.sqlRead more "Simiple mysql notes"
Today, I found a need to show all rows in a table and add associated information from another table. After reading a SQL reference manual on LEFT JOIN, I gave it a try and it met my needs. Here is the general format: SELECT field1, field2 FROM table1 LEFT JOIN table2 ON condition1 WHERE condition2 […]Read more "SQL: LEFT JOIN tables"
I was given access to an existing instance of MySQL via phpMyAdmin. My task was to import a CSV file using the import feature on phpMyAdmin. First, I went to the the main phpMyAdmin page. Next, I clicked on the database instance that I am interested. Then, I click on the table that I want […]Read more "Import a CSV file to MySQL via phpMyAdmin"