For When You Can't Have The Real Thing
[ start | index | login ]
start > MySQL > Database Information

Database Information

Created by dave. Last edited by dave, 4 years and 21 days ago. Viewed 1,645 times. #1
[edit] [rdf]
labels
attachments
(2019-02-28)

List tables in a database

SHOW TABLES

List columns in a table

SHOW COLUMNS FROM mytable FROM mydb;
SHOW COLUMNS FROM mydb.mytable;
no comments | post comment
see also:
snipsnap-index Avoiding Hazardou... Database Informa... Windows
arp dave Avoiding+Hazardou... RTC Power ...
start RTC+Power+... LAG and... Send Feedback To Dave
ASDM on ... Time In Seconds Graph Titles Inc... Trouble Beeping
Ra... mysql Cookie+M... reading bios inf...

Virtual Dave Megaplex:

(read this note about local search)

Logged in Users: (0)
… and 6 Guests.

Recently Changed

Editing: snipsnap-help, Image Macro

(Et auditum est, et idcirco ego nunc simulare)

This is a collection of techical information, much of it learned the hard way. Consider it a lab book or a /info directory. I doubt much of it will be of use to anyone else.

Useful:

snipsnap.org | Copyright 2000-2002 Matthias L. Jugel and Stephan J. Schmidt