Results 1 to 3 of 3

Thread: MySQL UPDATE Query

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

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

    UPDATE table_name SET field1=new-value1, field2=new-value2
    [WHERE Clause]

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


    UPDATE Student
    SET Student _name='XYX'
    WHERE Student_id=3

Similar Threads

  1. MySQL query in a query
    By Rail racer in forum Software Development
    Replies: 3
    Last Post: 21-07-2009, 07:06 PM
  2. Turn on MySQL query cache to speed up query performance
    By DMA2Superman in forum Software Development
    Replies: 3
    Last Post: 07-07-2009, 10:26 AM
  3. Use variables in a MySQL query
    By Chrisch in forum Software Development
    Replies: 3
    Last Post: 25-04-2009, 12:11 PM
  4. MySQL IF ELSE in Query
    By Ryder in forum Software Development
    Replies: 3
    Last Post: 27-03-2009, 05:24 PM
  5. MySQL Query Analyzer
    By Jesse Bas in forum Software Development
    Replies: 1
    Last Post: 25-11-2008, 07:21 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,650,008.87775 seconds with 17 queries