COMPGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### MYSQL Internal tables

• Email
• Follow

Is there a List of all "key" MYSQL tables somewhere

Detailing table attributes, columns, USER Privileges over a database
or table etc....

O know on the mainframe side of things the IBM DB2 product has a
control internal table called  SYSIBM.SYSTABLES and that lists about
ALL the internal tables that DB2 uses so you can query a specific one
say to see who has access to a specfic table etc.

I assume MYSQL must have these internal (metastore tables) uif so does
anyone have a list of what these are ?


 0
Reply martin99 11/5/2007 12:07:37 PM

See related articles to this posting

>Is there a List of all "key" MYSQL tables somewhere

Look at INFORMATION_SCHEMA.TABLES for a list of all tables.

>Detailing table attributes, columns, USER Privileges over a database
>or table etc....
>
>O know on the mainframe side of things the IBM DB2 product has a
>control internal table called  SYSIBM.SYSTABLES and that lists about
>ALL the internal tables that DB2 uses so you can query a specific one
>say to see who has access to a specfic table etc.

The MySQL privilege system is a bit complicated so a single query
for who has access to which table may be complicated (there's global
access, per-database access, and per-table access).  The relevant
real tables are in the 'mysql' database.  There are also privileges
in the INFORMATION_SCHEMA database.

>I assume MYSQL must have these internal (metastore tables) uif so does
>anyone have a list of what these are ?

 0
Reply gordonb 11/5/2007 1:09:36 PM

1 Replies
504 Views

Similar Articles

12/7/2013 3:05:59 AM
page loaded in 96136 ms. (0)

 Reply:

Similar Artilces:

Numbering of tables
Dear All, I have a Lyx file in which I have float tables. In the list of tables page, it is seen that tables are not numbered sequential, like the first table is , and then, I have 1.3, 1.4, and then 1.6 for the four tables. I am not sure how to change the sequential numbering. Also, there are some blank pages coming up between the Table of contents, list of figures, and list of tables, and in between the file. Any suggestions to get rid of this? Thanks very much, Vidhya

Three tables
their names are Jane, Alice, Tom, Peter and Greg.) I am not free to adjust the tables, so I have to work with what is there. Unfortunately, there is no common field throughout all tables. Table1 and table2 share show_id. Table2 and table3 share attendee_id. I just need to end up with an array that contains all the Jane, Alice, Tom, Peter and Greg. Any help would be appreciated. On Aug 7, 10:12 am, Jerim79 <my...@hotmail.com> wrote: > I am wondering if anyone can help me with getting either a complex SQL > query, or several simple ones that would help me accomplish the >... the tables, so I have to work with what is > there. Unfortunately, there is no common field throughout all tables. > Table1 and table2 share show_id. Table2 and table3 share attendee_id. > I just need to end up with an array that contains all the Jane, Alice, > Tom, Peter and Greg. Any help would be appreciated. You just join them together on the fields that are common: select t3.name attendeeName from table1 t1 join table2 t2 on t1.show_id = t2.show_id join table3 t3 on t2.attendee_id = t3.attendee_id where t1.name = 'Mickey Mouse Show'

Collapsible tables
I'm looking to create collapsible tables, similar to the outlines available in Microsoft Excel and Open Office spreadsheet. I'd prefer something cross platform. Is something like this available online? I've been searching for months, but haven't found anything remotely close. -- "It's easy enough to be pleasant, when life hums along like a song. But the man worth while is the man who can smile when everything goes dead wrong.". Bootstrap bill wrote: > I'm looking to create collapsible tables, similar to the outlines available > in Microsoft Excel and Open Office spreadsheet. I'd prefer something cross > platform. Is something like this available online? I've been searching for > months, but haven't found anything remotely close. Unless you really have tabular data (*several* columns), you should use unordered lists. Useful example: <http://pointedears.de/scripts/test/ObjectInspector/nightly/latest/index> PointedEars

HTML Tables
Afternoon all. Just want to know how to create html tables using a for loop. I need to display 34 html tables, so I figured a for loop will do. Please show me an example of how to do that. Also how do I display the results of an sql query onto the html tables? Thanks in advance On Aug 18, 7:16=A0pm, Amie <sthembileng...@gmail.com> wrote: > Afternoon all. > > Just want to know how to create html tables using a for loop. > I need to display 34 html tables, so I figured a for loop will do. > Please show me an example of how to do that. for i in range(33): print "<table border>" for j in range(numberofrows-1): print "<tr><td>stuff</td><td>stuff</td><td>stuff</td></tr>" print "</table>" Or something like that. You could have for loops for the individual rows, too. En Mon, 18 Aug 2008 09:05:30 -0300, Adrian Smith <adrian_p_smith@yahoo.com> escribi�: > On Aug 18, 7:16�pm, Amie <sthembileng...@gmail.com> wrote: >> Afternoon all. >> >> Just want to know how to create html tables using a for loop. >> I need

