Sponsored Content
Full Discussion: MYsql: How to rename
Top Forums Web Development MYsql: How to rename Post 302408459 by tannu on Monday 29th of March 2010 02:43:24 PM
Old 03-29-2010
MYsql: How to rename

Hi All

I add a new value to a table as below
Code:
Insert into hcl (category,detail,priority) VALUES ('project','test1','p1');

Now I need to rename "test1" to a new name "value1" so can some one tell me how can I rename the value.

BTW, I am using MySQL Query Browser to run queries.

Thanks
Tannu

Last edited by Yogesh Sawant; 03-29-2010 at 04:03 PM.. Reason: added code tags
 

6 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

MySQL problem >> missing mysql.sock

MySQL on my server is down.... I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock Any suggestions? Here's what I can't do: can't be root don't have physical access (do stuff via SSH) reinstall MySQL (need to keep the current MySQL... (8 Replies)
Discussion started by: _hp_
8 Replies

2. UNIX for Advanced & Expert Users

mysql would not start: missing mysql.sock

I recently installed mysql-standard-5.0.21-solaris9-sparc-64bit.pkg on a Solaris 9 machine (SunOS 5.9 Generic_118558-19 sun4u sparc SUNW,Ultra-250). The package installation went very smooth, however, starting mysql is a different story. I get the message below everytime I try to start mysql: #... (2 Replies)
Discussion started by: xnightcrawl
2 Replies

3. Red Hat

MySQL conflicts with mysql-3.23.58-16.RHEL3.1

I am tring to install mysql 5.0 on redhat linux3. In this server mysql 3 is already installed and hence while I install mysql 5 it gives the following error. How I can install mysql 5 with out affect previous installation? bash-2.05b# rpm -i MySQL-server-community-5.0.41-0.rhel3.i386.rpm... (2 Replies)
Discussion started by: johnveslin
2 Replies

4. UNIX for Dummies Questions & Answers

need help with rename

hi guys i am writing a script to change the filename which is enterered as input to lower case letter even if one letter is upper case i have to change it to lower case i get the input and use sed comand should i use like that sed/s/a-z/A-Z/d will it be like that can u please help me (8 Replies)
Discussion started by: farhan_t49
8 Replies

5. UNIX and Linux Applications

MySQL Daemon failed to start - no mysql.sock file

After doing a yum install mysql mysql-server on Fedora 14 I wasn't able to fully install the packages correctly. It installed MySQL 5.1. I was getting the following error when running the: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)... (3 Replies)
Discussion started by: jastanle84
3 Replies

6. UNIX for Dummies Questions & Answers

Using rename

I want to rename files Files show like this 1977SSD_rsdtst.pdf 1976SDP_rstdtsr.pdf 1943FDT_rstdsrt.pdf 1996DFF_stdstrd.pdf I want to introduce _ after the year, and move the characters to the end to get 1977_rsdtst_SSD.pdf 1976_rstdtsr_SDP.pdf 1943_rstdsrt_FDT.pdf... (4 Replies)
Discussion started by: kristinu
4 Replies
explain_rename_or_die(3)				     Library Functions Manual					  explain_rename_or_die(3)

NAME
explain_rename_or_die - change the name of a file and report errors SYNOPSIS
#include <libexplain/rename.h> void explain_rename_or_die(const char *oldpath, const char *newpath); DESCRIPTION
The explain_rename_or_die function is used to call the rename(2) system call. On failure an explanation will be printed to stderr, obtained from explain_rename(3), and then the process terminates by calling exit(EXIT_FAILURE). This function is intended to be used in a fashion similar to the following example: explain_rename_or_die(oldpath, newpath); oldpath The oldpath, exactly as to be passed to the rename(2) system call. newpath The newpath, exactly as to be passed to the rename(2) system call. Returns: This function only returns on success. On failure, prints an explanation and exits. SEE ALSO
rename(2) change the name or location of a file explain_rename(3) explain rename(2) errors exit(2) terminate the calling process COPYRIGHT
libexplain version 0.52 Copyright (C) 2008 Peter Miller explain_rename_or_die(3)
All times are GMT -4. The time now is 05:05 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy