Results 1 to 6 of 6

Thread: MYSQL

  1. #1
    Join Date
    Feb 2008
    Posts
    291
    Tokens
    0

    Default MYSQL

    Is there a way to make a certain mysql table browsable?

  2. #2
    Join Date
    Jan 2006
    Location
    Kent
    Posts
    987
    Tokens
    0

    Default

    You mean so that the little red cross doesnt appear when you hover over browse?
    Insert some data.
    This is our situation and we're happy to be here,
    I wouldn't change this place for anything.


  3. #3
    Join Date
    Feb 2008
    Posts
    291
    Tokens
    0

    Default

    --
    -- Table structure for table `land`
    --

    DROP TABLE IF EXISTS `land`;
    CREATE TABLE `land` (
    `id` int(32) NOT NULL default '0',
    `owner` varchar(100) collate latin1_general_ci NOT NULL default '0',
    `location` enum('England','Spain','Italy','France','Sweden',' Portugal') collate latin1_general_ci NOT NULL default 'England',
    `garage` varchar(100) collate latin1_general_ci NOT NULL default '0',
    `house` varchar(100) collate latin1_general_ci NOT NULL default '0',
    `security` enum('None','Fence','Guard','Mines','Army') collate latin1_general_ci NOT NULL default 'None',
    `amount` varchar(100) collate latin1_general_ci NOT NULL default '5',
    PRIMARY KEY (`id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

    --
    -- Dumping data for table `land`
    --

    LOCK TABLES `land` WRITE;
    /*!40000 ALTER TABLE `land` DISABLE KEYS */;
    /*!40000 ALTER TABLE `land` ENABLE KEYS */;
    UNLOCK TABLES;

    That have database info in.

  4. #4
    Join Date
    Jun 2004
    Location
    Reading, Berkshire
    Posts
    2,260
    Tokens
    12,202
    Habbo
    :Jin:

    Latest Awards:

    Default

    Theres no data in that table, so you dont have anything to browse.


  5. #5
    Join Date
    Feb 2008
    Posts
    291
    Tokens
    0

    Default

    So how would I put data in?

  6. #6

    Default

    There's an "insert" tab. Or you can execute a SQL query.

Posting Permissions

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