RE: Newbie - How can I insert new data with the current date/time?

*if you create a column of the type TIMESTAMP instead of DATETIME then it automatically stores the time when the record was inserted/last updated. If you have more that one column of type TIMESTAMP in the same table then only the first TIMESTAMP column gets updated automatically. (Don't confuse

RE: Newbie Query Question

is a crosstab is what you want? pls. give the result (output of the query) that you expect from the example and what you are actually getting. regds, -Original Message- From: Charles Kline [mailto:[EMAIL PROTECTED] Sent: Saturday, March 15, 2003 20:53 To: [EMAIL PROTECTED] Subject:

Re: Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL

The file exists: When i starts mysql i do ls -l /var/lib/mysql and shows: srwxrwxrwx 1 mysqlmysql 0 16 mar 12:51 /var/lib/mysql/mysql.sock If i look in mysql log i get: 030316 12:51:34 mysqld started /usr/local/bin/mysqld: ready for connections mysqld got signal 11; The manual

comment with foreign key text causes innodb CREATE TABLE failure

Hi! Brandon == Brandon Bird [EMAIL PROTECTED] writes: Brandon From: [EMAIL PROTECTED] Brandon To: [EMAIL PROTECTED] Brandon Subject: comment with foreign key text causes innodb CREATE TABLE Brandon failure Brandon Description: Brandon If an innodb table is created with a comment with the

broken database? or?

I'm a total newbie. If this issue does not belong here, please suggest a more appropriate mailing list or fourm. I have recently moved onto a new server. For a brief period after the move I could access the mySQL database using GUI clients such as mysqlf and sqlyog. And the web site that it

embedded server

hi ! I've wrote an application that run on Win32 and that embed the server. It works perfectly on XP but some friends of mine reported crash on win2000 when mysql_server_init(...) is called. When I debug it (winXP / MSVC++ 6.0 / MySQL 4.0.11) the debug process stops when mysql_server_init(...)

How to compile mysql-3.23.55 on Aix 4.3.3.11

Hi! First of all i had working mysql 3-23-35 on aix 4.3.3.10. After upgrade to 4.3.3.11 it doesn't works. I get: Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL server through socket '/tmp/mysql.sock Now i'm trying to compile 3.23.55 version to probe if it

RE: How to compile mysql-3.23.55 on Aix 4.3.3.11

I don't know about the make problem you describe, but in order to use MySql with AIX 4.3.3.11 you'll have to include set-variable=thread_stack=256k in the [mysqld] portion of you’re my.cnf file. HTH -Bart -Original Message- From: Jose [mailto:[EMAIL PROTECTED] Sent: Sunday, March

INTO LOCAL OUTFILE?

Hello All: I am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) I believe that INTO LOCAL OUTFILE is not implemented, but all the same, I would like to save a selection set into a local output (text) file. Can someone suggest a way to use mysqldump to do the same

Re: broken database? or?

On Sun, 16 Mar 2003 12:04:37 -0500, joe [EMAIL PROTECTED] wrote: I have recently moved onto a new server. For a brief period after the move I could access the mySQL database using GUI clients such as mysqlf and sqlyog. And the web site that it supported was accessible in various browsers

Re: INTO LOCAL OUTFILE?

At 9:14 -0900 3/16/03, Tim Johnson wrote: Hello All: I am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) I believe that INTO LOCAL OUTFILE is not implemented, but all the same, I would like to save a selection set into a local output (text) file. Can someone suggest a

VB6 ODBC Memory problems

Hello, I have been developing an application in VB60 (SP5) which seems to eat up my memory after running some time. The programm is just doing a SELECT in a loop. When the programm is stopped, the memory is freed. Developement environment: WinNT40 SP6a VB60 SP5 DAO 3.6 MySql 2.23.54-nt

Re: INTO LOCAL OUTFILE?

Hi Paul: * Paul DuBois [EMAIL PROTECTED] [030316 09:59]: At 9:14 -0900 3/16/03, Tim Johnson wrote: Hello All: I am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) I believe that INTO LOCAL OUTFILE is not implemented, but all the same, I would like to save a

Re: How to compile mysql-3.23.55 on Aix 4.3.3.11

In the last episode (Mar 16), Jose said: Now i'm trying to compile 3.23.55 version to probe if it works. I use gcc-3.2.1. I have read installation instructions for aix but i get this error for make process: gcc -pipe -mcpu=power -Wa,-many -O3 -DDBUG_OFF -felide-constructors -fno-exceptions

Process Limit on Linux ?

Hi there, i wrote several times to the list asking for help with a problem regarding process limits on linux, but never got an answer. today i found this story: http://www.mysql.com/press/user_stories/handy.de.html here are the relevant sentences: We had some process limit problems on our

Foreign Key and default action/RESTRICT behaviour?

Hi List, regarding the foreign key definitions: [CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...) REFERENCES table_name (index_col_name, ...) [ON DELETE {CASCADE | SET NULL | NO ACTION | RESTRICT}] [ON UPDATE

Re: INTO LOCAL OUTFILE?

At 10:34 -0900 3/16/03, Tim Johnson wrote: Hi Paul: * Paul DuBois [EMAIL PROTECTED] [030316 09:59]: At 9:14 -0900 3/16/03, Tim Johnson wrote: Hello All: I am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) I believe that INTO LOCAL OUTFILE is not implemented, but

