how to update entire column with different values

[muralikrishna g]

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.. i am in need

thanks in advance

regards
muralikrishn...@gmail.com

help me regarding how to use cursor and handler

[muralikrishna g]

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

[muralikrishna g]

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
mysql> mysqldump -u root -p dbadmin murali > backupfile.sql;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that
corresponds to your MySQL server version for the right syntax to use near
'mysql
dump -u root -p dbadmin murali > backupfile.sql' at line 1

mysql> mysqldump -uroot -pdbadmin murali > backupfile.sql;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that
corresponds to your MySQL server version for the right syntax to use near
'mysql
dump -uroot -pdbadmin murali > backupfile.sql' at line 1
mysql>



On 2/2/10, Suresh Kuna  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 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
>>
>
>
>
> --
> Thanks
> Suresh Kuna
> MySQL DBA
>

hi help to take backup-mysql-windows-xp

[muralikrishna g]

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

[muralikrishna g]

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 in advance

how to switch between users

[muralikrishna g]

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

[muralikrishna g]

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 advance