Re: Help with sql mode

[Richard Riley <rileyrgdev@gmail.com>]

"Gary ." <help-gnu-emacs@garydjones.name> writes:

> 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.
>

You don't need "use" for that. It should work.

>> 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 :)
>

http://dev.mysql.com/doc/refman/5.1/en/creating-database.html