RE: How long is my piece of string?
You need indexes as soon as (or rather just before) they provide a performance difference. Alan -Original Message- From: Iain Lang [mailto:[EMAIL PROTECTED]] Sent: Sunday, 22 December 2002 11:15 AM To: [EMAIL PROTECTED] Subject: How long is my piece of string? . Dear List, I'm using php & MySQL for a cycling club website, results, guest-book, events and so on. I've just started and have faithfully created indices all over the place. At present, we have less than 400 records, be they of members, of image URLs, whatever. Each year will, I expect, create an additional 400 records. Am I gilding the lily adding indices for such a small database? Does such a small database really *need* indices, and beyond what number of records might indices provide faster extraction/presentation? I realise how vague a question it is, hence the subject title. Yooors, Iain. - "Most progress has been the result of the actions of unreasonable men." G.B.Shaw. http://www.johnstone-wheelers.co.uk Johnstone-Wheelers - the friendliest cycling club in Scotland! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Embarrassing: can't log in
it only takes a few minutes to uninstall and install... > -Original Message- > From: Amittai Aviram [mailto:[EMAIL PROTECTED]] > Sent: Monday, 2 December 2002 9:37 > To: Mysql > Subject: Embarrassing: can't log in > > > I've got an embarrassing problem. I installed MySQL on my WinXP machine > months ago. Since then, though, I've continued to use the MySQL > on a remote > (FreeBSD) host, so I haven't had occasion to use my local > version. Now as I > went back to it, I found that I couldn't log in. I can't remember my > username and password. All the usernames and passwords that I could think > of would fail. What to do now? Thanks! > > Amittai Aviram > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: date conversion problem
this might give you some ideas select CONCAT(DAYOFMONTH(p.DATEGOLIVE),'.',MONTH(p.DATEGOLIVE),'.',YEAR(p.DATEGOLIV E)) DATEGOLIVEF from my table p > -Original Message- > From: Alex Behrens [mailto:[EMAIL PROTECTED]] > Sent: Friday, 22 November 2002 13:01 > To: MYSQL > Subject: date conversion problem > > > Hey All, > > I'm storing date values for hockey game information using the > DATE value and > they are stored as MMDD and when I retrieve them from the > database they > are shown as: "2002-11-23" I was wondering if there was a way to have them > converted to November, 23, 2002 when they are displayed on my displayed on > the page. Is this possible? > > mysql > > Thanks! > > -Alex "Big Al" Behrens > E-mail: [EMAIL PROTECTED] > Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) > Phone: 651-482-8779 > Cell: 651-329-4187 > Fax: 651-482-1391 > ICQ: 3969599 > Owner of the 3D-Unlimited Network: > http://www.3d-unlimited.com > Send News: > [EMAIL PROTECTED] > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: trouble with LOAD command
I'd pick up the text file and search/replace all end of line character(s) with a end of line"00 "comma combination so it reads > 00,Abe,Lincoln,8347 on each line and try your first method. If that fails, I would drop the ID field off the table, then do the import with original file, then atlter the table again to add the ID field Alan > -Original Message- > From: Chris Walcott [mailto:cwalcott@;macromedia.com] > Sent: Thursday, 14 November 2002 9:42 > To: Mysql-L (E-mail) > Subject: trouble with LOAD command > > > How do I LOAD a text file into a table that has a Primary Key defined? > > I have the following table defined: > mysql> describe phoneList; > +--+-+--+-+-++ > | Field| Type| Null | Key | Default | Extra | > +--+-+--+-+-++ > | ID | int(11) | | PRI | NULL| auto_increment | > | First_Name | varchar(20) | YES | | NULL|| > | Last_Name| varchar(20) | YES | | NULL|| > | Phone_Number | varchar(20) | YES | | NULL|| > +--+-+--+-+-++ > > I'm attempting to load a comma delimited list using load. The > text file looks like this: > > Abe,Lincoln,8347 > Herb,Albert,9387 > George,Washington,9283 > ... > > When I do this: > mysql> load data local infile "/home/cwalcott/PhoneList_b.txt" > into table phoneList > -> fields terminated by ',' (First_Name, Last_Name, Phone_Number); > > I get this on select * > ++++--+ > | ID | First_Name | Last_Name | Phone_Number | > ++++--+ > |e| Lincoln| 8347 > |rb | Albert | 9387 > |orge | Washington | 9283 > ++++--+ > > if I do this: > load data local infile "/home/cwalcott/PhoneList_b.txt" into > table phoneList; > > I get: > +++---+--+ > | ID | First_Name | Last_Name | Phone_Number | > +++---+--+ > | 1 | NULL | NULL | NULL | > | 2 | NULL | NULL | NULL | > | 3 | NULL | NULL | NULL | > +++---+--+ > > I've also tried using a text file with the first column set to > index numbers but the results are very similar. > > If I do this: > > mysql> load data local infile > "/home/cwalcott/PhoneList_small.txt" into table phoneList > -> fields terminated by ',' (First_Name, Last_Name, Phone_Number); > > I get: > +++---+--+ > | ID | First_Name | Last_Name | Phone_Number | > +++---+--+ > | 1 | 1 | Abe | Lincoln | > | 2 | 2 | Herb | Albert | > | 3 | 3 | George| Washington | > +++---+--+ > > If I do this: > mysql> load data local infile > "/home/cwalcott/PhoneList_small.txt" into table phoneList > -> fields terminated by ',' (ID, First_Name, Last_Name, Phone_Number); > > I get this: > ++++--+ > | ID | First_Name | Last_Name | Phone_Number | > ++++--+ > |e| Lincoln| 8347 > |rb | Albert | 9387 > |orge | Washington | 9283 > +-++---+--+ > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Count Rows in two tables
Ah, yes - sorry Alan > -Original Message- > From: [EMAIL PROTECTED] > [mailto:murad@;godel.bioc.columbia.edu]On Behalf Of Murad Nayal > Sent: Wednesday, 13 November 2002 12:58 > Cc: [EMAIL PROTECTED] > Subject: Re: Count Rows in two tables > > > > Alan McDonald wrote: > > > > You can't count the join? > > Alan > > if you count the (unqualified) join you'll end up with the product of > the two table counts. > > Murad > > > > > > -Original Message- > > > From: Rick Baranowski [mailto:rickb@;baranconsulting.com] > > > Sent: Wednesday, 13 November 2002 12:10 > > > To: [EMAIL PROTECTED] > > > Subject: Count Rows in two tables > > > > > > > > > Hello all, > > > > > > Does anybody have a SQL string to count the rows in two different > > > tables and > > > give you a total number of rows? I have been trying to find an > > > answer for a > > > couple of days and seems like a simple string. > > > > > > Thank you > > > > > > Rick > > > > > > > > > - > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Count Rows in two tables
You can't count the join? Alan > -Original Message- > From: Rick Baranowski [mailto:rickb@;baranconsulting.com] > Sent: Wednesday, 13 November 2002 12:10 > To: [EMAIL PROTECTED] > Subject: Count Rows in two tables > > > Hello all, > > Does anybody have a SQL string to count the rows in two different > tables and > give you a total number of rows? I have been trying to find an > answer for a > couple of days and seems like a simple string. > > Thank you > > Rick > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: last_insert_id()
The .Neta Adapter.. does it make a persistent connection? If the connection drops between the first insert and the call to select, then the return would be zero Alan > -Original Message- > From: Cain O'Sullivan [mailto:cos@;iinet.net.au] > Sent: Wednesday, 13 November 2002 16:13 > To: [EMAIL PROTECTED] > Subject: last_insert_id() > > > Hi, > > I am using C# with ODBC.Net to communicate with MySQL. I want to > determine > the last ID of an auto_increment field in the database. When I manually > perform the insert using the MySQL command window I can then > follow up with > "select last_insert_id()" and I get the correct value, however, when using > ODBC to perform the insert (via a .Net DataAdapter) the last_insert_id() > returns 0. > > Can anyone provide some insight into this? > > Best Regards, > > Cain O'Sullivan > [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
RE: How to port MS Access to MySQL ??
MySQLFront will create the tables and pump the data with one button press Alan > -Original Message- > From: Terry [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 12 November 2002 22:02 > To: [EMAIL PROTECTED] > Subject: RE: How to port MS Access to MySQL ?? > > > > MyODBC works fine, > but what to do if you have hundreds of tables?=20 > > its painful job, maybe theres some > easier way to do that ? > > regards, > terry > > 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 > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - Query works in access but not MySQL
Do you have a space between PartNumber and Like? Also there's not need to ORDER BY - the GROUP BY does that anyway (I know that's the case elsewhere) and finally, I have to guess that it's objecting to Obsolete not being in the main select.. have you tried including it and grouping by it? you can ignore the obsolete in the main select when it's returned since it will all be the same value... put it first. Alan > -Original Message- > From: Ed Reed [mailto:ereed@;nearfield.com] > Sent: Tuesday, 12 November 2002 18:54 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Newbie Question - Query works in access but not MySQL > > > UPDATE: > > Still trying to solve this and I think I have something that's a little > easier to understand. If I run the following query against MySQL it > returns "Unknown column 'Obsolete' in 'having clause'". If I run the > query using MSAccess as a frontend to MySQL the query runs correctly (it > returns a recordset with 9 records). If I remove the Obsolete column > from the Having clause the MySQL server appears to hang up while it > processes the query but it never returns even if left for an hour. > > Please, has anyone got any ideas? > > SELECT Products.PartNumber, Sum(tblInvTransaction.Qty) AS SumOfQty > FROM Products LEFT JOIN tblInvTransaction ON Products.ProductID = > tblInvTransaction.ProductID > GROUP BY Products.PartNumber > HAVING ((Products.PartNumberLike "%A-000%") AND > (Products.Obsolete<>-1)) > ORDER BY Products.PartNumber; > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: PHP bias (Way OT)
I agree mostly,... but why is ASP worthless? Alan > -Original Message- > From: [EMAIL PROTECTED] [mailto:vanboers@;why.dedserius.com]On > Behalf Of Van > Sent: Monday, 11 November 2002 6:21 > To: Paul DuBois > Cc: MySQL > Subject: Re: PHP bias (Way OT) > > > Paul: > > Not sure why my post didn't cc to the list, originally. I think > I picked up on > your tone, but the one thing I had intended to add was the > dynamic that the more > I do this stuff, the more I find myself just having to "get over" > some of the > more ugly and cludged implementations due to limitations in what our > end-users/clients are willing to let us do. In other words: who cares. > They'll never really look at it that closely and if another > developer comes in > several years later to make any changes/enhancements, they'll > probably just do a > rewrite. > > Once upon a time, I thought you could code elegantly, and C/C++ > is about the > only realm in which I see this to still be possible. PHP/ASP and > _especially!!!_ ColdFusion are impossible to write elegant and > easy to document > code, but I think PHP is the best of these evils since it has such a huge > function set. ASP is worthless for other reasons, and CF is just > disgusting to > look at. > > I _realize_ Perl is fast, and powerful. I really _do_ realize > that. But, it's > ugly. It looks like Snoopy swearing characters, and you can talk > (write) about > how it's elegant until you're blue in the face, but show it to a > CIO/CFO and > they'll tell you it's ugly, and they're quite correct. > > But, people program in it extensively, and do great things with > it; it's just > ugly. And, so are most implementations. In a perfect world, > everyone would use > C/C++, but they don't and I don't care. I'll use it if I choose > to. I'll use > Perl to do quick and dirty things. And, I'll code ColdFusion if > someone is > offering me money to do so. At the end of the day, no > programming/technology is > pretty; where are those beer nuts. > > And, BTW, clearly there's no one better equipped to point out > your original > thoughts on what _can_ be done in Perl. > > --mysql, table, drop, explain, database-- > > Best Regards, > Van > -- > = > Linux rocks!!! http://www.dedserius.com/ > = > Paul DuBois wrote: > > (some stuff I snipped) > > http://www.kitebird.com/mysql-perl/ > > > > >You can do all these things from perl. Or PHP, or CF, or ASP. > Just pass your > > >variables to an external web-server running it's own > proprietary web database > > >and you'll get what you need. > > > > > >Sorry; am I speaking out of step, here? We all do this... I > run MySQL on my > > >own servers, but my clients are still pretty thick-headed... they > > >use M$Access > > >and ColdFusion. And, I can still drop and add columns through a > > >web-interface. > > >It's very ugly, but it still works. Is there anyone here > making a living that > > >doesn't have to work through such interface-specific things? > > > > > >Didn't think so; but, in a perfect world, we'd all be doing > things ANSI SQL > > >92... Whatever... pass the beer nuts. >:) > > > > > >Van > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: little problem, I need some help...
Every SQL database requires the ability to locate a record which is unique
in some way. You can't have two records which look the same.
That's why you need to define a primary KEY on a column or coumns.
You need to read a primer on SQL databases
Alan
> -Original Message-
> From: 3mip1s4la-Emilio Pisanty [mailto:emipisala@;lancaster.edu.mx]
> Sent: Sunday, 10 November 2002 11:34
> To: R. Hannes Niedner
> Cc: MySQL Mailinglist
> Subject: Re: little problem, I need some help...
>
>
>
> > > tables have met with a 1175 error ("You are using safe update
> mode and you
> > > tried to update a table without a WHERE that uses a KEY column").
> > Nothing is obvious and is hard to advise you if you don't give
> us some more
> > info on the table structure and the update query you have trouble with.
> >
> > /h
>
> ok. thable structure is this:
> mysql> describe pupils;
> +--+-+--+-+-+---+
> | Field| Type| Null | Key | Default | Extra |
> +--+-+--+-+-+---+
> | name | varchar(20) | YES | | NULL| |
> | surname | varchar(20) | YES | | NULL| |
> | surname2 | varchar(20) | YES | | NULL| |
> | form | char(3) | YES | | NULL| |
> | tutor| varchar(20) | YES | | NULL| |
> | sex | char(1) | YES | | NULL| |
> | birth| date| YES | | NULL| |
> | math | char(3) | YES | | NULL| |
> | optA | char(3) | YES | | NULL| |
> | optB | char(3) | YES | | NULL| |
> +--+-+--+-+-+---+
> 10 rows in set (0.00 sec)
>
> it was built in version 3.23, and we recently updated to 4.0.4 beta.
>
> the query I'm running is
>
> mysql> UPDATE pupuils SET tutor = 'URIOSTEGUI' WHERE group = 'U6U';
> (setting the name of the tutor for Upper 6)
>
> and I meet with:
> ERROR 1175: You are using safe update mode and you tried to
> update a table
> without a WHERE that uses a KEY column
>
> I don't quite understand what a "KEY column" is, can someone
> explain it to
> me? if you can't answer, where can I find error listings? because they
> don't appear to be on the site.
>
> hope this helps you help me...
>
> thanks in advance,
>
>Emilio Pisanty
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> 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: mysqld refuse to die
Also In My Humble Opinion (IMHO) For What It's Worth (FWIW) > -Original Message- > From: Gelu Gogancea [mailto:ggelu@;arctic.ro] > Sent: Saturday, 9 November 2002 23:37 > To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED] > Subject: Re: mysqld refuse to die > > > Yes.All processes are named "mysqld"...less one "mysqld_safe" > which is "main > guilty" for keeping mysql daemon in "life". > > P.S. > Please tell me (if you wish)...what means AFAIK? > Regards, > > Gelu > _ > G.NET SOFTWARE COMPANY > > Permanent e-mail address : [EMAIL PROTECTED] > [EMAIL PROTECTED] > - Original Message - > From: "Jocelyn Fournier" <[EMAIL PROTECTED]> > To: "Gelu Gogancea" <[EMAIL PROTECTED]>; "Jack Chen" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Saturday, November 09, 2002 2:27 PM > Subject: Re: mysqld refuse to die > > > > just kill mysqld_safe and then the mysqld process :) > > (but AFAIK all the mysql thread are names mysqld ??) > > - Original Message - > > From: "Gelu Gogancea" <[EMAIL PROTECTED]> > > To: "Jocelyn Fournier" <[EMAIL PROTECTED]>; "Jack Chen" > <[EMAIL PROTECTED]>; > > <[EMAIL PROTECTED]> > > Sent: Saturday, November 09, 2002 12:20 PM > > Subject: Re: mysqld refuse to die > > > > > > > ...because not all mysql processes are named "mysql" and is > one (and you > > > know about this) which is for safe running(mysqld_safe or safe_mysqld) > > which > > > create new threads when another is "killed". > > > Regards, > > > > > > Gelu > > > _ > > > G.NET SOFTWARE COMPANY > > > > > > Permanent e-mail address : [EMAIL PROTECTED] > > > [EMAIL PROTECTED] > > > - Original Message - > > > From: "Jocelyn Fournier" <[EMAIL PROTECTED]> > > > To: "Gelu Gogancea" <[EMAIL PROTECTED]>; "Jack Chen" <[EMAIL PROTECTED]>; > > > <[EMAIL PROTECTED]> > > > Sent: Saturday, November 09, 2002 2:12 PM > > > Subject: Re: mysqld refuse to die > > > > > > > > > > Hi, > > > > > > > > Why not trying killall -9 mysqld ? > > > > > > > > Regards, > > > > Jocelyn > > > > - Original Message - > > > > From: "Gelu Gogancea" <[EMAIL PROTECTED]> > > > > To: "Jack Chen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > > > Sent: Saturday, November 09, 2002 12:08 PM > > > > Subject: Re: mysqld refuse to die > > > > > > > > > > > > > Hi, > > > > > If you really wish to kill the mysql daemon in this way : > > > > > You should try : > > > > > ps -ef |grep "mysql" > > > > > ...show all the mysqld processes and after this must enumarate all > pid > > > of > > > > > processes in a single kill command. > > > > > E.g. > > > > > kill -9 1024 1056 ...(processes which are open). > > > > > But it's more "health" if you can stop the server using : > > > > > /etc/rc.d/mysqld stop > > > > > > > > > > Regards, > > > > > > > > > > Gelu > > > > > _ > > > > > G.NET SOFTWARE COMPANY > > > > > > > > > > Permanent e-mail address : [EMAIL PROTECTED] > > > > > [EMAIL PROTECTED] > > > > > - Original Message - > > > > > From: "Jack Chen" <[EMAIL PROTECTED]> > > > > > To: <[EMAIL PROTECTED]> > > > > > Sent: Saturday, November 09, 2002 7:57 AM > > > > > Subject: Re: mysqld refuse to die > > > > > > > > > > > > > > > > I have just figured out: > > > > > > > > > > > > kill -9 xxx (process number) > > > > > > > > > > > > Thanks, > > > > > > > > > > > > Jack > > > > > > > > > > > > > > > > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs > > > > > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724 > > > > > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > On Sat, 9 Nov 2002, Jack Chen wrote: > > > > > > > > > > > > > Hi All, > > > > > > > > > > > > > > Please help me with this problem: > > > > > > > > > > > > > > For some reason, I could not bring down my mysqld by running > > > > > > > > > > > > > > mysqld stop > > > > > > > > > > > > > > An error message indicate: fail > > > > > > > > > > > > > > What's going on? > > > > > > > > > > > > > > Thanks, > > > > > > > > > > > > > > Jack > > > > > > > > > > > > > > > > > > > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs > > > > > > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724 > > > > > > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > - > > > > > > > Before posting, please check: > > > > > > >http://www.mysql.com/manual.php (the manual) > > > > > > >http://lists.mysql.com/ (the list archive) > > > > > > > > > > > > > > To request t
RE: mysqld refuse to die
As Far As I Know > -Original Message- > From: Gelu Gogancea [mailto:ggelu@;arctic.ro] > Sent: Saturday, 9 November 2002 23:37 > To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED] > Subject: Re: mysqld refuse to die > > > Yes.All processes are named "mysqld"...less one "mysqld_safe" > which is "main > guilty" for keeping mysql daemon in "life". > > P.S. > Please tell me (if you wish)...what means AFAIK? > Regards, > > Gelu > _ > G.NET SOFTWARE COMPANY > > Permanent e-mail address : [EMAIL PROTECTED] > [EMAIL PROTECTED] > - Original Message - > From: "Jocelyn Fournier" <[EMAIL PROTECTED]> > To: "Gelu Gogancea" <[EMAIL PROTECTED]>; "Jack Chen" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Saturday, November 09, 2002 2:27 PM > Subject: Re: mysqld refuse to die > > > > just kill mysqld_safe and then the mysqld process :) > > (but AFAIK all the mysql thread are names mysqld ??) > > - Original Message - > > From: "Gelu Gogancea" <[EMAIL PROTECTED]> > > To: "Jocelyn Fournier" <[EMAIL PROTECTED]>; "Jack Chen" > <[EMAIL PROTECTED]>; > > <[EMAIL PROTECTED]> > > Sent: Saturday, November 09, 2002 12:20 PM > > Subject: Re: mysqld refuse to die > > > > > > > ...because not all mysql processes are named "mysql" and is > one (and you > > > know about this) which is for safe running(mysqld_safe or safe_mysqld) > > which > > > create new threads when another is "killed". > > > Regards, > > > > > > Gelu > > > _ > > > G.NET SOFTWARE COMPANY > > > > > > Permanent e-mail address : [EMAIL PROTECTED] > > > [EMAIL PROTECTED] > > > - Original Message - > > > From: "Jocelyn Fournier" <[EMAIL PROTECTED]> > > > To: "Gelu Gogancea" <[EMAIL PROTECTED]>; "Jack Chen" <[EMAIL PROTECTED]>; > > > <[EMAIL PROTECTED]> > > > Sent: Saturday, November 09, 2002 2:12 PM > > > Subject: Re: mysqld refuse to die > > > > > > > > > > Hi, > > > > > > > > Why not trying killall -9 mysqld ? > > > > > > > > Regards, > > > > Jocelyn > > > > - Original Message - > > > > From: "Gelu Gogancea" <[EMAIL PROTECTED]> > > > > To: "Jack Chen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > > > Sent: Saturday, November 09, 2002 12:08 PM > > > > Subject: Re: mysqld refuse to die > > > > > > > > > > > > > Hi, > > > > > If you really wish to kill the mysql daemon in this way : > > > > > You should try : > > > > > ps -ef |grep "mysql" > > > > > ...show all the mysqld processes and after this must enumarate all > pid > > > of > > > > > processes in a single kill command. > > > > > E.g. > > > > > kill -9 1024 1056 ...(processes which are open). > > > > > But it's more "health" if you can stop the server using : > > > > > /etc/rc.d/mysqld stop > > > > > > > > > > Regards, > > > > > > > > > > Gelu > > > > > _ > > > > > G.NET SOFTWARE COMPANY > > > > > > > > > > Permanent e-mail address : [EMAIL PROTECTED] > > > > > [EMAIL PROTECTED] > > > > > - Original Message - > > > > > From: "Jack Chen" <[EMAIL PROTECTED]> > > > > > To: <[EMAIL PROTECTED]> > > > > > Sent: Saturday, November 09, 2002 7:57 AM > > > > > Subject: Re: mysqld refuse to die > > > > > > > > > > > > > > > > I have just figured out: > > > > > > > > > > > > kill -9 xxx (process number) > > > > > > > > > > > > Thanks, > > > > > > > > > > > > Jack > > > > > > > > > > > > > > > > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs > > > > > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724 > > > > > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > On Sat, 9 Nov 2002, Jack Chen wrote: > > > > > > > > > > > > > Hi All, > > > > > > > > > > > > > > Please help me with this problem: > > > > > > > > > > > > > > For some reason, I could not bring down my mysqld by running > > > > > > > > > > > > > > mysqld stop > > > > > > > > > > > > > > An error message indicate: fail > > > > > > > > > > > > > > What's going on? > > > > > > > > > > > > > > Thanks, > > > > > > > > > > > > > > Jack > > > > > > > > > > > > > > > > > > > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs > > > > > > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724 > > > > > > > Tel: 1 516 3676904; e-mail: [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]>
RE: Copy Records in a table...
maybe it doesn't then in MySQL - it does elsewhere Alan > -Original Message- > From: David Felio [mailto:david@;ark.org] > Sent: Saturday, 9 November 2002 1:59 > To: MySQL List > Subject: Re: Copy Records in a table... > > > Is the implementation of this different than the docs say? According to > the manual, I didn't think this would work: > > "* The target table of the INSERT statement cannot appear in the FROM > clause of the SELECT part of the query because it's forbidden in ANSI > SQL to SELECT from the same table into which you are inserting." > - http://www.mysql.com/doc/en/INSERT_SELECT.html > > On Thursday, November 7, 2002, at 08:56 PM, Alan McDonald wrote: > > > insert into mytable(field1, field2, field3) select field1, field2, > > newvalue > > from mytable where productcode=xx > > > >> -Original Message- > >> From: Doug Coning [mailto:lists@;coning.com] > >> Sent: Friday, 8 November 2002 14:35 > >> To: [EMAIL PROTECTED] > >> Subject: Copy Records in a table... > >> > >> > >> Hi everyone, > >> > >> I'm still learning MySQL. I have a database of 600 items. I am still > >> adding products. Several of these products are identical in nature, > >> but > >> have maybe one or two columns that are different. Is there a way > >> to write a > >> SQL command that selects these items and then inserts them, and > >> then updates > >> them respectively with one command? > >> > >> Thanks, > >> > >> Doug > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to port MS Access to MySQL ??
MySQLfront does it all > -Original Message- > From: tmb [mailto:topmailbox@;yahoo.com] > Sent: Friday, 8 November 2002 23:18 > To: [EMAIL PROTECTED] > Subject: How to port MS Access to MySQL ?? > > > Is there a tool for doing a quick port from MS Access > to MySQL? > > Or must you manually create all the tables & sql > statements in MySQL and then export the MS Access data > to a comma delimited file... then import it into > MySQL? > > Thanks for any help - tmb > > > __ > Do you Yahoo!? > U2 on LAUNCH - Exclusive greatest hits videos > http://launch.yahoo.com/u2 > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Copy Records in a table...
insert into mytable(field1, field2, field3) select field1, field2, newvalue from mytable where productcode=xx > -Original Message- > From: Doug Coning [mailto:lists@;coning.com] > Sent: Friday, 8 November 2002 14:35 > To: [EMAIL PROTECTED] > Subject: Copy Records in a table... > > > Hi everyone, > > I'm still learning MySQL. I have a database of 600 items. I am still > adding products. Several of these products are identical in nature, but > have maybe one or two columns that are different. Is there a way > to write a > SQL command that selects these items and then inserts them, and > then updates > them respectively with one command? > > Thanks, > > Doug > > > > > > MySQL > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL and amanda
I was under the impression that hotbackup was only available with innodb tables where do you get amanda from? Alan > -Original Message- > From: Lewis Watson [mailto:lists@;visionsix.com] > Sent: Wednesday, 6 November 2002 14:22 > To: mysql > Subject: MySQL and amanda > > > Hey MySQL users! > I have been using amanda as backup software. It seems that it is working > fine as a backup for the MySQL data directory but I am wondering > is there a > better way to backup up the databases? They are production Db's > so I really > do not want to stop the server, but isn't this necessary to > properly backup > up the db directory? > Thanks. > Lewis > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Removal of Primary Key in Mysql
Because a primary key is a table property and the index of the key is a property of the primary key. If you want ot drop a primary key you alter the table > -Original Message- > From: Eric Frazier [mailto:ef@;kwinternet.com] > Sent: Tuesday, 5 November 2002 15:26 > To: Paul DuBois > Cc: Uma Shankari T.; [EMAIL PROTECTED] > Subject: Re: Removal of Primary Key in Mysql > > > Hi, > > This is a why questionk, which may be somewhat pointless, but. Why is this > under alter table instead of drop index? > > Thanks, > > Eric > > At 01:10 AM 11/5/02 -0600, Paul DuBois wrote: > >At 12:08 +0530 11/5/02, Uma Shankari T. wrote: > >>Hello, > >> > >> I have set one of my field in the mysql table as primary > key..no i want > >>to remove that primary key setting in mysql..Can anyone please > tell me how > >>to do that ??? > >> > >>Regards, > >>Uma > > > >ALTER TABLE tbl_name DROP PRIMARY KEY; > > > >- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail > <[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > (250) 655 - 9513 (PST Time Zone) > > "Inquiry is fatal to certainty." -- Will Durant > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
Error Code Question
This error comes up when altering table structure BUT it times out after a while. Error: 7 - Error on rename of '.\DBNAME\tablename.MYI' to '.\DBNAME\#sql2-61-19.MYI' (Errcode: 13) Some have said - "oh yeah, that's a permissions problem" but if it times out and finally the command executes after a while, then how can it be a permissions problem. It's more likely that the server will not allow change while connections are live... but I wait until the connections are not there (in MySQLAdmin) and still the error persists for a while longer. Finally it executes. Is there something else at play here? Alan ' Keywords: ' myODBC, mySQL, ' Error: ' Error: 7 - Error on rename of '.\DBNAME\tablename.MYI' to '.\DBNAME\#sql2-61-19.MYI' ' (Errcode: 13) ' Environment: ' WkStn - Windows 2000 WkStn, 512 meg, Pentium 1000 mhz, build 2195, SP3 ' myODBC 3.51 - WinX ' ' Server - Windows NT 4.0 Server SP6, 256 meg, Pentium II 450 mhz ' mySQL - 3.23.52 - NT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Access2MySQL
I use MySQLFront and is creats the tables and imports the data with one click never had a problem Alan > -Original Message- > From: [EMAIL PROTECTED] [mailto:Sam4Software@;aol.com] > Sent: Wednesday, 30 October 2002 9:15 > To: [EMAIL PROTECTED] > Subject: Access2MySQL > > > Hi all, > > After setting the field data type in MySQL to Text, which is the > same data > type for Access data type where the data is being imported from, > the import > process was succeful and the same number of rows was imported, BUT I > don't see any data in the MySQL, all I see is Null, Null. any > comment ?? > > Sam > > > Sam > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Altering Table errors
Then, why..., if I wait a little longer, does the alter command work? I do not change the the permissions in the meantime. I just wait. Alan > -Original Message- > From: gerald_clark [mailto:gerald_clark@;suppliersystems.com] > Sent: Tuesday, 29 October 2002 1:38 > To: Alan McDonald > Cc: [EMAIL PROTECTED] > Subject: Re: Altering Table errors > > > Error 13 is an operating system privilege violation error. > the user 'mysql' does not own or have access to something in > the database. > > Alan McDonald wrote: > > >MySQL > > > > > >I asume that when I add a field or rename a field etc and get the errcode > >13, that I must wait til a connection timeout has occurred to be able to > >make this structural change. While I'm developing, is there a > quicker way to > >do this? > >Stopping/starting the service is not that quick.. Is there another way? > > > >thanks > >Alan > > > > > > > >- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail > <[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Altering Table errors
But after a while it does, cause I only have to wait a while with no activity on the database, and the command executes. So it's not permissions Alan > -Original Message- > From: gerald_clark [mailto:gerald_clark@;suppliersystems.com] > Sent: Tuesday, 29 October 2002 1:38 > To: Alan McDonald > Cc: [EMAIL PROTECTED] > Subject: Re: Altering Table errors > > > Error 13 is an operating system privilege violation error. > the user 'mysql' does not own or have access to something in > the database. > > Alan McDonald wrote: > > >MySQL > > > > > >I asume that when I add a field or rename a field etc and get the errcode > >13, that I must wait til a connection timeout has occurred to be able to > >make this structural change. While I'm developing, is there a > quicker way to > >do this? > >Stopping/starting the service is not that quick.. Is there another way? > > > >thanks > >Alan > > > > > > > >- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >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
Altering Table errors
MySQL I asume that when I add a field or rename a field etc and get the errcode 13, that I must wait til a connection timeout has occurred to be able to make this structural change. While I'm developing, is there a quicker way to do this? Stopping/starting the service is not that quick.. Is there another way? thanks Alan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Import from files
Is it possible to update a field using SQL with the contents of a text file previoously written to disk? I want to update a mediumtext field with the contents of c:\data\mytext.txt file. update mytable set mymediumtext= filecontents where id=number... ? Alan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
adUseClient
SQL The docs say that recordset1.RecordCount will return the correct value if adUseClient is used as the cursorlocation setting. I find that this is not correct - is there another setting which needs to be mae to make this return correctly - my return matching rows setting is also set. Alan McDonald http://www.meta.com.au - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: The request properties can not be supported by this ODBC Driver.
SQL ASP I can't seem to find any examples of saving text area form inputs to TEXT type fields. They all seem to be text inputs or strings being saved to varchar fields... Can someone point me to an example of saving large text quantities to a TEXT Type field in ASP? Thanks Alan McDonald http://www.meta.com.au - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
error in the list?
can someone tell me why I get this error back from postings? Your message was not delivered for the following reason: E-mail Account: lists-mysql is over the limit of 31457280 bytes. Automated Postmaster Alan McDonald http://www.meta.com.au - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: timestamp bug increments by one day
isn't that the month changing? it's changing from october to january...?? Alan > -Original Message- > From: Jay X [mailto:sparqz50@;hotmail.com] > Sent: Monday, 21 October 2002 12:20 > To: [EMAIL PROTECTED] > Subject: timestamp bug increments by one day > > > Hi There, > > Just reciently (after no changes) my MySQL database is automatically > incrementing timestamps by one day. > > Timestamp format is timestamp(14). > > An example date would be 20021021143513 > > when I use command such as: > INSERT INTO MyTable SET timestamp = 200210211143513; > > and then: > SELECT * FROM MyTable; > > I get : > > > timestamp > > 200201221143513 > > > This is happening on Redhat 7.1, MySQL Ver 11.15 Distrib 3.23.38, for > pc-linux-gnu (i686) > > when I type: > SELECT NOW(); > > I get the correct date, and when I type: > INSERT INTO MyTable SET timestamp = NOW(); > > that also increments the timestamp by one day just like it does > when I set > the > timestamp manually. > > Thanks, > > Stuart > > > _ > Surf the Web without missing calls! Get MSN Broadband. > http://resourcecenter.msn.com/access/plans/freeactivation.asp > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: Select statment
John, StudioName? GenreName? F_Name? L_Name? DatabaseName? ServerName? Alan I can't seem to figure out the select statement to get the name. Do I need the the StarID or ActorID in Titles table? Thank you. I am using PHP and MYSQL. Studios (StudioName, StudioID) Genres (GenreName, GenreID) Titles (VideoTitle, Details, StudioID, GenreID, BitRateID, TitleID) Actors (F_Name, L_Name, ActorID) Stars (TitleID, ActorID) TitleGenres (TitleID, GenreID) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: a mysql question
I think you need to give us the SQL you are using to do the search - we'll ba ble to see what your are trying to do better Alan > -Original Message- > From: µÑ ¶Ì [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 17 October 2002 15:37 > To: [EMAIL PROTECTED] > Subject: a mysql question > > > I'm a chinese software engineer, and I has use mysql > for three years ago.Now,I get a matter from it. > recently,I'm deal big data use mysql first.every > table's data is one million,so user search the data > will use long time.now ,if some user search one table > togeter,the table is dead , and I find the connection > to the mysql cann't close,my God,I only restart it. > > my develop language is JAVA.But I can't think the > error is in JAVA code.my question is wheather mysql > can't support a lot of connection search one table > together? > > I want get a help or an advance for you ,thanks. > > _ > Do You Yahoo!? > ÐÂÏʵ½µ×,ÓéÀÖµ½¼Ò - ÑÅ»¢ÍƳöÃâ·ÑÓéÀÖµç×ÓÖܱ¨! > http://cn.ent.yahoo.com/newsletter/index.html > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Inserting Master and Details records
Sorry your second link makes that claim a little clearer - it's on a per-connection basis Alan > -Original Message- > From: Roger Baklund [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 16 October 2002 23:58 > To: [EMAIL PROTECTED] > Cc: Alan McDonald > Subject: Re: Inserting Master and Details records > > > * Alan McDonald > > My task is to insert a new master record and several detail > records within > > the one transaction. > > > > There is a foreign key on the detail table set to the unique > key (autoinc) > > field of the master table. > > > > Inserting a master record, even with a special field value so > > that it can be > > quickly returned with the newly created primary key, so that I > might then > > insert the detail records with this primary key as their > foreign key, does > > not seem very reliable to me (as suggested a few days ago). > > > > There must be a more reliable way to do this under heavy traffic. > > I'm afraid > > I'm used to being able to grab a generator ID and using that > > (guaranteed to > > be unique) for both the primary key of the master and the foreign > > key of the > > detail records. Surely there is a good method for use with MySQL? > > Yes, there is. Check out the function LAST_INSERT_ID(): > > http://www.mysql.com/doc/en/Miscellaneous_functions.html > > http://www.mysql.com/doc/en/mysql_insert_id.html > > > -- > Roger > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Inserting Master and Details records
Peter, Thanks you - I looked up Insert_ID() in the manual... Page 171-172 If I insert into person but before I insert into short, someone else inserts into person, surely my inserts into shirt will have their last Insert_ID()? Do you know if this is true only in the same connection context only? Or does insert_id() return another connections last insert? Alan > -Original Message- > From: Peter Lovatt [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 17 October 2002 0:59 > To: Alan McDonald; [EMAIL PROTECTED] > Subject: RE: Inserting Master and Details records > > > Hi > > insert_id returns the key value. I use php, and the mysql_insert_id is the > last insert_id on that connection, so even if other processes > have added new > records in the time the script runs the insert_id is the correct one. > > You can then use that as the key in the detail records. > > HTH > > Peter > > --- > Excellence in internet and open source software > --- > Sunmaia > www.sunmaia.net > tel. 0121-242-1473 > --- > > -Original Message- > From: Alan McDonald [mailto:[EMAIL PROTECTED]] > Sent: 16 October 2002 13:45 > To: [EMAIL PROTECTED] > Subject: Inserting Master and Details records > > > My task is to insert a new master record and several detail records within > the one transaction. > > There is a foreign key on the detail table set to the unique key (autoinc) > field of the master table. > > Inserting a master record, even with a special field value so > that it can be > quickly returned with the newly created primary key, so that I might then > insert the detail records with this primary key as their foreign key, does > not seem very reliable to me (as suggested a few days ago). > > There must be a more reliable way to do this under heavy traffic. > I'm afraid > I'm used to being able to grab a generator ID and using that > (guaranteed to > be unique) for both the primary key of the master and the foreign > key of the > detail records. Surely there is a good method for use with MySQL? > > Alan McDonald > http://www.meta.com.au > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
Inserting Master and Details records
My task is to insert a new master record and several detail records within the one transaction. There is a foreign key on the detail table set to the unique key (autoinc) field of the master table. Inserting a master record, even with a special field value so that it can be quickly returned with the newly created primary key, so that I might then insert the detail records with this primary key as their foreign key, does not seem very reliable to me (as suggested a few days ago). There must be a more reliable way to do this under heavy traffic. I'm afraid I'm used to being able to grab a generator ID and using that (guaranteed to be unique) for both the primary key of the master and the foreign key of the detail records. Surely there is a good method for use with MySQL....? Alan McDonald http://www.meta.com.au - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
