I’ve always wanted to write my own simple shell in php. Call me a glutin for punishment, but it seems like something that a lot of people could use to be able to do… If your web app had a command line interface for various things… like looking up stats, or users, or suspending […]
Category Archives: Mysql
Menjalankan XAMPP di Windows Vista
Langsung aja, aku anggap udah tahu semua apa itu XAMPP ya, kalo ada yg belum tahu, XAMPP itu bundel aplikasi yg terdiri dari Apache Web Server, MySQL, Perl beserta semua modul2nya, dibuat untuk memudahkan kita menginstall dan mengkonfigurasinya, tinggal install/extract dan semuanya langsung jalan.
XAMPP berguna untuk menguji coba WordPress blog kita di komputer lokal sebelum […]
MySQL Having Clause
Last Friday, I had to run some complicated SQL queries at work. I was dealing with 300k rows of history items that I had to select based on an aggregate function. Unfortunately, WHERE clauses cannot contain the result of an aggregate function. Having clauses are like where clauses, but they’re applied last, […]
Why MySQL
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 […]
Enabling remote connections to a MySQL server
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 […]
MySQLTuner 0.9.9 is now available
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 […]
Resolving transaction concurrency issues in a PHP+MySQL multi-user environment
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 […]
How I Seamlessly Merged Two Tasks Proâ„¢ Databases
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 […]
Infobright goes open source, raises $10m
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 […]
Introducerea datelor in Mysql cu php
Introducerea datelor in Mysql cu php, acesta este cel de-al treilea tutorial video, in care puteti invata cum se introduc informatiile in mysql folosind php
Imi cer scuze, dar sunt foarte bolnav , daca aveti intrebari, sau nu ati inteles ceva, lasa-ti un comentariu` si vom incerca sa rezolvam solutia.Fisierele create in tutorial se […]