Hi all,
Running MySQL 5.0.22 Community on Win 2003 Server.
Can anyone give me some guidance as to what is wrong with the following SP?
It continually errors with "1054 Unknown column 'Individual' in 'field
list'. "
The SP is completing the drop table and the create table, but it is when it
comes
eed to quote it? I think MySQL is telling you it's
>DB- trying to set
>DB- `Title` = var_a;
>DB- which is the same as
>DB- `Title` = Individual;
>DB- which is the same as setting the Title column equal to the Individual
>DB- column.
>DB- What you want instead is
>
Hi all,
I have a couple of stored procedures where SP1 is calling SP2.
SP2 has a return value which I need for SP1 to continue processing the data.
The relevant bit of SP1 looks like this:
mlCounter = 12;
call SP2(mlCounter, return_val);
Relevant bits of SP2 look like:
CREATE PROCEDURE
Hi all,
I am using MySQL 4.1.11nt
I have two MyISAM tables:
Table 1 holds usage information about users accessing various parts of the
database.
Relevant fields are "Users_Code", "Users_action" and "Affected_Member".
Table 2 holds personal information about the Member.
Relevant fields are "Membe
Hi all,
I am wondering if anyone can recommend an application that will allow me to
manage an Embedded MySQL database similar to the operation of Navicat or
EMS SQL Manager on a "normal" MySQL server instance?
Thanks in advance
Martin
--
--
[EM
On Sat, 18 Oct 2003 09:42:30 -0600 Colleen Dick said:
>CD- Have anybody ever set up MS Access as a frontend to mysql?
>CD-
>CD- the dB is an already established mysql db running on linux
>CD- I don't want to convert it, just use access to get to it.
>CD-
>CD- I have followed the recipe at
>CD- htt
