Professional Web Applications Themes

First table name - MySQL

How can I retrieve name of the first table in database? I tried: SHOW TABLES LIKE "*" LIMIT 1 and SHOW TOP 1 TABLES LIKE "*" but it doesn't work......

  1. #1

    Default First table name

    How can I retrieve name of the first table in database?

    I tried:
    SHOW TABLES LIKE "*" LIMIT 1
    and
    SHOW TOP 1 TABLES LIKE "*"
    but it doesn't work...

    nusch88@gmail.com Guest

  2. #2

    Default Re: First table name

    com wrote: 

    Since MySQL 5:

    SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE
    TABLE_SCHEMA='your schema name' LIMIT 1;

    What do you want to do with "the first table"? What means "the first table"?

    Greetings
    Kai

    --
    This signature is left as an exercise for the reader.
    Kai Guest

  3. #3

    Default Re: First table name

    On Mon, 08 Jan 2007 19:02:35 +0100, Kai Ruhnau wrote: 
    >
    > Since MySQL 5:
    >
    > SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE
    > TABLE_SCHEMA='your schema name' LIMIT 1;
    >
    > What do you want to do with "the first table"? What means "the first table"?[/ref]

    Obviously, this will vary by what ordering is specified.

    --
    186,000 Miles per Second. It's not just a good idea. IT'S THE LAW.
    Peter Guest

  4. #4

    Default Re: First table name


    I want to list all tables names, in database through Blind SQL
    Injection.
    It's MySQL 4.x :/
    On 8 Sty, 19:02, Kai Ruhnau <dyndns.org>
    wrote: 

    >
    > SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE
    > TABLE_SCHEMA='your schema name' LIMIT 1;
    >
    > What do you want to do with "the first table"? What means "the first table"?
    >
    > Greetings
    > Kai
    >
    > --
    > This signature is left as an exercise for the reader.[/ref]

    nusch88@gmail.com Guest

  5. #5

    Default Re: First table name

    On 25 Jan, 17:42, com wrote: [/ref]
    > [/ref]



    > [/ref]

    Confused, if you want to list all the tables, why are you asking how to
    list the first one (and you still haven't defned what you mean by
    "first", the first one that was created? the lowest one in a particular
    collation order?

    Captain Guest

Similar Threads

  1. Replies: 0
    Last Post: September 16th, 04:37 PM
  2. Replies: 0
    Last Post: September 10th, 10:49 PM
  3. Replies: 0
    Last Post: September 10th, 05:33 PM
  4. Replies: 0
    Last Post: September 10th, 05:29 PM
  5. Replies: 2
    Last Post: August 12th, 07:55 AM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139