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 My

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: Newbi

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 sec

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

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 sup

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(...) i

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 work

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 16,

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 M

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 sav

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-except

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 Lin

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 a

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,

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] F

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

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 {CASCAD

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 implement

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 check

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 impressi

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 ba

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 >>

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 suc

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)