General :: Scripting: Modifying SQL Fields Dynamically?
Feb 22, 2010
I'm looking for a way to dynamically modify a fied in the SQL file.
Example,
INSERT INTO `TABLE` VALUES(1AADFDF,DFF33D,10023,SOMEDATA, SOMEDATA);
INSERT INTO `TABLE` VALUES(1AADFDF,DFF33D,10098,SOMEDATA, SOMEDATA);
[code]....
The third field in this SQL file is what needs to change to n+1
"10023" needs to change to "1"
"10098" needs to change to "2"
"10123" needs to change to "3"
"10983" needs to change to "4"
etc...
I tried with awk and sed, but since both require the usage of ' (single quote), my variable fails to get updated. I know i can use cut and recreate the sql statememnt, but i believe there should be easier way using sed or awk. Would anyone know of any creative way to get this to work in one-liner? This needs to be a part of the script preferable without making call to external file.
I know this is somewhat lame, but I remember back in college the MOTD on some of the systems was a random quote. I always wanted to do that. It seemed really trivial, but still neat and clever.
I searched a bit and don't see anything built-in for CentOS, so I was considering writing a Perl script to parse the RSS feed from a quotes site, then update /etc/motd with a random quote from the feed. This would nearly guarantee I could have this on any distro with identical results. Does anyone know of anything that already exists? Is anyone interested in using a script that I write to have the MOTD updated with random quotes themselves, or am I the only one? I'm perfectly willing to share the result when I'm finished.
Basically I am trying to add a new driver[megasr] into the ISO image, hence performed the following :
1. Mounted the RHEl5.4 ISO image
2. Copied the initrd.img to a temporary directory, performed changes to add the new driver in the modules.cgs, updated the corresponding files and recreated the modules.cgz file module-info modules.alias modules.cgz modules.dep pci.ids
3. Copied back the newly created initrd.img file into the isolinux folder.
I tried to burn the ISO and install it, but it seems that the new driver does not get loaded. I am unaware of any other changes?
I'm trying to use awk to remove rows that are duplicates based on 3 fields, and I want to keep the on that has the higher value in another field. I'm working in C-Shell. For example the below is greped out of a larger data set to use in here as example:
I'm writing a script that picks out the time offset in a string, but am trying to figure out a way to print a field based on a match (likely needs to be regex).
Here are some sample fields: 09.900. Either add -12:-1: 0 to existing offset, or restart the slicer with no offset or with offset=00 09.900. Either add -12:-1:30 to existing offset, or restart the slicer with no offset or with offset=00 09.900. Either add -10: 0:-47 to existing offset, or restart the slicer with no offset or with offset=00
What I need would be "-12:-1: 0" from the first line, for example. I was just using "awk '{print $4}'" originally but because of the damn space in the 1st and 3rd lines by the 0, that doesn't work for me. How to grab those fields correctly for all cases?
For example: file a:Tom:blackLily:pinkfile b:Tom:bigKate:smallAnd, the result:join -t: a1 a ot:Tom:black:bigLily:pinkBut what I want is:Tom:black:bigLily::pink
I have a couple of MP3s that have duplicate fields in their ID3 tags. Let me show you what I mean: This is causing problems with some media players. Is there a tool that can automatically fix these MP3s in batch? I'd prefer a free Windows or Linux program. I'm not afraid to work on the command line if necessary.
I am trying to remove the space between the 2nd and 3rd fields but just cannot work out how to do it. I've considered sed, cut, awk...I know with sed you can replace all instances within a file but can you also specify to remove, say, the 2nd instance of a space in each line (this would be perfect for me)?
If I do setenv DISPLAY other_machine:0 and launch a gui application I can send this application to my other_machine Is there any mean (utility or whatever) to send an OPEN application to another machine (by its pid eventually) So if I have an nedit open, and its pid is 13245, I could do something like send_to_display pid=13245 machine=other_machine:0
Libraries have always been ambiguous to me. I would love to have a clear understanding of them. Here's what I know so far... Ok I know that libraries are a bunch of functions and definitions in C that binaries use. I also understand that static libraries are used by the binaries in /sbin:/usr/sbin:/usr/local/sbin and dynamically linked libraries are used by the binaries in /bin:/usr/bin:/usr/local/bin So why have statically linked and dynamically linked libraries? I know that dynamically linked libraries are used to save space. Otherwise each binary would need its own private copy of a library. So dynamically libraries are used to save space.
1. Where are the static libraries and the dynamically linked libraries located in the file structure?
2. Where does ldconfig fit into all of this?
3. Would a rootkit affect both statically and dynamically linked libraries? I would think yes unless the libraries only have read permissions.
4. If the above is true, is there any reason for your libraries to have write permission other than when you want to edit them?
I don't know almost anything about it so I was thinking of asking this question from the experts.I recently downloaded the xPUD 0.9.2.I LOVE that OS!It's simple,fast and smart.I just would like to add some other programs to it somehow.Is that possible for ex. extracting the image,modifying files,then remaking the iso?(Talking in Windows7)I would like to add some programs like Wine and some games also.Please reply as soon as possible because the xpud site is down for bandwidth exceeded.
Is it possible to change the GNOME desktop background during some period of time by just a random phrase from the list on black screen? Will is seriously load the CPU and consume battery life?
I have a few FTP users on my linux server(running vsftpd). They all have their own directory and can upload and delete files in that folder.Now, I was wondering whether it would be possible to create special permissions/rights for users. For example, I would like to make it so that certain users could not upload .exe files, or I want a certain user to only be able to upload image files (gif, jpg).
I want to pick up Python3 from squeeze, meanwhile I would like to stay with lenny with all other packages. Is this possible by just modifying source.list file?
I have an archive directory that needs to be cleaned up once per quarter. The top level (/data/archive/*) directory names change daily, as well as the subdirectories and the filenames (the application names everything according to date). Also, there are two top level directories, bin and incoming, that we can't touch. I want to write a shell script that loops through the 15 or 20 top level directories and deletes all files and subdirectories older than 3 days (skipping the bin and incoming folders). Can someone get me started on a script? I am kinda new to shell scripting.
I have to loop through this file and copy the files with the first field to a new name that contains both the first and second field. To be more specific, file quote2224.pdf has to be copied to 23943843_quote2224.pdf file quote5494.pdf has to be copied to 39843843_quote5494.pdf I don't know how or if it's even possible to use a for loop and access both fields. I don't know how to copy files in awk.
Does anyone know of any man pages that would provide me information on commands in shell scripting like while or case? I have a test tomorrow where we have to write shell scripts and we're allowed to use the man pages, but not allowed to look at previous scripts. I don't feel like memorizing a bunch of commands if I don't have to.
There is a scripting language made for Windows called AutoIt. It can do things like, for example, if a user highlights a word and presses a certain hotkey, it can copy that word into memory, open up firefox, go to google.com, paste the word into the text box, and click the button to search. What are some of the easiest scripting languages in Linux to learn that can do this?
I've been playing around with awesome wm, uzbl and doing quite a bit of reading and thinking. Do more programs need scripting support? I've found that being able to tell a program what I want it to do specificially has made life much easier. I'm finding some things (my prefered editors, ed and vim) are starting to seem a little limited since what they can do is fairly well defined and hard to change.
I am a bit confused with the first line while writing a shell script , if someone can please explain me the meaning of the first line " #!/bin/bash "the confusion for me is the # at the beginning , in shell scripting # means a comment. but in this case it loads the shell which the script must use,instead of commenting the line how is this possible. where is this defined , any particular file.
