Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 10-02-2009
Member
 
Join Date: Feb 2009
Posts: 2
MySQL UPDATE Query

I want information about update Query in My SQL As i want to change name of Student from Student table. I tried to run queries but it didn't work can some one help me ?

Thanks
Reply With Quote
  #2  
Old 10-02-2009
Member
 
Join Date: Oct 2008
Posts: 54
Re: Information about MySQL UPDATE Query

You modify table by using SQL UPDATE command. This will modify any field value of any MySQL table. Here is generic SQL syntax of UPDATE command to modify data into MySQL table:

Quote:
UPDATE table_name SET field1=new-value1, field2=new-value2
[WHERE Clause]
Reply With Quote
  #3  
Old 10-02-2009
Member
 
Join Date: Oct 2008
Posts: 20
Re: Information about MySQL UPDATE Query

Updating Data from Command Prompt:

This will use SQL UPDATE command with WHERE clause to update selected data into MySQL table.


Quote:
UPDATE Student
SET Student _name='XYX'
WHERE Student_id=3
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "MySQL UPDATE Query"
Thread Thread Starter Forum Replies Last Post
MySQL query in a query Rail racer Software Development 3 21-07-2009 07:06 PM
Turn on MySQL query cache to speed up query performance DMA2Superman Software Development 3 07-07-2009 10:26 AM
Use variables in a MySQL query Chrisch Software Development 3 25-04-2009 12:11 PM
MySQL IF ELSE in Query Ryder Software Development 3 27-03-2009 05:24 PM
MySQL Query Analyzer Jesse Bas Software Development 1 25-11-2008 07:21 PM


All times are GMT +5.5. The time now is 04:49 PM.