You need to have quotes around test in the insert statement. So it would
be as follows:
sprintf (query, "INSERT INTO tablename (userid) VALUES(\"%s\")", test");
res=mysql_query(connection, query);
Oviously query needs declaration here, but the SQL has to be quoted
exactly the same as if you were
upport option to get assistance with installing
from source.
Now, in the intrest of the list, I think this flame war should be nipped
in the bud, and I will end it with this email.
Sean Conley
On Wed, 28 Feb 2001, John Jensen wrote:
> BUG: Telling me I "shouldn't have done" s
It sounds like the problem is that you originally installed from RPM and
later installed from source, or vice versa. RPMs often use a different
file layout than source distributions, this is one reason why I always
install software that I consider system critical from source, so that
there are no
You are just missing a step. The execute method does exactly what it says,
executes the prepared SQL statement. Once this is done, you must fetch data
from the handle with one of the fetch methods such as fetchrow_array or
fetchall_arrayref. Another alternative is to combine the prepare, execut
Just take the .rpm off the end, and any additional platform information
like i386, etc. It would just be, for example, rpm -e MySQL-3.23.32-1
Sean
On Fri, 2 Feb 2001, Abby Jiang wrote:
> Hi,
>
> I installed MySQL on Red Hat 6.2. Now I am having
> trouble with uninstalling it. If I do rpm -era
265218 to db: '' user: ''
host: `localhost' (Got timeout reading communication packets)
010109 14:37:27 /usr/local/libexec/mysqld: Shutdown Complete
010109 14:37:27 mysqld ended\n
Sean Conley
-
Bef