Re: Foreign Key and default action/RESTRICT behaviour?

At 19:21 +0100 3/16/03, Tor R. Skoglund (NextG) wrote: Hi List, regarding the foreign key definitions: [CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...) REFERENCES table_name (index_col_name, ...) [ON DELETE {CASCADE | SET NULL | NO ACTION

MySQL CC Mandrake 8.2

I have Mandrake 8.2 installed and had MySQL loaded during the system installation.I have questions about the location of MySQL and where I should unpack the MySQL graphical interface(s) to install. I have the MySQLCC (version glibc-0.8.10) in a tarball, MySQL Client (version 3.23.7-5.3) in an RPM

Re: INTO LOCAL OUTFILE?

On 16-Mar-2003 Tim Johnson wrote: Hi Paul: * Paul DuBois [EMAIL PROTECTED] [030316 09:59]: At 9:14 -0900 3/16/03, Tim Johnson wrote: Hello All: I am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) I believe that INTO LOCAL OUTFILE is not implemented, but all the

Re: Newbie - How can I insert new data with the current date/time?

Thanks Paul, that works great. Yes, I meant to say the table animals, not bug_master. Paul DuBois

RE: Newbie - How can I insert new data with the current date/time?

Great, this is more of what I was looking fora way to have the DB auto populate the date/time in a column, without having to use sql. Thanks again! Uttam

Re: Foreign Key and default action/RESTRICT behaviour?

Tor, - Original Message - From: Tor R. Skoglund (NextG) [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Sunday, March 16, 2003 10:11 PM Subject: Foreign Key and default action/RESTRICT behaviour? Hi List, regarding the foreign key definitions: [CONSTRAINT symbol] FOREIGN

Re: How to compile mysql-3.23.55 on Aix 4.3.3.11

Thats right. problem resolved. Thanks. set-variable=thread_stack=256k in the [mysqld] portion of you're my.cnf file. HTH -Bart -Original Message- From: Jose [mailto:[EMAIL PROTECTED] Sent: Sunday, March 16, 2003 10:22 AM To: [EMAIL PROTECTED] Subject: How to compile mysql-3.23.55 on

Re: Foreign Key and default action/RESTRICT behaviour?

At 23:12 +0200 3/16/03, Heikki Tuuri wrote: Tor, - Original Message - From: Tor R. Skoglund (NextG) [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Sunday, March 16, 2003 10:11 PM Subject: Foreign Key and default action/RESTRICT behaviour? Hi List, regarding the foreign key

Re: Foreign Key and default action/RESTRICT behaviour?

At 14:29 -0600 3/16/03, Paul DuBois wrote: At 19:21 +0100 3/16/03, Tor R. Skoglund (NextG) wrote: Hi List, regarding the foreign key definitions: [CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...) REFERENCES table_name (index_col_name, ...) [ON DELETE

Re: Foreign Key and default action/RESTRICT behaviour?

RESTRICT is, of course, the default 'action'. ON DELETE and ON UPDATE are later additions. Paul DuBois wrote: I see in the change notes that ON UPDATE was implemented in 4.0.8. But how can ON DELETE be a later addition than RESTRICT? I was under the impression that RESTRICT wasn't even

Re: Upgrading from 3.22

We are wanting to upgrade to MYSQL 3.23 on a Linux system. Is there an upgrade from 3.22 to 3.23 or do I simply install 3.23 in the same directory where 3.22 was? Any help would be appreciated. - Before posting, please

Re: Foreign Key and default action/RESTRICT behaviour?

At 4:13 +0100 3/17/03, Andreas wrote: RESTRICT is, of course, the default 'action'. ON DELETE and ON UPDATE are later additions. Paul DuBois wrote: I see in the change notes that ON UPDATE was implemented in 4.0.8. But how can ON DELETE be a later addition than RESTRICT? I was under the

Re: Upgrading from 3.22

At 22:33 -0500 3/16/03, [EMAIL PROTECTED] wrote: We are wanting to upgrade to MYSQL 3.23 on a Linux system. Is there an upgrade from 3.22 to 3.23 or do I simply install 3.23 in the same directory where 3.22 was? Any help would be appreciated. You can do that, though of course you should make a

Re: Two mysql servers on the same database directory

From: gerald_clark [EMAIL PROTECTED] User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0 To: Vlad Shalnev [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Two mysql servers on the same database directory Vlad Shalnev wrote: Hi, All Can two mysql

MySQL JDBC driver problem

Hi, How are you? I have a problem to jdbc driver. My paltform is win2000 professional and MySQL Server's version is 3.23.55. I use jdbc driver of mysql-connector-java-3.0.6-stable.jar and i find some problems to this jdbc driver version. When i use some method about setting or getting String

Goldmine

Dear All Has anyone successfully used Goldmine accessing MySQL databases via ODBC or any other connection method? Regards Michael Johnson - Before posting, please check: http://www.mysql.com/manual.php (the manual)