Re: Help with sql mode

[Gary .]

On Thu, Apr 8, 2010 at 7:14 PM, Richard Riley wrote:
> "Gary ." writes:
>
>> Okay, so it seems to be running, and connected to my mysql server on 
>> localhost.
>>
>> Err... now what? Obviously the simplest thing I want to do is execute
>> a query and see the results, but I'm <self censored> if I can find out
>> how to do that.
>>
>
> You couldn't find that you simply type in a sql statement?

Oh, I can type 'em in all right. Just not sure what to do then...

> Example:
>
> use mydatabase;
> select name from phonerecords where name like "Ril%";

Ah. Well I didn't do a use, I just tried
SELECT VERSION(), CURRENT_DATE;
and nothing happened.

> Its just an interface to mysql command line really. Not particularly
> useful other than "its in emacs" ;)

Which is about the most useful thing there is :)