Sponsored Content
Top Forums Web Development Updating Records in Mysql Database Post 302567921 by radoulov on Tuesday 25th of October 2011 02:09:21 PM
Old 10-25-2011
I suppose you mean /app/cacti/scripts/ (notice the trailing slash):

Code:
update 
  data_input 
set 
  input_string = replace(
    input_string, 
      '/opt/cacti/scripts/', 
      '/app/cacti/scripts/'
    );

This User Gave Thanks to radoulov For This Post:
 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Getting database records in an array

Hi Unix Gurus, I am new to unix and perl/shell script. Can anybody guide me how i can get records from a database table in an array. My requirement is : From Unix script i have to read a column of a databse table and put those reocrds in an array. Once i have a array list i have to... (2 Replies)
Discussion started by: rawat_me01
2 Replies

2. UNIX for Dummies Questions & Answers

Updating a database

i've got a database setup that references user inputs to see if they are already inputted. What I am wanting to do is allow the user to update the database by typing "update: name" where name is someone already in the database. echo "Enter your name." read NAME location=`find . -name... (2 Replies)
Discussion started by: fufaso
2 Replies

3. Shell Programming and Scripting

Scroll records from database, one at a time

Hi, I need to come up with a site that will display all the records in the database, but one at a time. Not sure how to go about it. Please pour in your suggestions. Thanks ---------- Post updated at 04:38 AM ---------- Previous update was at 12:52 AM ---------- Can... (3 Replies)
Discussion started by: sh_kk
3 Replies

4. Red Hat

Missing dependencies updating unixODBC / MySQL Connector

I have installed mysql-connector-odbc-5.1.5-0.i386.rpm and libtools on my Fedora12 system. Updating with yum says that there is nothing to update. Updating with rpm -Uvh mysql-connector-odbc-5.1.7-0.i386.rpm fails with the same missing dependencies as for the 64-bit version. Should I force... (4 Replies)
Discussion started by: Bengbers
4 Replies

5. Homework & Coursework Questions

UNIX- Database creating/viewing/updating assignment

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: I have posted the assignment below, I am new to unix programming and am having a very hard time knowing where... (5 Replies)
Discussion started by: student1989
5 Replies

6. Shell Programming and Scripting

How to backup a particular Database in MYSQL?

Hi All, Thanks in Advance!! How to backup a particular Databases..through Bash script!! For example i have 6 databases; Anish linux Software Questions Rhce Google these are the databases i have from that i want to take "Anish" and "questions" database backup regularly.... (4 Replies)
Discussion started by: anishkumarv
4 Replies

7. Programming

mysql query multiple records for one field

Hello Group, What I have is a database with about a dozen fields and one being "City". What I would like to do is to have a custom query on a single field for multiple items (cities) but I don't know how to do this. I know this is probably kids play for most of you but I am lost. What I have... (4 Replies)
Discussion started by: vestport
4 Replies

8. Shell Programming and Scripting

Delete records in mysql database where record is less than today

Guys, I need help. I need to create a script to delete records in mysql database where record is 2 days old. Thanks. (1 Reply)
Discussion started by: jasperux
1 Replies
All times are GMT -4. The time now is 09:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy