Re: storing files...
Nick, Tuesday, April 09, 2002, 5:21:00 PM, you wrote: NS> Is there a way to store files in MySQL? Looking to store somthing like a NS> zip file in the databaseand be able to retrieve/download it from something like ASP. Yes, you can store files in the BLOB fields. You can find some info about BLOB column types and storage requirements in the MySQL manual: http://www.mysql.com/doc/B/L/BLOB.html http://www.mysql.com/doc/n/o/node_368.html To put binary data in the database you can use LOAD_FILE() function. LOAD_FILE() function is described at: http://www.mysql.com/doc/S/t/String_functions.html If you don't use LOAD_FILE() - don't forget to escape chars. You can find the list of chars to escape and escape sequences at: http://www.mysql.com/doc/S/t/String_syntax.html To read binary data use the SELECT statement. NS> Thanks NS> -Nick -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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
Char set Win1250
Hello,
I have simple question.I have installed on my computer WinNT 4.0, Apache 1.3.14, PHP4
(4.0.4pl1), MySQL MAX 4.0.1. There's problem with char set win1250. I don't know how
can I link this char set. Script with this row $spojeni = MySQL_Connect("localhost");
sends an error Warning: MySQL Connection Failed: Can't initialize character set 26
(path: default) in c:/program files/apache group/apache/htdocs/tellib.php on line 84.
(Char set 26 is Win1250). Does anybody know, how can I link char-set Win1250 in Win32
system to PHP4 and MySQL? In PHP3 works everything properly.
Pavel Zaklasnik
Czech Republic
---
Odchozí zpráva neobsahuje viry.
Zkontrolováno antivirovým systémem AVG (http://www.grisoft.cz).
Verze: 6.0.320 / Virová báze: 179 - datum vydání: 30.1.2002
-
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
mysqlbug
I purchased a book entitled "PHP3 programming browser-based Applications" it came with a cd that contained a copy of MySql-3.22.16a-gamma for any linux distribution. Anyhow, I am having problems installing the software on my SuSe 7.1 linux box. Basically, there are eleven steps that the author "david medinets" requires in order to properly install the software, but of those eleven, I am having problems with step 8. From root directory linux: ~ # - 1 cd /usr/local/src/mysql-3.22.16a-gamma 2 ./configure --prefix=/usr/local/mysql 3 make 4 make install 5 echo "/usr/local/mysql/lib/mysql" >> /etc/ld.so.conf 6 ldconfig -v | grep libmysqlclient 7 echo "/usr/local/mysql/bin/safe_mysqld > /dev/null &" >> /etc/rc.d/rc.local 8 ./scripts/mysql_install_db 9 /usr/local/mysql/bin/safe_mysqld > /dev/null & 10 ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql 11 ln -s /usr/local/mysql/bin/mysql /usr/bin/mysqlshow after this, the author gives you a sample code to test the database. _ step 8 after entering this at the prompt: linux: usr/local/src/mysql-3.22.16a-gamma # ./scripts/mysql_install_db an error message ( did'nt find /usr/local/mysql/libexec/mysql ) ( You should do a "make install" before executing this script ) I tryed to run the sample code with out this being installed correctly, but no luck. I would really like any help from anyone on solving this problem. As far as libexec not be found, well there is a lib directory with a subdirectory of mysql. Why its looking for libexec? Well, I simply don't know. Thanks [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
installation problems
I purchased a book entitled "PHP3 programming browser-based Applications" it came with a cd that contained a copy of MySql-3.22.16a-gamma for any linux distribution. Anyhow, I am having problems installing the software on my SuSe 7.1 linux box. Basically, there are eleven steps that the author "david medinets" requires in order to properly install the software, but of those eleven, I am having problems with step 8. From root directory linux: ~ # - 1 cd /usr/local/src/mysql-3.22.16a-gamma 2 ./configure --prefix=/usr/local/mysql 3 make 4 make install 5 echo "/usr/local/mysql/lib/mysql" >> /etc/ld.so.conf 6 ldconfig -v | grep libmysqlclient 7 echo "/usr/local/mysql/bin/safe_mysqld > /dev/null &" >> /etc/rc.d/rc.local 8 ./scripts/mysql_install_db 9 /usr/local/mysql/bin/safe_mysqld > /dev/null & 10 ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql 11 ln -s /usr/local/mysql/bin/mysql /usr/bin/mysqlshow after this, the author gives you a sample code to test the database. _ step 8 after entering this at the prompt: linux: usr/local/src/mysql-3.22.16a-gamma # ./scripts/mysql_install_db an error message ( did'nt find /usr/local/mysql/libexec/mysql ) ( You should do a "make install" before executing this script ) I tryed to run the sample code with out this being installed correctly, but no luck. I would really like any help from anyone on solving this problem. As far as libexec not be found, well there is a lib directory with a subdirectory of mysql. Why its looking for libexec? Well, I simply don't know. Thanks [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
Unexpected end of input stream-mm.mysql driver related problem*****URGENT*****
Hi, I am geeting an error Unexpected Exception: java.io.IOException message given: Unexpected end of input stream Is there any limitation on the length of the query string (In mm.mysql driver?)? Can any one help me out to avoid this error. LOG: SELECT PURCHASE_ORDERS.ORDER_ID,PURCHASE_ORDERS.LAST_UPDATE,PURCHASE_ORDERS.ORDER_N AME,PURCHASE_ORDERS.R EQUEST_ID,PURCHASE_ORDERS.START_DATE,PURCHASE_ORDERS.OWNER_ID,PURCHASE_ORDER S.CREATION_DATE,PURCH ASE_ORDERS.PARENT_ID,PURCHASE_ORDERS.END_DATE,PURCHASE_ORDERS.CONTRACTOR_ID, PURCHASE_ORDERS.SUPPL IER_COMPANY,PURCHASE_ORDERS.COMMENTS,PURCHASE_ORDERS.ORDER_STATUS_ID,PURCHAS E_ORDERS.UNIT_PRICE,P URCHASE_ORDERS.CLIENT_COMPANY_ID,PURCHASE_ORDERS.CONTRACTOR_NAME FROM PURCHASE_ORDERS WHERE ORDER_ID=? [2002-04-08 22:44:54,320; JAWSPersistenceManager] Set parameter: idx=1, jdbcType=VARCHAR, value=1017769113300:10.2.36.212:6001 [2002-04-08 22:44:54,322; JAWSPersistenceManager] java.sql.SQLException: Error during query: Unexpected Exception: java.io.IOException message given: Unexpected end of input stream [2002-04-08 22:44:54,330; Thanks, Rama Raju - 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
performance for single/multiple databases
I have a performance question between having a single database for all tables or splitting up tables into multiple databases. The hosting service I use charges extra for multiple databases. Using PHP/MySQL for website. I currently have 12 tables in one database. Are there any performance advantages if I create 3 databases and split up the tables? SQL queries to insert/update data is done from the web expecting thousands page hits a day. Also, if I split up the databases...how would i perform a table join from two tables which are in different databases. Thank You! Truong-An. - 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: replication
On Wed, 10 Apr 2002 [EMAIL PROTECTED] wrote: > I use MySQL server replication last month, but currently I stopped using > it...coz for some reason > > 1.my master server is running on windows 98 platform, I cant prevent > it from hanging-up > 2.my slave server is running on windows 98 also, I cant prevent it > also from hanging-up > 3.if master hangs-up, slave also stop replicating...as the master > recover the slave cant replicate due some changes made by the master which > is not updated in the slave...a corruption... > 4.I always shutdown both servers and copy the database from master to > slave, and start over again...I started up the master then second the > slave...it works better and reliable... > 5.My setup weakness is only when my master server hangs-up... > > Is there some tips known about this?I really appreciate it... > > > R.B.Roa > PhilCom Corporation > Tel. No. 858- > Mobile No. (63) (919-xxx) Your primary weakness in that setup is windows 98. Windows 98 is prone to memory problems and does not like to function well under any kind of load. My recomendation is to run your database on some flavor of linux or if your really partial to it, a flavor of bsd. If the *nixes are out of the question at least upgrade to windows 2000 server or something based off of NT. I have also had corruption issues running under very high load on IDE drives, if you can afford it go SCSI. Eric Bergen Webmaster ItsYourDomain.com 1005 W. Wise Road Schaumburg, IL 60193 (847) 895-4301 / Tel -(847) 895-4123 / Fax http://www.itsyourdomain.com [EMAIL PROTECTED] "The Wholesale Registrar" - 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: database -> er diagram
ERWIN may be able to reverse engineer via an ODBC connection. Particularly, ERWIN can infer relationships via explicit foreign key constraints, or via similar column names, or indices. You should have started with model. Kudos to your boss for calling you on it. At 09:14 PM 4/9/2002 -0700, Land, Christopher wrote: >Check the Contributed Software page: > >Contributed software - http://www.mysql.com/downloads/contrib.html > > > >APIs >Clients >Web Tools >Performance Benchmarking Tools >Authentication Tools >Converters >Using MySQL with Other Products >Utilities >RPMs for Common Tools (Most Are for RedHat 6.1) >Useful Functions >Windows Programs >Uncategorised > > >C:~ > >-Original Message- >From: Mr Hai Luong [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, April 09, 2002 8:11 PM >To: [EMAIL PROTECTED] >Subject: database -> er diagram > > >i got a MySQL database that my supervisor wats me to do an ER diagram >for. The problem is that there is no/not much documentation on this >database. Also one cannot draw an ER-Diagram by looking at the mySQL- >Database, since there is no way (i know of) i can defining logical >relationships especially when a column names for the same attribute are >different between the tables. > >Is there some Tutorials/fact sheets/program/information to do this? > >Cheers >Alex > > > >- >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
RE: database -> er diagram
Check the Contributed Software page: Contributed software - http://www.mysql.com/downloads/contrib.html APIs Clients Web Tools Performance Benchmarking Tools Authentication Tools Converters Using MySQL with Other Products Utilities RPMs for Common Tools (Most Are for RedHat 6.1) Useful Functions Windows Programs Uncategorised C:~ -Original Message- From: Mr Hai Luong [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 8:11 PM To: [EMAIL PROTECTED] Subject: database -> er diagram i got a MySQL database that my supervisor wats me to do an ER diagram for. The problem is that there is no/not much documentation on this database. Also one cannot draw an ER-Diagram by looking at the mySQL- Database, since there is no way (i know of) i can defining logical relationships especially when a column names for the same attribute are different between the tables. Is there some Tutorials/fact sheets/program/information to do this? Cheers Alex - 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: I have multiple servers in a machine.
To start MySQL, are you using, minimum, the following? ./safe_mysqld & 2.4.2 Problems Starting the MySQL Server http://www.mysql.com/doc/S/t/Starting_server.html 2.4.3 Starting and Stopping MySQL Automatically http://www.mysql.com/doc/A/u/Automatic_start.html C:~ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 6:56 PM To: [EMAIL PROTECTED] Subject: I have multiple servers in a machine. I have two mysql servers in a machine. OS is linux and system is dell. I ran the servers in a separate datadir, socket and port yesterday. But after six hours from the start two of them corrupted accidently. I ran two servers from remote terminal. And there was no problem until I exited from the terminal. But... as soon as I typed "exit" to exit from terminal, some error messages appeared on my screen. And two servers stopped. After corruption one of them restarted automatically but the other couldn't restart automatically. This is error message from the server FIRST ONE 020409 04:03:03 mysqld started /usr/local/libexec/mysqld: ready for connections Number of processes running now: 20 mysqld process hanging, pid 18761 - killed mysqld process hanging, pid 18811 - killed mysqld process hanging, pid 18832 - killed 020409 14:34:04 mysqld restarted /usr/local/libexec/mysqld: ready for connections ~ ~ SECOND ONE 020409 04:03:03 mysqld started /usr/local/libexec/mysqld: ready for connections Number of processes running now: 94 mysqld process hanging, pid 18762 - killed 020409 14:34:03 mysqld restarted Number of processes running now: 0 020409 14:34:03 mysqld restarted 020409 14:34:03 mysqld ended 020409 14:34:04 mysqld ended The accident occured at 14:34 2002/04/09. Do you have any idea why the server corrupted? I can show you my mysql.server script. Here is this. $bindir/safe_mysqld --datadir=$datadir \ --pid-file=$pid_file \ -O max_heap_table_size=512M \ -O key_buffer=256M \ -O table_cache=256 \ -O sort_buffer=4M -O record_buffer=1M \ -O max_allowed_packet=1M \ -O max_connections=400 \ -O back_log=100 \ & $bindir/safe_mysqld --datadir=/usr/local/mysql/other \ --socket=/usr/local/mysql/other/mysql.sock \ --port=3307 \ -O max_heap_table_size=512M \ -O key_buffer=256M \ -O table_cache=256 \ -O sort_buffer=4M -O record_buffer=1M \ -O max_allowed_packet=1M \ -O max_connections=400 \ -O back_log=100 \ & Any answer will be appreciated. Thank you for reading. - 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 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: database problem
On Wed, 10 Apr 2002 03:59:22 + "saraswathy saras" <[EMAIL PROTECTED]> wrote: > hi everybody, > > i have problem with storing chinese word to databaseall the chinese > automatic change to code like this 算盘。 its not only > waste the space, also i have problem to display it...sometime, some of the > word not complete and also display symbols.is there anybody can help me? > Please help mei am stuck here.. > It's a problem of UNICODE ... you have to set your mysql with Chinese Unicode char. but still the data will be and should be remain with "算盘。" codes ... it's only a matter on terminal or software that will retreive / read the data ... if the terminal/software doesn't support Chinese Unicode ... so data will not be translated into proper way. -- Let's call it an accidental feature. -- Larry Wall - 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 Manual | 6.2.6.1: Range of MEDIUMINT, and BIGINT of mySQL type ? (sql query)
Check the documentation: 6.2.6.1 Storage requirements for numeric types http://www.mysql.com/doc/n/o/node_365.html C:~ -Original Message- From: Son Nguyen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 6:30 PM To: [EMAIL PROTECTED] Subject: Range of MEDIUMINT, and BIGINT of mySQL type ? (sql query) Do anybody knows the range of MEDIUMINT, and BIGINT type to use when I do the create table in mySQL ? Son Nguyen sql, query __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.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: how do I give permissions to a web browser
The "web application" is running in an environment *outside* of the server, compared to your context, which may be 'root@localhost', for instance. The browser's context, then, might be '[EMAIL PROTECTED]'; thus, you will need to add an entry to m,ysql.user table. C:~ -Original Message- From: Henry de Jong [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 7:41 PM To: [EMAIL PROTECTED] Subject: how do I give permissions to a web browser It seems that an internet connection from a browser to my unix/apache hosted mysql database presents itself as some user to whom I haven't yet given permissions because the calling web page gives up without a whimper. I have generous permissions for 'root', 'nobody' and 'localhost'. The perl script works fine from my shell acount (through a socket) and works up till the connect statement in the browser. How can I 'identify' the browser or change the script to accomodate a browser connection. thanks, Henry de Jong - 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
database problem
hi everybody, i have problem with storing chinese word to databaseall the chinese automatic change to code like this 算盘。 its not only waste the space, also i have problem to display it...sometime, some of the word not complete and also display symbols.is there anybody can help me? Please help mei am stuck here.. sql thanks in advance regards, saras _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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
replication
I use MySQL server replication last month, but currently I stopped using it...coz for some reason 1. my master server is running on windows 98 platform, I cant prevent it from hanging-up 2. my slave server is running on windows 98 also, I cant prevent it also from hanging-up 3. if master hangs-up, slave also stop replicating...as the master recover the slave cant replicate due some changes made by the master which is not updated in the slave...a corruption... 4. I always shutdown both servers and copy the database from master to slave, and start over again...I started up the master then second the slave...it works better and reliable... 5. My setup weakness is only when my master server hangs-up... Is there some tips known about this?I really appreciate it... R.B.Roa PhilCom Corporation Tel. No. 858- Mobile No. (63) (919-xxx) - 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: row totals
> I need to know how many total reviews are in my table for each category > name, im using this query and it doesn't work: > > SELECT SUM(name) AS articletotal WHERE category = 'Processors' Try SELECT count(name) AS articletotal FROM tablename WHERE category = 'Processors' Sincerely, Craig Vincent - 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
database -> er diagram
i got a MySQL database that my supervisor wats me to do an ER diagram for. The problem is that there is no/not much documentation on this database. Also one cannot draw an ER-Diagram by looking at the mySQL- Database, since there is no way (i know of) i can defining logical relationships especially when a column names for the same attribute are different between the tables. Is there some Tutorials/fact sheets/program/information to do this? Cheers Alex - 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: binlog and replication stuff
When a slave crashes or reboots, it should start replicating from where it left off--at least ours do work that way. The current replication state is saved in master.info on the slave and when it starts up again, it should read that file and resume reading the binlog on the master where it left off. The master.info file contains the binlog#, location, user, password, etc... neccessary to restart replication. In you case, does the slave give you any error messages in it's error log about why it couldn't resume replication? If it doesn't try to start replication, have you tried doing a 'slave start' on the slave after it reboots? -Marc Davide Giunchi wrote: > > Hello. > I'm using MySQL-3.23.38 on 5 RedHat 7.1/7.2 servers composed by one master > and 4 mysql slave, every write is made on the master and then replicated to > the slave. > The problem is that if one client crash or must be rebooted i've to: > > - on the mysql master stop mysql, delete binlogfile, tar all the data in a > file and then restart mysql > - on ALL the mysql slave stop mysql, delete all data, get the tar file from > the master and the restart mysql > > so i've to restart all mysql slave even if only one is really "crash", if i > don't do this i loose the syncronization between master and slave (as shown > in the mysql.log). > As your experience what do you do when a mysql slave "crash" and loose the > sync? I would like to use a method to restart only the crashed client without > touch other's slave and without restart master. > > I could make a backup script that get all the data from the the master (like > mysqlhotcopy) without restart nothing, but what about the binlog file? i > could FLUSH them in the server but then other slave will loose the sync > I appreciate any help or suggestion. > > Best Regards. > -- > Davide Giunchi. > Membro del FoLUG (Forlí Linux User Group) - http://folug.linux.it > GPG Key available on http://www.keyserver.net > Fingerprint: 8075 363A B4FA 0196 FEEC AF9C 19A9 66C7 CDAB D0D5 > > - > 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
how do I give permissions to a web browser
It seems that an internet connection from a browser to my unix/apache hosted mysql database presents itself as some user to whom I haven't yet given permissions because the calling web page gives up without a whimper. I have generous permissions for 'root', 'nobody' and 'localhost'. The perl script works fine from my shell acount (through a socket) and works up till the connect statement in the browser. How can I 'identify' the browser or change the script to accomodate a browser connection. thanks, Henry de Jong - 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: Range of MEDIUMINT, and BIGINT of mySQL type ? (sql query)
G'day Son Nguyen > Do anybody knows the range of MEDIUMINT, and BIGINT type to use > when I do the create table in mySQL ? >From the manual at http://www.mysql.com/doc/C/o/Column_types.html MEDIUMINT[(M)] [UNSIGNED] [ZEROFILL] A medium-size integer. The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215. BIGINT[(M)] [UNSIGNED] [ZEROFILL] A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615. cheers kim - 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
I have multiple servers in a machine.
I have two mysql servers in a machine. OS is linux and system is dell. I ran the servers in a separate datadir, socket and port yesterday. But after six hours from the start two of them corrupted accidently. I ran two servers from remote terminal. And there was no problem until I exited from the terminal. But... as soon as I typed "exit" to exit from terminal, some error messages appeared on my screen. And two servers stopped. After corruption one of them restarted automatically but the other couldn't restart automatically. This is error message from the server FIRST ONE 020409 04:03:03 mysqld started /usr/local/libexec/mysqld: ready for connections Number of processes running now: 20 mysqld process hanging, pid 18761 - killed mysqld process hanging, pid 18811 - killed mysqld process hanging, pid 18832 - killed 020409 14:34:04 mysqld restarted /usr/local/libexec/mysqld: ready for connections ~ ~ SECOND ONE 020409 04:03:03 mysqld started /usr/local/libexec/mysqld: ready for connections Number of processes running now: 94 mysqld process hanging, pid 18762 - killed 020409 14:34:03 mysqld restarted Number of processes running now: 0 020409 14:34:03 mysqld restarted 020409 14:34:03 mysqld ended 020409 14:34:04 mysqld ended The accident occured at 14:34 2002/04/09. Do you have any idea why the server corrupted? I can show you my mysql.server script. Here is this. $bindir/safe_mysqld --datadir=$datadir \ --pid-file=$pid_file \ -O max_heap_table_size=512M \ -O key_buffer=256M \ -O table_cache=256 \ -O sort_buffer=4M -O record_buffer=1M \ -O max_allowed_packet=1M \ -O max_connections=400 \ -O back_log=100 \ & $bindir/safe_mysqld --datadir=/usr/local/mysql/other \ --socket=/usr/local/mysql/other/mysql.sock \ --port=3307 \ -O max_heap_table_size=512M \ -O key_buffer=256M \ -O table_cache=256 \ -O sort_buffer=4M -O record_buffer=1M \ -O max_allowed_packet=1M \ -O max_connections=400 \ -O back_log=100 \ & Any answer will be appreciated. Thank you for reading. - 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
Range of MEDIUMINT, and BIGINT of mySQL type ? (sql query)
Do anybody knows the range of MEDIUMINT, and BIGINT type to use when I do the create table in mySQL ? Son Nguyen sql, query __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.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
Range of MEDIUMINT, and BIGINT of mySQL type ?
Do anybody knows the range of MEDIUMINT, and BIGINT type to use when I do the create table in mySQL ? Son Nguyen __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.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: slow to a crawl
Benjamin Pflugmann <[EMAIL PROTECTED]> writes: > Hello. > > First, key_buffer=16M seems a bit low for me with 13 million rows > (well, depends on the indexes, and how much free memory you have, of > course). 1 gig, plenty free. > If I am not mistaken, sort_buffer/tmp_table_size are the one mostly > needed for this query, I think. Btw, you can get more info about the > query with EXPLAIN. Please post the result of it (for both SELECTs), > if you answer. Query 1, works: group by bayid, ds1 table typepossible_keys key key_len ref rowsExtra detail_20020408 ALL NULLNULLNULLNULL13083666Using temporary Query 2, bad: group by bayid, ds1, scid table typepossible_keys key key_len ref rowsExtra detail_20020408 ALL NULLNULLNULLNULL13083666Using temporary > Another idea is that you have an index over the two fields you were > talking, but not the additional field. In this case, the first query > can run only from index, but the second needs to read from the table > file. EXPLAIN should show. Btw, this is a full table scan, no WHERE clause exists, so I'm not sure where indexes would change the behaviour of this. > Btw, please always post what you observe, e.g. the vmstat output. > Maybe someone on the list can see something you didn't. Query 1: procs memoryswap io system cpu r b w swpd free buff cache si sobibo incs us sy id 1 0 0492 5084 91104 837016 0 0 4 43 3 1 1 1 1 0 0492 5084 91104 836632 0 0 11968 0 1178 2444 47 6 47 2 0 0492 5084 91104 835524 0 0 8228 714 1653 3283 36 6 58 2 0 0492 5096 91104 835248 0 0 12342 8 1205 2553 49 7 44 2 0 0492 5096 91104 836780 0 0 11220 0 1180 2477 47 7 47 2 0 0492 5096 91104 836764 0 0 10472 714 1729 3297 40 6 54 1 0 0492 5096 91104 836744 0 0 11220 0 1220 2609 49 5 46 0 1 0492 5096 91104 836728 0 0 10392 736 1599 3259 42 7 50 Query 2: procs memoryswap io system cpu r b w swpd free buff cache si sobibo incs us sy id 2 0 0492 5060 91148 820528 0 0 4 44 3 1 1 1 2 0 0492 5096 91152 817160 0 0 16836 0 1276 2611 84 13 3 4 0 0492 5092 91164 817340 0 0 11232 3040 1168 2573 81 16 3 3 0 0492 16404 91168 820312 0 0 9736 2722 1776 4093 74 16 10 2 1 1492 5092 91168 834696 0 0 11976 7756 1183 2793 81 17 2 0 2 1492 5092 91168 834420 0 0 9734 8382 1950 3270 60 15 25 2 1 1492 5092 91168 833448 0 0 10476 164 1705 2571 45 7 47 2 1 1492 5092 91172 833172 0 0 13100 6382 1536 2897 78 18 3 1 2 1492 5092 91172 832888 0 0 9354 9148 2187 3468 46 14 41 3 1 2492 5092 91172 831904 0 0 11226 6210 1644 2567 60 11 28 2 2 1492 5092 91172 832900 0 0 13102 7286 1740 2507 75 19 6 You can see how very eradict the machine gets... Interactive typing even starts to pause when you see the idle near zero, it's like something is thrashing in the kernel but top yields no clues. Cliff - 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
row totals
Hey Guys, What is the command to add up the amount of rows in a total? I need to know how many total reviews are in my table for each category name, im using this query and it doesn't work: SELECT SUM(name) AS articletotal WHERE category = 'Processors' mysql Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [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
Re: prefix
Thanks, but what I need to do is have make install install everything into /home/turner/mysql/test then I'll check everything out to make sure it is how I want it and last I'll copy it all to /usr/local. Any way to do this ./configure --prefix=/usr/local (default) make make install prefix=/home/turner/mysql/test Thanks, Dave On Tue, Apr 09, 2002 at 05:41:08PM -0700, Jeremy Zawodny wrote: > On Tue, Apr 09, 2002 at 05:30:06PM -0700, David Turner wrote: > > > > I would like to make install to my home directory but can't seem to get it to > > work. > > > > make install prefix=/home/turner/mysql/test > > > > It keeps wanting to install to /usr/local even though I pass the > > prefix parm. > > ./configure --prefix=/home/turner/mysql/test > make > make install > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 > > MySQL 3.23.47-max: up 61 days, processed 1,654,532,924 queries (311/sec. avg) - 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: prefix
On Tue, Apr 09, 2002 at 05:30:06PM -0700, David Turner wrote: > > I would like to make install to my home directory but can't seem to get it to > work. > > make install prefix=/home/turner/mysql/test > > It keeps wanting to install to /usr/local even though I pass the > prefix parm. ./configure --prefix=/home/turner/mysql/test make make install Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 61 days, processed 1,654,532,924 queries (311/sec. avg) - 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
prefix
I would like to make install to my home directory but can't seem to get it to work. make install prefix=/home/turner/mysql/test It keeps wanting to install to /usr/local even though I pass the prefix parm. Thanks, Dave - 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: slow to a crawl
Hello. First, key_buffer=16M seems a bit low for me with 13 million rows (well, depends on the indexes, and how much free memory you have, of course). If I am not mistaken, sort_buffer/tmp_table_size are the one mostly needed for this query, I think. Btw, you can get more info about the query with EXPLAIN. Please post the result of it (for both SELECTs), if you answer. Another idea is that you have an index over the two fields you were talking, but not the additional field. In this case, the first query can run only from index, but the second needs to read from the table file. EXPLAIN should show. Btw, please always post what you observe, e.g. the vmstat output. Maybe someone on the list can see something you didn't. Hops that helps. Mostly shots in the dark. Bye, Benjamin. On Tue, Apr 09, 2002 at 06:35:57PM -0400, [EMAIL PROTECTED] wrote: > I have one query, that basically reads from one table of 13 million rows, > groups it by two fields, and inserts into a rollup table. The result set > ends up being about 31,000 rows. This runs in about 2 minutes which is > acceptable. However, I add an additional group by field, which will probably > result in a million results and mysql goes to a crawl. It doesn't even > max out one cpu as the former query does. Instead vmstat reports a process > blocked and in wait, while mysql goes down to hardly any cpu. The box lags a > tad bit like it's I/O related, but the I/O isn't abnormal. As soon as I use > mysqladmin to kill the query everything is back to normal. I'll note the load > goes above 3.0 when this is running but none of it's in CPU ... > > I realize this is very vague, bu I'm just shooting in the dark here wondering > if someone has seen similar oddities, and it might be resolvable by tuning > some of the parameters. > > 3.23.49, precompiled from mysql.com > 2.4.9-21smp Linux > key_buffer=16M table_cache=128 sort_buffer=8M > record_buffer=2M tmp_table_size=16M > > I've tried increasing these but didn't help. -- [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
Re: Column order
Hi. For what I know, MySQL always reads a whole row if it has to read the row at all. So, no, column order should not matter at all. With MyISAM tables, indexes are in a seperate file, build their own way. So no, also no influence. I don't know enough about InnoDB to say something for sure, but I think column order should not matter either. IMHO, most potential for optimizing lies in a good choice of properly indexes. Bye, Benujamin. On Tue, Apr 09, 2002 at 03:50:52PM -0400, [EMAIL PROTECTED] wrote: > Sorry, this came out ugly. I misinterpreted the list filter's > comments, and thought it would post my original message if I replied > to it, but instead it posted my reply including its warning. > > Here's my original question, which is indeed about MySQL, although it > does not contain the words "SQL" or "query": > > Is there any reason to prefer a particular order of columns in a > table? > > For example, will SELECTs be faster if the columns are requested in > the same order they exist in the table? Is there a tendency for > columns earlier in the table to be preferred in queries with complex > WHERE clauses, so I should put columns which would be good candidates > for using their index earlier in the database? Is there any inherent > speed difference between earlier and later columns, for example > earlier columns are always at the beginning of the record, and so > won't require as much of the database file to be read to get their > value for each row? [...] -- [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
Re: mySQL and innoDB
Hi. Is there a chance that you make this behaviour dependend on the --ansi switch? I never used foreign keys until now, but from the theory I would expect that a missing "not null" declaration on a FK declaration should either be implicitly assumed or result in an error - at least on insert. I meanwhile see why others databases have softened the foreign key constraint, but I would call accepting NULLs unexpected behaviour from what I have learned about FK. Bye, Benjamin. On Tue, Apr 09, 2002 at 10:22:21PM +0300, [EMAIL PROTECTED] wrote: > Hi! > > >From the changelog of 3.23.50: > > * We suppress the FOREIGN KEY check if any of the column values in the > foreign key or referenced key to be checked is the SQL NULL. This is > compatible with Oracle, for example. > > It is conceptually a bit strange that we first declare a FOREIGN KEY > constraint, but then let a user to slip it through using a NULL value. But, > since we may declare a column as NOT NULL, we can still force full > referential integrity in 3.23.50. [...] -- [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
Re: 200 milions records
On Mon, Apr 08, 2002 at 01:32:59PM +0200, ddd wrote: > HI, > > I want to insert into db 200.000.000 records of type (int6,int6).. > > the structure is: > CREATE TABLE word_page ( >IDword mediumint(6) NOT NULL default '0', >IDpage mediumint(6) NOT NULL default '0', >KEY IDword (IDword) > ) TYPE=MyISAM; > > > What do you think of it,, how would be the speed after then when i > do simple select query ... for example "Select IDpage where > IDword=44" > > What should I do for best performance? We have a similar table (with a few more rows) that has about 270 million rows in it. We add 50,000 - 100,000 per day. Queries are very fast against it. As long as you have a good sized key buffer, you should be okay. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 61 days, processed 1,654,117,497 queries (311/sec. avg) - 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: 200 milions records
On Mon, Apr 08, 2002 at 08:25:01AM -0700, MySQL Newsgroup wrote: > 1. Use PostgreSQL. Why? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 61 days, processed 1,654,104,995 queries (311/sec. avg) - 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 automate bin-log clean-up with replicated MySQL servers?
On Tue, Apr 09, 2002 at 10:15:12AM +0200, paul wrote:
> Hello all,
>
> I have setup a replication between two MySQL v4.01a servers on
> FreeBSD, which works really fine. The only problem is that since we
> have MANY updates on the master database, the bin-logs grow very
> fast. We need to do a manual clean-up at least once every other day,
> otherwise the disk space will get exhausted: "SHOW SLAVE STATUS" on
> the slave, write down the 'Log_File' name, and pass that to "PURGE
> MASTER LOGS TO 'logname'" on the master.
>
> Does anybody have an idea how we could automate this procedure, or
> should we manage the log-files is another way?
Here's a quick home-grown solution that works well for us. It's not
the smartest approach, but we never let a slave get too far behind
(they're all closely monitored), it works qutie well.
This is purge_master_logs:
---snip---
#!/usr/local/bin/perl -w
#
# $Source: /CVSROOT/yahoo/finance/mysql/bin/purge_master_logs,v $
## On a mysql server, purge the replication logs if there are "too
## many" sitting around and sucking up disk space.
$|++;
use strict;
use RunMutex '/tmp/.write_heartbeat.lock';
use DBIx::DWIW;
my $MIN_LOGS = 4; ## keep at least three binary logs around
my $db = DBIx::DWIW->Connect(
DB => "mysql",
User => "root",
Pass => "password",
Host => 'localhost',
);
if (not $db)
{
die "Couldn't connect to database!";
}
my @logs = $db->FlatArray("SHOW MASTER LOGS");
## see if there are enough to bother
if (@logs < $MIN_LOGS)
{
exit;
}
## if so, figure out what the last one we want to kee is
my $last_log = $logs[-$MIN_LOGS];
print "last log is $last_log\n" unless $ENV{CRON};
## and purge the rest
$db->Execute("PURGE MASTER LOGS TO '$last_log'");
exit;
__END__
---snip---
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.47-max: up 61 days, processed 1,654,071,336 queries (311/sec. avg)
-
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
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
libmysqlclient on Darwin/OS X
Heya: in openBSD I have a cli interface for simple i/o to mysql database. Written in C. it works perfectly. On Darwin and OS X it won't compile. It gives the following errors. $ cc -lmysqlclient -I/usr/local/mysql/include testmy.c linklist.c /usr/bin/ld: Undefined symbols: _mysql_close _mysql_error _mysql_fetch_row _mysql_init _mysql_query _mysql_real_connect _mysql_store_result all are defined in libmysql.c ar -t libmysqlclient.a | grep libmysql.o shows that libmysql.o IS indeed in the archive? plainly something is going wrong here, but what? using mysql-darwin-3.23.49 from the link on www.mysql.com Darwin opus.my.localnet 5.3 Darwin Kernel Version 5.3: Thu Jan 24 22:06:02 PST 2002; root:xnu/xnu-201.19.obj~1/RELEASE_PPC Power Macintosh powerpc Thanks kindly -- Liam Allen [EMAIL PROTECTED] it may be that your sole purpose in life is to serve as a warning to others - 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
slow to a crawl
I have one query, that basically reads from one table of 13 million rows, groups it by two fields, and inserts into a rollup table. The result set ends up being about 31,000 rows. This runs in about 2 minutes which is acceptable. However, I add an additional group by field, which will probably result in a million results and mysql goes to a crawl. It doesn't even max out one cpu as the former query does. Instead vmstat reports a process blocked and in wait, while mysql goes down to hardly any cpu. The box lags a tad bit like it's I/O related, but the I/O isn't abnormal. As soon as I use mysqladmin to kill the query everything is back to normal. I'll note the load goes above 3.0 when this is running but none of it's in CPU ... I realize this is very vague, bu I'm just shooting in the dark here wondering if someone has seen similar oddities, and it might be resolvable by tuning some of the parameters. 3.23.49, precompiled from mysql.com 2.4.9-21smp Linux key_buffer=16M table_cache=128 sort_buffer=8M record_buffer=2M tmp_table_size=16M I've tried increasing these but didn't help. - 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: skipping rows after select
Yes there is.. You can use LIMIT keyword to do so. For example to get the records between 3 and 5, you could issue the statement: SELECT * FROM content ORDER BY id LIMIT 2, 3; See: http://www.mysql.com/doc/S/E/SELECT.html Gurhan -Original Message- From: lance turner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 5:08 PM To: [EMAIL PROTECTED] Subject: skipping rows after select After executing a query such as: SELECT * FROM content ORDER BY id I there a SQL query for skipping ahead a certain number of records? Or should this be done as part of the initial query? If so, how? thanks, lance turner - 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
skipping rows after select
After executing a query such as: SELECT * FROM content ORDER BY id I there a SQL query for skipping ahead a certain number of records? Or should this be done as part of the initial query? If so, how? thanks, lance turner - 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: Creating a mysql database usinc VC++
Argh. my email got prematurely sent, sorry. mySQL C++ API is available at http://www.mysql.com/downloads/api-mysql++.html (along with a quick tutorial) Mike -Original Message- From: Mike Grabski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 5:00 PM To: 'Guy-Maurice Lepoutre'; [EMAIL PROTECTED] Subject: RE: Creating a mysql database usinc VC++ You can, using the c++ api -Original Message- From: Guy-Maurice Lepoutre [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 4:30 PM To: [EMAIL PROTECTED] Subject: Creating a mysql database usinc VC++ Hello, I wondered if there is a way to create a mysql database using Visual C++ 6.0. I don't want the database to be registered, I want the program to create the database for me. Thanks a lot for your help. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.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
RE: Creating a mysql database usinc VC++
Hi !! > -Original Message- > From: Christopher Thompson [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 09, 2002 1:39 PM > To: Guy-Maurice Lepoutre; [EMAIL PROTECTED] > Subject: Re: Creating a mysql database usinc VC++ > > > On Tuesday 09 April 2002 2:30 pm, Guy-Maurice Lepoutre wrote: > > Hello, > > > > I wondered if there is a way to create a mysql > > database using Visual C++ 6.0. I don't want the > > database to be registered, I want the program to > > create the database for me. > > Certainly. If by no other way, execute a batch file to do this. > > You cannot, afaik, do this using ODBC. That's a limitation of ODBC. > You only have three options, which uses ODBC internally. 1. Making use of direct VC Database project: Just create a VC project called 'Database project' (under new -> projects), upon entering the project name, it displays the ODBC DSN dialog, and you can continue from their by extending the code. 2. Making use of MFC ODBC (Direct) Classes: Another option is, write your own code using MFC ODBC classes. For more information, refer to MSDN under 'CDatabase' class, which directs you in the right path. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vcmfc98/htm l/_mfc_cdatabase.asp 3. Making use of MFC DAO(CDAO*) classes. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vcmfc98/htm l/_mfc_cdaoworkspace.asp Hope this helps you. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ 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
RE: Creating a mysql database usinc VC++
You can, using the c++ api -Original Message- From: Guy-Maurice Lepoutre [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 4:30 PM To: [EMAIL PROTECTED] Subject: Creating a mysql database usinc VC++ Hello, I wondered if there is a way to create a mysql database using Visual C++ 6.0. I don't want the database to be registered, I want the program to create the database for me. Thanks a lot for your help. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.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: Creating a mysql database usinc VC++
On Tuesday 09 April 2002 2:30 pm, Guy-Maurice Lepoutre wrote: > Hello, > > I wondered if there is a way to create a mysql > database using Visual C++ 6.0. I don't want the > database to be registered, I want the program to > create the database for me. Certainly. If by no other way, execute a batch file to do this. You cannot, afaik, do this using ODBC. That's a limitation of ODBC. - 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
Creating a mysql database usinc VC++
Hello, I wondered if there is a way to create a mysql database using Visual C++ 6.0. I don't want the database to be registered, I want the program to create the database for me. Thanks a lot for your help. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.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
[net_serv.o] Error 1
When compiling Mysql on a Dec 3000 OSF1 V4.0 I get the following error:
...
net_serv.cc:421" macro ' thr_alarm' used with to many {3} args
Make[3]: [net_serv.o] Error 1
I've used this to configure, but changes the O3 to O like other
documentation has said to do:
env CC="cc -pthread" CFLAGS="-I./include -DDONT_USE_THR_ALARM" CXX=gcc \
CXXFLAGS="-O3 -DDONT_USE_THR_ALARM" ./configure --with-low-memory \
--with-named-thread-libs="-lpthread -lmach -lexc"
And then I just run make.. Anyone know what I could do to fix this? The
machine has 64 Megs of RAM, and it's not giving me the OUt of Virtual
Memory error that seems to be the only other problem I've found out there
with this.
I've also upgraded Make, gcc , and bison to the newest versions.
Thanks,
Cj B
[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
RE: MyODBC on win98
Hi !!! > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 09, 2002 12:40 PM > To: [EMAIL PROTECTED] > Subject: MyODBC on win98 > > > hi, > i'd like to know which ODBC driver is most suitable, fast and reliable for > win98. > I tried myodbc 2.50.39, but the dll was faulty, i had to replace it by the > 2.50.36(on win2k!). > On win98 now am using the latest 3.51.01, but it has slown down > the machine > so much, it's incredible. > So now am using on both OS Mysql 3.23.49 as well as: > -2.50.36 with Borland BDE 3.0 on win2k > -3.51.01 with Borland BDE 3.0 on win98 > Can anybody advice me on the best ODBC drivers to use to get the maximum > speed of it. > Thanx Better to use 2.50.39 only. If you want all features with ODBC 3.x spec, then use 3.51.02. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ 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
RE: download latest odbc-driver
Hi !! > -Original Message- > From: Ralph Walther [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 09, 2002 12:43 PM > To: [EMAIL PROTECTED] > Subject: download latest odbc-driver > > > hi, > if i try to download the latest odbc driver i get a file with 43k. what > is wrong ? the original file on > http://www.mysql.com/downloads/api-myodbc-3.51.html is over 602K... > > what have i to do? > It should be ~600k only. Please try from another mirror, and if nothing works out try from ftp. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ 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
Re: MD5
On Tuesday 09 April 2002 2:13 pm, Andrew Hazen wrote: > Hi, > Can I use the MD5 function in the where clause, as in: > > Select * from table where md5(column)=value > I see no reason why not but note that you are likely MUCH better off storing column as an MD5 hash, computing the MD5 of value, and then doing your select on that. That way, you won't have to calculate an MD5 value n times, where n is the number of rows in your table. sql filter daemon sucks. - 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
MD5
Hi, Can I use the MD5 function in the where clause, as in: Select * from table where md5(column)=value spam filter: mysql Andrew Hazen - 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: Re: Uninstall Mysql
Kathy, Tuesday, April 09, 2002, 5:43:23 PM, you wrote: KR> I am using Linux 7.2 OS. KR> I think reseting the root password fixed it. Because I was no able to log KR> in. Ok, try to reset root password according to step-by-step instruction in the manual. Don't forget execute FLUSH PRIVILEGES _before_ using GRANT statement. KR> I'm not really running any queries to the mysql database that why i'm not KR> sure whats causing this problem. KR> I also cant figure out why when I type mysql it doesnt doesnt use the KR> password and I alway have to type mysql -u root -p and then password. What error did you receive? KR> - Original Message - KR> From: "Victoria Reznichenko" <[EMAIL PROTECTED]> KR> To: <[EMAIL PROTECTED]> KR> Sent: Tuesday, April 09, 2002 10:00 AM KR> Subject: Re: Uninstall Mysql >> Kathy, >> Monday, April 08, 2002, 10:10:04 PM, you wrote: >> >> KR> Can anyone tell me how can I uninstall mysql. I have done it again. I >> KR> have >> KR> messed up my permission. >> KR> I dont know what is is that i'm doing that makes me loose my >> KR> previleges. >> KR> I keep getting the access denied error >> >> Before uninstalling MySQL server you can >> 1. reset root password, look at: >>http://www.mysql.com/doc/R/e/Resetting_permissions.html >> >> 2. re-create grant tables, look at: >>http://www.mysql.com/doc/m/y/mysql_install_db.html >> >> And about the MySQL server uninstallation, tell me, what OS do you use? >> >> KR> Kathy Reyes -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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
Re: Column order
Sorry, this came out ugly. I misinterpreted the list filter's comments, and thought it would post my original message if I replied to it, but instead it posted my reply including its warning. Here's my original question, which is indeed about MySQL, although it does not contain the words "SQL" or "query": Is there any reason to prefer a particular order of columns in a table? For example, will SELECTs be faster if the columns are requested in the same order they exist in the table? Is there a tendency for columns earlier in the table to be preferred in queries with complex WHERE clauses, so I should put columns which would be good candidates for using their index earlier in the database? Is there any inherent speed difference between earlier and later columns, for example earlier columns are always at the beginning of the record, and so won't require as much of the database file to be read to get their value for each row? Thanks for any tuning tips along these lines; I'll do some benchmarks tonight, but I was hoping somebody already knew this stuff and could point me in the right direciton. ScottG. - 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
download latest odbc-driver
hi, if i try to download the latest odbc driver i get a file with 43k. what is wrong ? the original file on http://www.mysql.com/downloads/api-myodbc-3.51.html is over 602K... what have i to do? - 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: Column order
References: <[EMAIL PROTECTED]> From: Scott Gifford <[EMAIL PROTECTED]> Date: 09 Apr 2002 15:40:38 -0400 In-Reply-To: [EMAIL PROTECTED]'s message of "Tue, 9 Apr 2002 21:28:35 +0200" Message-ID: <[EMAIL PROTECTED]> Lines: 33 User-Agent: Gnus/5.0807 (Gnus v5.8.7) Emacs/20.7 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii [EMAIL PROTECTED] writes: > 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 in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. Just typing the word MySQL once will be sufficient, for example. > > You have written the following: > > Is there any reason to prefer a particular order of columns in the > table? > > For example, will SELECTs be faster if the columns are requested in > the same order they exist in the table? Is there a tendency for > columns earlier in the table to be preferred in queries with complex > WHERE clauses, so I should put columns which would be good candidates > for using their index earlier in the database? Is there any inherent > speed difference between earlier and later columns, for example > earlier columns are always at the beginning of the record, and so > won't require as much of the database file to be read to get their > value for each row? > > Thanks for any tuning tips along these lines; I'll do some benchmarks > tonight, but I was hoping somebody already knew this stuff and could > point me in the right direciton. > > ScottG. - 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
MyODBC on win98
hi, i'd like to know which ODBC driver is most suitable, fast and reliable for win98. I tried myodbc 2.50.39, but the dll was faulty, i had to replace it by the 2.50.36(on win2k!). On win98 now am using the latest 3.51.01, but it has slown down the machine so much, it's incredible. So now am using on both OS Mysql 3.23.49 as well as: -2.50.36 with Borland BDE 3.0 on win2k -3.51.01 with Borland BDE 3.0 on win98 Can anybody advice me on the best ODBC drivers to use to get the maximum speed of it. Thanx - 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: mySQL and innoDB
Hi!
>From the changelog of 3.23.50:
* We suppress the FOREIGN KEY check if any of the column values in the
foreign key or referenced key to be checked is the SQL NULL. This is
compatible with Oracle, for example.
It is conceptually a bit strange that we first declare a FOREIGN KEY
constraint, but then let a user to slip it through using a NULL value. But,
since we may declare a column as NOT NULL, we can still force full
referential integrity in 3.23.50.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
- Original Message -
From: ""Alain Del Giust"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, April 09, 2002 7:59 PM
Subject: Re: mySQL and innoDB
> "if you have a foreign key constraint, that field must be one of the
values
> of the referenced column and that column, being an index, is never NULL"
>
> OK so my understanding is that it is impossible with mySQL to do such
things
> wich are basic with at least:
> Oracle
> Sybase Adaptive Server Enterprise
> Sybase Adaptive Server Anywhere
>
> Thanks,
>
> Alain
>
> - Original Message -
> From: "Rance Hall" <[EMAIL PROTECTED]>
> To: "Alain Del Giust" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Tuesday, April 09, 2002 6:42 PM
> Subject: RE: mySQL and innoDB
>
>
> well, your right about one thing, I did misread the order of your SQL
> statement, but if you have a foreign key constraint, that field must be
one
> of the values of the referenced column, and that column, being an index,
is
> never NULL
>
> so inserting NULL into a properly configured foreign key column should
fail
>
> inserting anything into that column that isn't in the referenced column
> should fail, and it does.
>
> so my apologies for my mistake from earlier
>
> Rance Hall
> 308.238.2455
> Internal Office Extensions: 2455 or 6655
> PC Programmer, The Buckle, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 11:45 AM
> To: Rance Hall; [EMAIL PROTECTED]
> Subject: Re: mySQL and innoDB
>
>
> Nope
>
> insert into b values ('BBB',null);
> here:
>BBB is PK of table b
>null is FK of table b referencing table a
>
> for example
> insert into b values ('BBB','aaa');
> works well
>
> Alain
>
> - Original Message -
> From: "Rance Hall" <[EMAIL PROTECTED]>
> To: "Alain Del Giust" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Tuesday, April 09, 2002 6:25 PM
> Subject: RE: mySQL and innoDB
>
>
> The "insert into b values ('BBB', NULL)" statement should fail under the
> conditions you describe, BBB was not inserted into the A table, and
> therefore the foreign key constraint fails as it should.
>
>
> Rance Hall
> 308.238.2455
> Internal Office Extensions: 2455 or 6655
> PC Programmer, The Buckle, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 11:28 AM
> To: [EMAIL PROTECTED]
> Subject: mySQL and innoDB
>
>
> Hi all,
>
> I am pretty new to mySQL actually I started yesterday.
> mySQL with innoDB handles integrity constraints.
> I tried :
>
> create table a (
> id varchar(3) not null,
>primary key(id) )
> TYPE=INNODB;
>
> insert into a values ('aaa');
>
> create table b (
> id varchar(3) not null,
> a_id varchar(3),
> index idx_b_a_id (a_id), foreign key (a_id) references a (id),
> primary key(id) )
> TYPE=INNODB;
>
> insert into b values ('AAA','aaa');
>
> insert into b values ('BBB',null);
>
> the last statment doesn't work ... ERROR 1216: Cannot add a child row: a
> foreign key constraint fails
>
> I am using mySQL version 3.23.49 (and 4.0.1-alpha) on win2Ksp2
> "mysqld-max --standalone --console"
>
> Thanks,
>
> Alain
>
>
>
> -
> 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 u
RE: InnoDB tables
FOREIGN KEYs by themselves make it faster and easier to validate that your code is correctly maintaining referrential integrity. They also let O/R mappers do more of the work in generating code for accessing your data (Blatant Plug: http://freshmeat.net/projects/easyorm/ -- EasyORM is an O/R mapper that introspects a MySQL DB and generates PHP code (eventually it'll also do Java (JDBC and EJB) and Perl.), and uses "hints" from an XML document you provide to build object-oriented code to access your schema. It's really crude right now -- the version in development is vastly more robust -- but we're using it successfully in our production environment.) FOREIGN KEYs combined with CASCADE ON DELETE/UPDATE (which InnoDB does not support yet) make it easier to write correct code: It manages changes/removals of dependant objects so you don't have to even think about it, let alone code it. -JF > -Original Message- > From: Richard Clarke [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 09, 2002 5:11 AM > To: [EMAIL PROTECTED] > Subject: Re: InnoDB tables > > > Luke, > > How exactly will the foreign keys save you time? Please explain. > > Ric. > > - Original Message - > From: "Luke van Blerk" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, April 09, 2002 9:17 AM > Subject: InnoDB tables > > > > Hi everyone, > > > > I've been reading up about InnoDB tables and they seem to have lots of > > advantages. I'm particularly interested in using the foreign > keys as this > > will save me some much need time. In the benchmark tests on the InnoDB > > website they show up faster than MyISAM tables but will foreign > keys have > a > > slow down effect? And are there any issues I need to know about before > > switching to InnoDB tables? > > > > Thanks in advance > > Luke van Blerk > > > > mysql > > > > > > - > > 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
RE: mySQL and innoDB
> -Original Message-
> From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 12:48 PM
> To: Christopher Thompson; [EMAIL PROTECTED]
> Cc: Rance Hall
> Subject: Re: mySQL and innoDB
>
>
> I am just testing mySQL so I will be able to use it instead
> of Oracle Sybase
> ...
>
> I am not saying a PK can be NULL wich is impossible
> But a FK can be NULL and I'd like to know how to do that with mySQL
>
>
> A concrete example could be:
>
> table employee
> column 1 : employee_id - primary key
> column 2 : employee_name - name of the employee
>
> table hierarchy
> column 1 : hierarchy_id - primary key
> column 2 : hierarchy_employee_id_son - a foreign key referencing
> employee.employee_id
> column 3 : hierarchy_employee_id_father- a foreign key referencing
> employee.employee_id
>
>
> Now I want to use that:
>
> I have 6 employee
> employeeA
> employeeB
> employeeC
> employeeD
> employeeE
> employeeF
>
> I have 2 hierarchies X and Y
>
> For hierachie X
> employeeA is the manager of employee C
> employeeC is the manager of employee F
>
> For hierachie Y
> employeeB is the manager of employee D and E
>
> So i have in my tables
>
> insert into table employee values ('A','employeeA');
> insert into table employee values ('B','employeeB');
> insert into table employee values ('C','employeeC');
> insert into table employee values ('D','employeeD');
> insert into table employee values ('E','employeeE');
> insert into table employee values ('F','employeeF');
>
> insert into table hierarchy values ('X','A',NULL);
> insert into table hierarchy values ('X','C','A');
> insert into table hierarchy values ('X','F','C');
> insert into table hierarchy values ('X','B',NULL);
> insert into table hierarchy values ('X','D','B');
> insert into table hierarchy values ('X','E','B');
>
> The employee who is at the top of the hierarchy as no manager ...
> so for A and B in the hierarchy table the foreign key referencing
> employee.employee_id is NULL
>
> Alain
>
I dont see where what you are doing is allowed, and I think Chris mentioned it in
another note
But, Now I see where you are going, and I can think of Two different ideas
1. If the employee is a supervisor, then let him supervise himself/herself and
populate the field accordingly
2. Create a supervisor field in the employee table, and programmatically enforce that
an employees supervisor be in the select group of supervisor = yes employees
-
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: InnoDB
Carl, when it runs out of disk space the auto-extend feature prints to the MySQL error log a complaint that disk space has run out, and stops extending the file. If you do not give it more free disk space, InnoDB behaves as if it would have a fixed size data file. That is, you will get the 'Table is full' errors. But when you give it more disk space, auto-extension continues. I have not tested what happens on those file systems where max file size is 2 GB. If you run on such a file system, best to specify ibdata1:10M:autoextend:max:2000M Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message - From: "Carl McNamee" <[EMAIL PROTECTED]> To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 4:53 PM Subject: RE: InnoDB > Heiki, > > I have a question concerning the new auto-extending function (which sounds > really cool by the way!). How does it handle the case where it runs out of > disk space while expanding? Will it gracefully handle this scenerio or will > some sort of recovery be necessary? > > Carl McNamee > Systems Administrator > Billing Concepts > (210) 949-7282 > > > >The auto-extending data file of InnoDB-3.23.50 will solve your problem. No > >need to preallocate tablespace any more. > >Best regards, > > >Heikki Tuuri > >Innobase Oy - 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: mySQL and innoDB
On Tuesday 09 April 2002 11:47 am, Alain Del Giust wrote: > I am just testing mySQL so I will be able to use it instead of Oracle > Sybase ... > > I am not saying a PK can be NULL wich is impossible > But a FK can be NULL and I'd like to know how to do that with mySQL I do not see this as being allowed in SQL92. In fact, my documentation says specifically that it is not allowed. That said, I understand now why you would want to do this. It seems to me that perhaps you just want to do without a foreign key and enforce the constraint programmatically? - 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: mySQL and innoDB
I am just testing mySQL so I will be able to use it instead of Oracle Sybase
...
I am not saying a PK can be NULL wich is impossible
But a FK can be NULL and I'd like to know how to do that with mySQL
A concrete example could be:
table employee
column 1 : employee_id - primary key
column 2 : employee_name - name of the employee
table hierarchy
column 1 : hierarchy_id - primary key
column 2 : hierarchy_employee_id_son - a foreign key referencing
employee.employee_id
column 3 : hierarchy_employee_id_father- a foreign key referencing
employee.employee_id
Now I want to use that:
I have 6 employee
employeeA
employeeB
employeeC
employeeD
employeeE
employeeF
I have 2 hierarchies X and Y
For hierachie X
employeeA is the manager of employee C
employeeC is the manager of employee F
For hierachie Y
employeeB is the manager of employee D and E
So i have in my tables
insert into table employee values ('A','employeeA');
insert into table employee values ('B','employeeB');
insert into table employee values ('C','employeeC');
insert into table employee values ('D','employeeD');
insert into table employee values ('E','employeeE');
insert into table employee values ('F','employeeF');
insert into table hierarchy values ('X','A',NULL);
insert into table hierarchy values ('X','C','A');
insert into table hierarchy values ('X','F','C');
insert into table hierarchy values ('X','B',NULL);
insert into table hierarchy values ('X','D','B');
insert into table hierarchy values ('X','E','B');
The employee who is at the top of the hierarchy as no manager ...
so for A and B in the hierarchy table the foreign key referencing
employee.employee_id is NULL
Alain
- Original Message -
From: "Christopher Thompson" <[EMAIL PROTECTED]>
To: "Alain Del Giust" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 7:04 PM
Subject: Re: mySQL and innoDB
> On Tuesday 09 April 2002 11:07 am, Alain Del Giust wrote:
> > "if you have a foreign key constraint, that field must be one of the
values
> > of the referenced column and that column, being an index, is never NULL"
> >
> > OK so my understanding is that it is impossible with mySQL to do such
> > things wich are basic with at least:
> > Oracle
> > Sybase Adaptive Server Enterprise
> > Sybase Adaptive Server Anywhere
>
> What are you saying? If you are saying these databases allow a primary
key
> column (or a unique key column) to contain a NULL, they are violating
SQL92.
> By extension, any column that is a foreign key can also not be NULL.
>
> Perhaps you are saying something else. But if you are saying this, you
can
> hardly take MySQL to task for properly supporting SQL92 (at least, in this
> instance).
>
-
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 check which version of mysql is installed
Hi, Try with SELECT VEERSION() from mysql client. - Original Message - From: Jianping Zhu <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 9:55 AM Subject: How to check which version of mysql is installed > > I have a redhat 7.1 server, I want to get rid of the installed mysql > server. How can check which version is installed and how to get rid of it? > > Thanks > > > Jianping Zhu > Department of Computer Science > Univerity of Georgia > Athens, GA 30602 > Tel 706 5423900 > > > > - > 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: mySQL and innoDB
Well, I know I'm gonna catch flak for this, but oh well, here goes anyway I send an off list mail to Alain to ask for some more specific information about what he is trying to do so that we can find a way to do it. But this I will say to the whole list... What is the point of setting up a referential integrity constraint just to exploit it in the way Alain described? Given what the manual says about the limitations of these type of constraints (at least so far) seems to me that it is not desirable to use them. While I know that NULL is by definition a part of every column (just like in set theory math where you have the null set is a subset of every set), NULL is not rendered as an actual entry in any column when looking at the output of any select * or similar SQL statement. Clearly NULL is both there and not there at the same time, and it depends greatly on context which understanding is used for any given command. >From a very practical standpoint, I think that the output Alain described is >desirable in over 90% of implementation ideas (and 100% desirable in all of my >previous implementations) Standards be what Standards be, but standards can be either changed or ignored, depending on if it benefits one to do so. This is especially true when dealing with NULL, heck, some databases don't even support the NULL concept at all Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] -Original Message- From: Christopher Thompson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 12:05 PM To: Alain Del Giust; [EMAIL PROTECTED] Subject: Re: mySQL and innoDB On Tuesday 09 April 2002 11:07 am, Alain Del Giust wrote: > "if you have a foreign key constraint, that field must be one of the values > of the referenced column and that column, being an index, is never NULL" > > OK so my understanding is that it is impossible with mySQL to do such > things wich are basic with at least: > Oracle > Sybase Adaptive Server Enterprise > Sybase Adaptive Server Anywhere What are you saying? If you are saying these databases allow a primary key column (or a unique key column) to contain a NULL, they are violating SQL92. By extension, any column that is a foreign key can also not be NULL. Perhaps you are saying something else. But if you are saying this, you can hardly take MySQL to task for properly supporting SQL92 (at least, in this instance). - 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: Problems with Mac OS X
At 10:14 -0700 4/9/02, Jim Dickenson wrote: > >> This still leaves the question as to when version 3.23.49a will >be compiled >>> for Mac OS X, instead of version 3.23.47. >> >> I always compile my own. Is there some reason you don't do that? > > >There are many messages on this list that say "use the binary from MySQL". >It makes since to me to use "official" binaries so I do not end up with >unique problems because of some option or compiler difference. Sure, but given the fact that the binary available doesn't run on your system, I was simply pointing out that it's possible to compile it yourself. > >I was just wondering why there is a version 3.23.49 that maybe runs on Mac >OS X server but not one that runs on regular Mac OS X. I reported the >missing library if I try to use the 3.23.49 version intended for server. - 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: Problems with Mac OS X
On 4/9/2002 9:41 AM, "Paul DuBois" <[EMAIL PROTECTED]> wrote: > At 9:31 -0700 4/9/02, Jim Dickenson wrote: >> On 4/8/2002 7:25 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote: >> >>> At 17:52 -0700 4/8/02, Jim Dickenson wrote: I am having problems getting the "load data local infile" working. I am running Mac OS X 10.1.3 build 5Q110 with all available updates installed. I had installed version 3.23.49 from http://www.entropy.ch/software/macosx/mysql/ and found that a change was made in verion 3.23.49 as related to the use of local files. I added --local-infile=1 when I run mysql and the command was accepted. The problem I was then having is that if I issued the following command load data local infile 'mt2308.dat' into table mt2308 ; mt2308.dat was not found. I had to specify the fully qualified file name for the command to work. This is a change from the way it used to work as I recall. It was the case that at one time this command would find the file if the file was in the current working directory. >>> >>> I don't have any problem with unqualified filenames under Mac OS X. >>> Still works like it used to. >>> >>> Perhaps --local-infiile=1 isn't actually having any effect, so the server >>> is still really reading the file. Do you have the FILE privilege? If >>> so, that might be the case. You can test that by making the file mode >>> 600 so it's readable only to you, and then loading the file with the >>> full pathname. If that's what's happening, the server will no longer >>> be able to read it. (Assuming it doesn't run as you.) >>> >>> I suppose another possibility is that you're not really running mysql >>> in the same directory where the file is located, although that seems >>> unlikely -- unless maybe "mysql" is actually aliases to something >>> weird. >>> >> >> I had some other version of mysql executables in /usr/local/bin so I was not >> running the application I thought I was. Thanks for making me look at what >> really got executed when I said mysql. > > Heh. Wait until you start running about 10 different versions. :-) > >> >> I then went to www.mysql.com and looked at what binary distributions were there for Mac OS X. First I downloaded version 3.23.49 but when I tried to run that version /usr/lib/libpthread.A.dylib was not found. I could not find where I could get this library. I then picked up version 3.23.47 and although I did not need to use --local-infile=1 the file was not find unless I specified the fully qualified file name. Two questions. First, what can I do to get the MySQL version 3.23.49 working on my system so I have the current version of the software? Second, what can be done so I do not need to specify the fully qualified file name? >> >> >> This still leaves the question as to when version 3.23.49a will be compiled >> for Mac OS X, instead of version 3.23.47. > > I always compile my own. Is there some reason you don't do that? There are many messages on this list that say "use the binary from MySQL". It makes since to me to use "official" binaries so I do not end up with unique problems because of some option or compiler difference. I was just wondering why there is a version 3.23.49 that maybe runs on Mac OS X server but not one that runs on regular Mac OS X. I reported the missing library if I try to use the 3.23.49 version intended for server. -- Jim Dickenson mailto:[EMAIL PROTECTED] Computers for Marketing Corporation http://www.cfmc.com/ eFax: 1-419-791-8924 - 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: mySQL and innoDB
On Tuesday 09 April 2002 11:07 am, Alain Del Giust wrote: > "if you have a foreign key constraint, that field must be one of the values > of the referenced column and that column, being an index, is never NULL" > > OK so my understanding is that it is impossible with mySQL to do such > things wich are basic with at least: > Oracle > Sybase Adaptive Server Enterprise > Sybase Adaptive Server Anywhere What are you saying? If you are saying these databases allow a primary key column (or a unique key column) to contain a NULL, they are violating SQL92. By extension, any column that is a foreign key can also not be NULL. Perhaps you are saying something else. But if you are saying this, you can hardly take MySQL to task for properly supporting SQL92 (at least, in this instance). - 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: mySQL and innoDB
"if you have a foreign key constraint, that field must be one of the values
of the referenced column and that column, being an index, is never NULL"
OK so my understanding is that it is impossible with mySQL to do such things
wich are basic with at least:
Oracle
Sybase Adaptive Server Enterprise
Sybase Adaptive Server Anywhere
Thanks,
Alain
- Original Message -
From: "Rance Hall" <[EMAIL PROTECTED]>
To: "Alain Del Giust" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 6:42 PM
Subject: RE: mySQL and innoDB
well, your right about one thing, I did misread the order of your SQL
statement, but if you have a foreign key constraint, that field must be one
of the values of the referenced column, and that column, being an index, is
never NULL
so inserting NULL into a properly configured foreign key column should fail
inserting anything into that column that isn't in the referenced column
should fail, and it does.
so my apologies for my mistake from earlier
Rance Hall
308.238.2455
Internal Office Extensions: 2455 or 6655
PC Programmer, The Buckle, Inc.
[EMAIL PROTECTED]
-Original Message-
From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 11:45 AM
To: Rance Hall; [EMAIL PROTECTED]
Subject: Re: mySQL and innoDB
Nope
insert into b values ('BBB',null);
here:
BBB is PK of table b
null is FK of table b referencing table a
for example
insert into b values ('BBB','aaa');
works well
Alain
- Original Message -
From: "Rance Hall" <[EMAIL PROTECTED]>
To: "Alain Del Giust" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 6:25 PM
Subject: RE: mySQL and innoDB
The "insert into b values ('BBB', NULL)" statement should fail under the
conditions you describe, BBB was not inserted into the A table, and
therefore the foreign key constraint fails as it should.
Rance Hall
308.238.2455
Internal Office Extensions: 2455 or 6655
PC Programmer, The Buckle, Inc.
[EMAIL PROTECTED]
-Original Message-
From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 11:28 AM
To: [EMAIL PROTECTED]
Subject: mySQL and innoDB
Hi all,
I am pretty new to mySQL actually I started yesterday.
mySQL with innoDB handles integrity constraints.
I tried :
create table a (
id varchar(3) not null,
primary key(id) )
TYPE=INNODB;
insert into a values ('aaa');
create table b (
id varchar(3) not null,
a_id varchar(3),
index idx_b_a_id (a_id), foreign key (a_id) references a (id),
primary key(id) )
TYPE=INNODB;
insert into b values ('AAA','aaa');
insert into b values ('BBB',null);
the last statment doesn't work ... ERROR 1216: Cannot add a child row: a
foreign key constraint fails
I am using mySQL version 3.23.49 (and 4.0.1-alpha) on win2Ksp2
"mysqld-max --standalone --console"
Thanks,
Alain
-
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: mySQL and innoDB
... but the key NULL does not exist on the table a, but it should!!!
Adib.
Alain Del Giust wrote:
> Nope
>
> insert into b values ('BBB',null);
> here:
>BBB is PK of table b
>null is FK of table b referencing table a
>
> for example
> insert into b values ('BBB','aaa');
> works well
>
> Alain
>
> - Original Message -
> From: "Rance Hall" <[EMAIL PROTECTED]>
> To: "Alain Del Giust" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Tuesday, April 09, 2002 6:25 PM
> Subject: RE: mySQL and innoDB
>
>
> The "insert into b values ('BBB', NULL)" statement should fail under the
> conditions you describe, BBB was not inserted into the A table, and
> therefore the foreign key constraint fails as it should.
>
>
> Rance Hall
> 308.238.2455
> Internal Office Extensions: 2455 or 6655
> PC Programmer, The Buckle, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 11:28 AM
> To: [EMAIL PROTECTED]
> Subject: mySQL and innoDB
>
>
> Hi all,
>
> I am pretty new to mySQL actually I started yesterday.
> mySQL with innoDB handles integrity constraints.
> I tried :
>
> create table a (
> id varchar(3) not null,
>primary key(id) )
> TYPE=INNODB;
>
> insert into a values ('aaa');
>
> create table b (
> id varchar(3) not null,
> a_id varchar(3),
> index idx_b_a_id (a_id), foreign key (a_id) references a (id),
> primary key(id) )
> TYPE=INNODB;
>
> insert into b values ('AAA','aaa');
>
> insert into b values ('BBB',null);
>
> the last statment doesn't work ... ERROR 1216: Cannot add a child row: a
> foreign key constraint fails
>
> I am using mySQL version 3.23.49 (and 4.0.1-alpha) on win2Ksp2
> "mysqld-max --standalone --console"
>
> Thanks,
>
> Alain
>
>
>
> -
> 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
RE: mySQL and innoDB
well, your right about one thing, I did misread the order of your SQL statement, but
if you have a foreign key constraint, that field must be one of the values of the
referenced column, and that column, being an index, is never NULL
so inserting NULL into a properly configured foreign key column should fail
inserting anything into that column that isn't in the referenced column should fail,
and it does.
so my apologies for my mistake from earlier
Rance Hall
308.238.2455
Internal Office Extensions: 2455 or 6655
PC Programmer, The Buckle, Inc.
[EMAIL PROTECTED]
-Original Message-
From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 11:45 AM
To: Rance Hall; [EMAIL PROTECTED]
Subject: Re: mySQL and innoDB
Nope
insert into b values ('BBB',null);
here:
BBB is PK of table b
null is FK of table b referencing table a
for example
insert into b values ('BBB','aaa');
works well
Alain
- Original Message -
From: "Rance Hall" <[EMAIL PROTECTED]>
To: "Alain Del Giust" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 6:25 PM
Subject: RE: mySQL and innoDB
The "insert into b values ('BBB', NULL)" statement should fail under the
conditions you describe, BBB was not inserted into the A table, and
therefore the foreign key constraint fails as it should.
Rance Hall
308.238.2455
Internal Office Extensions: 2455 or 6655
PC Programmer, The Buckle, Inc.
[EMAIL PROTECTED]
-Original Message-
From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 11:28 AM
To: [EMAIL PROTECTED]
Subject: mySQL and innoDB
Hi all,
I am pretty new to mySQL actually I started yesterday.
mySQL with innoDB handles integrity constraints.
I tried :
create table a (
id varchar(3) not null,
primary key(id) )
TYPE=INNODB;
insert into a values ('aaa');
create table b (
id varchar(3) not null,
a_id varchar(3),
index idx_b_a_id (a_id), foreign key (a_id) references a (id),
primary key(id) )
TYPE=INNODB;
insert into b values ('AAA','aaa');
insert into b values ('BBB',null);
the last statment doesn't work ... ERROR 1216: Cannot add a child row: a
foreign key constraint fails
I am using mySQL version 3.23.49 (and 4.0.1-alpha) on win2Ksp2
"mysqld-max --standalone --console"
Thanks,
Alain
-
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: Problems with Mac OS X
At 9:31 -0700 4/9/02, Jim Dickenson wrote: >On 4/8/2002 7:25 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote: > >> At 17:52 -0700 4/8/02, Jim Dickenson wrote: >>> I am having problems getting the "load data local infile" working. >>> >>> I am running Mac OS X 10.1.3 build 5Q110 with all available updates >>> installed. >>> >>> I had installed version 3.23.49 from >>> http://www.entropy.ch/software/macosx/mysql/ and found that a change was >>> made in verion 3.23.49 as related to the use of local files. I added >>> --local-infile=1 when I run mysql and the command was accepted. The problem >>> I was then having is that if I issued the following command >>> >>> load data local infile 'mt2308.dat' into table mt2308 ; >>> >>> mt2308.dat was not found. I had to specify the fully qualified >>>file name for >>> the command to work. This is a change from the way it used to work as I >>> recall. It was the case that at one time this command would find >>>the file if >>> the file was in the current working directory. >> >> I don't have any problem with unqualified filenames under Mac OS X. >> Still works like it used to. >> >> Perhaps --local-infiile=1 isn't actually having any effect, so the server >> is still really reading the file. Do you have the FILE privilege? If >> so, that might be the case. You can test that by making the file mode >> 600 so it's readable only to you, and then loading the file with the >> full pathname. If that's what's happening, the server will no longer >> be able to read it. (Assuming it doesn't run as you.) >> >> I suppose another possibility is that you're not really running mysql >> in the same directory where the file is located, although that seems >> unlikely -- unless maybe "mysql" is actually aliases to something >> weird. >> > >I had some other version of mysql executables in /usr/local/bin so I was not >running the application I thought I was. Thanks for making me look at what >really got executed when I said mysql. Heh. Wait until you start running about 10 different versions. :-) > > >>> >>> I then went to www.mysql.com and looked at what binary distributions were >>> there for Mac OS X. First I downloaded version 3.23.49 but when I tried to >>> run that version /usr/lib/libpthread.A.dylib was not found. I >>>could not find >>> where I could get this library. >>> >>> I then picked up version 3.23.47 and although I did not need to use >>> --local-infile=1 the file was not find unless I specified the fully >>> qualified file name. >>> >>> Two questions. First, what can I do to get the MySQL version >>>3.23.49 working >>> on my system so I have the current version of the software? >>>Second, what can >>> be done so I do not need to specify the fully qualified file name? >>> > > >This still leaves the question as to when version 3.23.49a will be compiled >for Mac OS X, instead of version 3.23.47. I always compile my own. Is there some reason you don't do that? - 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: mySQL and innoDB
Nope
insert into b values ('BBB',null);
here:
BBB is PK of table b
null is FK of table b referencing table a
for example
insert into b values ('BBB','aaa');
works well
Alain
- Original Message -
From: "Rance Hall" <[EMAIL PROTECTED]>
To: "Alain Del Giust" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 6:25 PM
Subject: RE: mySQL and innoDB
The "insert into b values ('BBB', NULL)" statement should fail under the
conditions you describe, BBB was not inserted into the A table, and
therefore the foreign key constraint fails as it should.
Rance Hall
308.238.2455
Internal Office Extensions: 2455 or 6655
PC Programmer, The Buckle, Inc.
[EMAIL PROTECTED]
-Original Message-
From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 11:28 AM
To: [EMAIL PROTECTED]
Subject: mySQL and innoDB
Hi all,
I am pretty new to mySQL actually I started yesterday.
mySQL with innoDB handles integrity constraints.
I tried :
create table a (
id varchar(3) not null,
primary key(id) )
TYPE=INNODB;
insert into a values ('aaa');
create table b (
id varchar(3) not null,
a_id varchar(3),
index idx_b_a_id (a_id), foreign key (a_id) references a (id),
primary key(id) )
TYPE=INNODB;
insert into b values ('AAA','aaa');
insert into b values ('BBB',null);
the last statment doesn't work ... ERROR 1216: Cannot add a child row: a
foreign key constraint fails
I am using mySQL version 3.23.49 (and 4.0.1-alpha) on win2Ksp2
"mysqld-max --standalone --console"
Thanks,
Alain
-
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: Problems with Mac OS X
On 4/8/2002 7:25 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote: > At 17:52 -0700 4/8/02, Jim Dickenson wrote: >> I am having problems getting the "load data local infile" working. >> >> I am running Mac OS X 10.1.3 build 5Q110 with all available updates >> installed. >> >> I had installed version 3.23.49 from >> http://www.entropy.ch/software/macosx/mysql/ and found that a change was >> made in verion 3.23.49 as related to the use of local files. I added >> --local-infile=1 when I run mysql and the command was accepted. The problem >> I was then having is that if I issued the following command >> >> load data local infile 'mt2308.dat' into table mt2308 ; >> >> mt2308.dat was not found. I had to specify the fully qualified file name for >> the command to work. This is a change from the way it used to work as I >> recall. It was the case that at one time this command would find the file if >> the file was in the current working directory. > > I don't have any problem with unqualified filenames under Mac OS X. > Still works like it used to. > > Perhaps --local-infiile=1 isn't actually having any effect, so the server > is still really reading the file. Do you have the FILE privilege? If > so, that might be the case. You can test that by making the file mode > 600 so it's readable only to you, and then loading the file with the > full pathname. If that's what's happening, the server will no longer > be able to read it. (Assuming it doesn't run as you.) > > I suppose another possibility is that you're not really running mysql > in the same directory where the file is located, although that seems > unlikely -- unless maybe "mysql" is actually aliases to something > weird. > I had some other version of mysql executables in /usr/local/bin so I was not running the application I thought I was. Thanks for making me look at what really got executed when I said mysql. >> >> I then went to www.mysql.com and looked at what binary distributions were >> there for Mac OS X. First I downloaded version 3.23.49 but when I tried to >> run that version /usr/lib/libpthread.A.dylib was not found. I could not find >> where I could get this library. >> >> I then picked up version 3.23.47 and although I did not need to use >> --local-infile=1 the file was not find unless I specified the fully >> qualified file name. >> >> Two questions. First, what can I do to get the MySQL version 3.23.49 working >> on my system so I have the current version of the software? Second, what can >> be done so I do not need to specify the fully qualified file name? >> This still leaves the question as to when version 3.23.49a will be compiled for Mac OS X, instead of version 3.23.47. >> >> >> Thanks for any help with these items. >> -- >> Jim Dickenson >> mailto:[EMAIL PROTECTED] >> >> Computers for Marketing Corporation >> http://www.cfmc.com/ >> >> eFax: 1-419-791-8924 > > > - > 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 -- Jim Dickenson mailto:[EMAIL PROTECTED] Computers for Marketing Corporation http://www.cfmc.com/ eFax: 1-419-791-8924 - 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: mySQL and innoDB
The "insert into b values ('BBB', NULL)" statement should fail under the conditions
you describe, BBB was not inserted into the A table, and therefore the foreign key
constraint fails as it should.
Rance Hall
308.238.2455
Internal Office Extensions: 2455 or 6655
PC Programmer, The Buckle, Inc.
[EMAIL PROTECTED]
-Original Message-
From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 11:28 AM
To: [EMAIL PROTECTED]
Subject: mySQL and innoDB
Hi all,
I am pretty new to mySQL actually I started yesterday.
mySQL with innoDB handles integrity constraints.
I tried :
create table a (
id varchar(3) not null,
primary key(id) )
TYPE=INNODB;
insert into a values ('aaa');
create table b (
id varchar(3) not null,
a_id varchar(3),
index idx_b_a_id (a_id), foreign key (a_id) references a (id),
primary key(id) )
TYPE=INNODB;
insert into b values ('AAA','aaa');
insert into b values ('BBB',null);
the last statment doesn't work ... ERROR 1216: Cannot add a child row: a
foreign key constraint fails
I am using mySQL version 3.23.49 (and 4.0.1-alpha) on win2Ksp2
"mysqld-max --standalone --console"
Thanks,
Alain
-
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
mySQL and innoDB
Hi all,
I am pretty new to mySQL actually I started yesterday.
mySQL with innoDB handles integrity constraints.
I tried :
create table a (
id varchar(3) not null,
primary key(id) )
TYPE=INNODB;
insert into a values ('aaa');
create table b (
id varchar(3) not null,
a_id varchar(3),
index idx_b_a_id (a_id), foreign key (a_id) references a (id),
primary key(id) )
TYPE=INNODB;
insert into b values ('AAA','aaa');
insert into b values ('BBB',null);
the last statment doesn't work ... ERROR 1216: Cannot add a child row: a
foreign key constraint fails
I am using mySQL version 3.23.49 (and 4.0.1-alpha) on win2Ksp2
"mysqld-max --standalone --console"
Thanks,
Alain
-
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
Fw: MySQL 3.23.43-nt stop working after approx 10 days.
The server does not shutdown. It just stops responding. Best Regards Tommy Jensen http://www.sc-resources.net - Original Message - From: "Miguel Angel Solorzano" <[EMAIL PROTECTED]> To: "ServiceCenter resources" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 7:11 AM Subject: Re: MySQL 3.23.43-nt stop working after approx 10 days. At 22:21 8/4/2002 +0200, ServiceCenter resources wrote: Hi! >I have a problem with my MySQL server, it has started to stop working >after approximately 10 days of uptime. Seems to me an issue in your environment, not a MySQL service code issue. Take a look in the properties of the service called MySQL on the screen Recovery or the right of the user who installed the service. Also verify if \mysql\data\mysql.err shows the line with the message like this: 020405 19:56:24 c:\mysql\bin\mysqld-nt: Normal shutdown 020405 19:56:24 c:\mysql\bin\mysqld-nt: Shutdown Complete In the above case the SCM was received the instruction for to stop the service. Regards, Miguel -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil <___/ 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 - 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
InnoDB and duplicate key
I am playing around with portable sql queries (mysql, oracle and postgres). When executing: ipplan=> BEGIN; BEGIN ipplan=> INSERT INTO area (areaaddr, descrip, customer) VALUES (16777216, 'kjshdf', 1) ; ERROR: Cannot insert a duplicate key into unique index area_areaaddr_key ipplan=> SELECT custdescrip, customer FROM customer; NOTICE: current transaction is aborted, queries ignored until end of transactio n block *ABORT STATE* in postgress, I get an error if the transaction failed and then try to do a SELECT. Mysql using innodb happily continues. Who is correct? I would think that a SELECT is independent of an INSERT and could continue? Please copy me on replies. - 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
mysqlimport problem
Hi, I been using mysqlimport for a long time with no problems. But today when I try (as root) mysqlimport admin /usr/local/systems/admin/data/person.txt -p I get mysqlimport: Error: Can't get stat of '/usr/local/systems/admin/data/person.txt' (Errcode: 13), when using table: person even though stat /usr/local/systems/admin/data/person.txt File: "/usr/local/systems/admin/data/person.txt" Size: 1497 Blocks: 8 Regular File Access: (0444/-r--r--r--) Uid: (0/root) Gid: (0/ root) Device: 305Inode: 245470 Links: 1 Access: Tue Apr 9 15:54:34 2002 Modify: Tue Apr 9 01:00:01 2002 Change: Tue Apr 9 15:35:52 2002 What can cause it to stop working all of a sudden? mysqlimport -V is mysqlimport Ver 2.7 Distrib 3.23.49a, for pc-linux-gnu (i686) Any help would be greatly appreciated. regards Scott - 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] efficiency issues
On Monday 08 April 2002 10:09 pm, Daniel Jarrett wrote: > i'm building a table in MYSQL that has about 30 fields.. > > is this inefficient to have a large number of columns? Not necessarily, no. Often, it is more efficient. > if anyone can direct me to some good info on efficient design tips/ > techniques i'd be grateful. Read up on database normalisation. Any good database book will cover this. - 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-test-run broken on Tru64 4.0F PK3
>Description: The mysql-test-run script uses 'time -p' to time the test scripts on line 782 of the script. The -p option on this version of Tru64 is broken though and causes the test script(s) to fail. Since -p is the the default option for time on this version of Tru64 removing the -p allows mysql-test-run to execute correctly. >How-To-Repeat: Build mysql on this version of Tru64. cd mysql-test ./mysql-test-run output should be: Installing Test Databases Removing Stale Files Installing Master Databases 020409 1:32:44 ../sql/mysqld: Shutdown Complete Installing Slave Databases 020409 1:32:45 ../sql/mysqld: Shutdown Complete Starting MySQL daemon Loading Standard Test Databases Starting Tests TEST USER SYSTEM ELAPSEDRESULT alias [ fail ] -p: illegal option -- - -p: illegal option -- n -p: illegal option -- o -p: illegal option -- - -p: illegal option -- d -p: illegal option -- e -p: illegal option -- f -p: illegal option -- a -p: illegal option -- u -p: illegal option -- l -p: illegal option -- t -p: illegal option -- s -p: illegal option -- - -p: illegal option -- s -p: illegal option -- o -p: illegal option -- c -p: illegal option -- k -p: illegal option -- e -p: illegal option -- t -p: illegal option -- = -p: illegal option -- / -p: illegal option -- h -p: illegal option -- o -p: illegal option -- m -p: illegal option -- e -p: illegal option -- b -p: illegal option -- / -p: illegal option -- l -p: illegal option -- o -p: illegal option -- n -p: illegal option -- g -p: illegal option -- / -p: illegal option -- s -p: illegal option -- r -p: illegal option -- c -p: illegal option -- / -p: illegal option -- m -p: illegal option -- y -p: illegal option -- s -p: illegal option -- q -p: illegal option -- l -p: ill! egal option -- - -p: illegal option -- 3 -p: illegal option -- . -p: illegal option -- 2 -p: illegal option -- 3 -p: illegal option -- . -p: illegal option -- 4 -p: illegal option -- 9 -p: illegal option -- / -p: illegal option -- m -p: illegal option -- y -p: illegal option -- s -p: illegal option -- q -p: illegal option -- l -p: illegal option -- - -p: illegal option -- t -p: illegal option -- e -p: illegal option -- s -p: illegal option -- t -p: illegal option -- / -p: illegal option -- v -p: illegal option -- a -p: illegal option -- r -p: illegal option -- / -p: illegal option -- t -p: illegal option -- m /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- d /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- i /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- r /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- = /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal o! ption -- / /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- h /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- o /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- m /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- e /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- b /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- / /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- l /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- o /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- n /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- g /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- / /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- s /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest:! illegal option -- r /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- c /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- / /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- m /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- y /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- s /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- q /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- l /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- - /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- 3 /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- . /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- 2 /homeb/long/src/mysql-3.23.49/client/.libs/lt-mysqltest: illegal option -- 3 /homeb/long/src/mysql-3.23.49/client/
How to check which version of mysql is installed
I have a redhat 7.1 server, I want to get rid of the installed mysql server. How can check which version is installed and how to get rid of it? Thanks Jianping Zhu Department of Computer Science Univerity of Georgia Athens, GA 30602 Tel 706 5423900 - 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: sql query alter HELP!!!
Wild cards do work, but you have to make sure you use the right type. SQL uses % and I believe _ as wild cards. I know if you wish to use them in SELECT statements it would look like: SELECT * FROM pet WHERE name LIKE "b%" this would return anything from pet where the name starts with ab. Go look at: http://www.mysql.com/doc/P/a/Pattern_matching.html for more on this. However I dont know how you would do the same for updating tables. I tried using the % andsimilar for update but failed to get it to work. -nick > Hello everyone > I want to alter 50 tables, and for each the names start with the string > 'mak' > Is there an SQL query, so that I can do the change in one command. I > have tried using wildcards - they don't seem to work in SQL. > Thanks in advance. > Aman > > _ > Get your FREE download of MSN Explorer at > http://explorer.msn.com/intl.asp. > > > - > 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 To > unsubscribe, e-mail > 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: Uninstall Mysql
I am using Linux 7.2 OS. I think reseting the root password fixed it. Because I was no able to log in. I'm not really running any queries to the mysql database that why i'm not sure whats causing this problem. I also cant figure out why when I type mysql it doesnt doesnt use the password and I alway have to type mysql -u root -p and then password. - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 10:00 AM Subject: Re: Uninstall Mysql > Kathy, > Monday, April 08, 2002, 10:10:04 PM, you wrote: > > KR> Can anyone tell me how can I uninstall mysql. I have done it again. I have > KR> messed up my permission. > KR> I dont know what is is that i'm doing that makes me loose my previleges. > KR> I keep getting the access denied error > > Before uninstalling MySQL server you can > 1. reset root password, look at: >http://www.mysql.com/doc/R/e/Resetting_permissions.html > > 2. re-create grant tables, look at: >http://www.mysql.com/doc/m/y/mysql_install_db.html > > And about the MySQL server uninstallation, tell me, what OS do you use? > > KR> Kathy Reyes > > > > > -- > For technical support contracts, goto https://order.mysql.com/ > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ 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 > > > - 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
alter table - query help
Hello everyone I want to alter 50 tables, and for each the names start with the string 'mak' Is there an SQL query, so that I can do the change in one command. I have tried using wildcards - they don't seem to work in SQL. Thanks in advance. Aman _ Send and receive Hotmail on your mobile device: http://mobile.msn.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
storing files...
Is there a way to store files in MySQL? Looking to store somthing like a zip file in the databaseand be able to retrieve/download it from something like ASP. Thanks -Nick - 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
sql query alter HELP!!!
Hello everyone I want to alter 50 tables, and for each the names start with the string 'mak' Is there an SQL query, so that I can do the change in one command. I have tried using wildcards - they don't seem to work in SQL. Thanks in advance. Aman _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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: ORDER BY
>From my limited experience. I believe your gonna have to split that one field of alpha and numeric into two fields one for the alpha info and one for the numeric info. Then you can sort the information the way you want. Mike - Original Message - From: "Luc Foisy" <[EMAIL PROTECTED]> To: "MYSQL-List (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 9:55 AM Subject: ORDER BY > > If we have char data field > mixed alpha + numeric data is entered, alpha data is entered, and numeric > data is entered > when we sort this, we would like the numeric data sorted numerically instead > of alphabetically ( while the rest of course sorts alphabetically ) > do I have some kind of option here? > > Luc Foisy > 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.342 / Virus Database: 189 - Release Date: 3/14/02 - 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: InnoDB
Heiki, I have a question concerning the new auto-extending function (which sounds really cool by the way!). How does it handle the case where it runs out of disk space while expanding? Will it gracefully handle this scenerio or will some sort of recovery be necessary? Carl McNamee Systems Administrator Billing Concepts (210) 949-7282 >The auto-extending data file of InnoDB-3.23.50 will solve your problem. No >need to preallocate tablespace any more. >Best regards, >Heikki Tuuri >Innobase Oy sql sql mysql query query 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: HELP!
GOLDEN, Monday, April 08, 2002, 11:09:36 PM, you wrote: GS> Would you help me, how to install, setup, and configure MySQL in my server GS> with O/S windows 2000 server and IIS v. 5 Installation on Windows is covered in the manual, please check following links: http://www.mysql.com/doc/W/i/Windows_installation.html (description of MySQL installation on Windows) http://www.mysql.com/doc/W/i/Windows.html (general Windows notes - starting, running, etc) http://www.mysql.com/doc/N/T/NT_start.html (..and how to correctly start MySQL server on WinNT, 2000, XP) GS> Thank you, GS> Best Regards, -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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
Re: MySQL and GCC
Barry, Monday, April 08, 2002, 8:33:02 PM, you wrote: BB> I have a system here based on Red Hat's 7.2 distribution and I am wanting to BB> get MySQL up and running. After browsing your web page it seems that I will BB> have go to a different version of gcc. Would I be safe to go to the latest BB> version (3.0.4) of gcc? MySQL team is now working hard to test GCC 3.0x; the safest is to run precompiled MySQL version as there are a lot of other things that influence MySQL functionality. BB> Barry Blatz -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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
Re: mysql_install_db still locking :-(
Chris, Tuesday, April 09, 2002, 3:22:00 PM, you wrote: CL> Still having this trouble with mysql.. Running the mysql_install_db renders CL> this... CL> Preparing db table CL> Preparing host table CL> Preparing user table CL> Preparing func table CL> Preparing tables_priv table CL> Preparing columns_priv table CL> Installing all prepared tables CL> At this point the script locks at this point & won't go any further. CL> This happens when the binary runs it automatically after running the RPM, or CL> just trying to run it by hand. CL> I am using CL> MySQL-3.23.49a-1.i386.rpm CL> MySQL-client-3.23.49a-1.i386.rpm CL> Red Hat Linux version 2.2.16-22 CL> I also pulled the sources down & installed them, compiled & ran them CL> same thing! Chris, which version of RedHat do you use on what kind of hardware? CL> Anybody have any ideas - I'm starting to loose hope! CL> Thanks! CL> Chris -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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
Re: Strange behavior
LeTortorec, Tuesday, April 09, 2002, 12:17:06 AM, you wrote: Leoen> I have a table with the following fields: Leoen> id=autoincrement, int (11) Leoen> ts_h=decimal Leoen> ts_pid=int (11) Leoen> ts_day=text Leoen> There is a unique record where ts_pid=60 and ts_day="2002032800" Leoen> (ts_h=0). Leoen> If I do [update t_timesheet set ts_h=0 where ts_pid=60 and Leoen> ts_day="2002032800" ], every thing works fine. (nothing is changed Leoen> because the values remain the same) Leoen> But if I change the query to ts_h=1: Leoen> [update t_timesheet set ts_h=1 where ts_pid=60 and Leoen> ts_day="2002032800" ] Leoen> The record is deleted instead of being update. Leoen> I changed ts_h to a decimal, or integer, same behavior. It deletes my record Leoen> instead of updating it. Leoen> Any idea why this occurs? What version of MySQL do you use? Can you create a test case for this? Leoen> Thank you. Leoen> Jean-Louis -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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
Re: Uninstall Mysql
Kathy, Monday, April 08, 2002, 10:10:04 PM, you wrote: KR> Can anyone tell me how can I uninstall mysql. I have done it again. I have KR> messed up my permission. KR> I dont know what is is that i'm doing that makes me loose my previleges. KR> I keep getting the access denied error Before uninstalling MySQL server you can 1. reset root password, look at: http://www.mysql.com/doc/R/e/Resetting_permissions.html 2. re-create grant tables, look at: http://www.mysql.com/doc/m/y/mysql_install_db.html And about the MySQL server uninstallation, tell me, what OS do you use? KR> Kathy Reyes -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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
Re: Re: Starting problem with safe_mysqld
Kannan, Tuesday, April 09, 2002, 7:54:07 AM, you wrote: K> You need to create a user mysql and also create a group mysql and add the user K> to the group..You will find this in the installation docs.. Using commands of your OS ... It is described in the MySQL manual in the section 2.2.7 Installing a MySQL Binary Distribution, look at: http://www.mysql.com/doc/I/n/Installing_binary.html K> regards K> kannan -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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
Re: Some permissions help
VR> Ryan, VR> Thursday, March 28, 2002, 7:22:47 AM, you wrote: RC>> I'm working on a MySQL permissions problem, and would welcome some RC>> suggestions and/or comments, or to be pointed in the right direction. The RC>> goals I have are: RC>> b) Eliminate anony browsing of db's.. and ideally eliminate RC>> ability to view a complete list of all db's. VR> If you setup privileges on some database for user, user doesn't have VR> grants on other databases, but he can see the list of databases using VR> SHOW DATABASES command. Oh! Actually I was wrong, this could be done by starting mysqld with "--safe-show-database" option, look at: http://www.mysql.com/doc/C/o/Command-line_options.html (mysqld command-line options are described there) -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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
Re: TIMESTAMP(14) or Bigint ??
Sent: Tuesday, April 09, 2002 2:14 PM Subject: Re: TIMESTAMP(14) or Bigint ?? > David, > I could be wrong but since bigint isn't a date or time oriented data > type I imagine this would be completely useless to you unless you are > storing unix timestamps. In fact i'm looking to a way to store date and time in only one field and with the smallest space. I can take date and time with my C client client and then create a string like MMDDHHMMSS manually ... > You also have the option of using datetime data > types. I'm not quite sure what you are asking nor what difference it makes > how big the field is in bytes. Timestamp and Datetime are pretty much the > same except the first timestamp field of every row will automatically be > "timestamped" when you do update's or inserts with a null value in the > field. > > Ric. > As we can see here : http://www.mysql.com/doc/n/o/node_367.html TIMESTAMP is 4 Bytes and DATETIME is 8 Bytes. So, 4 Bytes difference per 5 Millions records = a 20 MB bigger table ... But i think the feature "timestamp field of every row will automatically be "timestamped" ... " will anoy me. In fact the mos efficient way to store date and time will be 2 fields : date = 3 Bytes, time = 3 Bytes but when i'm doing sql query like this : select * from Table where field4 = 15 order by date , time; i can use index for the where but not for the order by, explain say me "file sort" So i thought to store date and time in only one field ... David - 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: TIMESTAMP(14) or Bigint ??
Sent: Tuesday, April 09, 2002 2:14 PM Subject: Re: TIMESTAMP(14) or Bigint ?? > David, > I could be wrong but since bigint isn't a date or time oriented data > type I imagine this would be completely useless to you unless you are > storing unix timestamps. In fact i'm looking to a way to store date and time in only one field and with the smallest space. I can take date and time with my C client client and then create a string like MMDDHHMMSS manually ... > You also have the option of using datetime data > types. I'm not quite sure what you are asking nor what difference it makes > how big the field is in bytes. Timestamp and Datetime are pretty much the > same except the first timestamp field of every row will automatically be > "timestamped" when you do update's or inserts with a null value in the > field. > > Ric. > As we can see here : http://www.mysql.com/doc/n/o/node_367.html TIMESTAMP is 4 Bytes and DATETIME is 8 Bytes. So, 4 Bytes difference per 5 Millions records = a 20 MB bigger table ... But i think the feature "timestamp field of every row will automatically be "timestamped" ... " will anoy me. In fact the mos efficient way to store date and time will be 2 fields : date = 3 Bytes, time = 3 Bytes but when i'm doing sql query like this : select * from Table where field4 = 15 order by date , time; i can use index for the where but not for the order by, explain say me "file sort" So i thought to store date and time in only one field ... David - 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: check, analyze and optimize table
Hi,
I use all this in the same order and i don't have any problems:
CHECK TABLE
IF (CHECK TABLE!=OK)
{
REPAIR TABLE
}
// i don't use analyze tables
OPTIMIZE TABLE
Before to perform this commands, you must be sure is not any users connected
(show full processlist;) to the DataBase.
Good luck,
Gelu
- Original Message -
From: Peter Romianowski <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 2:08 PM
Subject: check, analyze and optimize table
> Hi,
>
> I am writing a maintenance-deamon which is executing
> CHECK TABLE, ANALYZE TABLE and OPTIMIZE TABLE once at
> night.
> If CHECK TABLE fails for at least one table, then the
> rest will be skipped.
> The question is if the order of the statements is ok
> this way. A second question would be, if I should run
> a REPAIR statement automatically if CHECK fails.
> Are there any more tasks that I should perform nightly
> in order to keep my database healthy and in a "high
> performance shape"?
> And another general question: Do I have to take down
> my Application that is using the MySQL-DB in order to
> perform the CHECK, ANALYZE and OPTIMZE commands?
>
> thanks in advance,
> Peter
>
> -
> 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: InnoDB tables
Hi Richard I'm writing a web application in PHP with a MySQL backend. I'm a novice at both PHP and MySQL having started with both about November last year and I'm also new to programming at large so please excuse any question which may seem obvious. The foreign keys are to be used to enforce referential integrety in the application -- e.g. If I try to delete a specific entry from the 'town' table it won't allow me to if there are entries in the 'advertiser' table which refer to that town. At the moment I'm using a table called 'advertisers_towns' which stores the ID of each entity and thereby the relationship is maintained. But if I can have the foreign keys operating this would cut out the need for such a table and all the extra coding work which goes with it. I hope that explains why I'd like to use foreign keys. What do you think? Regards Luke - Original Message - From: "Richard Clarke" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 2:11 PM Subject: Re: InnoDB tables > Luke, > > How exactly will the foreign keys save you time? Please explain. > > Ric. > > - Original Message - > From: "Luke van Blerk" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, April 09, 2002 9:17 AM > Subject: InnoDB tables > > > > Hi everyone, > > > > I've been reading up about InnoDB tables and they seem to have lots of > > advantages. I'm particularly interested in using the foreign keys as this > > will save me some much need time. In the benchmark tests on the InnoDB > > website they show up faster than MyISAM tables but will foreign keys have > a > > slow down effect? And are there any issues I need to know about before > > switching to InnoDB tables? > > > > Thanks in advance > > Luke van Blerk > > > > mysql > > > > > > - > > 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
mysql_install_db still locking :-(
Hey guys, Still having this trouble with mysql.. Running the mysql_install_db renders this... Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables At this point the script locks at this point & won't go any further. This happens when the binary runs it automatically after running the RPM, or just trying to run it by hand. I am using MySQL-3.23.49a-1.i386.rpm MySQL-client-3.23.49a-1.i386.rpm Red Hat Linux version 2.2.16-22 I also pulled the sources down & installed them, compiled & ran them same thing! Anybody have any ideas - I'm starting to loose hope! Thanks! Chris - 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: TIMESTAMP(14) or Bigint ??
David, I could be wrong but since bigint isn't a date or time oriented data type I imagine this would be completely useless to you unless you are storing unix timestamps. You also have the option of using datetime data types. I'm not quite sure what you are asking nor what difference it makes how big the field is in bytes. Timestamp and Datetime are pretty much the same except the first timestamp field of every row will automatically be "timestamped" when you do update's or inserts with a null value in the field. Ric. - Original Message - From: "David BORDAS" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 10:04 AM Subject: TIMESTAMP(14) or Bigint ?? > Hi, > > i'd like to alter a table which have a date and time field so 3 Bytes for > date and 3 Bytes for time. > I'd table to add a new field to store date like this : MMDDHHMMSS. > > In fact, I can't use indexes on sql query like select with order by with 2 > fields date + time and with > one unique field i can. > > So, for this new field that i'll insert and update manually, should i use a > Bigint which required 8 Bytes or a Timestamp(14) with 4 Bytes ? > > Timestamp looks great but, can i insert and update it manually ?? > > Thanks > David > > > > - > 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: InnoDB tables
Luke, How exactly will the foreign keys save you time? Please explain. Ric. - Original Message - From: "Luke van Blerk" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 9:17 AM Subject: InnoDB tables > Hi everyone, > > I've been reading up about InnoDB tables and they seem to have lots of > advantages. I'm particularly interested in using the foreign keys as this > will save me some much need time. In the benchmark tests on the InnoDB > website they show up faster than MyISAM tables but will foreign keys have a > slow down effect? And are there any issues I need to know about before > switching to InnoDB tables? > > Thanks in advance > Luke van Blerk > > mysql > > > - > 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
ANN: MM.MySQL-2.0.12 Released
MM.MySQL-2.0.12, a JDBC driver for MySQL was released yesterday. It can be found at http://sourceforge.net/mmmysql/ Changes include: - General code cleanup. - Added getIdleFor() method to Connection and MysqlLogicalHandle. - Relaxed synchronization in all classes, should fix 520615 and 520393. - Added getTable/ColumnPrivileges() to DBMD (fixes 484502). - Added new types to getTypeInfo(), fixed existing types thanks to Al Davis and Kid Kalanon. - Added support for BIT types (51870) to PreparedStatement. - Fixed getRow() bug (527165) in ResultSet - Fixes for ResultSet updatability in PreparedStatement. - Fixed timezone off by 1-hour bug in PreparedStatement (538286, 528785). - ResultSet: Fixed updatability (values being set to null if not updated). - DataSources - fixed setUrl bug (511614, 525565), wrong datasource class name (532816, 528767) - Added identifier quoting to all DatabaseMetaData methods that need them (should fix 518108) - Added support for YEAR type (533556) - ResultSet.insertRow() should now detect auto_increment fields in most cases and use that value in the new row. This detection will not work in multi-valued keys, however, due to the fact that the MySQL protocol does not return this information. - ResultSet.refreshRow() implemented. - Fixed testsuite.Traversal afterLast() bug, thanks to Igor Lastric. -Mark - 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
