Why I use MySQL?
1) The hosting compnay Dreamhost provides it. I can add unlimited MySQL database on it.
2) This Blog named as What A Lamp. The m of it stands for MySQL.
3) The other reasons I posted below are copied from MySQL official site. You can just treat it as an advertisement.
The MySQL® database […]
By default MySQL only permits connections from the server on which it resides. Although this makes for good security there may be times when you need to access the database from elsewhere. This might be using ODBC from your office or maybe a script running on a separate web server.
Using a SSH client like […]
Justin teased this earlier in the month, and today, Oracle Listens took over oracle.com.
I’m glad they overcame the hiccups that initially postponed its launch, and I’m nervously waiting for a flood of email to hit our support distribution list.
If you read here, you’ll remember that we’ve shifted our focus to Connect, our internal social platform […]
MySQLTuner 0.9.9 is now available for download. There’s a new wiki for the script at wiki.mysqltuner.com. The new wiki contains links to downloads, changelogs, and other details.
If you want to know when the latest releases are available, there are multiple options:
Follow RackerHacker on Twitter
Sign up for the MySQLTuner mailing list
Use the –checkversion option […]
I’ve been developing a PHP/MySQL web application that involves multiple users opening and editing records in the database. There is a very real possibility that two or more people will open the same record, make changes, and attempt to save these changes.
The most common concurrent execution problem that I expect to see is the […]
SQL is a case insensitive language. That means, you can write any SQL statement in uppercase or lowercase.
SQL> SELECT DUMMY FROM DUAL;
D
-
X
SQL> select dummy from dual;
D
-
X
Some formatters like Toad and some courseware like Skillsoft E-Learning advise to use UPPERCASE for commands and lowercase for tables and columns.
/* Formatted on 2008/09/19 10:00
(Formatter Plus v4.8.8) */
SELECT dummy
[…]
I’ve long maintained two Tasks Pro databases. This made little sense-even though one of them ostensibly had lots of people helping me out in my hobby involved, I was the main one using it. I finally got to neglecting the hobby database, to lots of bad effects. BAD effects. So I […]
one colleague just showed me how to insert duplicate rows in a table that has a primary key.
create table t(x number primary key);[F5]
Table created.
insert into t values (1);[F5]
1 row created.
insert into t values (1);[F5]
1 row created.
Hey, what happened? It took me quite a while to figure out which feature of Toad was “allowing” this.
Let’s […]
This is a quick review of free tools for web analytics / stats-analysis / weblog analysis. I’ll follow up with some more detailed posts about non-web tracking. Follow-up posts will extend this into game development, but this post is purely about web stuff.
Where to start with analysing data?
Analysis of data about what your consumers are […]
Until this week Infobright’s claim to open source fame was its partnership with MySQL that enabled its analytical data warehousing software to act as a storage engine for the open source database.
However, the company is now taking the open source route itself by releasing the code behind its Infobright data warehouse (formerly Brighthouse) as […]