Skip to main content
Solved

how do you see the table columns in mysql?


Forum|alt.badge.img+5
  • Contributor
  • 45 replies

A user on this site named donmontalvo turned me onto this way to access the MySQL DB.

$ mysql -u jamfsoftware -p
Enter password: Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 11478
Server version: 5.0.92-log Source distribution

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema | | jamfsoftware | | test | +--------------------+
3 rows in set (0.00 sec)

mysql> use jamfsoftware;
Database changed
mysql> show tables;

My next question is how do I view the columns in a table?

Best answer by donmontalvo

http://bit.ly/TbHyD0

:-)

View original
Did this topic help you find an answer to your question?

4 replies

donmontalvo
Forum|alt.badge.img+36
  • Legendary Contributor
  • 4293 replies
  • Answer
  • October 5, 2012

Forum|alt.badge.img+12
  • Valued Contributor
  • 139 replies
  • October 6, 2012

Doing a table dump in terminal can be daunting. Especially if you are keeping track of Unix binaries or usage logs. I keep a copy of phpMyAdmin on my dev box for looking through the tables via a web browser. You can execute queries or mysql operations via the GUI and have the mysql terminal syntax displayed for the command you just ran. This makes getting the proper mySQL syntax for complex terminal commands much easier.

http://www.phpmyadmin.net/home_page/index.php


Forum|alt.badge.img+5
  • Contributor
  • 96 replies
  • October 8, 2012

I use the Sequel Pro app to look at the Database

Check it out here

http://www.sequelpro.com


Forum|alt.badge.img+24
  • Valued Contributor
  • 1892 replies
  • October 8, 2012

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings