[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Help with sql mode
From: |
Richard Riley |
Subject: |
Re: Help with sql mode |
Date: |
Thu, 08 Apr 2010 21:27:03 +0200 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux) |
"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