SQL Help

2 posts / 0 new
Log in or register to post comments
Last post
Wed, 2013-03-27 00:51
#1
wc2l
SQL Help

Good Evening,
I want to brush off the dust and look at doing some special queries from the database. I am not used to setting up phpadmin or any other console with out a WEB server. So my question is, how do set it up and how do I get it to point to the database correctly? I am a semi newbie to Linux (I did my SQL stuff on NetWare a long time ago).
TNX Will WC2L

Top
Fri, 2013-04-05 23:10
k5tri
You can just use the command

You can just use the command line and use the mysql client directly. Not sure at the moment of top of my head how to connect via SOCKET as I have my database running on my server vs. my workstation. But I use it all the time for special queries.
mysql -h HOSTNAME -u USERNAME -p
Then select the database you want to use:use CQRLOG001 (for example)
And go off and query. The log itself is in table cqrlog_common
You can just do a "show tables" to see all tables and a "describe TABLENAME" to see which columns the table has.
 
Hope this helps.
73 Mike K5TRI

Top