Command that I believe should work...
...but doesn't. I am attempting to create a table using the following... CREATE TABLE INVOICE ( INV_NUMBER INTPRIMARY KEY, CUS_CODEINT NOT NULL REFERENCES CUSTOMER(CUS_CODE), INV_DATE DATETIME DEFAULT NOW() NOT NULL, ); I receive an error message stating that there is an error with 'NOW()' Which doesn't make sense to me. I understand both Oracle and MS-SQL Server use a similar format for putting the date and time into a field when a new row is created. At least that is my goal. Is there a very different method of doing this under MySQL 4.0.21? Thanks for any assistance you may offer. -Rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Command that I believe should work...
TIMESTAMP, at least by the book in front of me, is only valid from January 1, 1970 to December 31, 2037. I want to avoid using something that could create a Y2037 issue, if whatever I build ends up lasting that long. To me, that is a potential hazard and thus would be a bad habit to get into. Is there another method, besides relying on the application being built, to insert NOW() into a MySQL DB? Again, thanks for any assistance. -Rob Peter Lovatt wrote: hi you might want to look at TIMESTAMP which does it all for you. Peter ...but doesn't. I am attempting to create a table using the following... CREATE TABLE INVOICE ( INV_NUMBER INT PRIMARY KEY, CUS_CODE INT NOT NULL REFERENCES CUSTOMER(CUS_CODE), INV_DATE DATETIME DEFAULT NOW() NOT NULL, ); I receive an error message stating that there is an error with 'NOW()' Which doesn't make sense to me. I understand both Oracle and MS-SQL Server use a similar format for putting the date and time into a field when a new row is created. At least that is my goal. Is there a very different method of doing this under MySQL 4.0.21? Thanks for any assistance you may offer. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Serwer Hardware p4 or pIII ?
Helmut, I suppose that depends really upon the composition of your database. Unfortunately, I am far from an expert when it comes to MySQL or virtually any other database, I just happen to know a little bit about hardware and some performance related information. All of that is only on the low-end commodity hardware of the personal computer. If you know what size database, meaning how many tables and how much information you will have in the database then I am certain that other more database knowledgeable members of this list will be able to offer some suggestions. The only other thing that I can add is if your database is going to be relatively small (In comparison to some of the databases discussed on this list.) you will probably see admirable performance on the fastest Pentium 4 and the fastest AMD Athlon XP+ system you can build or buy. (Based upon an earlier response that states how Intel beefed up the FPU in the Pentium 4.) I feel as long as you don't skimp on the hardware, you shouldn't have too many issues. Good luck. Regards, Robert Adkins II IT Manager/Buyer Impel Industries, Inc. Ph. 586-254-5800 Fx. 586-254-5804 -Original Message- From: Helmut Apfelholz [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 7:39 AM To: Robert Adkins; andy thomas; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Serwer Hardware p4 or pIII ? Robert, thank you for your answer. I will be using the server strictly for MySQL database. That will be a backend for several Web Applications written mostly in PHP. What hardware is advised in such a configuration ? --- Robert Adkins [EMAIL PROTECTED] wrote: I am running a few AMD based servers in our offices here and have no issues with them. The big question is, What kind of operations are you most likely to see with your servers? If the servers will be doing some heavy floating point operations stay away from the Intel P4. (Unless recent versions have been fixed.) The Pentium 4 has a TERRIBLE FPU. If you need high FPU and MUST stick with Intel, then by all means look for Pentium III CPUs or look from some Pentium Xeon CPUs. If you aren't brand specific, take a look at AMD. They perform admirably for FPU options. For instance, there is one workstation application that we have for developing CNC Mill cutter path that simply tears things up when it is run on an AMD chip. Our old system would take nearly an hour to generate the same cutter path that is generated in less then 30 seconds on the AMD Chip. (Athlon 2000+ XP) In the tests performed by our vendor, a similar speed Pentium 4 takes quite a bit longer to generate the same cutter path. Something close to 5 minutes longer. Of course, that's all FPU doing the work there. The one thing that the P4 has over the AMD Athlon XP and P3 CPUs is raw memory bandwidth. It can easily outpace both of those other processors for VERY specific operations, like video editing and other HIGH Memory bandwidth hungry applications. Depending upon what you are building, you might want to utilize more then one CPU type across several boxes to be able to utilize the strengths of each processor design. Good luck! Regards, Robert Adkins II IT Manager/Buyer Impel Industries, Inc. Ph. 586-254-5800 Fx. 586-254-5804 -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 1:33 PM To: [EMAIL PROTECTED]; Helmut Apfelholz; Robert Adkins Cc: [EMAIL PROTECTED] Subject: Re: Serwer Hardware p4 or pIII ? On Wed, 4 Dec 2002, Helmut Apfelholz wrote: Hi, I am assembling mysql only server. I am planning 2Gb RAM, 4 x 15k SCSI disks. However I cannot decide if I should get 2 p4 processors or 2 tuallatin pIII. I could not find any mysql specif?c benchmarks, that would show which processors I should use. I will be running linux on the server. Could anyone share his/hers experience with me ? I have often wondered about that myself so I would be interested in other people's views. I currently run a number of servers with dual 1GHz P3's. Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list
RE: Serwer Hardware p4 or pIII ?
I am running a few AMD based servers in our offices here and have no issues with them. The big question is, What kind of operations are you most likely to see with your servers? If the servers will be doing some heavy floating point operations stay away from the Intel P4. (Unless recent versions have been fixed.) The Pentium 4 has a TERRIBLE FPU. If you need high FPU and MUST stick with Intel, then by all means look for Pentium III CPUs or look from some Pentium Xeon CPUs. If you aren't brand specific, take a look at AMD. They perform admirably for FPU options. For instance, there is one workstation application that we have for developing CNC Mill cutter path that simply tears things up when it is run on an AMD chip. Our old system would take nearly an hour to generate the same cutter path that is generated in less then 30 seconds on the AMD Chip. (Athlon 2000+ XP) In the tests performed by our vendor, a similar speed Pentium 4 takes quite a bit longer to generate the same cutter path. Something close to 5 minutes longer. Of course, that's all FPU doing the work there. The one thing that the P4 has over the AMD Athlon XP and P3 CPUs is raw memory bandwidth. It can easily outpace both of those other processors for VERY specific operations, like video editing and other HIGH Memory bandwidth hungry applications. Depending upon what you are building, you might want to utilize more then one CPU type across several boxes to be able to utilize the strengths of each processor design. Good luck! Regards, Robert Adkins II IT Manager/Buyer Impel Industries, Inc. Ph. 586-254-5800 Fx. 586-254-5804 -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 1:33 PM To: [EMAIL PROTECTED]; Helmut Apfelholz; Robert Adkins Cc: [EMAIL PROTECTED] Subject: Re: Serwer Hardware p4 or pIII ? On Wed, 4 Dec 2002, Helmut Apfelholz wrote: Hi, I am assembling mysql only server. I am planning 2Gb RAM, 4 x 15k SCSI disks. However I cannot decide if I should get 2 p4 processors or 2 tuallatin pIII. I could not find any mysql specif?c benchmarks, that would show which processors I should use. I will be running linux on the server. Could anyone share his/hers experience with me ? I have often wondered about that myself so I would be interested in other people's views. I currently run a number of servers with dual 1GHz P3's. Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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