Srijith Unplugged » Search Results » mysql-rownum

Important MySQL DBA Interview Questions

Srijith R — Tue, 28 Jun 2011 06:58:55 +0000

Here are a few sets of interview questions expected for MySQL DBA position.These are compilation of the usual questions from various DBA texts: What is Log Switch? - The point at which ORACLE ends writing to one online redo log file and begins writin ...

Installing Django on Dreamhost

Srijith R — Thu, 09 Jun 2011 08:27:36 +0000

Installing Django in Dreamhost and getting it to run wasn't straight forward at-least to me. There was lot of issues such as python bin directory not accessible as its shared and so. So the initial step in this to setup python yourself so that you can ...

Get the nth Word from a text field in mysql

Srijith R — Fri, 15 Oct 2010 09:28:01 +0000

I had a requirement to get the nth word out of a string and sort or order by the same. This is used when the text is stored in a purticular format and you would want to order it according to that or group it or so on. So how is it done? We do it us ...

Display row number in Mysql Select Query

Srijith R — Tue, 17 Aug 2010 22:54:07 +0000

How many times did want to have the row number or the position of the row in the selected query? I had many cases where I needed this feature. I needed the feature for printing the rank of a person where each row is the mark of the person. So lets see how ...

Customizing Mysql Prompt For multiple Servers

Srijith R — Sun, 08 Aug 2010 02:11:33 +0000

If you are using mysql regularly on multiple servers its really useful to have the promt in mysql to show something more than mysql>. It would be useful if it showed the username,hostname, current database and things like that. So how to do this. ...

Generate Date from a range in Mysql and pad the results where no date is present

Srijith R — Sun, 25 Jul 2010 10:35:03 +0000

If you want to generate dates, MYSQL doesn't have a range function, so I wrote a work around for the same. So how it works is I have reused a code to generate numbers from my previous post. So I added date function to that query and reduce the generated ...

Generate 1 to 1000 in mysql

Srijith R — Sun, 25 Jul 2010 09:24:11 +0000

Sometimes its necessary to have thousand rows to join or generate new values, we need to get the thousand rows first. For this I used union of numbers 0-9. I have joined four of these to get to four digit values. So here is the code: [sql]SELECT @ro ...

Check the port in which the Mysql is running on

Srijith R — Fri, 18 Jun 2010 12:21:43 +0000

Mysql can be configured to run other ports other than the default port (of 3306). So what will you do when you need to find the port on which a mysql server runs on. If you don't have access to the server files and can access the server only using the mysq ...

Group by Date when Stored in Mysql DataBase as Date Time

Srijith R — Mon, 10 May 2010 16:44:52 +0000

I have a table called date_count with 2 columns one is a value and another is a date time, say called date_time in mysql. Date Time in mysql is stored as dd-mm-yy hh:mm:ss. The issue comes when I need to get the number of rows per day. As its stored as dat ...

Check if a table exists in MySQL from PHP

Srijith R — Fri, 23 Apr 2010 10:55:55 +0000

Sometimes its necessary to execute a query or execute some code if a table exists or not. So a bit of searching got me to the conclusion that mysql doesn't have a direct query or method for it from php. So there are two methods to do it. Use the mys ...