hat's
why I need to print it into a file.
Please tell me how can I do this if it possible.
Thank you.
Octavian
Hey,
Try:
mysql -u -p -e "SHOW TABLES FROM ;" > file.txt
Stijn
--
metastable
Stijn Verholen
Camille Huysmanslaan 114, bus 2
B-2020 ANTWERPEN
+3
ds you need to make to extract 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 Huysmansl
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 id
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
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,
verkooppri
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 ot
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 unsubscribe:
