Scanning Directory/Inserting Image Links to DB
Greets Folks, Can someone recommend a Perl script/technique that will scan a Unix directory of image/text files, and then insert the links into a MySQL database? I used to have a good one, but it got misplaced... Doh! Thanks, Will _ 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
Re: Scanning Directory/Inserting Image Links to DB
From: Will K. [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, April 14, 2002 23:21 Subject: Scanning Directory/Inserting Image Links to DB Can someone recommend a Perl script/technique that will scan a Unix directory of image/text files, and then insert the links into a MySQL database? I used to have a good one, but it got misplaced... Doh! That's only a bit bigger than a one-liner. Your best bet is probably to grab a small script you have that inserts into MySQL, use File::Find or glob() to provide the file names, and trim off the excess. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age. - 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: Multiple updates
That the thing see, the form(using GET instead of POST) sends data with
the new dates like this:-
id=1name=Markjob_number=AA1job_date=2002-5-19
id=2name=Markjob_number=AA2job_date=2002-5-21
id=3name=Markjob_number=AA3job_date=2002-5-25
and the UPDATE query like this:-
$sql = UPDATE mytable set job_date='$job_date' where job_number
='$job_number';
$result = @mysql_query($sql, $connection) or die.;
just updates the last record.
Can the query be written so that it updates each of the three records?
cheers
Mark
On Mon, 15 Apr 2002, Joseph Jude wrote:
Are you sure job_number in your script equals to all the three records and not just
one record?
-
Joseph Jude
- Original Message -
From: Mark Dale
To: [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 6:33 AM
Subject: Multiple updates
I'm now trying to UPDATE the three records with one query.
Once the data is INSERTED into the db with this -
insert into mytable (id,name,job_number,job_date) values
('1','Mark','AA1','2002-04-15'),
('2','Mark','AA2','2002-04-16'),
('3','Mark','AA3','2002-04-17');
a form page is displayed where all the job_dates can be changed (updated).
I'm using this to update -
$sql = UPDATE mytable set job_date='$job_date' where job_number
='$job_number';
$result = @mysql_query($sql, $connection) or die.;
and it only changes the last record. Could someone kindly tell me what I'm
doing wrong.
cheers
Mark
--
Mark Dale
phone/fax: 02 6247.6731
mobile: 0403.831748
email: [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
-
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
problem
respected sir/madam, i had to recently encounter of entering the movie files in a database using the blob datatype. the problems i faced are: 1) while creating the table how do i mention the size of the blob field. say.. create table test (name varchar(8),movie blob()); how to mention its size 2) i used the following command to insert a file ,though the query said ok but the select statement showed a null value. the command i used is... update test set movie=LOAD_FILE(/home/Hitesh/hitesh.txt) where name=hitesh; 3)what exactly is the max_allowed_packet and how to increase or decrease it. 4) how to retrive the file from the database. i did go thru the entire manual but the specific query eluded me...like i got to know that a file locator is stored in the database which indirectly connects to that file and so on. i would be glad if my query is quickly answered upon.. thanking you in advance. hitesh - 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 stored procedures - v4.1 :(
Checked my own version and found it to be Ver 11.16 Distrib 3.23.49. He, version 11??? Quit confused, but after a sanity check with reality I realized I must be using version 3.23. Anyhow, check the status of next version and found out that version 4.0 is in alpha mode... The Ver 11.16 refers to the version of the MySQL *client* utility. Distrib 3.23.49, as you figured out is which version of MySQL it was distributed with. Geeeze - not even beta. So I guess even an estimate when the first alpha of version 4.1 is virtually impossible to give right now, or? I'll trust a MySQL alpha release before the final production releases of most vendors. In fact, we're using 4.0.1 in our production environment with great success. Its your system, and if you think it worth the risc, it is of course you decision to do so to, ;) but I would never ever trust _any_ code in an alpha-development stage. Anyone how does that is likely to get a big surprise, sooner or later - or they are just very lucky if nothing happens. Using Alpha-code in a production environment is not only doing a high risk experiment, but also nothing I never would recommend someone to do with my honor preserved. From the manual: *alpha indicates that the release contains some large section of new code that hasn't been 100% tested. No one can afford, neither in consumed time, nor in money or resources, to test system components up to 100% Known bugs (usually there are none) Does anyone more than me thinks that this smells lack of system testing? ;) should be documented in the News section. should be... have I ever heard that before? ;) See section D MySQL change history. There are also new commands and extensions in most alpha releases. That's the kind of basic idea with Alpha-code, yes L Active development that may involve major code changes can occur on an alpha release, but everything will be tested before doing a release. There should be no known bugs in any MySQL release. I'm impressed if they, really, can achieve this goal - which I of courses doesn't believe in a single second. ;) *beta means that all new code has been tested. No major new features that could cause corruption on old code are added. That's why we call it beta, yes... There should be no known bugs. !! A version changes from alpha to beta when there haven't been any reported fatal bugs within an alpha version for at least a month and we don't plan to add any features that could make any old command more unreliable. *gamma is a beta that has been around a while and seems to work fine. Only minor fixes are added. This is what many other companies call a release. So why not call it release to avoid confusion then? *If there is no suffix, it means that the version has been run for a while at many different sites with no reports of bugs other than platform-specific bugs. Only critical bug fixes are applied to the release. This is what we call a stable release. How are the binary distributions of alpha and beta releases complied? In debug or release mode? But anyway. When could one expect to find a first alpha version of 4.1? Sometimes during 2003? Or? The manual makes allusions to an early 2002 release for 4.1, but I think Which manual? mysql/docs/manual.txt? I did a text search in that file and couldn't find early 2002 nor 2002. that's probably slipped somewhat. First rule: Every release date slips. ;) Lemma: If released at correct date, either the software is to buggy to use, or it misses, important, promised features of that release. ;) Late 2002/early 2003 seems more likely. However, be aware that the fact that they plan on having stored procedures in 4.1, does not guarantee that they actually will have stored procedures. Often times, a feature cannot be implemented as efficiently as Monty et al would like, or other features become a higher priority and things get put off for a while. (*ahem* sub-selects -- when I started using 3.20.x they were supposed to be in 3.21.x, then 3.22.x, then...) That's strange. I would say that stored procedures is a highly useful thing to have had implimented in a RDBMS. //Anders - 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 stored procedures - v4.1 :(
Did I ask for optimization tips? Nope. ;) But I did ask for a release date of version 4.1. -Original Message- From: Land, Christopher Sent: Friday, April 12, 2002 11:18 PM To: Jon Frisby; Mysql List Subject: RE: MySQL and stored procedures - v4.1 :( 5.2.12 Other Optimisation Tips http://www.mysql.com/doc/T/i/Tips.html ... - Normally you should try to keep all data non-redundant (what is called 3rd normal form in database theory), but you should not be afraid of duplicating things or creating summary tables if you need these to gain more speed. Optimizing for what kind of need for speed? Redundancy kills speed performance for inserts and updates... - Stored procedures or UDF (user-defined functions) may be a good way to get more performance. In this case you should, however, always have a way to do this some other (slower) way if you use some database that doesn't support this. A nice thing with a stored procedure is that you can lower the load impact made by heavy queries on the database by using cursors to soften the performance hit they are likely to make - e.g. make the query behave like a high intensive interactive user instead of a huge one single shot batch job. - You can always gain something by caching queries/answers in your application and trying to do many inserts/updates at the same time. Let's say I need to do 10 millions inserts. In what way will bundling all these 10 million inserts into one single batch give me some gain? If your database supports lock tables (like MySQL and Oracle), this should help to ensure that the index cache is only flushed once after all updates. If you have a frequent interactive used system, then the time spent in high transaction isolation levels should kept to a minimum. Giving general thump rule advices about how to implimenbt a system whithout having knowledge about the intention of a system is like saying that one should spit on the left side of the boat - just to bad if you have the wind in the face when you do it... - 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
new windows Tool
Hello MYsql lovers; I wanna announce a new tool for windows users . Same interface as SQL server 2000 query analyzer but loaded with Visual Studio capabilities . SQL server users will love it . http://amr.activechannel.net http://amr.activechannel.net/setup.zip _ Get your FREE, Private email today - [EMAIL PROTECTED] http://www.msexpert.com _ Run a small business? Then you need professional email like [EMAIL PROTECTED] from Everyone.net http://www.everyone.net?tag - 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 problems
respected sir/madam, i had to recently encounter of entering the movie files in a database using the blob datatype. the problems i faced are: 1) while creating the table how do i mention the size of the blob field. say.. create table test (name varchar(8),movie blob()); how to mention its size 2) i used the following command to insert a file ,though the query said ok but the select statement showed a null value. the command i used is... update test set movie=LOAD_FILE(/home/Hitesh/hitesh.txt) where name=hitesh; 3)what exactly is the max_allowed_packet and how to increase or decrease it. 4) how to retrive the file from the database. i did go thru the entire manual but the specific query eluded me...like i got to know that a file locator is stored in the database which indirectly connects to that file and so on. i would be glad if my query is quickly answered upon.. thanking you in advance. hitesh - 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: Multiple Inserts
Mark
Does anyone know if it's possible to insert mutilple records into 1
table
in one query?
yes
Something like -
insert into mytable (id,name,job_number,job_date) values
('1','Mark','AA1','2002-04-15')
insert into mytable (id,name,job_number,job_date) values
('2','Mark','AA2','2002-04-16')
insert into mytable (id,name,job_number,job_date) values
('3','Mark','AA3','2002-04-17')
- all at once if the data is the result of a form page.
Sorry I can't give you a manual reference - my ISP/MySQL's site aren't
playing like nice children at the moment!?
However if you look at the template for the INSERT command notice that
after the VALUES clause there is an ellipsis - something like:
VALUES(expression [,expression]...) [,(expression, etc)...]
thus you can add as many rows' worth of data as you like - each row
within its own set of parentheses:
insert into mytable (id,name,job_number,job_date) values
('1','Mark','AA1','2002-04-15'),
('2','Mark','AA2','2002-04-16'),
('3','Mark','AA3','2002-04-17')
NB please double check my syntax/memory.
Regards,
=dn
-
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: Multiple updates
Mark,
Is it a two-fer-one sale today?
I'm now trying to UPDATE the three records with one query.
Once the data is INSERTED into the db with this -
insert into mytable (id,name,job_number,job_date) values
('1','Mark','AA1','2002-04-15'),
('2','Mark','AA2','2002-04-16'),
('3','Mark','AA3','2002-04-17');
a form page is displayed where all the job_dates can be changed
(updated).
I'm using this to update -
$sql = UPDATE mytable set job_date='$job_date' where job_number
='$job_number';
$result = @mysql_query($sql, $connection) or die.;
and it only changes the last record. Could someone kindly tell me what
I'm
doing wrong.
There doesn't appear to be anything wrong!?
The UPDATE statement will amend every row that meets the WHERE clause
selection criteria.
If the table only consists of the records mentioned, then only the
single (if any) row with the matching job number will update, ie if
$job_number = AA3 then only the last record will (possibly) change.
Did I miss something?
=dn
-
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: Multiple updates
Mark, Earlier joke rebounds - pardon me whilst I wipe the comedic egg from my face... That the thing see, the form(using GET instead of POST) sends data with the new dates like this:- id=1name=Markjob_number=AA1job_date=2002-5-19 id=2name=Markjob_number=AA2job_date=2002-5-21 id=3name=Markjob_number=AA3job_date=2002-5-25 and the UPDATE query like this:- $sql = UPDATE mytable set job_date='$job_date' where job_number ='$job_number'; $result = @mysql_query($sql, $connection) or die.; just updates the last record. Can the query be written so that it updates each of the three records? If you want EVERY row in the table to be updated then leave out the WHERE clause. BUT this is a risky technique to employ! If job_number='$job_number' is not the correct criteria what is the selection method you want to apply - a design question not a SQL problem. eg WHERE LEFT(job_number, 2) = AA. (see manual for string functions, if it is working again) Regards, =dn - 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 on FreeBSD
Ïðèâåòñòâóþ òåáÿ, mysql, Ïðîøó ïðîùåíèÿ çà íàçîéëèâîñòü íî êàðòèíà òà æå è íå çíàþ ê ñîæàëåíèþ êàê ñ íåé áîðîòüñÿ... :( --- Ôðàãìåíò Top - last pid: 55153; load averages: 1.60, 1.43, 1.35 up 4+19:23:57 10:42:44 205 processes: 2 running, 202 sleeping, 1 zombie CPU states: 23.7% user, 0.0% nice, 76.3% system, 0.0% interrupt, 0.0% idle Mem: 296M Active, 100M Inact, 62M Wired, 20M Cache, 60M Buf, 20M Free Swap: 1024M Total, 15M Used, 1008M Free, 1% Inuse PID USERNAME PRI NICE SIZERES STATETIME WCPUCPU COMMAND 14350 mysql 57 0 53732K 30240K RUN365:15 79.88% 79.88% mysqld 55153 www 2 0 11676K 4288K sbwait 0:00 1.62% 0.59% httpd 55139 www 2 0 11656K 4316K sbwait 0:00 0.42% 0.29% httpd --- End - âðåìÿ îò âðåìåíè Mysql íà÷èíàåò æðàòü cpu system usage... Ñåãîäíÿ ýòî íà÷àëîñü ïðèìåðíî â 6:30 óòðà! ó ìåíÿ âîîáùå â ýòî âðåìÿ òðàôèê ìèíèìàëüíûé!!! Îòñëåäèòü ïðè÷èííî-ñëåäñòâåííóþ ñâÿçü íå ïðåäñòàâëÿåòñÿ âîçìîæíûì... Ñèñòåìà FreeBSD 4.4 release RAM 512 Ïîìîãèòå! -- Âñåãî íàèëó÷øåãî, amber46 mailto:[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
mysql server not starting
From: terrence To: [EMAIL PROTECTED] Subject: see above Description: MySQL version 3.23.47 Darwin 5.x When I run mysqladmin version, I get the following message: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! How-To-Repeat: type bin/mysqladmin -u root shutdown at the root of mysql type bin/mysqladmin version at mysql application root Fix: Perhaps determining the location of mysql.sock. I could not locate in on my machine, thought it supposed to install with mysql binary. Submitter-Id: submitter ID Originator: Terrence Tyson Organization: na MySQL support: [none Synopsis: missing mysql.sock file Severity: serious Priority: medium Category: mysql Class:could be either - sw-bug | doc-bug | change-request | support ] Release: mysql-3.23.47 (Official MySQL binary) Environment: System: Darwin localhost 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 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='cc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxr-xr-x 1 root wheel 15 Mar 15 20:06 /usr/lib/libc.dylib - libSystem.dylib Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --disable-shared Email: [EMAIL PROTECTED] or [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: Multiple updates
That the thing see, the form(using GET instead of POST) sends data with the new dates like this:- id=1name=Markjob_number=AA1job_date=2002-5-19 id=2name=Markjob_number=AA2job_date=2002-5-21 id=3name=Markjob_number=AA3job_date=2002-5-25 and the UPDATE query like this:- $sql = UPDATE mytable set job_date='$job_date' where job_number ='$job_number'; $result = @mysql_query($sql, $connection) or die.; just updates the last record. Can the query be written so that it updates each of the three records? cheers Mark Hi Mark Your problem is misused of form transfer data please notify that by GET method the data transfer to server with name and equa sign (=) and then value each data seperate by so id=1name=Markjob_number=AA1job_date=2002-5-19 mean the data have 3 elecment id,name and job_date as your data you send 9 element but use the same name so finally it only have 3 element and the value id the last assign so you will got at last id=3name=Markjob_number=AA3job_date=2002-5-25 the first and the second set has over write so when you update data you got the last data (id=3) update only how to solve this problem you shoul declare the name seperate like this id1=1name1=Markjob_number1=AA1job_date1=2002-5-19 id2=2name2=Markjob_number2=AA2job_date2=2002-5-21 id3=3name3=Markjob_number3=AA3job_date3=2002-5-25 and update 3 time $sql = UPDATE mytable set job_date='$job_date1' where job_number ='$job_number1'; @mysql_query($sql, $connection) or die.; $sql = UPDATE mytable set job_date='$job_date2' where job_number ='$job_number2'; @mysql_query($sql, $connection) or die.; $sql = UPDATE mytable set job_date='$job_date3' where job_number ='$job_number3'; @mysql_query($sql, $connection) or die.; May be your answer. Kittiphum Worachat,M.T. www.hatyailab.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: [Sever demon gets killed when its started with safe_mysqld ]
imran, Sunday, April 14, 2002, 1:26:42 PM, you wrote: iDescription: i After installing the mysql server i moved it to my home dir under SQL. Tried i running the configure script first. Then i tried mysqladmin version but it i doesnt help. It says that not able to find /tmp/mysql.sock file. i The message prompted is as follows. i ./bin/mysqladmin version i ./bin/mysqladmin: connect to server at 'localhost' failed i error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' i Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! i Wonder whats wrong. Can somebody prompt me on this.!!! Specify path to your socket file using --socket option of mysqld or in my.cnf file. You can also create a symbolik link to your socket file. i of the problem (multiple ) -- 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: How to find out where is the installation directory
Jayakumar, Monday, April 15, 2002, 7:24:14 AM, you wrote: JD I am using Red Hat 7.1. When i use rpm query, it says that I have My SQL JD 3.23 Server and Client installed. Where can i find the installation JD directory. It depens on your installation ... If you installed MySQL from www.mysql.com, by default installation dir is /usr or /usr/local If you installed MySQL from RedHat package, MySQL is distributed across file system. JD I am planning to use 4.0.1. How useful it is to uninstall 3.23 and JD install 4.0.1 for development purpose. If MySQL was installed from RPM, you should find all MySQL packages and then uninstall them. rpm -qa| grep -i mysql rpm --uninstall package_name if MySQL was installed from source or binary package, you can uninstall it manually. JD Thanks JD -Jayakumar -- 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: Difference between MySQL and MySQL Max
Jayakumar, Monday, April 15, 2002, 6:54:05 AM, you wrote: JD I am new to MySQL. Can anyone tell me what is the difference between JD MySQL and MySQL Max. MySQL-Max is the extended MySQL server. It's configured with options: --with-server-suffix=-max --with-innodb --with-bdb CFLAGS=-DUSE_SYMDIR MySQL-Max supports transaction-safe tables, such as InnoDB and BDB. You can read more info about MySQL-Max at: http://www.mysql.com/doc/m/y/mysqld-max.html JD Thanks JD -Jayakumar -- 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: problem
HITESH, Monday, April 15, 2002, 10:44:45 AM, you wrote: HP i had to recently encounter of entering the movie HP files in a database using the blob datatype. HP the problems i faced are: HP 1) while creating the table how do i mention the size HP of the blob field. say.. HP create table test (name varchar(8),movie HP blob()); HPhow to mention its size Did you read about storage requirements for BLOB types in the MySQL manual? There are 4 types of BLOB: TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB and size of your field depends on which type of BLOB do you use and size of your data. Please, check the following link: http://www.mysql.com/doc/n/o/node_368.html So, if you decide to use TINYBLOB, for example, you should specify: CREATE TABLE test( name VARCHAR(8), movie TINYBLOB); HP 2) i used the following command to insert a file HP ,though the query said ok but the select statement HP showed a null value. HP the command i used is... HPupdate test set HP movie=LOAD_FILE(/home/Hitesh/hitesh.txt) where HP name=hitesh; It should work. Is there a row in your table named hitesh? Look at: mysql update blobtest set movie=LOAD_FILE(/tmp/blob.txt) where name='vita'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select * from blobtest; +--+-+ | name | movie | +--+-+ | vita | This is a test of using BLOB type :) | +--+-+ 1 row in set (0.00 sec) HP 3)what exactly is the max_allowed_packet and how to HP increase or decrease it. It's very well covered in the manual. Please, check it: http://www.mysql.com/doc/P/a/Packet_too_large.html If you want to increase max_allowed_packet you should run mysqld with the -O max_allowed_packet=# option. HP4) how to retrive the file from the database. Use SELECT statement ... HP i did go thru the entire manual but the specific query HP eluded me...like i got to know that a file locator is HP stored in the database which indirectly connects to HP that file and so on. HP i would be glad if my query is quickly answered upon.. HP thanking you in advance. HP hitesh -- 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: connect from foreign host
Gokce, Saturday, April 13, 2002, 1:19:26 PM, you wrote: GA I can use mysql server with all ways from localhost. But, there is no GA connection from any foreign host. I have two linux server. One of is mysql GA server. I try to connect from other server to mysql server. GA mysql -u user -h mysql.ser.adress -p GA and answer from mysql connection: GA Can't connect to MySQL server on 'mysql.server.adress' (111) Did you specified --skip-networking option in my.cnf or in mysqld command-line? If so, remove it. GA Edakom Internet Sorumlusu GA Gokce Akkaya -- 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: new windows Tool
I have no objection to you promoting your wares in this group of to your entrepreneurial skills. But to get the message This trial has expired on the first run after installing the 9 meg plus download is a bit rough, isn't it? And definitely not the way to win customers! Pierre amr salah wrote: Hello MYsql lovers; I wanna announce a new tool for windows users . Same interface as SQL server 2000 query analyzer but loaded with Visual Studio capabilities . SQL server users will love it . http://amr.activechannel.net http://amr.activechannel.net/setup.zip _ Get your FREE, Private email today - [EMAIL PROTECTED] http://www.msexpert.com _ Run a small business? Then you need professional email like [EMAIL PROTECTED] from Everyone.net http://www.everyone.net?tag - 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 -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - 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: problem
HITESH PATEL wrote: respected sir/madam, i had to recently encounter of entering the movie files in a database using the blob datatype. the problems i faced are: 1) while creating the table how do i mention the size of the blob field. say.. create table test (name varchar(8),movie blob()); how to mention its size [Sammy] In the manual (http://www.mysql.com/doc/B/L/BLOB.html), it said In most respects, you can regard a TEXT column as a VARCHAR column that can be as big as you like. In the manual (http://www.mysql.com/doc/C/R/CREATE_TABLE.html), in the create table syntax, you can see you don't need to specify the size of a blob column. The max size of a blob column is defined in the manual (http://www.mysql.com/doc/S/t/Storage_requirements.html) 2) i used the following command to insert a file ,though the query said ok but the select statement showed a null value. the command i used is... update test set movie=LOAD_FILE(/home/Hitesh/hitesh.txt) where name=hitesh; 3)what exactly is the max_allowed_packet and how to increase or decrease it. [Sammy] In the manual (http://www.mysql.com/doc/C/o/Command-line_options.html), you can see the definition of max_allowed_packet. 4) how to retrive the file from the database. i did go thru the entire manual but the specific query eluded me...like i got to know that a file locator is stored in the database which indirectly connects to that file and so on. -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - 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: search problem
When I so a search on www.mysql.com I get this! ---snip--- Warning: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug in /production/data/nweb/public/udmsearch/mysql.php on line 25 Error: Could not connect to mysql: ---snip--- Simon Green Internet Systems Engineer -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. - 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
Optimizing Indexes and such in MySQL
I'm interested to know how people keep their MySQL tables up-to-date on a regular basis. what is the methodology used to keep up indexes up to date and tables optimized etc... thanks berber - 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 of mysql
Hello, I want to install the source distribution of Mysql on Solaris 2.7. I have make this: gzip mysql-3.23.45.tar.gz gtar xvf mysql-3.23.45.tar cd mysql-3.23.45 setenv CFLAGS -O3 setenv CXX gcc setenv CXXFLAGS -O3 -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/opuskit/pub/mysql-3.23.45 --enable-assembler --with-mysqld-ldflags=-all-static make The error message is: ld: fatal: Symbol referencing errors. No output written to .libs/mysqlbinlog collect2: ld returned 1 exit status *** Error code 1 make: Fatal error: Command failed for target `mysqlbinlog' Current working directory /home/scd2/tringa/pub/mysql-3.23.45/client *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /home/scd2/tringa/pub/mysql-3.23.45 *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' Help me please. Christine TRINGA. ST Microelectronics. - 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: Writing to net
Does anyone have an idea about what this is? I see this sometimes in the process list of MySQL. thanks berber - 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
FULLTEXT index question
Environment:
MySQL Version 3.23.42
FreeBSD 4.4
ISAM table of about 300,000 rows and 10 columns
with a column structured as varchar(50) upon which
exists a FULLTEXT index
Behavior:
The query
select * from tablename where match(column_name)
against('tree');
selects seven records.
The query
select * from tablename where match(column_name)
against('three');
fails to match any record.
Ten to twelve records in the table are know to have
the distinct word three in them in the indexed column.
Question:
Is this in any way expected behavior?
Thanks for any enlightenment.
query sql
-
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 does DISTINCT really work ?
Hi! Ok, Monty said that this DISTINCT ... ORDER BY bug has already been fixed in 4.0. Regards, Heikki Innobase Oy - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: SDiZ (UHome) [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 15, 2002 9:06 AM Subject: Re: How does DISTINCT really work ? Hi! - Original Message - From: SDiZ (UHome) [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 15, 2002 7:51 AM Subject: Re: How does DISTINCT really work ? I think every thing are documented. http://www.mysql.com/doc/B/u/Bugs.html a.. The optimiser may handle DISTINCT differently if you are using 'hidden' columns in a join or not. In a join, hidden columns are counted as part of the result (even if they are not shown) while in normal queries hidden columns doesn't participate in the DISTINCT comparison. We will probably change this in the future to never compare the hidden columns when executing DISTINCT An example of this is: SELECT DISTINCT mp3id FROM band_downloads WHERE userid = 9 ORDER BY id DESC; and SELECT DISTINCT band_downloads.mp3id FROM band_downloads,band_mp3 WHERE band_downloads.userid = 9 AND band_mp3.id = band_downloads.mp3id ORDER BY band_downloads.id DESC; In the second case you may in MySQL Server 3.23.x get two identical rows in the result set (because the hidden 'id' column may differ). Note that the this only happens for queries where you don't have the ORDER BY columns in the result, something that is you are not allowed to do in ANSI SQL. Ok, thank you for noting this! We should update the manual so that it mentions this exception to the rule on the proper page http://www.mysql.com/doc/S/E/SELECT.html And maybe also change the processing of DISTINCT so that there is no such exception to the rule. Regards, Heikki Innobase Oy - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 15, 2002 2:24 AM Subject: Fw: How does DISTINCT really work ? Forwarded from the general mailing list. Mail filter bait: How-To-Repeat - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, April 14, 2002 9:14 PM Subject: Re: How does DISTINCT really work ? Jocelyn, the below shows a bug in the MySQL DISTINCT operation. If you specify DISTINCT, you should not get duplicate rows. I have forwarded this email to Monty. Have you tried myisamcheck on the tables? If the tables are small, could you please upload them to the 'secret' directory in the MySQL support ftp server. I do not remember the directory exactly, but you have reported so many bugs in MySQL that maybe you remember :). Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - Original Message - From: DL Neil [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Sunday, April 14, 2002 8:01 PM Subject: Re: How does DISTINCT really work ? Hi Jocelyn, I don't have a quick/sure answer for you, but am wondering about the relationship between the date and topic columns - I note that the '429s are interspersed by other values. I'm a great believer in the KISS principle (simple things amuse simple minds!) May I suggest taking out the last three clauses (ORDER BY, DESC, and LIMIT) and trying that. Then if it works, put the clauses back, one at a time (from left to right), observing the effect. Please let me know how you get on, =dn So why does I obtain duplicates numbers for 'topic' with the first query with DISTINCT ? (perhaps a bug ?) Regards, Jocelyn Fournier - Original Message - From: DL Neil [EMAIL PROTECTED] To: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, April 14, 2002 5:54 PM Subject: Re: How does DISTINCT really work ? Hi Jocelyn, I wonder how works DISTINCT when using it with the following join. Ex : mysql SELECT DISTINCT topic FROM searchmainhardwarefr7,searchjoinhardwarefr7 WHERE searchmainhardwarefr7.numreponse=searchjoinhardwarefr7.numreponse AND (mot='test') AND date = '2002-03-24' ORDER BY date DESC LIMIT 0,20; ++ | topic | ++ | 108499 | | 108341 | | 108425 | | 108425 | |
Re: FULLTEXT index question
Hi!
On Apr 15, Nicholas Murphy wrote:
The query
select * from tablename where match(column_name)
against('three');
fails to match any record.
Ten to twelve records in the table are know to have
the distinct word three in them in the indexed column.
Question:
Is this in any way expected behavior?
Yes.
-
% grep three myisam/ft_static.c
three,
%
-
That is three is present in the stopword list.
Of course, you can remove it from there and rebuild MySQL
(and your indexes).
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
___/
-
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 does DISTINCT really work ?
Hi, I have the latest 4.0.2 source installed, and the problem is still here AFAIK : mysql \s -- mysql Ver 12.1 Distrib 4.0.2-alpha, for pc-linux-gnu (i686) -=[root@anedroide]=(/usr/local/mysql-4.0)# bk export -tpatch (13:29:52) # This is a BitKeeper generated patch for the following project: # Project Name: MySQL - fast and reliable SQL database # This patch format is intended for GNU patch command version 2.5 or higher. # This patch includes the following deltas: # ChangeSet1.1235 - 1.1236 # Docs/manual.texi1.865 - 1.866 # # The following is the BitKeeper ChangeSet Log # # 02/04/15 [EMAIL PROTECTED] 1.1236 # Documentation fix. # mysql SELECT DISTINCT topic FROM forum.searchmainpresencepc4,forum.searchjoinpresencepc4 WHERE searchmainpresencepc4.numreponse=searchjoinpresencepc4.numreponse AND (mot='les') ORDER BY date DESC LIMIT 0,40; +---+ | topic | +---+ | 11462 | cut | 12313 | | 9673 | | 11462 | cut | 12282 | | 9673 | | 12224 | +---+ 40 rows in set (0.06 sec) BTW I have a problem with the latest mysql client (12.1) : It seems to be locked when I make a 'use database' : mysql use forum Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A locked Regards, Jocelyn - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 15, 2002 1:06 PM Subject: Re: How does DISTINCT really work ? Hi! Ok, Monty said that this DISTINCT ... ORDER BY bug has already been fixed in 4.0. Regards, Heikki Innobase Oy - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: SDiZ (UHome) [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 15, 2002 9:06 AM Subject: Re: How does DISTINCT really work ? Hi! - Original Message - From: SDiZ (UHome) [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 15, 2002 7:51 AM Subject: Re: How does DISTINCT really work ? I think every thing are documented. http://www.mysql.com/doc/B/u/Bugs.html a.. The optimiser may handle DISTINCT differently if you are using 'hidden' columns in a join or not. In a join, hidden columns are counted as part of the result (even if they are not shown) while in normal queries hidden columns doesn't participate in the DISTINCT comparison. We will probably change this in the future to never compare the hidden columns when executing DISTINCT An example of this is: SELECT DISTINCT mp3id FROM band_downloads WHERE userid = 9 ORDER BY id DESC; and SELECT DISTINCT band_downloads.mp3id FROM band_downloads,band_mp3 WHERE band_downloads.userid = 9 AND band_mp3.id = band_downloads.mp3id ORDER BY band_downloads.id DESC; In the second case you may in MySQL Server 3.23.x get two identical rows in the result set (because the hidden 'id' column may differ). Note that the this only happens for queries where you don't have the ORDER BY columns in the result, something that is you are not allowed to do in ANSI SQL. Ok, thank you for noting this! We should update the manual so that it mentions this exception to the rule on the proper page http://www.mysql.com/doc/S/E/SELECT.html And maybe also change the processing of DISTINCT so that there is no such exception to the rule. Regards, Heikki Innobase Oy - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 15, 2002 2:24 AM Subject: Fw: How does DISTINCT really work ? Forwarded from the general mailing list. Mail filter bait: How-To-Repeat - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, April 14, 2002 9:14 PM Subject: Re: How does DISTINCT really work ? Jocelyn, the below shows a bug in the MySQL DISTINCT operation. If you specify DISTINCT, you should not get duplicate rows. I have forwarded this email to Monty. Have you tried myisamcheck on the tables? If the tables are small, could you please upload them to the 'secret' directory in the MySQL support ftp server. I do not remember the directory exactly, but you have reported so many bugs in MySQL that maybe you remember :). Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news
Create table from results of a query
Hi Is it possible to create a new table from the results of a query, or export the result directly to a file (txt, csv, excel or alike) using MySQL? How is it done? Thanks Renger -- Renger van Nieuwkoop [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
Create table from results of a query
Hi Is it possible to create a new table from the results of a query, or export the result directly to a file (txt, csv, excel or alike) using MySQL? How is it done? Thanks Renger -- Renger van Nieuwkoop [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: How does DISTINCT really work ?
Hi, Sorry finally there is no lock with 'use database', it only takes a huge amont of time because of the number of table in my database :) Regards, Jocelyn - Original Message - From: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; Heikki Tuuri [EMAIL PROTECTED] Sent: Monday, April 15, 2002 1:35 PM Subject: Re: How does DISTINCT really work ? Hi, I have the latest 4.0.2 source installed, and the problem is still here AFAIK : mysql \s -- mysql Ver 12.1 Distrib 4.0.2-alpha, for pc-linux-gnu (i686) -=[root@anedroide]=(/usr/local/mysql-4.0)# bk export -tpatch (13:29:52) # This is a BitKeeper generated patch for the following project: # Project Name: MySQL - fast and reliable SQL database # This patch format is intended for GNU patch command version 2.5 or higher. # This patch includes the following deltas: # ChangeSet1.1235 - 1.1236 # Docs/manual.texi1.865 - 1.866 # # The following is the BitKeeper ChangeSet Log # # 02/04/15 [EMAIL PROTECTED] 1.1236 # Documentation fix. # mysql SELECT DISTINCT topic FROM forum.searchmainpresencepc4,forum.searchjoinpresencepc4 WHERE searchmainpresencepc4.numreponse=searchjoinpresencepc4.numreponse AND (mot='les') ORDER BY date DESC LIMIT 0,40; +---+ | topic | +---+ | 11462 | cut | 12313 | | 9673 | | 11462 | cut | 12282 | | 9673 | | 12224 | +---+ 40 rows in set (0.06 sec) BTW I have a problem with the latest mysql client (12.1) : It seems to be locked when I make a 'use database' : mysql use forum Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A locked Regards, Jocelyn - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 15, 2002 1:06 PM Subject: Re: How does DISTINCT really work ? Hi! Ok, Monty said that this DISTINCT ... ORDER BY bug has already been fixed in 4.0. Regards, Heikki Innobase Oy - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: SDiZ (UHome) [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 15, 2002 9:06 AM Subject: Re: How does DISTINCT really work ? Hi! - Original Message - From: SDiZ (UHome) [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 15, 2002 7:51 AM Subject: Re: How does DISTINCT really work ? I think every thing are documented. http://www.mysql.com/doc/B/u/Bugs.html a.. The optimiser may handle DISTINCT differently if you are using 'hidden' columns in a join or not. In a join, hidden columns are counted as part of the result (even if they are not shown) while in normal queries hidden columns doesn't participate in the DISTINCT comparison. We will probably change this in the future to never compare the hidden columns when executing DISTINCT An example of this is: SELECT DISTINCT mp3id FROM band_downloads WHERE userid = 9 ORDER BY id DESC; and SELECT DISTINCT band_downloads.mp3id FROM band_downloads,band_mp3 WHERE band_downloads.userid = 9 AND band_mp3.id = band_downloads.mp3id ORDER BY band_downloads.id DESC; In the second case you may in MySQL Server 3.23.x get two identical rows in the result set (because the hidden 'id' column may differ). Note that the this only happens for queries where you don't have the ORDER BY columns in the result, something that is you are not allowed to do in ANSI SQL. Ok, thank you for noting this! We should update the manual so that it mentions this exception to the rule on the proper page http://www.mysql.com/doc/S/E/SELECT.html And maybe also change the processing of DISTINCT so that there is no such exception to the rule. Regards, Heikki Innobase Oy - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 15, 2002 2:24 AM Subject: Fw: How does DISTINCT really work ? Forwarded from the general mailing list. Mail filter bait: How-To-Repeat - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, April 14, 2002 9:14 PM Subject: Re: How does DISTINCT really work ? Jocelyn, the below shows a bug in the MySQL DISTINCT operation. If you specify DISTINCT, you should
Newbie question: Create table from query or export query
Hi Is it possible to create a new table from the results of a query, or export the result directly to a file (txt, csv, excel or alike) using MySQL? How is it done? Thanks Renger _ ECOPLAN Forschung und Beratung in Wirtschaft und Politik Economic Research and Policy Consultancy Thunstrasse 22 / CH-3005 Berne (Switzerland) Phone: +41 31 356 61 61 / Fax: +41 31 356 61 60 mailto:[EMAIL PROTECTED] / http://www.ecoplan.ch - 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
don't work search on www.mysql.org - no connect to mysql
Warning: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug in /production/data/nweb/public/udmsearch/mysql.php on line 25 Error: Could not connect to mysql: Kokorev Alexey E-mail: [EMAIL PROTECTED] | http://www.izhcom.ru/ Phone: +7-3412-510138, +7-3412-511920 Fax: +7-3412-512080 - 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
Running multiple queries using MySql client
Hello all, I'm in a mysql client session and I want to do multiple inserts into a table (or run a multi-query script etc). This doesn't work so what's the correct seperator / methodology? INSERT INTO mytbl (a1) VALUES (12); INSERT INTO mytbl (a1) VALUES (13); INSERT INTO mytbl (a1) VALUES (14); \g TIA Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bad Handshake
Hi i need to access a MySQL Server via socket programming to check if it is alive. My script works fine but the mysql server blocks the host that is running the script after 10 connects because I get the bad handshake error. Is there any way to connect and cleanly disconnect to port 3306 without increasing the error counter for that host ? regards -- Stefan Immel |N|O|C Network Operation Center -+-+-+--- | Grove Auf der Stuecke 6Tel. +49 2773-8167-0 35708 Haiger / Germany Fax +49 2773-8167-20 -- mailto:[EMAIL PROTECTED] http://www.grove.de There is always hope, only because it is the one thing nobody's figured out how to kill yet. ~ Galen, Crusade Racing The Night -- http://www.nocr2.de - NOC R2 die Lösung für den IT-Workflow -- - 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 question: Create table from query or export query
Yes. Assuming you are comfortable using the mysql client program you could use: CREATE TABLE newtablename SELECT * FROM existingtablename; In addition, if you have an existing table and need to load data from a text file you could use: LOAD DATA INFILE 'textfilename.txt' INTO TABLE existingtablename; There are many variations on these themes, but this should get you pointed in the right direction. Hope it helps. Craig Ostrander At 06:38 AM 4/15/2002, you wrote: Hi Is it possible to create a new table from the results of a query, or export the result directly to a file (txt, csv, excel or alike) using MySQL? How is it done? Thanks Renger _ ECOPLAN Forschung und Beratung in Wirtschaft und Politik Economic Research and Policy Consultancy Thunstrasse 22 / CH-3005 Berne (Switzerland) Phone: +41 31 356 61 61 / Fax: +41 31 356 61 60 mailto:[EMAIL PROTECTED] / http://www.ecoplan.ch - 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 === Craig Ostrander Blue Forest Software and Development Inc Database Design Consultants Worldwide MySQL // SAP DB // Oracle // Microsoft SQL Server // Microsoft Access Need help now? [EMAIL PROTECTED] or +1 530 326 5680 === spam filter: 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
gunk in mysqldump output
In some recent release of MySQL, lines like this: /*!4 ALTER TABLE States DISABLE KEYS */; ...were added to the output of mysqldump --opt. This causes my usually load statement: mysql dumpfile ...to fail with ERROR 1046 at line 11: No Database Selected. If I do mydsql -f dumpfile it works (with errors), but I figure I'm missing something. Why were these /*... lines added to dump output if they don't parse? Should I be using some alternate method for loading now? -bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How does DISTINCT really work ?
Hi! Heikki == Heikki Tuuri [EMAIL PROTECTED] writes: Heikki From: SDiZ (UHome) [EMAIL PROTECTED] I think every thing are documented. http://www.mysql.com/doc/B/u/Bugs.html a.. The optimiser may handle DISTINCT differently if you are using 'hidden' columns in a join or not. Heikki Ok, thank you for noting this! Heikki We should update the manual so that it mentions this exception to the rule Heikki on the proper page http://www.mysql.com/doc/S/E/SELECT.html I think nothing this in the bugs section should be clear enough. It's very hard to keep the manual up to date if you duplicate everything at all places. Heikki And maybe also change the processing of DISTINCT so that there is no such Heikki exception to the rule. This should already be fixed in MySQL 4.0. Regards, Monty - 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
Signal 11 after flush privileges
Hi Version Mysql-Max-3.23.49a for Linux, binary distribution from www.mysql.com After deleting some users from user table and invoking flush privileges, I got Lost connection to server during query Resolved stack trace as follows: 0x806e2d4 init_signals__Fv + 16 0x82b12b8 _end + 271548 0x82d9f96 _end + 438682 0x82d9e83 _end + 438407 0x8298ee6 _end + 172266 0x829e995 _end + 195481 0x80a4304 wild_case_compare__FPCcT0 + 28 0x807947a yyparse__Fv + 410 0x8077978 check_access__FP3THDUiPCcPUib + 172 0x80791fc reload_acl_and_cache__FP3THDUiP13st_table_list + 216 0x8074284 do_command__FP3THD + 2276 0x8073637 handle_bootstrap__FPv + 303 Any ideas? query,sql -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - 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: Create table from results of a query
Your, Monday, April 15, 2002, 2:40:54 PM, you wrote: YN Is it possible to create a new table from the results of a query, or YN export the result directly to a file (txt, csv, excel or alike) using YN MySQL? How is it done? Yes, it's possible. You can use CREATE .. SELECT statement for creating new table, look at: http://www.mysql.com/doc/C/R/CREATE_TABLE.html Take a look at SELECT INTO OUTFILE statement, for writing selected rows to a file: http://www.mysql.com/doc/S/E/SELECT.html YN Thanks YN Renger -- 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: hello, i need help, about mysql MISSING charsets
Xuefer, Monday, April 15, 2002, 8:55:08 AM, you wrote: X mysql-4.01 X binary package X windows X also the same in linux source/binary package X when SHOW VARIABLES X got: X - X character_set gbk X character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek X win1250 croat cp1257 latin5 X - X but in apache+php, file Apache\logs\error.log X got: X - X File 'c:\mysql\\share\charsets\gbk.conf' not found (Errcode: 2) X Character set '#28' is not a compiled character set and is not specified in the 'c:\mysql\\share\charsets\Index' file X - It might be PHP or Apache problem. Please, check how encoding works with another client (i.e. MySQL client package). Did you specified path to your character set dirs in the my.cnf (my.ini) file? X i've also compiled in linux with charset gbk X gbk should work, but it didn't What exactly doesn't work? X why? either with gb2312 X does MultiByte Charset support broken? X Xuefer -- 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: mysql server not starting
Terrence, Monday, April 15, 2002, 12:26:31 PM, you wrote: TT Description: TT MySQL version 3.23.47 Darwin 5.x TT When I run mysqladmin version, TT I get the following message: TT 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' TT (2)' TT Check that mysqld is running and that the socket: '/tmp/mysql.sock' TT exists! TT How-To-Repeat: TT type bin/mysqladmin -u root shutdown at the root of mysql TT type bin/mysqladmin version at mysql application root TT Fix: TT Perhaps determining the location of mysql.sock. I could not locate in on TT my machine, thought it supposed to install with mysql binary. mysql.socket is created when MySQL server starts. So, if you can't find mysql.socket anywhere - your MySQL server is not running (please, check it!). If your MySQL server is really running, set up path to your socket file with --socket option of mysqld or edit my.cnf file. You can also create a symbolik link to your socket file. -- 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 on FreeBSD
amber46, Monday, April 15, 2002, 1:21:54 PM, you wrote: a Ïðèâåòñòâóþ òåáÿ, mysql, This mailing list is read by thousands subscribers in the world and most of them don't speak russian, so please use ONLY english here. a 14350 mysql 57 0 53732K 30240K RUN365:15 79.88% 79.88% mysqld a 55153 www 2 0 11676K 4288K sbwait 0:00 1.62% 0.59% httpd a 55139 www 2 0 11656K 4316K sbwait 0:00 0.42% 0.29% httpd a Ñèñòåìà FreeBSD 4.4 release a RAM 512 How did you installed MySQL on this FreeBSD box? -- 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: Hi I'm a Newbie
sql,query I also looking for a good ASP 3.0 mailing list Peter Sampson http://www.cfcnet.co.uk The information contained in this email is intended only for the person or organization to which it is addressed. If you have received it by mistake, please disregard and notify the sender immediately. Unauthorized disclosure or use of such information may be a breach of legislation or confidentiality and may be legally privileged. Emails sent from and received by Members and employees of Norfolk County Council may be monitored. Unless this email relates to Norfolk County Council business it will be regarded by the Council as personal and will not be authorized by or sent on behalf of the Council. The sender will have sole responsibility for any legal actions or disputes that may arise. - 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: BUG using left join.
Hi, Note that if you are using a condition on a t_boxdaily field in the where clause, i think that your left join will not take the desired effect. If there is a record in table t_fund that it's not in t_boxdaily then the t_boxdaily fields would appear in the result with NULL values (because of the left join). But if you use a condition on table t_boxdaily in the where clause, those rows will not be in the result set. Try this using Q1: select name, sum(repurchasedunits) from t_fund left join t_boxdaily on t_fund.fundid = t_boxdaily.fundid where t_fund.fundid = 'BB01' group by name and Q2: select name, sum(repurchasedunits) from t_fund left join t_boxdaily on t_fund.fundid = t_boxdaily.fundid where t_fund.fundid = 'BB01' and t_boxdaily.boxdate '' group by name Instead of and t_boxdaily.boxdate '' choose a condition that is always true. The goal is that you see different results in Q1 and Q2... Steve Briant wrote: Hi, I think I may have spotted a bug in connection with the LEFT JOIN statement. The following SQL select name, sum(repurchasedunits) from t_fund left join t_boxdaily on t_fund.fundid = t_boxdaily.fundid where t_fund.fundid = 'BB01' group by name produces the output as below: name max(boxdate)sum(repurchasedunits) - Marleborough Fund Managers (BB01)2002-04-12 0 (1 row(s) affected) However, a slight change to the join as below: select name, sum(repurchasedunits) from t_fund left join t_boxdaily on t_fund.fundid = t_boxdaily.fundid where t_fund.fundid = 'BB01' and t_boxdaily.boxdate '19990101' group by name produces this output: name max(boxdate)sum(repurchasedunits) - (0 row(s) affected) As detailed in the release notes, this join should still give a match as per the first example shouldn't it ? What is causing it not to is that I have no records in t_boxdaily that have a boxdate previous to 1st January 1999. I am running MySQL version 3.23.37 under Windows 2000. Regards Steve Briant. -- dsoares (sql) - 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 does DISTINCT really work ?
Fournier Jocelyn [Presence-PC] writes: Hi, I have the latest 4.0.2 source installed, and the problem is still here AFAIK : mysql \s -- mysql Ver 12.1 Distrib 4.0.2-alpha, for pc-linux-gnu (i686) -=[root@anedroide]=(/usr/local/mysql-4.0)# bk export -tpatch (13:29:52) # This is a BitKeeper generated patch for the following project: # Project Name: MySQL - fast and reliable SQL database # This patch format is intended for GNU patch command version 2.5 or higher. # This patch includes the following deltas: # ChangeSet1.1235 - 1.1236 # Docs/manual.texi1.865 - 1.866 # # The following is the BitKeeper ChangeSet Log # # 02/04/15 [EMAIL PROTECTED] 1.1236 # Documentation fix. # mysql SELECT DISTINCT topic FROM forum.searchmainpresencepc4,forum.searchjoinpresencepc4 WHERE searchmainpresencepc4.numreponse=searchjoinpresencepc4.numreponse AND (mot='les') ORDER BY date DESC LIMIT 0,40; +---+ | topic | +---+ | 11462 | cut | 12313 | | 9673 | | 11462 | cut | 12282 | | 9673 | | 12224 | +---+ 40 rows in set (0.06 sec) BTW I have a problem with the latest mysql client (12.1) : It seems to be locked when I make a 'use database' : mysql use forum Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A locked Regards, Jocelyn Hi! Can you upload a gzipped dump of your table, so that we could check the above ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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 counter for HIGH traffic site
Hello. First let me say, that I was talking about the MySQL side of things. If pconnect was broken in this regard - and I would call the behaviour you described as broken - just don't use it. On Mon, Apr 15, 2002 at 12:14:07AM -0600, [EMAIL PROTECTED] wrote: Actually, with a pconnect, there would be a trade off. Since it uses a shared connection, the last insert ID could change between the update and calling the api function. That said, where did you get this from? As I read it, mysql_pconnect() reuses a connection _only_, if it remained open from an ealier - not if it is still in use. Else a lot of things would not work (e.g. using locks at all). This is taken from http://www.php.net/manual/en/function.mysql-pconnect.php and http://www.php.net/manual/en/features.persistent-connections.php There are some caveats, but only with side-effects of the fact that the connection will not be closed. I.e. regarding mysql_pconnect(), calling mysql_insert_id() from the PHP API should be safe as long as you did not call mysql_close(). Bye, Benjamin. But as I said, it doesn't matter for the counter. Matthew Walker Senior Software Engineer ePliant Marketing -Original Message- From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 14, 2002 9:47 PM To: Matthew Walker Cc: Craig Westerman; MySQL List Subject: Re: MySQL counter for HIGH traffic site Hi. There is a one-query method to do that and it is even explicitly documented: http://www.mysql.com/doc/M/i/Miscellaneous_functions.html (under LAST_INSERT_ID([expr])). This requires an UPDATE and using a client API function like mysql_insert_id(). No locks needed and the operation is atomic (i.e. no 'precision' trade-off). [...] -- [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
Uploading Korean Data
A while ago I was asking about multi-language support in MySQL. In the end we ran several instances of MySQL, each with it's own database, for each language. I can now run the website in Korean, enter, save and retrieve data through the webpage, but, I am unable to take a CSV file (in Korean) and upload to the database. Can anybody shed any light on how I can do this? When I upload the file it saves as garbage. Regards 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
Boolean!
Hello! Well their you have it! It's a mysql freakshow out there..:) How can I set the domain of a attribute to a boolean value? T.T - 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: Signal 11 after flush privileges
Rafal, Monday, April 15, 2002, 4:54:23 PM, you wrote: RJ Version Mysql-Max-3.23.49a for Linux, binary distribution from www.mysql.com RJ After deleting some users from user table and invoking flush privileges, I got RJ Lost connection to server during query Resolved stack trace as follows: RJ 0x806e2d4 init_signals__Fv + 16 RJ 0x82b12b8 _end + 271548 RJ 0x82d9f96 _end + 438682 RJ 0x82d9e83 _end + 438407 RJ 0x8298ee6 _end + 172266 RJ 0x829e995 _end + 195481 RJ 0x80a4304 wild_case_compare__FPCcT0 + 28 RJ 0x807947a yyparse__Fv + 410 RJ 0x8077978 check_access__FP3THDUiPCcPUib + 172 RJ 0x80791fc reload_acl_and_cache__FP3THDUiP13st_table_list + 216 RJ 0x8074284 do_command__FP3THD + 2276 RJ 0x8073637 handle_bootstrap__FPv + 303 RJ Any ideas? Can you create a repeatable testcase for it ? -- 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: Boolean!
Hi T., How can I set the domain of a attribute to a boolean value? OK, I'm not entirely clear with your terminology, but I think you're asking how do I define a field as a boolean... MySQL doesn't provide a boolean datatype as such, but in my experience the best way to handle it is to define a field as a smallint and use 1 for true and 0 for false. Cheers Jon - 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: Signal 11 after flush privileges
Rafal, Monday, April 15, 2002, 4:54:23 PM, you wrote: RJ Version Mysql-Max-3.23.49a for Linux, binary distribution from www.mysql.com RJ After deleting some users from user table and invoking flush privileges, I got RJ Lost connection to server during query Resolved stack trace as follows: RJ 0x806e2d4 init_signals__Fv + 16 RJ 0x82b12b8 _end + 271548 RJ 0x82d9f96 _end + 438682 RJ 0x82d9e83 _end + 438407 RJ 0x8298ee6 _end + 172266 RJ 0x829e995 _end + 195481 RJ 0x80a4304 wild_case_compare__FPCcT0 + 28 RJ 0x807947a yyparse__Fv + 410 RJ 0x8077978 check_access__FP3THDUiPCcPUib + 172 RJ 0x80791fc reload_acl_and_cache__FP3THDUiP13st_table_list + 216 RJ 0x8074284 do_command__FP3THD + 2276 RJ 0x8073637 handle_bootstrap__FPv + 303 RJ Any ideas? Can you create a repeatable testcase for it ? Not really :(. I tried the same operations and this time it didn't crash -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - 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
Is there a sql query to Copying tables
Is there an easy way to copy/use the structure (not data) of a skeleton table to a new table? Thanks in advance PS how long has the sql,query requirement been on this list? - 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 counter for HIGH traffic site
Hello. On Sun, Apr 14, 2002 at 11:16:02PM -0400, [EMAIL PROTECTED] wrote: On Sun, 2002-04-14 at 22:17, Craig Westerman wrote: I'm needing counter for site that receives 80 to 120 hits a minute at peak load. Many I [...] I personally wouldn't recommend logging to mysql. 80 to 120 queries a second Please note that he talked about minutes and not seconds. Yes, I wouldn't call 100 hits a minute a high load server, either. :-) would overload a db server. Sorry? I dare to differ. Because I can do something like about 5.000 inserts/sec on my production machine, I did a small test: On my slower development machine[1], I can execute about 3800 dummy queries[2] or 1800 counter updates[3] per second. So no, 80-120 queries/sec don't overload a MySQL server. They only do, if they are more complex and not a simple counter. Of course, that wouldn't allow for an equivalent of 1800 page hit because there is other work involved. But, well, you were talking about the MySQL part being too slow. Because the same machine serves about 125 static pages/sec[4] with Apache 1.3.12, I would say the bottleneck is not with MySQL. Bye, Benjamin. [1] PIII 450MHz, 384MB, IDE disk [2] SELECT 1, measured with 100.000 queries [3] UPDATE login SET last_count=LAST_INSERT_ID(last_count+1) WHERE gid=id with random(!) ids to a table with about 33 entries (i.e. one of 33 counters!). [4] measured with 10 concurrent clients making each 1000 hits; btw, less than I had guessed. -- [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: Boolean!
I use char(1) with 't' and 'f'. The JDBC-Driver I am using (mm.sql) recognizes this correctly as Boolean. Peter -Original Message- From: Jon Haworth [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 5:24 PM To: 'T.Thiessens'; [EMAIL PROTECTED] Subject: RE: Boolean! Hi T., How can I set the domain of a attribute to a boolean value? OK, I'm not entirely clear with your terminology, but I think you're asking how do I define a field as a boolean... MySQL doesn't provide a boolean datatype as such, but in my experience the best way to handle it is to define a field as a smallint and use 1 for true and 0 for false. Cheers Jon - 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
Compile Problem - sql_lex.cc has undeclared functions (symbol, sql_functions, get_has_symbol)
I'm unable to get mysql compiled due to problems during my make. I am using gcc 3.04 on a Sparc 20 running Solaris: uname -a: SunOS primus 5.8 Generic_108528-06 sun4m sparc SUNW,SPARCstation-20 When I run the make I get the following problem with sql_lex.cc sql_lex.cc: In function `void lex_init()': sql_lex.cc:85: `symbols' undeclared (first use this function) sql_lex.cc:85: (Each undeclared identifier is reported only once for each function it appears in.) sql_lex.cc:87: `sql_functions' undeclared (first use this function) sql_lex.cc: In function `int find_keyword(LEX*, unsigned int, bool)': sql_lex.cc:168: `get_hash_symbol' undeclared (first use this function) make[3]: *** [sql_lex.o] Error 1 make[3]: Leaving directory `/nn/local/src/mysql-3.23.49-src/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/nn/local/src/mysql-3.23.49-src/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/nn/local/src/mysql-3.23.49-src' make: *** [all-recursive-am] Error 2 Anyone know why this is occurring? Thanks, Aaron ~ - 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: Boolean!
How can I set the domain of a attribute to a boolean value? OK, I'm not entirely clear with your terminology, but I think you're asking how do I define a field as a boolean... MySQL doesn't provide a boolean datatype as such, but in my experience the best way to handle it is to define a field as a smallint and use 1 for true and 0 for false. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Num eric_types MySQL does offer a boolean substitute, also smallint is a bit big for a true/false column. BOOL or tinyint(1) unsigned would probably be your best options for a boolean column need. 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
RE: Is there a sql query to Copying tables
Hi, You can just do SHOW CREATE TABLE ... and copy+paste it with a different table name in the command line.. See: http://www.mysql.com/doc/S/H/SHOW_CREATE_TABLE.html Or else, if you are using phpMyAdmin , you can do it with a mouse click. Gurhan -Original Message- From: Jason [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 11:45 AM To: [EMAIL PROTECTED] Subject: Is there a sql query to Copying tables Is there an easy way to copy/use the structure (not data) of a skeleton table to a new table? Thanks in advance PS how long has the sql,query requirement been on this list? - 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: Boolean!
ENUM datatype might help you... See: http://www.mysql.com/doc/E/N/ENUM.html Gurhan -Original Message- From: T.Thiessens [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 10:50 AM To: [EMAIL PROTECTED] Subject: Boolean! Hello! Well their you have it! It's a mysql freakshow out there..:) How can I set the domain of a attribute to a boolean value? T.T - 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: update question number in mysql
Hi, Steven and christopher, Thanks a lot for your help. I think i have to store the question number in table. my talbe questionbank store the questions related more than one course. every course has six question sets. so i use question set id and question number as primary key. There is one problem is every time i delete one question for example delete question 5, i have to update all the question numbers after question 5 in this question set.(for example if there is 10 question in this set, i delete question 5 i have to update question numbers for question 6,7 8 9,10 to 5,6,7,8,9) it will take some time. but i think this is for administrator so maybe speed is not very serious issue. Thanks steven for his recommendation for the transactional table i will take a look at it. This is great mailing list. Thanks again bin cai --- Steven Hajducko [EMAIL PROTECTED] wrote: On Fri, 2002-04-12 at 13:52, Christopher Thompson wrote: You shouldn't be storing the questio number at all. You have denormalised your database and this is why you are experiencing this problem. Maybe I don't understand bin's problem, but storing the question # wouldn't seem to be de-normalizing. It would only matter on how he plans on storing it. It would seem to matter on a few things - 1) Is he planning on storing more than 1 exam? 2) Can an exam really have the same question #, twice? If yes, then - Are the questions split upon sections of the exam? Are the questions the same, but have subsections? ( 1a, 1b ? ) From the looks of it, he doesn't seem to want to store more than 1 exam anyways. If he did, he could use a 2 field primary key of exam name and question number. There just isn't enough information on what he wants to do. Instead, store a unique identifier with each one (an 'id' field, autonumbering) and then, when you pull back all the questions, order it by this ID field. Your questions won't have numbers assigned to them but you can do that in whatever app uses the questions. Why not use the question number? It's unique per exam. (Or should be?). I can see the case of doing this would help in his problem of the first and second query, but what if someone enters questions out of order? If he deletes a question, then tries to re-insert it, it would end up being the last question in the exam. You might want to look into using a transactional table bin. Then, you could BEGIN the change, then after your two queries are both completed, commit the change. Therefore, if your computer crashed in the middle of the query, the table would revert to the old form. Of course, the truth is that you _can_ do what you want just using SQL. But trust me, you don't want to. It would be at least O(n^2), I think, and would be a pain to write. On Friday 12 April 2002 2:38 pm, bin cai wrote: Hello, verybody, I am afraid to send my question again. i created a table in mysql database system to store exam questions which has the following column fields: questionnumber(integer),questionbody(String), answers (String) and etc. My problem is if i delete one row(question record) how can iupdate the questionnumber in the easiest way which means mysql can do for me. Is it possible? or i have to write a method to update questionnumber. if In second case i got another worry. for example, i wrote two querys,one is to delete this question record another query is to update the questionnumber,that is , all records whose questionnumbers are greater than the questionnumber of the deleted question should deducted by 1. if at the time After the first query is executed successfully and the second query is being executed, the computer is crashed. the second query will be rolled back. so the question is deleted but the questionnumber is not updated. this will result in a mess. If anybody can give me some hint i will appreicate very much Have a good weekend bin __ Music, Movies, Sports, Games! http://entertainment.yahoo.ca - 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?
Re: Is there a sql query to Copying tables
Is there an easy way to copy/use the structure (not data) of a skeleton table to a new table? create table x select * from table y where 1=0; -Lance filter: sql - 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: Is there a sql query to Copying tables
CREATE TABLE new_table SELECT * FROM old_table LIMIT 0; - Original Message - From: Jason [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 15, 2002 10:44 AM Subject: Is there a sql query to Copying tables Is there an easy way to copy/use the structure (not data) of a skeleton table to a new table? Thanks in advance PS how long has the sql,query requirement been on this list? - 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
Connection timing problem?
Hi, I have installed MySQL and everything runs great. Most of the apps I'm running are perfectly fine except one problem: Through a webpage of mine I send a request to the database. Works great and I get a return no problem with the correct response. But when I ask it again right away to do another query, it just idles out. If I wait about a minute or two before I submit the next query I get a timely response like my initial one. I have this test running on 2 different installations of MySQL on 2 different servers. One virtually hosted and the other is the one I have the time problem with. Works great on the virtual hosted, mine I have to wait before sending the next query. Is there a setting somewhere that handles this? ps. In case its not painfully obvious I'm new at this and struggling with this particular problem. Any help is always, greatly appreciated. Example: Time problem: http://www.waysidepress.com/pages/FLASH/faq.html (search the word 'phone'). Normal response: http://www.synergystudio.ca/faq.html When the first response is returned, click on a resulting link for the next query. Both will return the first search fine. -- Todd Thompson Wayside Press Ltd. (Peerless Plant) 1172 Battle Street Kamloops, BC V2C 2N5 Ph: 250.372.3373 Fax: 250.828.6848 - 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: Bill-of-Materials
So far I have seen this feature in Oracle and DB2 alone. I am yet to find any other RDBMS. Vivek Chaudhary -Original Message- From: len [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 13, 2002 7:10 AM To: mysql Cc: len Subject: Bill-of-Materials Hello! As a newbie to MySQL (and used to be running DB2), I'm looking for a way to explode a bill-of-materials table. Is there any support for recursive SQL in MySQL, for example by using standard common table expressions? Thanks in advance! Lennart Henäng Henfield AB Sollentuna, Sweden - 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
Problems with Make on 3.23.49 on Sun SPARC 20 with Solaris 2.6
Description: Attempted to compile this version on a SPARC 20 running Solaris 2.6. Installed GNU gcc 3.0.2 and make 2.76 specifically for this installation. Normally use the make from SUN and the C compiler from Sun SparcWorks. Ran configure with the following set of command line options. --with-innodb --datadir=/misc4/data --enable-assembler --with-low-memory The last option was inserted with the first attempt of configure aborted on a return from sprintf and a conflict with cross compiling. After inserting the 4th command line option for configure it ran to completion. However it aborted with the following lines displayed. make all-recursive Making all in include make[1]: Entering directory `/users/lw06305/work/mysql-3.23.49/include' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/users/lw06305/work/mysql-3.23.49/include' Making all in Docs make[1]: Entering directory `/users/lw06305/work/mysql-3.23.49/Docs' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/users/lw06305/work/mysql-3.23.49/Docs' Making all in readline make[1]: Entering directory `/users/lw06305/work/mysql-3.23.49/readline' gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O3 -DDBUG_O FF -O3 -DHAVE_RWLOCK_T -c readline.c gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O3 -DDBUG_O F F -O3 -DHAVE_RWLOCK_T -c funmap.c gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O3 -DDBUG_O FF -O3 -DHAVE_RWLOCK_T -c keymaps.c gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O3 -DDBUG_O FF -O3 -DHAVE_RWLOCK_T -c vi_mode.c gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O3 -DDBUG_O FF -O3 -DHAVE_RWLOCK_T -c parens.c gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O3 -DDBUG_O FF -O3 -DHAVE_RWLOCK_T -c rltty.c gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O3 -DDBUG_O FF -O3 -DHAVE_RWLOCK_T -c complete.c gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O3 -DDBUG_O FF -O3 -DHAVE_RWLOCK_T -c bind.c /usr/ccs/bin/as: /fin/tmp/ccPKI9qJ.s, line 413: error: unknown opcode .subsectio n /usr/ccs/bin/as: /fin/tmp/ccPKI9qJ.s, line 413: error: statement syntax /usr/ccs/bin/as: /fin/tmp/ccPKI9qJ.s, line 489: error: unknown opcode .previous /usr/ccs/bin/as: /fin/tmp/ccPKI9qJ.s, line 489: error: statement syntax make[1]: *** [bind.o] Error 1 make[1]: Leaving directory `/users/lw06305/work/mysql-3.23.49/readline' make: *** [all-recursive] Error 1 *** Error code 2 make: Fatal error: Command failed for target `all-recursive-am' About 18 months ago I installed MySQL successfully on this same platform. Last week I installed a much earlier version but we need to install a version that contains support for INNODB tables. I was urged by Paul Dubois to compile and install from the source distribution. How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:System Administrator Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.22.32 (TCX binary) Server: /usr/local/mysql/bin/mysqladmin Ver 8.0 Distrib 3.22.32, for sun-solaris2.5.1 on sparc TCX Datakonsult AB, by Monty Server version 3.22.32 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 5 days 5 hours 23 min 25 sec Threads: 1 Questions: 73 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 2 Environment: machine, os, target, libraries (multiple lines) System: SunOS dorsal 5.6 Generic_105181-31 sun4m sparc SUNW,SPARCstation-20 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /opt/SUNWspro/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/3.0.2/specs Configured with: ../configure --with-as=/usr/local/bin/as --with-ld=/usr/local/bin/ld : (reconfigured) ../configure --with-as=/usr/local/bin/as --with-ld=/usr/local/bin/ld Thread model: posix gcc version 3.0.2 Compilation info: CC='gcc' CFLAGS='-O3 -fomit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=TCX binary' --with-low-memory --disable-shared Perl: This is perl, version 5.004_04 built for sun4-solaris Thanks for your help. Tom Lee Group Lead LM AERO - Field Information Network Software Development/Administration Group VOICE: 817-763-6541 FAX: 817-763-6548
beginners question
I'm converting an Access database to mySql (finally), and I'm having some problems: #1 - I have created a text file from Access to be able to import the data into the mySQL db, that part is ok, the problem is, from my 12 records (just a sample project), mySQL is only importing 6, the odd number records... very odd! why?? #2 - how do I make mySQL understand special characters, such as é... for fiancé?? Thanks, MM - 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: cron job help running mysql/php script
I am trying different options but everytime i make a change and type crontab mycron.txt in telnet it comes to the next promp without an error message. But it doesnot do what i want it to do. How can i even test if the cron tab is finding the file. Like the php file runs fine when run from a browser. But nothing is happening no matter what i cange in mycron.txt file. Help is appreciated . please refer me to a tutorial where i can start form scratch as this is my first cron job. my mycron.txt file has the following one single line. * * * * * /home/harpreet/crontest.php I have the crontest.php file and the mycron.txt file under/home/harpreet folder. Thanks, Regards, Harpreet Kaur From: Steven Deaton [EMAIL PROTECTED] To: Harpreet Kaur [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: cron job help running mysql/php script Date: Fri, 12 Apr 2002 14:06:56 -0700 You might try a lynx --dump ?? ---Steven Deaton - Original Message - From: Harpreet Kaur [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, April 12, 2002 1:52 PM Subject: cron job help running mysql/php script I wrote my first cron job to run a php script once every minute. The command i wrote is as follows: * * * * * * lynx http://domain ip address/scripts/crontest.php It doesnt seem to work as i tell it to populate the log table in the database. It runs fine when run through the browser. Where am i going wrong? I saved the above line in a text file and put in my home directory. Please help. Regards, Harpreet mysql cron help _ 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 - 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 _ 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
mysqld cannot start - Can't find file: './mysql/host.frm' (errno: 13)
Description: I installed the binary distribution (first time I am installing mysql ever) for Solaris 8 in a non-standard location (/data/mysql/3.23.47/SunOS_5.8) which is local on the server. I then moved the data directory to a file server so it will be part of daily backups (/proj/webamt/rel/mysqldb). I followed the steps in the INSTALL-BINARY file for the non-standard location. I changed all permissions and ownership as described in the doc - modified and copied the startup script, support-files/mysql.server to /etc/init.d and made symbolic links in rc2.d. Then (as root) I ran 'scripts/mysql_install_db --datadir=/proj/webamt/rel/mysqldb' and then 'bin/safe_mysqld --user=mysql --datadir=/proj/webamt/rel/mysqldb ' and the following error was reported in the log file (/proj/webamt/rel/mysqldb/amthq2.err): 020415 11:33:39 mysqld started 020415 11:33:39 /data/mysql/3.23.47/SunOS_5.8/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020415 11:33:39 mysqld ended How-To-Repeat: Fix: Submitter-Id: [EMAIL PROTECTED] Originator:Magnus Larsson Organization: Ericsson Amplifier Technologies Inc. 49 Wireless Blvd. Hauppauge, NY 11788 USA MySQL support: none Synopsis: Startup/config truoble Severity: non-critical Priority: medium Category: mysql Class: support Release: mysql-3.23.47 (Official MySQL binary) Environment: Sun Netra T1 (Ultra-SPARC), 1 GB RAM, 64 GB HDD; Solaris 8 (64-bit); /data/mysql/3.23.47/SunOS_5.8 (install dir); /proj/webamt/rel/mysqldb (database dir); LD_LIBRARY_PATH /data/mysql/0/SunOS_5.8/lib:/data/webserver/1.0.1/SunOS_5.8/lib:/usr/lib:/usr/local/lib:/usr/dt/lib:/usr/openwin/lib:/usr/ccs/lib:/usr/share/lib System: SunOS amthq2 5.8 Generic_108528-09 sun4u sparc SUNW,UltraAX-i2 Architecture: sun4 Some paths: /data/webserver/1.0.1/SunOS_5.8/bin/perl /data/webserver/1.0.1/SunOS_5.8/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1759400 Jul 30 2001 /lib/libc.a lrwxrwxrwx 1 root root 11 Aug 3 2001 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136720 Jul 30 2001 /lib/libc.so.1 -rw-r--r-- 1 root bin 1759400 Jul 30 2001 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Aug 3 2001 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136720 Jul 30 2001 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --enable-assembler --disable-shared - 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 stored procedures - v4.1 :(
I'll trust a MySQL alpha release before the final production releases of most vendors. In fact, we're using 4.0.1 in our production environment with great success. Its your system, and if you think it worth the risc, it is of course you decision to do so to, ;) but I would never ever trust _any_ code in an alpha-development stage. Anyone how does that is likely to get a big surprise, sooner or later - or they are just very lucky if nothing happens. Using Alpha-code in a production environment is not only doing a high risk experiment, but also nothing I never would recommend someone to do with my honor preserved. My point was that the developers of MySQL tend to be much more conservative than other developers, and what they call alpha is typically vastly more stable than the beta (and sometimes production) releases of other vendors. Does anyone more than me thinks that this smells lack of system testing? ;) Or perhaps they're better at writing robust code than you are? Let me just say this: I've never known MySQL to lose data -- even with the alpha releases I've used -- but I *have* seen production, stable, Oracle releases scramble data (or seg fault, or ...). I'm impressed if they, really, can achieve this goal - which I of courses doesn't believe in a single second. ;) Do you often pre-judge products based on experience with unrelated vendors and products? It seems to me you're saying Gee, such a statement has never been true for Windows (or Word, or PostgreSQL, or whatever) so it must not ever be true for any product. So why not call it release to avoid confusion then? Again, the developers of MySQL are much more conservative than most, which is why their production releases tend to be vastly more stable than the production releases of other vendors -- and why they can do things like ship a release with no known bugs. First rule: Every release date slips. ;) Lemma: If released at correct date, either the software is to buggy to use, or it misses, important, promised features of that release. ;) Again: You're projecting your lack of skill (or the arrogance upon which your project timeline estimates are based) onto others. That's strange. I would say that stored procedures is a highly useful thing to have had implimented in a RDBMS. What's strange about it? They don't plan on releasing it until they have an implementation that is fast, and robust. Funny, I didn't see one single comment in your e-mail that contributes to the discussion in a meaningful way. Your snide comments only serve as an irritant. Perhaps you're trying to show everyone how smart you are, but instead you just come off as arrogant and ignorant. -JF - 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
Uploading Korean Data - More detail
Apologies for sending again but though it may help if I add some more info. I can see my data in notepad in Korean, I have tried to save this as ANSI, Unicode, Unicode big enidian and UTF-8 and they all end up scrambled after I import the file. - A while ago I was asking about multi-language support in MySQL. In the end we ran several instances of MySQL, each with it's own database, for each language. I can now run the website in Korean, enter, save and retrieve data through the webpage, but, I am unable to take a CSV file (in Korean) and upload to the database. Can anybody shed any light on how I can do this? When I upload the file it saves as garbage. Regards 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: MySQL and stored procedures - v4.1 :(
But I did ask for a release date of version 4.1. When it's ready. A nice thing with a stored procedure is that you can lower the load impact made by heavy queries on the database by using cursors to soften the performance hit they are likely to make - e.g. make the query behave like a high intensive interactive user instead of a huge one single shot batch job. It sounds like cursors are the feature that improves performance, not stored procedures. Cursors are another item on MySQL's TODO list. (Planned for 4.1 or 4.2) Let's say I need to do 10 millions inserts. In what way will bundling all these 10 million inserts into one single batch give me some gain? Bundling them into batches of say 1,000 will minimize the number of disk operations MySQL must perform. If your database supports lock tables (like MySQL and Oracle), this should help to ensure that the index cache is only flushed once after all updates. If you have a frequent interactive used system, then the time spent in high transaction isolation levels should kept to a minimum. Giving general thump rule advices about how to implimenbt a system whithout having knowledge about the intention of a system is like saying that one should spit on the left side of the boat - just to bad if you have the wind in the face when you do it... That's funny, I read the statement to be of the form using X can minimize Y, (X = LOCK TABLES, Y=index cache flush events) whereas you seem to have read it as use X to improve performance. The author was not giving generic advice of how to make things faster, he was giving specific advice on how to avoid a particular performance problem. -JF - 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
Sorting alphabetically using charsets other than Latin 1
Hello, I have a table with text data in English in one column, same data in Russian (cp1251) in another, and so on. I'd be happy to retrive that data sorted alphabetically according to the *respected alphabets*. I couldn't figure out how to perform this despite I compiled MySQL with alternative charsets option. Is it possible, and if yes, how? Of course, I can ask Perl to do this for me, but this is not an elegant solution, is it? Also, is it possible to add month names in other languages to date/time formatting options without digging too deep into source code? (I have to confess I do not know much about C or C++). Thanks in advance, Tom - 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
MySQLAdmin
Please, can anyone tell me where is the source code for MySQLAdmin.exe for Win32? Thank you - 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 stored procedures - v4.1 :(
But I did ask for a release date of version 4.1. When it's ready. That's a tautological answer. A nice thing with a stored procedure is that you can lower the load impact made by heavy queries on the database by using cursors to soften the performance hit they are likely to make - e.g. make the query behave like a high intensive interactive user instead of a huge one single shot batch job. It sounds like cursors are the feature that improves performance, not stored procedures. Cursors are another item on MySQL's TODO list. (Planned for 4.1 or 4.2) That was, unfortunately bad news. Let's say I need to do 10 millions inserts. In what way will bundling all these 10 million inserts into one single batch give me some gain? Bundling them into batches of say 1,000 will minimize the number of disk operations MySQL must perform. Well, but now the claim was to bundle all the little small bundles to one big bundle to increase performance. So saying that I now should make the big bundle into a little bundle is not really confirming with the original statement - rather contradicting it. If your database supports lock tables (like MySQL and Oracle), this should help to ensure that the index cache is only flushed once after all updates. If you have a frequent interactive used system, then the time spent in high transaction isolation levels should kept to a minimum. Giving general thump rule advices about how to implimenbt a system whithout having knowledge about the intention of a system is like saying that one should spit on the left side of the boat - just to bad if you have the wind in the face when you do it... That's funny, I read the statement to be of the form using X can minimize Y, (X = LOCK TABLES, Y=index cache flush events) whereas you seem to have read it as use X to improve performance. Since you cut away the part I - really - gave the remark on, it is a bit hard for me to make any statement on that comment. The author was not giving generic advice of how to make things faster, he was giving specific advice on how to avoid a particular performance problem. That's only your opinion in the question and has nothing to do with the real facts. - 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: beginners question
show your table structures show us your data show us the commands you used to export the data show us the commands you used to import the data can't read your mind... - Original Message - From: Marcia Clover [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 15, 2002 12:11 PM Subject: beginners question I'm converting an Access database to mySql (finally), and I'm having some problems: #1 - I have created a text file from Access to be able to import the data into the mySQL db, that part is ok, the problem is, from my 12 records (just a sample project), mySQL is only importing 6, the odd number records... very odd! why?? #2 - how do I make mySQL understand special characters, such as é... for fiancé?? Thanks, MM - 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: beginners question
actually, another member of this list has already helped me figure it out. thanks. -Original Message- From: Richard Emery [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 3:42 PM To: Marcia Clover; [EMAIL PROTECTED] Subject: Re: beginners question show your table structures show us your data show us the commands you used to export the data show us the commands you used to import the data can't read your mind... - Original Message - From: Marcia Clover [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 15, 2002 12:11 PM Subject: beginners question I'm converting an Access database to mySql (finally), and I'm having some problems: #1 - I have created a text file from Access to be able to import the data into the mySQL db, that part is ok, the problem is, from my 12 records (just a sample project), mySQL is only importing 6, the odd number records... very odd! why?? #2 - how do I make mySQL understand special characters, such as é... for fiancé?? Thanks, MM - 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: cron job help running mysql/php script
crontab -l will list your current crontab entry. Cron is not running your job from a browser. If it won't run from your unix $ prompt, it won't run from cron. Harpreet Kaur wrote: I am trying different options but everytime i make a change and type crontab mycron.txt in telnet it comes to the next promp without an error message. But it doesnot do what i want it to do. How can i even test if the cron tab is finding the file. Like the php file runs fine when run from a browser. But nothing is happening no matter what i cange in mycron.txt file. Help is appreciated . please refer me to a tutorial where i can start form scratch as this is my first cron job. my mycron.txt file has the following one single line. * * * * * /home/harpreet/crontest.php I have the crontest.php file and the mycron.txt file under/home/harpreet folder. Thanks, Regards, Harpreet Kaur From: Steven Deaton [EMAIL PROTECTED] To: Harpreet Kaur [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: cron job help running mysql/php script Date: Fri, 12 Apr 2002 14:06:56 -0700 You might try a lynx --dump ?? ---Steven Deaton - Original Message - From: Harpreet Kaur [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, April 12, 2002 1:52 PM Subject: cron job help running mysql/php script I wrote my first cron job to run a php script once every minute. The command i wrote is as follows: * * * * * * lynx http://domain ip address/scripts/crontest.php It doesnt seem to work as i tell it to populate the log table in the database. It runs fine when run through the browser. Where am i going wrong? I saved the above line in a text file and put in my home directory. Please help. Regards, Harpreet mysql cron help _ 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 - 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 _ Join the world's 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 - 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: Copying tables
I though everyone may wish to know, I found an easy way to do this. SHOW CREATE TABLE table_name This will give you the SQL syntax for a createtable... Thanks everyone - Original Message - From: [EMAIL PROTECTED] To: Jason [EMAIL PROTECTED] Sent: Monday, April 15, 2002 9:24 AM Subject: Re: Copying tables 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 an easy way to copy/use the structure (not data) of a skeleton table to a new table? Thanks in advance - 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: Feature? (Not null and timestamps)
sql,query One of our developers pointed out something to me today and I can't explain. When we created a table with timestamp as one of the column types and not null the describe table command shows that nulls are allowed for the timestamp column. However, a show create table command shows the not null for the timestamp column. Which is correct? How do I make the column not null? Carl McNamee Systems Administrator Billing Concepts (210) 949-7282 - 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
Timestamp and Load Data command
We are attempting to put records into a table using the load data or mysqlimport commands. One quirk is with columns that include a timestamp type. When we import the records we get zeros in the timestamp column. How can we get the current time inserted when using the load data or mysqlimport commands? Carl McNamee Systems Administrator Billing Concepts (210) 949-7282 - 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
subselect query
I'm trying to do a fairly simple select of a column from a table where the date of that column happens to be the highest value. I tried this: SELECT name FROM products WHERE prod_type='foo' AND added=(SELECT MAX(added) FROM products WHERE prod_type='foo'); But I get the error: ERROR 1064: You have an error in your SQL syntax near 'SELECT MAX(added) FROM products WHERE prod_type='foo')' at line 1 Is there a problem with the parentheses? I've used this syntax with Oracle before with no troubles. name and prod_type are TINYTEXT and added is a DATE. Is there another way I should be doing this? I could probably order descending by the added date and then just LIMIT 1, but I don't think that's very clean. 'mysql --version' returns: mysql Ver 11.15 Distrib 3.23.41, for -freebsd4.4 (i386) Thanks in advance, -- Jeff Shippy Shipman E-Mail: [EMAIL PROTECTED] Computer Science MajorICQ: 1786493 New Mexico Institute of Mining and Technology Homepage: http://www.nmt.edu/~shippy - 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: subselect query
Read the manual. MySQL doesn't support subselects but offers you alternatives. On Monday 15 April 2002 2:45 pm, Jeff Shipman wrote: I'm trying to do a fairly simple select of a column from a table where the date of that column happens to be the highest value. I tried this: SELECT name FROM products WHERE prod_type='foo' AND added=(SELECT MAX(added) FROM products WHERE prod_type='foo'); But I get the error: ERROR 1064: You have an error in your SQL syntax near 'SELECT MAX(added) FROM products WHERE prod_type='foo')' at line 1 Is there a problem with the parentheses? I've used this syntax with Oracle before with no troubles. name and prod_type are TINYTEXT and added is a DATE. Is there another way I should be doing this? I could probably order descending by the added date and then just LIMIT 1, but I don't think that's very clean. 'mysql --version' returns: mysql Ver 11.15 Distrib 3.23.41, for -freebsd4.4 (i386) Thanks in advance, - 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 dying suddenly
I received the message that made our MySQL die sometimes now. Our mysqld is the binary package available @ www.mysql.com. Version is 3.23.49a The error message is below. key_buffer_size=16773120 record_buffer=1019904 sort_buffer=1048568 max_used_connections=284 max_connections=500 threads_connected=59 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 1026376 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x807bb5f 0x82a94aa 0x82cc0d5 0x82c31ae 0x82ca6b5 0x8077a6c 0x8080ca0 Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at (nil) is invalid pointer thd-thread_id=521437 Since in this version everything is compiled statically, I don't know what is wrong exactly. The log has the following information: 521437 Connect [EMAIL PROTECTED] on 521437 Init DB vagas 521437 Query select * from temp_vg_olhados where idvg=404147 and tabela = 'vagasvg' 521437 Init DB vagas 521437 Query update temp_vg_olhados set nvg_olhados = nvg_olhados + 1 where idvg=404147 and tabela = 'vagasvg' apparently an innocent query followed by an update. The binary package is statically linked ad it started happening after we started using InnoDB. The version is, actually, 3.23.49a-Max. Although I can't reproduce a better test case than this, I'm sure that you can check the binaries you have compiled statically there at MySQL AB and reproduce this bug with similar situations. The problem has this pattern: it is always a query in a MyISAM table followed by an update. Although it happens all the time in our application, sometimes it crashes the database. Thanks, -- Leonardo Dias Catho Online WebDeveloper http://www.catho.com.br/ - 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: subselect query
Yeah, that nasty thing with temporary tables and such? Or am I looking at the wrong page? If you could point me in the right direction, I'd appreciate it (slow modem connection, etc). Christopher Thompson wrote: Read the manual. MySQL doesn't support subselects but offers you alternatives. On Monday 15 April 2002 2:45 pm, Jeff Shipman wrote: I'm trying to do a fairly simple select of a column from a table where the date of that column happens to be the highest value. I tried this: SELECT name FROM products WHERE prod_type='foo' AND added=(SELECT MAX(added) FROM products WHERE prod_type='foo'); But I get the error: ERROR 1064: You have an error in your SQL syntax near 'SELECT MAX(added) FROM products WHERE prod_type='foo')' at line 1 Is there a problem with the parentheses? I've used this syntax with Oracle before with no troubles. name and prod_type are TINYTEXT and added is a DATE. Is there another way I should be doing this? I could probably order descending by the added date and then just LIMIT 1, but I don't think that's very clean. 'mysql --version' returns: mysql Ver 11.15 Distrib 3.23.41, for -freebsd4.4 (i386) Thanks in advance, -- Jeff Shippy Shipman E-Mail: [EMAIL PROTECTED] Computer Science MajorICQ: 1786493 New Mexico Institute of Mining and Technology Homepage: http://www.nmt.edu/~shippy - 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: subselect query
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#ANSI_diff_Sub-selects On Monday 15 April 2002 2:49 pm, Jeff Shipman wrote: Yeah, that nasty thing with temporary tables and such? Or am I looking at the wrong page? If you could point me in the right direction, I'd appreciate it (slow modem connection, etc). Christopher Thompson wrote: Read the manual. MySQL doesn't support subselects but offers you alternatives. On Monday 15 April 2002 2:45 pm, Jeff Shipman wrote: I'm trying to do a fairly simple select of a column from a table where the date of that column happens to be the highest value. I tried this: SELECT name FROM products WHERE prod_type='foo' AND added=(SELECT MAX(added) FROM products WHERE prod_type='foo'); But I get the error: ERROR 1064: You have an error in your SQL syntax near 'SELECT MAX(added) FROM products WHERE prod_type='foo')' at line 1 Is there a problem with the parentheses? I've used this syntax with Oracle before with no troubles. name and prod_type are TINYTEXT and added is a DATE. Is there another way I should be doing this? I could probably order descending by the added date and then just LIMIT 1, but I don't think that's very clean. 'mysql --version' returns: mysql Ver 11.15 Distrib 3.23.41, for -freebsd4.4 (i386) Thanks in advance, - 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: gunk in mysqldump output
Use option -K or --no-disable-keys with myqldump. Date: Mon, 15 Apr 2002 09:37:43 -0400 To: [EMAIL PROTECTED] From: Bill Marrs [EMAIL PROTECTED] Subject: gunk in mysqldump output In some recent release of MySQL, lines like this: /*!4 ALTER TABLE States DISABLE KEYS */; ...were added to the output of mysqldump --opt. This causes my usually load statement: mysql dumpfile ...to fail with ERROR 1046 at line 11: No Database Selected. If I do mydsql -f dumpfile it works (with errors), but I figure I'm missing something. Why were these /*... lines added to dump output if they don't parse? Should I be using some alternate method for loading now? -bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysqld at Startup:
Dear MySQL People: I am having a difficult time trying to run mysqld during system startup on both Mac OS X (workstation) and Mac OS X Server. I have tried several combinations based on the Mysql.com documentation and the Apple Developer Connection article on startup items: http://developer.apple.com/techpubs/macosx/Essentials/SystemOverview/BootingLogin/Customization_Techniques.html Currently I have a directory in /Library/StartupItems/ named MySQLd that contains a script named MySQLd and a file StartupItems.plist In the script I have tried running safe_mysqld as follows cd /sw/bin/ /sw/bin/safe_mysqld --user=mysql I have also tried /sw/share/mysql/mysql.server start As well as other combinations. None would start mysqld (Although I can run safe_mysqld as root manually after startup) The best debugging info I could get was by starting in verbose mode (command V) and quickly reading the messages as they flitted by on the screen. I saw something like /Library/StartupItems/MySQL:permission denied Can anyone help me get this to work on Mac OS X? Thank You, Jimi Oleksiak - 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 counter for HIGH traffic site
*light goes on* You know, I think I've been confused about that. Thanks for clearing things up. I for some reason didn't make the connection (no pun intended) that each page would be getting it's own connection to the DB, and so couldn't interfere with the last_insert_ID queries. Matthew Walker Senior Software Engineer ePliant Marketing -Original Message- From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 8:39 AM To: Matthew Walker Cc: Craig Westerman; MySQL List Subject: Re: MySQL counter for HIGH traffic site Hello. First let me say, that I was talking about the MySQL side of things. If pconnect was broken in this regard - and I would call the behaviour you described as broken - just don't use it. On Mon, Apr 15, 2002 at 12:14:07AM -0600, [EMAIL PROTECTED] wrote: Actually, with a pconnect, there would be a trade off. Since it uses a shared connection, the last insert ID could change between the update and calling the api function. That said, where did you get this from? As I read it, mysql_pconnect() reuses a connection _only_, if it remained open from an ealier - not if it is still in use. Else a lot of things would not work (e.g. using locks at all). This is taken from http://www.php.net/manual/en/function.mysql-pconnect.php and http://www.php.net/manual/en/features.persistent-connections.php There are some caveats, but only with side-effects of the fact that the connection will not be closed. I.e. regarding mysql_pconnect(), calling mysql_insert_id() from the PHP API should be safe as long as you did not call mysql_close(). Bye, Benjamin. But as I said, it doesn't matter for the counter. Matthew Walker Senior Software Engineer ePliant Marketing -Original Message- From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 14, 2002 9:47 PM To: Matthew Walker Cc: Craig Westerman; MySQL List Subject: Re: MySQL counter for HIGH traffic site Hi. There is a one-query method to do that and it is even explicitly documented: http://www.mysql.com/doc/M/i/Miscellaneous_functions.html (under LAST_INSERT_ID([expr])). This requires an UPDATE and using a client API function like mysql_insert_id(). No locks needed and the operation is atomic (i.e. no 'precision' trade-off). [...] -- [EMAIL PROTECTED] --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.345 / Virus Database: 193 - Release Date: 4/9/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
auto_increment fields get mangled in some cases when doing an alter table
If you have a table with an auto_increment column and one of the rows has the value set to 0, doing an ALTER TABLE will change that value to either 2147483647 or the next auto_increment value. mysql create table blah (id int not null primary key auto_increment,stuff char(128)); Query OK, 0 rows affected (0.00 sec) mysql insert into blah set stuff='blah'; Query OK, 1 row affected (0.00 sec) mysql select * from blah; ++---+ | id | stuff | ++---+ | 1 | blah | ++---+ 1 row in set (0.01 sec) mysql update blah set id=0; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select * from blah; ++---+ | id | stuff | ++---+ | 0 | blah | ++---+ 1 row in set (0.00 sec) mysql alter table blah add morestuff int not null; Query OK, 1 row affected (0.00 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql select * from blah; ++---+---+ | id | stuff | morestuff | ++---+---+ | 2 | blah | 0 | ++---+---+ 1 row in set (0.00 sec) -- tani hosokawa river styx internet - 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
does mysql support multi table update?
Hi, everyone, does mysql latest version support multi tables update? Thanks a lot __ Find, Connect Date! http://personals.yahoo.ca - 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: Running multiple queries using MySql client
Hi insert into mytbl (a1) values (12),(13),(14); cheers Mark --- On Mon, 15 Apr 2002, Bill Adair wrote: Hello all, I'm in a mysql client session and I want to do multiple inserts into a table (or run a multi-query script etc). This doesn't work so what's the correct seperator / methodology? INSERT INTO mytbl (a1) VALUES (12); INSERT INTO mytbl (a1) VALUES (13); INSERT INTO mytbl (a1) VALUES (14); \g TIA Bill - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
triggers
What's the status of triggers in MySQL? Acording to the book, it's on the to-do list, but has anything been done with it since publication? --Cindy -- [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
MySQL crashes is fulltext search on with some words.
I'm not sure if this has been reported earlier, but my mysql-server goes
down if I run a query with two 'match against' where one of them
contains/matches the word 'think'...
It terminates after the first query, but when I change the word 'think' to
'excel' or any other word it works flawlessy. I have written the queries
like this since '... against ('+windows +excel' IN BOOLEAN MODE)' doesn't
work in the 4.0.1 version of MySQL.
I find this pretty strange
If this is solved, are there som places where you can download the 4.0.2
source? I can try and put together a test case if it's not been seen before.
I've resovled the stack dump etc. etc.
From mysql consol:
mysql SELECT count(*) FROM DB_GNIST.varer WHERE MATCH (tittel) AGAINST
('windows' IN BOOLEAN MODE) AND match (tittel) against ('think' IN BOOLEAN
MODE);
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:1
Current database: DB_GNIST
ERROR 2013: Lost connection to MySQL server during query
mysql SELECT count(*) FROM DB_GNIST.varer WHERE MATCH (tittel) AGAINST
('windows' IN BOOLEAN MODE) AND match (tittel) against ('excel' IN BOOLEAN
MODE);
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:1
Current database: DB_GNIST
+--+
| count(*) |
+--+
| 149 |
+--+
1 row in set (0.17 sec)
mysql
mysql SELECT count(*) FROM DB_GNIST.varer WHERE MATCH (tittel) AGAINST
('windows' IN BOOLEAN MODE) AND match (tittel) against ('excel' IN BOOLEAN
MODE);
+--+
| count(*) |
+--+
| 149 |
+--+
1 row in set (0.16 sec)
Regards
Erlend Stromsvik
-
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: auto_increment fields get mangled in some cases when doing analter table
At 14:17 -0700 4/15/02, Tani Hosokawa wrote: If you have a table with an auto_increment column and one of the rows has the value set to 0, doing an ALTER TABLE will change that value to either 2147483647 or the next auto_increment value. Storing anything other than positive integers in an AUTO_INCREMENT column is not supported and you are playing with fire by doing so. mysql create table blah (id int not null primary key auto_increment,stuff char(128)); Query OK, 0 rows affected (0.00 sec) mysql insert into blah set stuff='blah'; Query OK, 1 row affected (0.00 sec) mysql select * from blah; ++---+ | id | stuff | ++---+ | 1 | blah | ++---+ 1 row in set (0.01 sec) mysql update blah set id=0; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select * from blah; ++---+ | id | stuff | ++---+ | 0 | blah | ++---+ 1 row in set (0.00 sec) mysql alter table blah add morestuff int not null; Query OK, 1 row affected (0.00 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql select * from blah; ++---+---+ | id | stuff | morestuff | ++---+---+ | 2 | blah | 0 | ++---+---+ 1 row in set (0.00 sec) -- tani hosokawa river styx internet - 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
Handling Memo Fields from MS-Access?
Hello All: I am using mysql 3.23 on Linux. I have a project in what I will need to do the following: First: export a MS-Access database to a set of delimited text files, one for each table. Secondly: Load each of those text files into a MySql Table. Since I am new to MySql, I am posing this question? Exporting a Ms-Access Memo field (which can contain newline/carriage returns) to a text file will mess up the structure of the delimited file. In other case, I have used VBA to convert line endings to another character, (ctrl-B or Ascii 2, as an example) Is there a way that I can use a newline substitute for export that can then be converted back to the original newline when mysql loads the text file? TIA Regards -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL and stored procedures - v4.1 :(
When it's ready. That's a tautological answer. You've already stated your lack of belief in the reliability of deadlines, so what did you expect? If someone had responded with 4.1 will be done on 5/1/2002 you'd respond that the only way that would happen would be if it were horribly buggy or lacked critical features -- if you hold such a belief then no estimate would be meaningful because the critical feature likely to be dropped to maintain the deadline would be stored procedures, thus rendering any estimate worthless to you. Let's say I need to do 10 millions inserts. In what way will bundling all these 10 million inserts into one single batch give me some gain? Bundling them into batches of say 1,000 will minimize the number of disk operations MySQL must perform. Well, but now the claim was to bundle all the little small bundles to one big bundle to increase performance. So saying that I now should make the big bundle into a little bundle is not really confirming with the original statement - rather contradicting it. I made the (apparently false) assumption that you wanted a more pragmatic answer. Yes, you can batch them all in one and achieve a greater degree of the same affect -- minimizing the number of I/O operations MySQL must before -- but then one must be careful to not hit various buffer/memory pool size limitations. I forget which particular ones would be meaningful here, but it would be easy to (for example) exceed the size of your transaction logs if you're doing 10 million write operations in a single transaction. That's only your opinion in the question and has nothing to do with the real facts. So anything you disagree with is an opinion, and not a fact? -JF - 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: Handling Memo Fields from MS-Access?
Hi .. Mysql's LOAD DATA INFILE will take newline character as the lines' terminating character, but you can always change by LINES TERMINATED BY clause. So, say you have | character as the line ending character in your text file, you can just add LINES TERMINATED BY '|' clause to your LOAD DATA INFILE syntax. See: http://www.mysql.com/doc/L/O/LOAD_DATA.html If you need to change some characters in the text file before loading it into the database just vi the file and make the necessaray changes thru global search/replace . Gurhan -Original Message- From: Tim Johnson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 7:09 PM To: [EMAIL PROTECTED] Subject: Handling Memo Fields from MS-Access? Hello All: I am using mysql 3.23 on Linux. I have a project in what I will need to do the following: First: export a MS-Access database to a set of delimited text files, one for each table. Secondly: Load each of those text files into a MySql Table. Since I am new to MySql, I am posing this question? Exporting a Ms-Access Memo field (which can contain newline/carriage returns) to a text file will mess up the structure of the delimited file. In other case, I have used VBA to convert line endings to another character, (ctrl-B or Ascii 2, as an example) Is there a way that I can use a newline substitute for export that can then be converted back to the original newline when mysql loads the text file? TIA Regards -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: Handling Memo Fields from MS-Access?/\t\n
Forgive me, I should have searched the archives first. Let me rephrase from what I have seen there: Do I understand that I should have my export routine Subsitute '\n' for newline ? Substitute '\t' for TAB? Thanks Again -tim- * Tim Johnson [EMAIL PROTECTED] [020415 15:13]: Hello All: I am using mysql 3.23 on Linux. I have a project in what I will need to do the following: First: export a MS-Access database to a set of delimited text files, one for each table. Secondly: Load each of those text files into a MySql Table. Since I am new to MySql, I am posing this question? Exporting a Ms-Access Memo field (which can contain newline/carriage returns) to a text file will mess up the structure of the delimited file. In other case, I have used VBA to convert line endings to another character, (ctrl-B or Ascii 2, as an example) Is there a way that I can use a newline substitute for export that can then be converted back to the original newline when mysql loads the text file? TIA Regards -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and stored procedures - v4.1 :(
Hi! I can disclose that there is actually some progress being made in stored procedures + triggers. Regards, Heikki Innobase Oy - Original Message - From: Jon Frisby [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, April 16, 2002 2:12 AM Subject: RE: MySQL and stored procedures - v4.1 :( When it's ready. That's a tautological answer. You've already stated your lack of belief in the reliability of deadlines, so what did you expect? If someone had responded with 4.1 will be done on 5/1/2002 you'd respond that the only way that would happen would be if it were horribly buggy or lacked critical features -- if you hold such a belief then no estimate would be meaningful because the critical feature likely to be dropped to maintain the deadline would be stored procedures, thus rendering any estimate worthless to you. Let's say I need to do 10 millions inserts. In what way will bundling all these 10 million inserts into one single batch give me some gain? Bundling them into batches of say 1,000 will minimize the number of disk operations MySQL must perform. Well, but now the claim was to bundle all the little small bundles to one big bundle to increase performance. So saying that I now should make the big bundle into a little bundle is not really confirming with the original statement - rather contradicting it. I made the (apparently false) assumption that you wanted a more pragmatic answer. Yes, you can batch them all in one and achieve a greater degree of the same affect -- minimizing the number of I/O operations MySQL must before -- but then one must be careful to not hit various buffer/memory pool size limitations. I forget which particular ones would be meaningful here, but it would be easy to (for example) exceed the size of your transaction logs if you're doing 10 million write operations in a single transaction. That's only your opinion in the question and has nothing to do with the real facts. So anything you disagree with is an opinion, and not a fact? -JF - 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
