We want MySQL distinct to use case sensitive grouping because by default MySQL use case insensitive.
We can use binary operator to convert the character set.
SELECT DISTINCT CAST(expr as BINARY)As an alternative we can just use BINARY.
SELECT BINARY expr
Turn off or disable word wrap on MySQL shell
We can use external pager such as less to do the job. Pager in MySQL shell actually is a pipe to another program.
mysql> pager less -SFX PAGER set to 'less -SFX'
That's it. Simple and easy. Now when you have very long output horizontally it will not wrap.
When developing an application there is case when you need to clear all the data in your database e.g: testing the seeding or such. But you want to exclude some tables let say migration table which used by the application framework to migrate the schema.
You want to clean up data on all the tables, except the migration table because you don't want to re-run the schema migration.
$ echo "SHOW TABLES;" | mysql -N DB_NAME | grep -v orb_migration | sed -e 's/^/DELETE FROM /' -e 's/$/;/' | mysql DB_NAMEIn case above the table which excluded is
orb_migration.
You want to set the default timezone for MySQL using my.cnf configuration file. But MySQL unable to start and the error log says:
Fatal error: Illegal or unknown default time zone 'NAMED_TIMEZONE'
Do not use named timezone unless you had timezone data populated on your mysql database. Instead use an offset relative to the UTC e.g: '+07:00' or '-04:00'.
This query is quite helpful when you moving from development machine to production where your table content is full of dozen 'http://localhost/' links.
UPDATE [table] SET [column] = REPLACE( [column], [old_value], [new_value] ) WHERE [column] LIKE [old_value];
PHP.net merekomendasikan penggunan apache-mpm-prefork karena ada beberapa extension PHP yang masih belum thread safe.
## dengan menginstall libapache2-mod-php5 maka otomatis paket-paket apache ikut terinstall # apt-get install libapache2-mod-php5 ## install PHP APC untuk opcode caching # apt-get install php-apc ## install ekstensi untuk mysql # apt-get install php5-mysql ## install mysql server # apt-get install mysql-server