Help with database deleting data!!!

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....

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....

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...

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.

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. 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:...

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 ...

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...

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....

LEARN ABOUT HPUX

chsh

chsh(1) 						      General Commands Manual							   chsh(1)

NAME

       chsh - change default login shell

SYNOPSIS

       login-name [shell]

       login-name [shell]

       login-name [shell]

       login-name [shell]

DESCRIPTION

       The command changes the login-shell for a user's login name in the repository (see passwd(1)).

       The  DCE  repository is only available if Integrated Login has been configured; see auth.adm(1M).  If Integrated Login has been configured,
       other considerations apply.  A user with appropriate DCE privileges is capable of modifying a user's shell;  this  is  not  dependent  upon
       superuser privileges.

       If the repository is not specified (as in [login-name]), the login shell is changed in the file only.

       Run after running to make sure the information was processed correctly.

   Notes
       The  command  is  a hard link to the command. When is executed, actually the command gets executed with appropriate arguments to change the
       user login shell in the repository specified in command line. If no repository is specified, the login shell is changed in the file.

   Arguments
	      login-name  A login name of a user.

	      shell	  The absolute path name of a shell.  If the file exists, the new login shell must be listed in that file.  Otherwise, you
			  can specify one of the standard shells listed in the getusershell(3C) manual entry.  If shell is omitted, it defaults to
			  the POSIX shell,

   Options
       The following option is recognized:

	      Specify the repository to which the operation is to be applied.
		     Supported repositories include and

   Security Restrictions
       You must have appropriate privileges to use the optional login-name argument to change another user's login shell.

NETWORKING FEATURES

   NFS
       File can be implemented as a Network Information Service (NIS) database.

EXAMPLES

       To change the login shell for user to the default:

       To change the login shell for user to the C shell:

       To change the login shell for user to the Korn shell in the DCE registry:

WARNINGS

       If two or more users try to write the file at the same time, a passwd locking mechanism was devised.  If this locking  fails  after  subse-
       quent retrying, terminates.

AUTHOR

       was developed by HP and the University of California, Berkeley.

FILES

SEE ALSO

       chfn(1), csh(1), ksh(1), passwd(1), sh(1), sh-posix(1), getusershell(3C), pam(3), passwd(4), shells(4).

																	   chsh(1)

Shell Programming and Scripting