Ben,
This really belongs on the main list, so I'm CCing that instead of
internals. How carefully have you read section 4.6 of the manual?
http://www.mysql.com/doc/L/o/Localisation.html
You shouldn't have to make a big5.conf. Big5 is supported in the
standard distribution for quite some time,
Hi
I'm designing 2 tables, where tabProds has the foreign key of tabUsers.
So when I want to join them I use..
WHERE tabProds.usr_ID = tabUsers.usr_ID
Ok
But the thing is that sometimes will not be possible to specify a user when
you insert a Product(becaouse we don't know at that time)...
And
Hi,
Can someone tell me what is the best MySQL native component set for Delphi?
It does not matter if it is commercial, but I need one urgently.
Thanks,
Daniel
-
Before posting, please check:
Hi all , i'm about to upgrade from MySql 3.23 to version 4 are there any
issues that should be addressed ie uninstall v3 prior to installing v4
or can i just install over v3.
Any suggested sites' ,FAQ regarding my question.
--
Regards
Chuck Amadi
ICT Dept Systems Programmer
Rhaglenydd
Hi again . I have a project whereby the client has a legacy M$ Access (
as far as im concerned ) and i'm to design.build and construct a MySql
v4 Back-end and more than likely pursue a front-end with MS Access due
to easability and conversant of it's user's nevertheless are there any
field
Hello Sergei,
Tuesday, July 23, 2002, 10:17:06 PM, you wrote:
SG Hi!
SG On Jul 23, Artem V. Ryabov wrote:
Hello mysql,
see this 2 queries:
why they not equal?
why first skip many records?
mysql select left(ftText,20) from Txt_index where match(ftText)
against('+(wùd200206*) +wù12p'
Hi,
As I understand it an ANSI92 join is written as;
SELECT b.columnA
FROM tableB AS b JOIN ON tableC AS c ON b.id = c.id
Whereas the 'old' style would be;
SELECT b.columnA
FROM tableB AS b, tableC AS c
WHERE b.id = c.id
Personally I find the former much easier to read though not sure about
Hi,
well, the subject says it all. I'm using version 3.23.41-log, and I got the
following error message when trying to update a row:
Got error 127 from table handler (1030)
It's a normal query which has succeeded several thousand times already.
Any ideas what might be wrong?
Thanks,
Daniel
Description:
Strange NULL in reply.
How-To-Repeat:
mysql CREATE TABLE S (ID1 int, ID2 int, ID int NOT NULL
AUTO_INCREMENT,PRIMARY KEY(ID));
Query OK, 0 rows affected (0.00 sec)
mysql insert into S values
(1,244,NULL),(2,243,NULL),(134,223,NULL),(185,186,NULL);
Query OK, 4 rows affected (0.00
Hello.
Is there a tool that i can use to convert mysql tables
(structure) to dbf tables?
Most of the tools i encounter converts dbf to mysql. I want to
do it the other way around.
tia
Get your own 800 number
Voicemail, fax, email, and a lot
Daniel,
Wednesday, July 24, 2002, 11:23:05 AM, you wrote:
DK Can someone tell me what is the best MySQL native component set for Delphi?
DK It does not matter if it is commercial, but I need one urgently.
I'm not a professional with Delphi+MySQL, but Zeos Library looks fine
for me:
Steve,
Monday, July 22, 2002, 3:39:52 AM, you wrote:
SD I am a MySQL newbie and can not seem to find the documentation that
SD explains how to allow network or remote access to a running MySQL
SD server. It does not seem to be in the my.cnf file or in the manual???
SD I am sure this is a
Yamin,
Monday, July 22, 2002, 11:15:30 AM, you wrote:
YP I had a auto increment column
YP let say the auto increment would look like this
YP 100,1001,1003,1101,1103,10005,10006
YP yes I had delete several column in tha past
YP now I would like to sort it again so it would be an order from 100
Publici-Textes,
Tuesday, July 23, 2002, 10:40:40 PM, you wrote:
PT In MSAccess, I am able to use a query as a (partial) source for another query.
PT LSelect Names, Department from qrySelectedEmployees, tblDepartment
PT where qrySelectedEmployees.EmplId = tblDepartment.EmplId
PT Is this
Daniel,
Monday, July 22, 2002, 11:47:17 AM, you wrote:
DK Nikolaos and Victoria,
DK Victoria! Just like Nikolaos, I also don't know what you mean send new
DK character sets as seen with the explanations.
DK The first thing I have to mention that I'm not sure how MySQL string
DK comparison
James,
Tuesday, July 23, 2002, 8:32:10 PM, you wrote:
JC There didn't seem to be any responses to this question last time I posted.
JC So I'll try again. Does anyone know where to locate mysqlimport logs, if
JC there are any?
No, mysqlimport doesn't write logs and you can't see warnings.
Bill,
Tuesday, July 23, 2002, 11:04:27 PM, you wrote:
BB Also, do you happen to know how old is 3.23.21-beta-log? Our MYSQL is
BB old, but I can't find out how old, is there a version history online
BB anywhere?
Check MySQL manual:
http://www.mysql.com/doc/index.html
--
For
Sergio,
Wednesday, July 24, 2002, 6:15:57 AM, you wrote:
SB Im getting in trouble trying to restore a .sql dump generated with
SB mysqldump for a database with lots of foreign keys because of the
SB order of tables in the .sql. the first table already declares a
SB FOREIGN KEY referencing a
We are discussing the 'mysql' client which is often used to write
scripts that run under the
UNIX shell.
...
If you write a script that has two semi-colons in a row, the second one
is ignored and no error message is given.
Err, not true (in amysql script anyway)
I think you are trying
hi all,
is there any command in mysql prompt for set page size and set line size
like SQL*Plus?
TIA
ivan paul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi,
Yes, I'm using it actually, but I ask te author if MySQL features will be
extended to stored procedures, when will he come out with the new version.
He told me that he finished the development of the component set and gave
it to sourcesorge.net to continue it. Anyway, the newest version
Use:
tabProds LEFT JOIN tabUsers ON tabProds.usr_ID = tabUsers.usr_ID
from the manual:
If there is no matching record for the right table in the |ON| or
|USING| part in a |LEFT JOIN|, a row with all columns set to |NULL| is
used for the right table.
Jorge Garza wrote:
Hi
I'm designing 2
Pada Wed, 24 Jul 2002 11:01:24 +0200
Daniel Brockhaus [EMAIL PROTECTED] menulis :
Hi,
well, the subject says it all. I'm using version 3.23.41-log, and I got the
following error message when trying to update a row:
Got error 127 from table handler (1030)
It's a normal query which has
By coincidence, we had this yesterday for the first time
in our experience. It is a corrupt table, and we fixed
is with isamchk. We are running an older version, you might
have to use myisamchk.
_justin
=
Daniel Brockhaus wrote:
Hi,
well, the subject says it all.
Hi,
I've encountered a similar bug on my own table.
If you want, I can upload a tar.gz of my table (5 MB), with the associated
query needed to reproduce the problem ?
Regards,
Jocelyn
- Original Message -
From: Artem V. Ryabov [EMAIL PROTECTED]
To: Sergei Golubchik [EMAIL PROTECTED]
On Tue, 2002-07-23 at 21:04, Bill Bernat wrote:
Hey, thanks *so* much for checking into this.
Your message did help. In case you're curious. First, I had the admin
create a 777 dump directory from root. Still couldn't write out. Then,
though, I just tried going to /tmp as you had done,
Hi Guys
Sorry this is quite off topic.
Any idea hows IT doing in Brazil...
-Arul
sql , query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Description:
Strange NULL in reply.
How-To-Repeat:
mysql CREATE TABLE S (ID1 int, ID2 int, ID int NOT NULL
AUTO_INCREMENT,PRIMARY KEY(ID));
Query OK, 0 rows affected (0.00 sec)
mysql insert into S values
(1,244,NULL),(2,243,NULL),(134,223,NULL),(185,186,NULL);
Query OK, 4 rows affected (0.00
Hello,
I've been using MySQL for over 2 years in my Bacula
GPL project (network backup program). To simplify
installation for users, I would like to offer them
the possibility of using the embedded MySQL server.
However, I'm having a few problems, and maybe you
can help me:
1. There seems to
[EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this message, and include the entire text of it
I just moved my servers and have new DNS names and IP addresses.
I need to update my MySQL databases because our Ecommerce sites are giving
Internal Server Errors in Apache, see this link:
http://www.toyotaworld.com/cart/toyotaecommerce.cgi?store=toyotaecommerceac
tion=filefile=home.tmpl
I
Hi all,
I have a table with a field full of urls.. what I need to do is to append
to those urls with a new url, so for example, if the field had
http://www.yahoo.com i want to make it
http://www.myserver.com/login?url=http://www.yahoo.com ..
I have tried the following which I thought should
Thanks, that was simple enough...guess I just couldnt think of that.
Thanks again!
-Nick
Gordon said:
Try round(value*4,0)/4
Worked on the samples I tried
-Original Message-
From: Nicholas Stuart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 1:47 PM
To: [EMAIL
Network access or remote access is handled by the OS such as Linux.
All you need to do is make sure you have a user setup that is allowed to
access the database from those locations. Example:
shell mysql --user=root mysql
mysql GRANT ALL PRIVILEGES ON *.* TO monty@localhost
- IDENTIFIED
Well I have FreeBSD 4.2 and MySQL 3.23.33 running on localhost.
I use PhpMyAdmin to do any modifications. I did make the nameserver changes
in:
Database ShoppingCart - table stores
Database mysql - table db
Database mysql - table host
Database mysql - table user
I reset mysql and apache and
Let us say I have two tables tab1 and tab2.
tab1:
col1
col2
tab2:
col3
col4
For my search, a user can enter space delimited words to search, e.g.,
microsoft windows xp
i have to search for EACH of these words, and join the 2 tables too, so
my sql query looks somewhat like
Sergey S. Kostyliov writes:
At first I want to thank you for a fast answer,
On Tuesday 23 July 2002 21:45, Peter Zaitsev wrote:
On Tuesday 23 July 2002 19:39, Sergey S. Kostyliov wrote:
Description:
ERROR 2013: Lost connection to MySQL server during query.
snip
Note:
Hi!
Do anybody can help me?
Every time a program has an error and did his backout, all other
programs get an Lock wait timeout if they do an update.
Allways I have to restart the database to get back the access for the
programs.
The programm with the error did his backout completely!
We use
Pete French wrote:
We are discussing the 'mysql' client which is often used to write
scripts that run under the
UNIX shell.
...
If you write a script that has two semi-colons in a row, the second one
is ignored and no error message is given.
Err, not true (in amysql script anyway)
On Wednesday 24 July 2002 17:23, Sinisa Milivojevic wrote:
Sergey S. Kostyliov writes:
At first I want to thank you for a fast answer,
On Tuesday 23 July 2002 21:45, Peter Zaitsev wrote:
On Tuesday 23 July 2002 19:39, Sergey S. Kostyliov wrote:
Description:
ERROR
In the last episode (Jul 23), Steve Dickey said:
Can anyone tell me how to get an RPM that provides the
libmysqlclient.so.10? I am trying to install the
php-mysql-4.1.2-7.i386.rpm and it says that this is a requirement. It
comes in an older version of the mysql database rpm but I have
I'm having problems installing MySQL Server 3.23.51. When trying, I'm using
all standard options during installation. Quite late in the installation --
it seems like after all files have been unpacked and copied to their proper
locations -- I get an error message titled InstallShield Engine.
Hi!
On Jul 24, Jocelyn Fournier wrote:
Hi,
I've encountered a similar bug on my own table.
If you want, I can upload a tar.gz of my table (5 MB), with the associated
query needed to reproduce the problem ?
Regards,
Jocelyn
sure, thank you.
upload it to
Check you users table under 'mysql' database. This is what controls access.
Here, check the 'hosts' column. Update the old IP/DSN to the new ones and
then do a 'flush privileges' and you should be fine.
If you don't want to update but add a new record that should be fine to.
Do a GRANT . for
I have come across a problem compiling MySQL 3.23.51 on a SuSE 8.0
computer. I have tried compiling the same source code on a SuSE 7.3
computer with no apparent problems. Note that I have not actually used
the version compiled on the 7.3 machine - I simply wanted to make sure it
would compile.
I am currently using MySQL version 3.23.39-max-nt, MS Access 2000 as my
gui, and MyODBC 2.50.39-nt
I am able to run reports, queries and use the SQL pass through in access
to retrieve data from the MySQL database through MyODBC. The
problem is that I can not create a table in MySQL from
Hi,
You must reconfigure httpd.conf , because i suppose you don't change the
path to your new location of the CGI scriptor...you not have right to
execute POST/GET method on your serverand this mean that your CGI
script can not run.
This error is specific about what i aforementioned.
My MySQL server 3.23.51 died in an hour after
I created a table containing longtext field.
I am not sure that this was the reason but
suspect so since it was running for few weeks
w/out problems.
It stopped accepting answering TCP UNIX socket
connections, although was still listening on TCP.
Hi.
On Wed 2002-07-24 at 09:46:03 +0100, [EMAIL PROTECTED] wrote:
As I understand it an ANSI92 join is written as;
SELECT b.columnA
FROM tableB AS b JOIN ON tableC AS c ON b.id = c.id
Ah. Okay. Was not aware that this was new in ANSI92.
Whereas the 'old' style would be;
SELECT
At 16:53 24.07.02 +0700, you wrote:
Pada Wed, 24 Jul 2002 11:01:24 +0200
Daniel Brockhaus [EMAIL PROTECTED] menulis :
well, the subject says it all. I'm using version 3.23.41-log, and I got
the
following error message when trying to update a row:
Got error 127 from table handler (1030)
Hi
Probably a silly question but how can I set a time field to the current
time with update in mysql?
I have 4 time fields per record. Should I have used set them up as
timestamp?
Thanx.
Dp.
~~
Dermot Paikkos * [EMAIL PROTECTED]
Network Administrator @ Science Photo Library
Phone: 0207 432
Hi!
Minjie == Minjie Qiu [EMAIL PROTECTED] writes:
Minjie Hello,
Minjie I'm working on a purge utility to purge 3 tables: call_record,
Minjie modem_call_rec and makrup. Those 3 tables are related with foreign key
Minjie recid, so I used the following sql to purge data that is older than 30
Question is, can you connect via the mysql client. This looks like an
authentication issue as opposed to something specific to PHP.
Bhavin.
- Original Message -
From: Ingrid Kast Fuller [EMAIL PROTECTED]
To: chuck amadi [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, July 24,
Description:
The problem is affected in combination with 'order by' and
'rand()'.
Please check the report under:
http://bugs.php.net/bug.php?id=13287edit=1
How-To-Repeat:
You can compare my results with the method which is reported in
php
bug report number
Hi,
I'm in the same situation (installing mysql on a raq4).
The package master site's most recent version (that I noticed) of mysql is
MySQL 3.23.37
Does anyone have suggestions for a more recent version in .pkg?
Thanks,
Brian
Hi,
You must reconfigure httpd.conf , because i suppose that you don't change
the
path to your new location of the CGI scriptor...you not have right to
execute POST/GET method on your serverand this mean that your CGI
script can not run.
This error is specific about what i aforementioned.
Hi All,
Do anyone knows when the MySQL4.0.2a for windows is available for
download? Thanks.
Regards,
Michael
-Original Message-
From: Tam, Michael [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 11:38 AM
To: 'Victoria Reznichenko'; [EMAIL PROTECTED]
Subject: RE: Problem
I was wondering if somebody could give me any suggestions on how to optimize
a query I am working on.
This is my table:
CREATE TABLE testdata (
Begin char(9) NOT NULL default '',
End char(9) NOT NULL default '',
UNIQUE KEY BeginEndIndex (Begin,End)
) TYPE=MyISAM;
It is a table of ranges.
Hi,
I uploaded the table under
ftp://support.mysql.com/pub/mysql/secret/config.tar.gz
To reproduce the bug :
SELECT pseudo FROM config WHERE MATCH (config) AGAINST ('+(tes*) +test' IN
BOOLEAN MODE);
SELECT pseudo FROM config WHERE MATCH (config) AGAINST ('+tes* +test' IN
BOOLEAN MODE);
mysql
Hi, I did some more research on my problem. (Sorry for not doing it before
I posted the other message), and I think perhaps my question could be
summarized into the following.
Can I use an index to speed up a select max() or select min()?
I read what the manual has to say about a query like
Hello,
I am running mysql in our production environment, which have a few reporting
tables with millions of rows. Certain queries cascade 2 such tables that
have millions of rows and there by, there are extremely slow, sometimes
taking over 10 minutes.
However, we are ok with that since the size
Hello,
I am working on MySQL database. I have come across a 'problem' but don't know
how to get around that. The problem is the following:
I have a table, say TABLE1, with primary key being called as table1_id.
Now there are other tables, like TABLE1A, TABLE1B, TABLE1C etc.. where I want to
It would be a lot easier for you to have just used a timestamp, it automatically
updates itself when a record is modified.
Otherwise you would just update the time field in question when you do your other
updates
SET timefield = NOW() should work
Though using a TIME datatype is not very
You gave the answer. Using left join it will work and give you NULL values
for not found records.
I had a similar problem here and left join worked ok.
Bye,
Anderson Ataides
=
Em Quarta 24 Julho 2002 03:51, you wrote:
Hi
I'm
Description:
Make reports this:
libmysql.c: In function `mysql_real_connect':
libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer type
libmysql.c:1325: too few arguments to function `gethostbyname_r'
libmysql.c:1325: warning: assignment makes pointer from
On Wed, 24 Jul 2002, Dermot Paikkos wrote:
Date: Wed, 24 Jul 2002 17:46:00 +0100
From: Dermot Paikkos [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: how to update time field with current time?
Hi
Probably a silly question but how can I set a time field to the current
time with update
hi guys,
am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show
characters of language such as hebrew/arabic?
thanks for help
sql
--
Hytham Shehab
-
Before posting, please check:
In the last episode (Jul 24), Dave Dutcher said:
I was wondering if somebody could give me any suggestions on how to optimize
a query I am working on.
This is my table:
CREATE TABLE testdata (
Begin char(9) NOT NULL default '',
End char(9) NOT NULL default '',
UNIQUE KEY
I'm assuming you have AUTO_INCREMENT columns in each table?
Try this:
INSERT INTO TABLE1(...) VALUES(...);
SELECT @t1id := LAST_INSERT_ID();
INSERT INTO TABLE1A(table1_id, ...) VALUES(@t1id, );
INSERT INTO TABLE1B(table1_id, ...) VALUES(@t1id, );
...
-JF
-Original Message-
On 2002-07-24 08:46, Dermot Paikkos [EMAIL PROTECTED] wrote:
Hi
Probably a silly question but how can I set a time field to the current
time with update in mysql?
I have 4 time fields per record. Should I have used set them up as
timestamp?
Now() will update to the current time
Insert
Hello there
Mysql documentation says the following:
values are stored using only as many characters as are needed, plus one
byte to record the length. Values are not padded; instead, trailing spaces
are removed when values are stored.
So, then would there be anything wrong with making all
Pada Wed, 24 Jul 2002 18:43:43 +0200
Daniel Brockhaus [EMAIL PROTECTED] menulis :
At 16:53 24.07.02 +0700, you wrote:
Pada Wed, 24 Jul 2002 11:01:24 +0200
Daniel Brockhaus [EMAIL PROTECTED] menulis :
well, the subject says it all. I'm using version 3.23.41-log, and I got
the
Hi,
Does anyone know how to separate values in a text area field, to enter
the separated values into a database?
For instance if enter these values into a text area field
Dogs
Cats
Fish
I want to be able to take Dogs, Cats and Fish and put them in different
rows in a database. I guess the
Hello there
Mysql documentation says the following:
values are stored using only as many characters as are needed, plus one
byte to record the length. Values are not padded; instead, trailing spaces
are removed when values are stored.
So, then would there be anything wrong with making all
I have an existing mysql user that I wish to add the INDEX privilege. Is
there a command that I can use to add a privilege without first deleting the
user and then recreating with the GRANT command?
Thank You
-
Before posting,
Hi,
When I try to execute scripts/mysql_install_db, I get
some errors about some libraries missing:
exec(): 0509-036 Cannot load program
./bin/my_print_defaults because of the following
errors:
0509-150 Dependent module libz.a(shr.o) could not be
loaded.
0509-022 Cannot load module
Bhavin
I'm doing queries to one table with 4 other smaller tables.
The large table is 12-14 million records. With an index,
the table select is 13-15 seconds. With a compound index,
the delay is sub one second. Use explain to verify which
index is being used. Read the manual to tune your
I have an existing mysql user that I wish to add the INDEX privilege. Is
there a
command that I can use to add a privilege without first deleting the user
and then recreating with the GRANT command?
Thank You
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent:
Hi All,
Sorry about the typo. MySQL4.0.2a should be MySql4.0.2a-Max instead.
Thank you.
Regards,
Michael
-Original Message-
From: Tam, Michael [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 10:54 AM
To: [EMAIL PROTECTED]
Subject: RE: Problem downloading MySQL4.0.2a for
Daniel,
Personally I found ZEOS a pain in proverbial - poorly documented,
constant AVs etc.. D6 dbExpress works very well for me, but I think it
only comes with D6 Enterprise. The myODBC driver is another way to go,
in which case you could probably use the BDE.
There is an ADO driver for
I may be a little OT, but the current myODBC driver does work quite well
with Access. So you can use Access to write your queries and app etc and
have mySQL as your backend.
I've mainly used Access and myODBC to port manipulate Access data to
mySQL. For writing mySQL frontends my preferred
I have 3 tables tableA, tableB and tableC and the fields tableA.id,
tableB.idA and tableC.idA.
I'm using this query (bellow) to call information from the database that has
in tableA but tableA.id is not found on tableB.idA and tableC.idA.
SELECT tableA.*
FROM tableA
LEFT JOIN tableB ON
From: [EMAIL PROTECTED]
To: Desmond Lee [EMAIL PROTECTED]
Subject: Re: THIS IS NOT AN ADVERTISEMENT Date: Thu, 25 Jul 2002 03:37:48
+0200
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the
Pada Wed, 24 Jul 2002 18:52:44 -0500
Paul Maine [EMAIL PROTECTED] menulis :
I have an existing mysql user that I wish to add the INDEX privilege. Is
there a command that I can use to add a privilege without first deleting the
user and then recreating with the GRANT command?
you can run :
Another grant command for the existing privileges + index privs. should work
Bhavin.
- Original Message -
From: Paul Maine [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 24, 2002 5:33 PM
Subject: RE: Grant question
I have an existing mysql user that I wish to add the
On Tue, Jul 23, 2002 at 09:22:55PM -0600, Steve Dickey wrote:
Can anyone tell me how to get an RPM that provides the
libmysqlclient.so.10? I am trying to install the
php-mysql-4.1.2-7.i386.rpm and it says that this is a requirement. It
comes in an older version of the mysql database rpm
hi all,
is there any command in mysql prompt for set page size and set line size
like SQL*Plus?
TIA
ivan paul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hello Daniel!
It works fine. Been using it for several years. Close your connection and
query objects and there will be no AV problems...
Fredrick
- Original Message -
From: Pierre du Parte [EMAIL PROTECTED]
To: Daniel Kiss [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, July
Hello All,
I m using mysql 3.23.42 and myodbc 3.51 on linux7.2.
I use SQLDescribeCol API to get type of column(field).
When i call above functuon it returns type of datetime
and timestamp is 93 for both. but the format of
inserting datetime value uses ( )and timesstamp
value is different.
I m
Hello All,
I m using mysql 3.23.42 and myodbc 3.51 on linux7.2.
I use SQLDescribeCol API to get type of column(field).
When i call above functuon it returns type of datetime
and timestamp is 93 for both. but the format of
inserting using sql query, datetime value uses (
)and timesstamp value is
Can anyone see any problems with using the HPUX 10.20 MySQL binaries on
HPUX 11.00- it seems to work fine in small scale tests.
Regards,
Ian Collins.
-
Before posting, please check:
http://www.mysql.com/manual.php
91 matches
Mail list logo