[TxMt] Re: SQL in textmate

[richdang]

I tested on terminal and it works correctly. But on textmate, there is no
thing happen when I use a database.

My code:

create database demo; ( it worked)
use demo; ( when I show this message on corner right "use demo; 0 rows
affected")

then I try create a table in demo database. It shows no error but cannot
create table because no database selected.





David Parry wrote:
> 
> On 08/03/2011, at 12:24 PM, richdang wrote:
> 
>> I am pretty new in textmate and working with MySQL. Anyone know how I use
>> SQL query to use a database in MySQL via textmate. I tried USE [database
>> name], the database browser show 0 affected
> 
> Sounds like you got a connection. What happens when you do a real query?
> 
> 	show databases;
> 
> or
> 
> 	show tables;
> 
> or
> 
> 	describe your_table_name;
> 
> Do you have any tables or rows in your database?
> 
> If so, can you show us what they are?
> 
> Do you know how to do an SQL query?
> 
> 
> You might want to google for some basic MySQL tutorials.
> 
> 
> 
> _______________________________________________
> textmate mailing list
> textmate at lists.macromates.com
> http://lists.macromates.com/listinfo/textmate
> 
> 

-- 
View this message in context: http://old.nabble.com/SQL-in-textmate-tp31093481p31093607.html
Sent from the textmate users mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macromates.com/textmate/attachments/20110307/df2cb2e9/attachment.html>