http://qs1969.pair.com?node_id=78579


in reply to Re: Re: Maximum DBI query length?
in thread Maximum DBI query length?

The bug is not in DBD::mysql, but in your SQL: there's no FROM.

Replies are listed 'Best First'.
Re: Re: Re: Re: Maximum DBI query length?
by Merlin83 (Novice) on May 07, 2001 at 21:49 UTC
    Oops, I thought the 'table.column' notation obviated the need for that. What should I be putting for the SQL query then?
[reply]
      nope, you need to list out each of the tables.. 
      SELECT contact.field1, contact.field2, business.field1, acn.field1 
FROM contact, business, acn
WHERE ... (Etc.)

      [download]
      or you can assign aliases 
      SELECT c.field1, c.field2, b.field1, a.field1 
FROM contact c, business b, acn a
WHERE ... (Etc.)

      [download]

      OK?

[reply]
[d/l]
[select]
        Fantastic, thanks. I've had to take out the AS thing, since I don't know where in the statement it goes, but I'm back to a working script that doesn't produce any results.

        Thanks again.

[reply]
      SELECT [columns] FROM [tables] WHERE [condition].

      [download]
[reply]
[d/l]

In Section Seekers of Perl Wisdom