Does anyone know the easiest way to copy a column in mysql?
I have a table (table1) which has 4 columns, I want to copy all the
contents of col1 into col2.
Col3 is the primary unique key, so the copy has to keep the data matched
with col3.
I guess one possible way is to do a select and output to
Hello,
I have a Perl CGI script which uses DBI to access MySQL.
I noticed that each query through the Perl CGI script using DBI has a
connect, query and then quit.
I was wondering if there is a way of keeping the connection persistent
to Mysql through the Perl CGI script.
In my Apache httpd.conf
Hello,
I would like to move data between tables in mysql within the same
database, I am not sure what the best way to go about it is.
I do not need to move all the data in the tables, just the output of
some select statements.
I am using Perl DBI and MySql 4.0.15-standard on RedHat 8.0.
I guess I
So if you needed to know status of a work day for an employee day (say 9/1/2003), how
did you go about looking it up in your table?
Assuming that a employee can be present (p), on vacation (v), sick day (s)?
Your table seems to store only the number of hours worked
Thank you,
Syed Ali
(609
Hello,
I am trying to store our timesheet data in the Mysql database.
I would appreciate suggestions on the database scheme to use.
One of the possible ways to do it is to have a table indexed with the employee ID and
then having as many columns as there are days in the year.
This approach woul
Hi Thomas
In VC++, go to project file, right clik there, select
setting then choose C/C++ then preprocessor. Here type
the path c:/mysql/include at include path options.
Also you have to add mysqlclient.lib for linker. To do
so you should go to Linker tab and explicitly type the
file in lib f
Hi
I'm using Borland BCC32 & ILINK32 command line tools for windows to compile
& link the C source code which contains calls for mySQL C APIs. I've
downloaded the borland libraries. The problem I'm having is unable to refer
to mysqlclient.lib file from BCC32. The problem is bit confus
Hi
I'm new mySQL user (on Windows). I tried to compile &
run the example C code "myTest.c" using lcc-win32 IDE
but it throws errors. Although I put proper header
path at setting...I think there is some problem with
linker. I also included the "libmysql.lib" file but in
vain..
Whe
Hi...
I'm new to MySQL. I can play it by ODBC connectivity using JDBC-ODBC bridge.
But I want to write code in C using MySQL native C-APIs. One reason for me
to switch to MySQL is its C-APIs. I've been using Borland Turbo C/C++ 3.0
for a long time on DOS/Windows OS. When I try to include MySQ
