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 MySQL TIMESTAMP column type with Unix Timestamp, MySQL TIMESTAMP column is just an automatically updated DATETIME column) *to insert current datetime in a DATETIME column, use NOW() or SYSDATE(). e.g. INSERT INTO bug_master VALUES (1, Timothy, NOW()) regards, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, March 15, 2003 20:08 To: [EMAIL PROTECTED] Subject: Newbie - How can I insert new data with the current date/time? I have a table called animals (using the example in the MySQL guide). I have a datetime column type. Here is the table: create table bug_master ( id MEDIUMINT NOT NULL AUTO_INCREMENT, name CHAR(30) NOT NULL, date DATETIME NOT NULL, PRIMARY KEY (id) ); I want to do a simple insert into the table with the current date and time, i.e. the system date. I'm having some problems finding the correct sql syntax to do this. Could anyone help with this? Do I need a Now() function? insert into animals the rest of the query??; Thanks! Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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: Newbie Query Question Hi all, My first post to this list. I have a query which I can't quite get to work. I was hoping that someone here could educate me a bit. I have two tables. tbl_people | id| fname|lname| --- | 1 |frank |smith | tbl_peoples_interests | id | interest_id | person | -- | 1| 500 | 1 | | 2| 504 | 1 | So... basically what I am trying to do is find the person and join them with their interests, but I need to get ALL their interests and I need to be able to access the values of each interest separately. Here is what I have, but both SELECT DISTINCT p.fname AS firstname, p.lname AS lastname, int_1.interest_id AS int_a, int_2.interest_id AS int_b FROM tbl_personnel AS p, tbl_peoples_interests AS int_1, tbl_peoples_interests AS int_2 WHERE int_1.person = p.id AND int_2.person = p.id AND p.id = 1 what I get back has 500 for both int_a and int_b Thanks Charles - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 030316 12:51:49 mysqld restarted Tu portal de Aix en Español http://aixpanish.com - Original Message - From: Bhavin Vyas [EMAIL PROTECTED] To: Jose [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, March 15, 2003 11:13 PM Subject: Re: Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL It is probably looking for a socket file that doesn't exist. Check to see if it does. Also check to see if DB server is running. Bhavin. - Original Message - From: Jose [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 15, 2003 3:03 PM Subject: Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL I get this error after upgrade my server aix 4.3.3.10 to 4.3.3.11: Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock Any one can tell me what could be the problem ? Thanks. Tu portal de Aix en Español http://aixpanish.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 words foreign Brandon key, the table creation fails. cut Just a short note about this. Currently the InnoDB table handler scans the CREATE statement and handles the foreign key definition infernally in InnoDB. In 4.1 MySQL will handle the parsing of the foreign key definition and will store the foreign key definitions in the normal table definition file. This will fix these kind of problems once and for all. Regards, Monty -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 supported was accessible in various browsers (msie, mozilla, opera, etc.) Now the PHP-based forum that the MySQL serves is down. When I try to open it in the browser I get four error error messages that say MySQL has problems with login in, passwords, etc. I can't get into MySQL using the MySQL front ends. Attempting that gets an error that says Error 1130 - host dialup (and then it lists the first node in my internet connection) is not allowed to connect to this MySQL server. I gather from this that the login and pw are not even getting to the server. I am not seeing this error with any other application nor am I having any problem with any other app using the net. I'm over my head here. I can't even claim to understand the fundamentals of PHP and MySQL. Can anyone suggest how I can begin to address this? Or is someone here willing to help me fix it? TIA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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(...) is called and the log is filled with: Loaded 'ntdll.dll', no matching symbolic information found. Loaded 'C:\WINDOWS\system32\kernel32.dll', no matching symbolic information found. Loaded 'C:\qt\bin\qt-mt230nc.dll', no matching symbolic information found. Loaded 'C:\WINDOWS\system32\user32.dll', no matching symbolic information found. Loaded 'C:\WINDOWS\system32\gdi32.dll', no matching symbolic information found. Loaded 'C:\WINDOWS\system32\advapi32.dll', no matching symbolic information found. *Loaded 'D:\app\Debug\libmysqld.dll', no matching symbolic information found.* [...] you can notice the last line... So, why is it running anyway on my winXP although mysql_server_init() isn't found (when debugging only) ? Why does it crash on win2000 ? I've tried 4.0.2, 4.0.9 and 4.0.11 thanx guillaume burlet - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 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-exc eptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -Wa,-man y -DUNDEF_HAVE_INITGROUPS -DSIGNALS_DONT_BREAK_READ -o .libs/mysqlbinlog mysqlbinlog.o -L../libmysql/.libs -lmysqlclient -lz -lcrypt -lnsl_r -lm -Wl ,-bnolibpath -Wl,-blibpath:/usr/local/mysql/lib/mysql:/usr/lib:/lib ld: 0711-317 ERROR: Undefined symbol: __cxa_pure_virtual ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information. collect2: ld returned 8 exit status make: 1254-004 error code last command is 1. I build with: CC=gcc -pipe -mcpu=power -Wa, -many CXX=gcc -pipe -mcpu=power -Wa, -many CXXFLAGS=-felide-constructors -fnoexceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory Thanks in advance. Tu portal de Aix en Español http://aixpanish.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 youre 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 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 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-exc eptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -Wa,-man y -DUNDEF_HAVE_INITGROUPS -DSIGNALS_DONT_BREAK_READ -o .libs/mysqlbinlog mysqlbinlog.o -L../libmysql/.libs -lmysqlclient -lz -lcrypt -lnsl_r -lm -Wl ,-bnolibpath -Wl,-blibpath:/usr/local/mysql/lib/mysql:/usr/lib:/lib ld: 0711-317 ERROR: Undefined symbol: __cxa_pure_virtual ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information. collect2: ld returned 8 exit status make: 1254-004 error code last command is 1. I build with: CC=gcc -pipe -mcpu=power -Wa, -many CXX=gcc -pipe -mcpu=power -Wa, -many CXXFLAGS=-felide-constructors -fnoexceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory Thanks in advance. Tu portal de Aix en Español http://aixpanish.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 (or any other strategy). I've tried using the --tab option but get am getting Errcode: 13 TIA -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 (msie, mozilla, opera, etc.) Now the PHP-based forum that the MySQL serves is down. When I try to open it in the browser I get four error error messages that say MySQL has problems with login in, passwords, etc. Joe, your PHP scripts are probably out of date, using global variables. As of PHP 4.2, the setting register_globals = off as default, and this made a lot of PHP scripts all but obsolete overnight. You can verify for yourself what the PHP settings are if you upload a little code to your webserver: html body ?php phpinfo(); ? /body /html Save this as phpinfo.php on the document root, then point your browser to it. You'll get all kinds of useful information. I have not found documentation with a comprehensive explanation of how scripts should be rewritten, but there's a lot of information out there if you know what to look for. See especially url:http://www.php.net/manual/en/security.registerglobals.php. By the way, replies belong to the list, not to you personally. Please remove your address from the Reply-To field when addressing mail lists. regards, -- Leif Biberg Kristensen http://solumslekt.org/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 way to use mysqldump to do the same (or any other strategy). I've tried using the --tab option but get am getting Errcode: 13 There is no analog to INTO LOCAL OUTFILE. You can save the output of a query executed in mysql to a file, which will give you a tab-delimited file. In some cases, that may be sufficient. mysql -e select * from tbl_name db_name output TIA -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com -- Paul DuBois http://www.kitebird.com/ sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 MySql-ODBC 3.51.04 (using no transactions) Are there known problems ? Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 selection set into a local output (text) file. Can someone suggest a way to use mysqldump to do the same (or any other strategy). I've tried using the --tab option but get am getting Errcode: 13 There is no analog to INTO LOCAL OUTFILE. You can save the output of a query executed in mysql to a file, which will give you a tab-delimited file. In some cases, that may be sufficient. mysql -e select * from tbl_name db_name output Paul, that works just fine. I note that column names are inserted as the first line. Is there a way to eliminate that? If not, that is just fine. Thank you very much -tim- -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -Wa,-many -DUNDEF_HAVE_INITGROUPS -DSIGNALS_DONT_BREAK_READ -o .libs/mysqlbinlogmysqlbinlog.o -L../libmysql/.libs -lmysqlclient -lz -lcrypt -lnsl_r -lm -Wl,-bnolibpath -Wl,-blibpath:/usr/local/mysql/lib/mysql:/usr/lib:/lib ld: 0711-317 ERROR: Undefined symbol: __cxa_pure_virtual ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information. collect2: ld returned 8 exit status make: 1254-004 error code last command is 1. I build with: CC=gcc -pipe -mcpu=power -Wa, -many CXX=gcc -pipe -mcpu=power -Wa, -many CXXFLAGS=-felide-constructors -fnoexceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory use CXX=g++ -pipe ... instead. g++ links in the correct C++ libraries during link time. -- Dan Nelson sql,query [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 Linux Systems, but thanks to your support we where able to patch the linux boxes and move the limit to a size that meets our needs (we've got an average of about 1600 concurrent threads per server). These people use 2.2 Kernels so i dont know if the mentioned kernel and glibc patching is also relevant for me, as i am using 2.4 kernels only. Here is my problem in detail: i am using mysql-3.23.55 binary packages on linux 2.4.20 and i raised ulimit values and configuration in my.conf to allow more then 1500 threads. but when there are around 750 threads a new client connecting is told something like that (dont have the errno at the moment, i think its 11): cant create new thread, perhaps you are out of memory or there is a os-depended bug. The machine only runs apache and mysql and is a Xeon 2x2 2.4 Gz with 2 GB of RAM. cat /proc/meminfo sais that more then 1 Gig is used for caching, so memory should be no problem . Please, if you have any ideas, let me know. If it is a kernel issue, tell me to go to linux mailing lists or if its some kind of secret issue only the support will be able to answer let me know that. Thanks in advance, Philipp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 {CASCADE | SET NULL | NO ACTION
| RESTRICT}]
Is there a default action for ON DELETE and ON UPDATE if no action
is specified in the database definition?
I presume RESTRICT makes it impossible to delete a record from
the parent table if there are any references from a child record to
the parent for that key?
The MySQL documentation on the web does not seem to say
anything about this...
Best regards,
Tor Rune Skoglund
[EMAIL PROTECTED]
sql query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 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 (or any other strategy). I've tried using the --tab option but get am getting Errcode: 13 There is no analog to INTO LOCAL OUTFILE. You can save the output of a query executed in mysql to a file, which will give you a tab-delimited file. In some cases, that may be sufficient. mysql -e select * from tbl_name db_name output Paul, that works just fine. I note that column names are inserted as the first line. Is there a way to eliminate that? If not, that is just fine. Yes, use either the --skip-column-names or -N option. Alternatively, use -ss (double silent), but's mainly for versions older then 3.22.20 that don't support --skip-column-names/-N. Thank you very much -tim- -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com -- Paul DuBois http://www.kitebird.com/ sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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
| RESTRICT}]
[ON UPDATE {CASCADE | SET NULL | NO ACTION
| RESTRICT}]
Is there a default action for ON DELETE and ON UPDATE if no action
is specified in the database definition?
The NO ACTION action seems to cover this. :-)
I presume RESTRICT makes it impossible to delete a record from
the parent table if there are any references from a child record to
the parent for that key?
It's unimplemented.
The MySQL documentation on the web does not seem to say
anything about this...
Best regards,
Tor Rune Skoglund
[EMAIL PROTECTED]
sql query
--
Paul DuBois
http://www.kitebird.com/
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 and MySQL GUI Linux semi-static (version 1.7.5) in a tarball. I have the directions to install these but the directions and the locations I have on my Linux install don't seem to match. Most of the time the documentation points to /usr/local as the location to install--there are no MySQL directories or files in /usr/local or in any of the other sub-directories. I'm doing all of this as root, of course. Which of the above interfaces to MySQL should be used? I have MySQL 3.23.7-5.3mdk installed. Can any Mandrake user direct me to how the Mandrake distro matches up with the documented directory locations in MySQL documentation? I hate to start the install from an incorrect location and cause conflicts along the line. Any and all help would be appreciated. -*-Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 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 (or any other strategy). I've tried using the --tab option but get am getting Errcode: 13 There is no analog to INTO LOCAL OUTFILE. You can save the output of a query executed in mysql to a file, which will give you a tab-delimited file. In some cases, that may be sufficient. mysql -e select * from tbl_name db_name output Paul, that works just fine. I note that column names are inserted as the first line. Is there a way to eliminate that? If not, that is just fine. mysql -N -e select * from tbl_name db_name output Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED] t cc: Subject: Re: Newbie - How can I insert new data with the current 03/15/2003date/time? 10:37 AM At 8:37 -0600 3/15/03, [EMAIL PROTECTED] wrote: I have a table called animals (using the example in the MySQL guide). I have a datetime column type. Here is the table: Looks like it's called bug_master, not animals. :-) create table bug_master ( id MEDIUMINT NOT NULL AUTO_INCREMENT, name CHAR(30) NOT NULL, date DATETIME NOT NULL, PRIMARY KEY (id) ); I want to do a simple insert into the table with the current date and time, i.e. the system date. I'm having some problems finding the correct sql syntax to do this. Could anyone help with this? Do I need a Now() function? That's exactly right. insert into animals the rest of the query??; INSERT INTO bug_master (id,name,date) VALUES(id_val,name_val,NOW()); Thanks! Kevin -- Paul DuBois http://www.kitebird.com/ sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED] in cc: Subject: RE: Newbie - How can I insert new data with the current 03/16/2003date/time? 02:10 AM *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 MySQL TIMESTAMP column type with Unix Timestamp, MySQL TIMESTAMP column is just an automatically updated DATETIME column) *to insert current datetime in a DATETIME column, use NOW() or SYSDATE(). e.g. INSERT INTO bug_master VALUES (1, Timothy, NOW()) regards, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, March 15, 2003 20:08 To: [EMAIL PROTECTED] Subject: Newbie - How can I insert new data with the current date/time? I have a table called animals (using the example in the MySQL guide). I have a datetime column type. Here is the table: create table bug_master ( id MEDIUMINT NOT NULL AUTO_INCREMENT, name CHAR(30) NOT NULL, date DATETIME NOT NULL, PRIMARY KEY (id) ); I want to do a simple insert into the table with the current date and time, i.e. the system date. I'm having some problems finding the correct sql syntax to do this. Could anyone help with this? Do I need a Now() function? insert into animals the rest of the query??; Thanks! Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 KEY (index_col_name, ...)
REFERENCES table_name (index_col_name, ...)
[ON DELETE {CASCADE | SET NULL | NO ACTION
| RESTRICT}]
[ON UPDATE {CASCADE | SET NULL | NO ACTION
| RESTRICT}]
Is there a default action for ON DELETE and ON UPDATE if no action
is specified in the database definition?
RESTRICT is, of course, the default 'action'. ON DELETE and ON UPDATE are
later additions.
...
Best regards,
Tor Rune Skoglund
[EMAIL PROTECTED]
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-4.0 from http://www.mysql.com
sql query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 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 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-exc eptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -Wa,-man y -DUNDEF_HAVE_INITGROUPS -DSIGNALS_DONT_BREAK_READ -o .libs/mysqlbinlog mysqlbinlog.o -L../libmysql/.libs -lmysqlclient -lz -lcrypt -lnsl_r -lm -Wl ,-bnolibpath -Wl,-blibpath:/usr/local/mysql/lib/mysql:/usr/lib:/lib ld: 0711-317 ERROR: Undefined symbol: __cxa_pure_virtual ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information. collect2: ld returned 8 exit status make: 1254-004 error code last command is 1. I build with: CC=gcc -pipe -mcpu=power -Wa, -many CXX=gcc -pipe -mcpu=power -Wa, -many CXXFLAGS=-felide-constructors -fnoexceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory Thanks in advance. Tu portal de Aix en Español http://aixpanish.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 definitions:
[CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...)
REFERENCES table_name (index_col_name, ...)
[ON DELETE {CASCADE | SET NULL | NO ACTION
| RESTRICT}]
[ON UPDATE {CASCADE | SET NULL | NO ACTION
| RESTRICT}]
Is there a default action for ON DELETE and ON UPDATE if no action
is specified in the database definition?
RESTRICT is, of course, the default 'action'. ON DELETE and ON UPDATE are
later additions.
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 implemented.
Also, the manual lists SET DEFAULT as a reference option for the general
CREATE TABLE syntax. Does that come into play for InnoDB at all?
...
Best regards,
Tor Rune Skoglund
[EMAIL PROTECTED]
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-4.0 from http://www.mysql.com
--
Paul DuBois
http://www.kitebird.com/
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 {CASCADE | SET NULL | NO ACTION
| RESTRICT}]
[ON UPDATE {CASCADE | SET NULL | NO ACTION
| RESTRICT}]
Is there a default action for ON DELETE and ON UPDATE if no action
is specified in the database definition?
The NO ACTION action seems to cover this. :-)
I presume RESTRICT makes it impossible to delete a record from
the parent table if there are any references from a child record to
the parent for that key?
It's unimplemented.
Heikki's clarified that RESTRICT is the default, which means it
must be implemented.
Obviously I don't know anything. Don't listen to me.
--
Paul DuBois
http://www.kitebird.com/
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 implemented. Also, the manual lists SET DEFAULT as a reference option for the general CREATE TABLE syntax. Does that come into play for InnoDB at all? As I get it, RESTRICT is no real action at all, since all it does is watching the foreign key restriction to be followed. ON DELETE was implemented because it makes sense and is actually useful to safe some work. ON UPDATE seams to me to be more exotic since most foreign keys have a primary key on one side, so the update target is a primary key, which is not really elegant in my view. Both actions DELETE and UPDATE have drawbacks if you have some relations not covered by an explicit foreign-key-rule or if some tables are still myisam. Anyway RESTRICT is the core funtionality of foreign keys. Without it FKs don't make much sense at all. sql, query yada yada ... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 impression that RESTRICT wasn't even implemented. Also, the manual lists SET DEFAULT as a reference option for the general CREATE TABLE syntax. Does that come into play for InnoDB at all? As I get it, RESTRICT is no real action at all, since all it does is watching the foreign key restriction to be followed. That's an action in the sense that it prevents a parent table record from being deleted. ON DELETE was implemented because it makes sense and is actually useful to safe some work. What I meant is that because RESTRICT is one of the options for the ON DELETE clause, you cannot implement RESTRICT *before* ON DELETE. You cannot implement an option before the clause that it is an option *of*. It makes sense to say that ON UPDATE was updated after ON DELETE, because it was. ON UPDATE seams to me to be more exotic since most foreign keys have a primary key on one side, so the update target is a primary key, which is not really elegant in my view. Both actions DELETE and UPDATE have drawbacks if you have some relations not covered by an explicit foreign-key-rule or if some tables are still myisam. Anyway RESTRICT is the core funtionality of foreign keys. Without it FKs don't make much sense at all. sql, query yada yada ... -- Paul DuBois http://www.kitebird.com/ sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 backup first, just in case something goes wrong. -- Paul DuBois http://www.kitebird.com/ sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 servers work on the same database directory ? It it possible in read only mode or in read and write mode ? With best regards Yes, if you don't disable file locking. Why would you do this though? Each server will have to lock the files, blocking the other server. Thanks Sun cluster system. Two independent nodes work on the same disk array. That is why two mysql servers have to work on the same database directory. Vlad A. Shalnev E-mail: [EMAIL PROTECTED] Gravity can't be blamed for someone falling in love ( Albert Einstein ) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 such like setString(1,kkk) in PrepareStatement or getTableName(1) in ResultMetaData, these methods do not work correctly. I can not get correct String by some getting String method, so do others setting String method. Strange, when i change JDBC driver to mysql-connector-java-2.0.14.jar everything is right. All programs work, so i report this problem to you and wish to find the reason of causing the problem. Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
