RE: stupid question

2002-06-11 Thread Kenneth Hylton
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

Re: Stupid Question ?

2001-03-28 Thread Gerald Clark
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: >

Re: STUPID QUESTION

2001-03-26 Thread Rolf Hopkins
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

RE: STUPID QUESTION

2001-03-26 Thread Chris Becker
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

RE: STUPID QUESTION

2001-03-26 Thread Cal Evans
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

RE: STUPID QUESTION

2001-03-26 Thread Chris Becker
-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