Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Script to update mysql
#1

Hi, i'm a portuguese Linux user.

 

I need help to create a script to update my database, this script is to be launched daily on cron.

 

The query is: (update accountinfo set Entreprise="OLICAR" where TAG="admin_reg" or TAG="agro";)

 

The table accountinfo is in database "test". I use mysql-server 5.0.32 in fedora 8.

I have already searched, but I only found script's in PHP.

 

I really appreciate your answer, thank you for your help.

 

Sorry my English.

 

Cheers.

Andr

Reply
#2

Code:
$ mysql -u Username -pPassword test -e 'update accountinfo set Entreprise="OLICAR" where TAG="admin_reg" or TAG="agro"'




Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)