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
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.
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
On 08/03/2011, at 12:47 PM, richdang wrote:
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.
Have you tried configuring a connection using the menu Bundles/SQL/Preferences ?
-
David Parry -
richdang