Results 1 to 2 of 2
  1. #1
    JavaDreams is offline Member
    Join Date
    Jan 2011
    Posts
    18
    Rep Power
    0

    Default What is url of my database? MySql WorkBench

    Hello members,
    I am very new to the database, so i opted a gui(MySql WorkBench).
    #1.I created a server instance name 'MySql@localhost'
    #2.I created a conncetion 'localhost' user 'root', host 'localhost:3306'
    #3.then in 'localhost' connection created a schema 'online_auction'
    #4.In 'online_auction' created a table 'user' with 5 colums.

    I am using connector J
    So now what will be the URL of my table 'user' which i can use in my Code.
    Last edited by JavaDreams; 03-12-2011 at 10:15 PM.

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,817
    Rep Power
    19

    Default

    If you haven't said which schema you've logged into as root then you'll need to append the schema name to the table name, I think.
    eg
    SELECT * FROM online_auction.user

    You should be able to tell connectorJ which one to log into, though, so you can skip that bit.

Similar Threads

  1. Database Help
    By simtology in forum New To Java
    Replies: 3
    Last Post: 08-18-2009, 03:03 PM
  2. Database Help
    By simtology in forum New To Java
    Replies: 1
    Last Post: 08-17-2009, 06:14 PM
  3. What database shall i use?
    By etherkye in forum JDBC
    Replies: 13
    Last Post: 06-26-2009, 06:03 PM
  4. Replies: 2
    Last Post: 02-11-2009, 04:43 AM
  5. Database in a PDA
    By percivalwcy in forum JDBC
    Replies: 2
    Last Post: 08-08-2007, 03:10 AM

Posting Permissions

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