.
Please tell me how can I do this if it possible.
Thank you.
Octavian
Hey,
Try:
mysql -uuser -ppassword -e SHOW TABLES FROM database; file.txt
Stijn
--
metastable
Stijn Verholen
Camille Huysmanslaan 114, bus 2
B-2020 ANTWERPEN
+32 (0)3 707 08 08
+32 (0)473 47 62 88
[EMAIL PROTECTED]
http
the
data, depends on the number of question series (or alternitavely the
number of users), not the number of answers. You can select all answers
in a single query.
You'll need a left join in that query.
hth
--
metastable
Stijn Verholen
Camille Huysmanslaan 114, bus 2
B-2020 ANTWERPEN
+32 (0
leegold wrote:
On Sat, 27 Aug 2005 19:43:57 +0100, [EMAIL PROTECTED] said:
Using mysql with php I have a database that has a unique value for the
user id. when people get delete off the list I want the unique numbers to
compact down so.
user id 1
user id 4
user id 5
user id 7
user id 9
user
Greetings, list !
ANSI SQL has the WHERE key IN (value1, value2, ...)
MySQL doesn't seem to support this.
Is this a faulty assumption, or am i stuck with WHERE key = value1 OR
key = value2 ...
TIA,
Stijn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Jay, thx for your speedy reply.
MySQL does indeed know the WHERE IN syntax (bad coding on my part).
I have another question.
There are two tables in the db from which I want to gather information.
These tables are identical, except for two fields that have different
names, the same types (but
Jigal van Hemert wrote:
Here is my solution:
(SELECT ID, referentie, postcode, gemeente,
kadastrale_opp,prijs_zichtbaar, verkoopprijs, status, adres, '' AS
hoofdtype FROM gronden WHERE status = 'te koop' ) UNION (SELECT ID,
referentie, postcode, gemeente, kadastrale_opp, prijs_zichtbaar,
Ha!
Thx Michael, your first suggestion (reversing the order of the UNION
terms) worked like a charm.
greetz,
Stijn
Michael Stassen wrote:
Stijn Verholen wrote:
Jigal van Hemert wrote:
Here is my solution:
(SELECT ID, referentie, postcode, gemeente,
kadastrale_opp,prijs_zichtbaar, verkoopprijs