New Using Sqlyog

[API]

Just started to use SQLyop and mysql.. I seem to be missing something here..

With SQLyop I have logged into mySql

selected a db and tables.

Read in and populated tables

did simple queries ( SELECT * FROM tUser)

But when I attemp to use use a query with WHERE I get noting returned

The query is:

SELECT UserName FROM tUser WHERE (Password =”password”)

the table has an entry for Password which is 'password'. I have cut and pasted the dat from th etable to make sure it's correct but no luck.. What am I doind wrong?…

I started with the trouble when I was attempting to do a ….WHERE (UserName =”[email protected]” which gave me an error at the '@address'.. What am I missing besides being a little young at this..

Thanks

[peterlaursen]

“I get noting returned” not even an error message?

HOW do you I attempt to use the query:

SELECT UserName FROM tUser WHERE (Password =”password”)

try:

SELECT UserName FROM dbname.tUser WHERE Password = 'password';

(standard quotes in MySQL are ” ' ” – paranthesis'es are not needed – and this adds the database name

– but yours hould work as well!)

It is not a LETTERCASE mismatch?

I really cannot figure out here what 'you are missing'

… is there a RESULT tab showing up in the DATA area ?

Of course such query would work!!

Also what do you mean by “Read in and populated tables” ?

Are you sure that there any data in the table at all?

Expand the database in the Object Borwser (left) – click the table and select DATA tab in the DATA area.

[API]

Thanks for getting back to me..

Read in and populated tables meant that I used the import CSV to put data into my table..

There is no letter case mismatch..

my table looks like:

Col. Contents

UserName “[email protected]”

Password “password”

I can get a one query to work with a WHERE

Just found it… my Tables entries have double quotes around them..

Thanks

peterlaursen wrote on Jul 25 2006, 01:10 PM:

“I get noting returned” not even an error message?

HOW do you I attempt to use the query:

SELECT UserName FROM tUser WHERE (Password =”password”)

try:

SELECT UserName FROM dbname.tUser WHERE Password = 'password';

(standard quotes in MySQL are ” ' ” – paranthesis'es are not needed – and this adds the database name

– but yours hould work as well!)

It is not a LETTERCASE mismatch?

I really cannot figure out here what 'you are missing'

… is there a RESULT tab showing up in the DATA area ?

Of course such query would work!!

Also what do you mean by “Read in and populated tables” ?

Are you sure that there any data in the table at all?

Expand the database in the Object Borwser (left) – click the table and select DATA tab in the DATA area.

[peterlaursen]

.. my Tables entries have double quotes around them..

… likely that happened in CSV-import.

Data in your .csv file was quoted but you did not select (optiomally) enclosed by in the SQLyog CSV import dialogue.

A FAQ on CSV-import:

http://www.webyog.com/faq/28_73_en.html

[Author]

Posts