Help with database deleting data!!!


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help with database deleting data!!!
# 8  
Old 05-29-2012
Here it is deleting data option

Code:
10)echo "Enter Id"
read id
sed '/$id/d' $db > dbs1
grep -v $id $db > dbs1
echo "Record deleted !"
cat dbs1;;

Sorry made some modification on the primary code and forgot to update here, thank you for helping with deleting file its works very well now Smilie and thank you for your precios help.

Last edited by Corona688; 05-29-2012 at 07:47 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Programming

Need help on Insert data to mySQL database

Hi guys, I would like to seek help on inserting data whenever the switch is on or off to my sensor mySQL database in phpMyAdmin from my control.php. I'm using Raspberry PI as my hardware and follow a few tutorials to create my own Web Control Interface, it works perfectly without insert method.... (1 Reply)
Discussion started by: aoiregion
1 Replies

2. Shell Programming and Scripting

Deleting data

Need Assistance in a script to delete date for Below example There are four period(.) line . I wanted to delete 2 period(.) from below . 5 .TODAY...MOSTLY SUNNY. HIGHS 58 TO 63. LIGHT WINDS IN THE MORNING 6 BECOMING NORTH 10 TO 15 MPH IN THE AFTERNOON. 7 .TONIGHT...MOSTLY CLEAR.... (5 Replies)
Discussion started by: ajayram_arya
5 Replies

3. UNIX for Dummies Questions & Answers

Deleting the unwanted data based on condition

hi i have my input data like this aaa bbb ccc asa dff nmj mnj saa dff oik aax cdx saa oik asq sdf dssi want my output file to be like this mnj saa dff oik aax cdx saa oiki want to retain only those lines which will have oik just below them and i want oik to be as next column to those... (1 Reply)
Discussion started by: anurupa777
1 Replies

4. Shell Programming and Scripting

Mask the Oracle Database Data

Hi, We have to mask the data that is coming from production environment to Non-production environment. The database is running in oracle platform. If anybody has generic scripts to achive this task,it would be great if that can be shared with me? Thank you, Jayaprakash. (10 Replies)
Discussion started by: bandaru_0810
10 Replies

5. Shell Programming and Scripting

Script problem with deleting data

The 10.Delete data doesnt work at all, plesase anyone could help on that. When I choose options 10 to delete a record it only copy the selected data on the other file dbs1 but doesnt delete it from the database where other records are. #! /bin/bash i="y" echo "Enter name of database " read db... (6 Replies)
Discussion started by: Lina_14
6 Replies

6. Shell Programming and Scripting

Deleting shorter lines from data file

Hello, I have the following data file structure: 1234 text 2345 text 3456 text text text 4567 text text text 5678 text text text 6789 text text text I simply want to delete all of the lines that only have one text column (i.e. the first two lines in this case). The output would be:... (1 Reply)
Discussion started by: palex
1 Replies

7. Shell Programming and Scripting

extracting data and store in database

Hello all, I have this text file data. The data are separated by comma in three column and space or line feed to start a new row anderson helberg, Jane, brother Sister ,mother,grandpa bombay,new york, china I would like store them in the following format. field1 ... (2 Replies)
Discussion started by: mam
2 Replies

8. UNIX for Dummies Questions & Answers

Howto capture data from rs232port andpull data into oracle database-9i automatically

Hi, i willbe very much grateful to u if u help me out.. if i simply connect pbx machine to printer by serial port RS232 then we find this view: But i want to capture this data into database automatically when the pbx is running.The table in database will contain similar to this view inthe... (1 Reply)
Discussion started by: boss
1 Replies

9. Shell Programming and Scripting

Moving data from one database to other

Dear All, I have 2 databases, There is a lot of data in both the databases, i would like to move some data from one database to the other. I would like to accept 2 parameters from the user, i.e. emplyee id & dept, on entering the 2 i will unload all the data from the tables to the flat files.... (6 Replies)
Discussion started by: lloydnwo
6 Replies
Login or Register to Ask a Question
NEWGRP(1)						    BSD General Commands Manual 						 NEWGRP(1)

NAME
newgrp -- change to a new primary group SYNOPSIS
newgrp [-l] [group] DESCRIPTION
The newgrp command changes a user to a new primary group (real and effective group ID) by starting a new shell. The user remains logged in and the current directory and file creation mask remain unchanged. The user is always given a new shell even if the primary group change fails. The newgrp command accepts the following options: -l The environment is changed to what would be expected if the user actually logged in again. This simulates a full login. The group is a group name or non-negative numeric group ID from the group database. The real and effective group IDs are set to group or the group ID associated with the group name. If group is not specified, newgrp restores the user's real and effective group IDs to the user's primary group specified in the password database. The user's supplementary group IDs are restored to the set specified for the user in the group database. If the user is not a member of the specified group, and the group requires a password, the user will be prompted for the group password. FILES
/etc/group The group database /etc/master.passwd The user database /etc/passwd A Version 7 format password file EXIT STATUS
If a new shell is started the exit status is the exit status of the shell. Otherwise the exit status will be >0. SEE ALSO
csh(1), groups(1), login(1), sh(1), su(1), umask(2), group(5), passwd(5), environ(7) STANDARDS
The newgrp command conforms to IEEE Std 1003.1-2001 (``POSIX.1''). HISTORY
A newgrp command appeared in Version 6 AT&T UNIX. A newgrp command appeared in NetBSD 5.0. BUGS
There is no convenient way to enter a password into /etc/group. The use of group passwords is strongly discouraged since they are inherently insecure. It is not possible to stop users from obtaining the encrypted password from the group database. BSD
June 6, 2007 BSD