Category: MySQL
Oct
29
On Oracle web site "Oracle and Sun" page has changed:There is also a PDF file for downloading... About MySQL it mainly says:What are Oracle’s plans for MySQL?Oracle plans to spend more money developing MySQL than Sun does now. Oracle expects… more »
Sep
14
If you don't want to make holes in your firewall because it would looks like "swiss cheese"... more »
Sep
07
For a long time the ft_stopword_file variable was a poorly documented feature.According to Wikipedia:stop words is the name given to words which are filtered out prior to, or after, processing of natural language data (text). more »
Aug
19
Following my old post from 2008 I give you once again the query to verify the amount of uniqueness of a column:
SET @firstXchars = 2;
SELECT COUNT(*) AS `total values / NULL`,
COUNT(DISTINCT column_name) AS `distinct values / distinct lef… more »
Jun
10
for DB in `grep "Current Database:" all-databases.sql | replace "-- Current Database: " "" | tr -d "\\\`" `; do sed -n "/-- Current Database: \`$DB\`/,/-- Current Database:/p" all-databases.sql > ${DB}.sql; done
Complicated... yes.. you're right. Let'… more »
Recent comments