I am assuming this is not a MySQL question since MySQL interacts with SQL
commands that are all in characters.
try using strstream. You can poke just about anything into it and get a
string out.
If you must have a char*, then use the c_str() function of the string class.
The best implementatio
Martin Jeremic wrote:
>
> Can somebody tell me how to save "SHOW VARIABLES" query into file ?
>
> --
> Martin Jeremic - JSoft
>
> http://jsoft.webjump.com/
> mailto:[EMAIL PROTECTED]
>
> -
> Before posting, please check:
>
Quite simple, you can't. Please read the manuals more thoroughly. You
can't just read a general book on SQL by itself without reading the manual
for your particular flavour of SQL. Each type of database may have added
extra features or have removed some from the standard SQL.
- Original M
Note that foreign keys in SQL are not used to join tables, but are used
mostly for checking referential integrity (foreign key constraints). If you
want to get results from multiple tables from a SELECT statement, you do
this by joining tables:
SELECT * from table1,table2 where table1.id = table2
In MySQL, you can create tables that have relationships but you can't create
what a lot of people call "Foreign Key relationships". In reality you CAN
create Foreign key (FK) relationships between tables, you just can't create
constraints that enforce them automatically.
Example time:
Let's say
-Original Message-
From: GERARDO GALLARDO [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 3:57 PM
To: [EMAIL PROTECTED]
Subject: STUPID QUESTION
I'm new to MySQL and SQL in general. I have been searching and searching
but I can't find an answer to a question which I know is si