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@lists.macromates.com http://lists.macromates.com/listinfo/textmate


View this message in context: Re: SQL in textmate
Sent from the textmate users mailing list archive at Nabble.com.