help me out for this scenario

Whats the query if first loin and second login were from two different tables.

help me out for this scenario

I have a table like as follws Emp_id, first_login , second_login 1 02/10/0904/11/09 2 03/10/0904/11/09 3 04/10/0905/11/09 4 05/10/0906/11/09 5 06/10/09 2 06/10/09

dumping error

D:\>mysqldump -u root -pdbadmin murali > murali.sql 'mysqldump' is not recognized as an internal or external command, operable program or batch file.

how to get distinct values in the following scenarion

. Please help me in this.. Regards Muralikrishna

hi.. is it possible

Hi is it possible to have two instances of mysql over single windows xp. because I want to workout with those as server and client. please help me regarding this.

order by-- rollup

Hi how to use "order by" with "with rollup", if it is not possible is there any alternative, in rollup how to name the null. is there chance to do so. please help me with this..

where is the best material handler and cursor

Hi I am in need to know about handlers and cursors.. if any site giving detailed explanation and examples on these. thanks in advance

help me out for this problem...

Here I have to update year column with reference to the row id mysql> update table1 -> set year=case when id=1 then 2000 -> when id=2 then 2001 -> when id=3 then 2000 -> when id=4 then 2001 -> when id=5 then 2000 -> when id=6 then 2001 -> else 2003

how to update a entire column elements

Hi I am in need to update a entire column elements with different values. If any body know the syntax please help me.. Regarding this.. Thanks in advance By Muralikrishna

how to update entire column with different values

hi.. i am in need to update a column with different values in a single query i know how to update a value of single column and single row element, and single row multiple columns. but i dont know how to update multiple values of a single column. if any body know the syntax for it please help me..

help me regarding how to use cursor and handler

hi.. i like to know really what is a cursor and a handler and those functionality and purpose... i have tried much over net... but i didnt find proper material and examples for those.. if any body familiar with those.. please help me.. thnaks in advance by Muralikrishna

Re: hi help to take backup-mysql-windows-xp

wrote: > > Please paste the error and don't give the spave between -p and password. > > > On Tue, Feb 2, 2010 at 12:05 PM, muralikrishna g < > muralikrishn...@gmail.com> wrote: > >> hi to all.. >> i was in need to take backup of database.. >> i am

hi help to take backup-mysql-windows-xp

hi to all.. i was in need to take backup of database.. i am using sql server version:5.0.27-coomunity-nt i have tried by using mysqldump -u name -p password database_name > backup.sql; but i am getting error.. i am using windows xp system.. please help me

how to dump database or tables

i am working on my pc with mysql-5.0.27-community-nt i have created several data bases and tables in that.. to take backup, we have to use dump., i dont know the correct syntax how to use dump to take backup to a specific location., after that how to resore. please help me regarding this. thanks i

how to switch between users

i am working on my pc with mysql-5.0.27-community-nt i have created users by using create user and i given some privileges, but i dont know how to switch between users on mysql command line, please help me regarding this.. thanks in advance

triggers- how to bring updates in one table to another table

i have two tables namely.. table1 and table2, table1 and table2 have the two columns samely like id and name, by using triggers i have to bring the updates in table1 to table2, if i updated name in table1 trigger has to made the same up date for table2. please help me regarding this. thnaks in adva