Database
phpmyadmin access problem and change server from URL
2012/09/30
I was having issues with one of the phpmyadmin setups. The first server defined in the config file was not accessible and the theme that I was using was not allowing me to change the server from the …
gqlplus – sqlplus with readline (tab completion)
2012/08/03
Tab completion is something which is missing in the sqlplus and if you have lot of tables with long names or lot of columns then it is sufficiently difficult to type them 🙂 Here is a solution for this …
tora installation on Fedora 17.
2012/06/22
Here are the previous links on Tora: Tora on F16 Tora on Fedora And if you are interested in installing from source then you can always use this link: …
Oracle Select the top 5 queries
2012/02/27
Here are one sql script that I found some time back. This will be listing the top 5 SQL queries in Oracle.
Tora installation on Fedora 16 with rpm
2012/02/09
Last article I talked about tora installation from the sources, but if that is too much for you then you can use this one liner: rpm -ivh "http://amit-agarwal.co.in/mystuff/tora-2.1.3-1.fc16.i686.rpm" …
tora on Fedora 16 for mysql and Oracle.
2012/02/06
Sometime back I had posted a article on Tora on Fedora. But that was a while back and things have progressed and we already have Fedora 16 (aka Verne). So, awhile back I installed Tora on my Fedora 16 …
mysql output to an array for easy parsing.
2011/05/11
Today I was looking for some way to put the output of the mysql output in an array in a bash script. Quick google search yeilded to results something like this: […] <td> <div …
SQLite – simple use in scripts
2010/08/21
Today we will look a the most simple use’s in the scripts and how to use them. […] echo ”insert into bills values (”$name”,$date_now, …
SQLite : Manager for this simple database
2010/08/19
We will look at sqliteman – <a class="zem_slink" title="SQLite" rel="homepage" href="http://sqlite.org/">SQLite Database manager. If you are looking for a …
SQLite – Easy to use, dependable and good to use database for small applications.
2010/08/17
For last couple of days I am looking at <a class="zem_slink" title="SQLite" rel="homepage" href="http://sqlite.org/">SQLite, a very footprint, file based …
MySQL tutorial and reference manual
2010/06/25
The refence for the mysql could be found at <a class="aligncenter" title="MySQL Help" href="http://http://dev.mysql.com/doc/refman/5.0/en/index.html" …
Using PHP to search a MySQL database and return paged results
2010/06/25
<a href="http://www.designplace.org/scripts.php?page=1amp;c_id=25">Using PHP to search a MySQL database and return paged results Link above to the article. I am using this as base to …