Hash tables
I dont know how can I store and recover data to/from a hash table which values are arrays. Is it OK? my %data = (); my @attributes = (); for($counter=1;$counter<@field;$counter++){$attr = <DB>; push(@attributes, $attr); }$data{$node} = @attributes;$node = <DB>; } I cant recover the values stored in the hash table Guillermo wrote: > I dont know how can I store and recover data to/from a hash table > which values are arrays. perldoc perlreftut perldoc perlref I don't understand what the code you posted is supposed to do, but I noticed that you tr

Tables in Tex
with this,and what i can do to have a >better table? well, of course, that won't compile at all, so anything that works is bound to be better... if you had bothered to read anything like the short intro to latex (any documentation of latex, in fact) you would have encountered the p column spec in tables. \begin{tabular}{p{4cm}p{4.5cm}p{4.5cm} and forget all those damn-fool \parboxes -- Robin Fairbairns, Cambridge On Dec 30, 2:18 am, r...@cl.cam.ac.uk (Robin Fairbairns) wrote: > nikhil <nikhilhitchhi...@gmail.com> writes: > >I have been working on a report in latex.I have to do... have encountered the p > column spec in tables. > > \begin{tabular}{p{4cm}p{4.5cm}p{4.5cm} > > and forget all those damn-fool \parboxes > -- > Robin Fairbairns, Cambridge Also, if necessary the "array" package (I think it is that one) introduces a new columnspecs that allow you to change the vertical alignment of the cells. I vaguely remember doing that when I couldn't remember/contemplate the equivalent TeX primitives to perform the same task. Thanks! figured it out after a while. cheers, nikhil. On Dec 30, 1:50 pm, Dreamlax <dream...@munchhut.com

Tables 29652
Hi everyone, I have a JTextPane and i am trying to insert tables into the JTextPane. I am using the default rtf editor kit together with styled document. I don't want to use the insert component to simply insert a JTable as if i do that then removing columns and rows becomes almost impossible Basically i need a way to insert tables into the styled document of the JTextPane something like Microsoft word. I hope someone can help me with this Some example codes would be helpful Thank You Yours Sincerely Richard West

locking tables
If I lock a table with write, will another connection be able to read from that table while it's locked? I hope not. "Jim Michaels" <NOSPAMFORjmichae3@yahoo.com> wrote in message news:uo6dnTOfVoLP2tHZnZ2dnUVZ_t6dnZ2d@comcast.com... > If I lock a table with write, will another connection be able to read from > that table while it's locked? I hope not. > I just tried it, I think reads are allowed. ugh. this race condition is causing grief. Am I technically wrong? I couldn't find anything specific about this situation in the manual (unfortunatel

trees or tables
I am having a difficult time with the concept of trees. I'm still not quite grasping the coding from kandr2. Too keep track of volume and price of a specific security, or atleast its volume I have created this struct and this seems to be as far as I can get with this. struct node { int count; /*iteration of nodes*/ int volume; char name[5]; double price; struct node *right; struct node *left; }; Now for the basis of the tree. I somewhere must allocate memory whether it be from the heap(malloc) or the stack it must be done somewhere. Then I must have a fun

Tables #4
I have put together a large LaTeX file using Memoir Class as I learned LaTeX. I have hundreds of tables, all of which begin with \begin{center} \begin{tabular}....................... They look fine, but a co-worker says I should be using \begin{table} \centering \begin{tabular}......... Am I missing something by not using the \begin{table} command? Note that I am not using captions on any of the tables. Thanks. Hi, a tabular is not a float (if i am not mistaken). This is the main difference (apart from the fact that there is no \caption possible) The good point of floats is that LaTeX will place it for you within the document, so that your document looks pretty (and so that you don't have to bother with it). --of course, the "drawback" is that you cannot really place it where you want if you have lots of floats-- Cheers, azra Le 12/12/2011 17:03, Paladin a �crit : > I have put together a large LaTeX file using Memoir Class as I learned > LaTeX. I have hundreds of tables, all of > which begin with > \begin{center} > \begin{tabular}....................... > > They look fine, but a co-worker says I should be using > > \begin