Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2014
    Posts
    1

    Post Unanswered: Question Queries

    Hey guys!!

    I need some help

    I have a project of mine in java that needs mySQL integration.
    I haven't worked with mysql before, so I need some simple queries

    1. Return a list of tables
    2. Add a table with x number of columns
    3. Add x value to x column in x table
    3. Remove x value from x column in x table
    4. Edit x value from x column in x table

    Thanks for reading my my topic!

    Regards,

    Joey

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    to find a list of tabels query the system tables
    https://dev.mysql.com/doc/refman/5.0...on-schema.html

    to add a table
    run a query that CREATEs a table

    to add x value to x column in x table
    run a query that UPDATEs that column in that table

    to Remove x value from x column in x table
    run another (different) update query

    to Edit x value from x column in x table
    run another (different) update query
    ,but first you'd need to find the valeu (use a SELECT query)
    display the vlaue in your JAVA app
    then run an updfate query once the user has modified the value
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •