if i were to declare a 'SET @foobar = 1;" in my mysql command line and
then access the variable @foobar in my application, in this case, using
php, why doesn't the variable recognized.
i then did a 'SET @foobar = 1;' in php but when i do a "SELECT @foobar"

Is possible to have both MySQL and MSSQL installed  on one computer?
Regards,
Lad.

I'm helping someone who has a simple simulation model in Excel.  He
wants to expand the model's complexity by adding a lot more data, and I
told him he needed to move to a real database.
He's probably going to keep the basic model calculation in Excel.  

Lotus Approach 9.6
I have just put together a mailing list, using 10 fields.
Some address fields are blank in records with short addresses.  When
printing labels, the blank lines are spreading the address down the

I have set up a php page to display search results from a database I
converted from Act! 2005 to mysql.  I now need some kind of a macro to
automate the task of exporting an Act! 2005 database into a text
delimited file with tabs as the delimiters and then import that into a

Does anyone knows when should a procedure be used rather than code the
statement into the application itself?
Like for instance an application needs to know whether a user exists so
the code will be SELECT * FROM table WHERE user.id = id;  And if i were

my apologies for asking this qn in here as my post at the mysql didn't
get a reply.
in oracle there is a '%TYPE' to reference the data type of another
column.  is there an equivalent in mysql? thank you.

All my accounts were on a partition of my Hard Drive which I've overwritten
with something else, completely. Is it still worth while sending it to a
data collection agency in the hope that they might have the technology to
recover it. I've heard that there are techniques that can ...

i have a question about answering ..... this topic is "need help"
what do i have to write at te topic line, !after i have klicked the
"answer message" button
ive tried many possibilities, all dont work

Is it possible to make a database reusable for various applications that
will be design in the future?
e.g.
- Project A and Project B and Project C require a 'member' table.

can anybody assist me with the following procedure?
it can compile and works when i do any of the following:
CALL ACTIVATE_ACCOUNT('')
CALL ACTIVATE_ACCOUNT('123')

OK, I just can't seem to get this. It should be super easy for most of
you to answer.
I have 2 tables that are similar in design. 1st is called
"Applications". The 2nd is called "ExtraApplications". They both

hi to everybody,
is it possible to constrain the values that can be inserted in a field
(i.e. field > 10)?

I am trying to setup a domain that has a vpn server to allow remote
access to 5-10 users. I have noticed that most database software
doesn't really sit well when being accessed over a vpn or other
remote utilities.

Qn 1:
I have a user_account table consisting of an auto id, email address and
password fields.
The id is made the primary key.  Is that a good idea or should i just