Re: [OT] LEGAL information about MySQL.

2002-12-05 Thread Pae Choi
Look! I already unsubscribed this. Do you understand what that mean? I have no interest to dealing with MySQL and have no time for this. You must understand that this thread was started from someone who were interested to sell his/her product that utilize MySQL. And I was trying to help both

Re: LEGAL information about MySQL.

2002-11-30 Thread Pae Choi
I know the GPL and seen many commercial software using the software and/or tool under GPL. Btw, which paragraph are you referring to? Pae -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pae Choi wrote: If your software utilize the software under GPL license, you can simply add those GPL

Re: LEGAL information about MySQL.

2002-11-30 Thread Pae Choi
mysql, sql, query What you advocate is the same as saying that you if stick a pirated copy of windows in with your software, but disclaim in your documentation that you're only paying for your software, not the copy of windows that is not following Microsoft's licensing terms. Your example

Re: [OT] LEGAL information about MySQL.

2002-11-30 Thread Pae Choi
Didn't you the previous posting that contains two paragraphs from GPL? And if someone wants to sell the software that use the MySQL, then simply let them downlaod it. Then you will be out of this crap. Also, PostgreSQL will be your alternative option as well. Pae P.S.: There are many

Re: LEGAL information about MySQL.

2002-11-30 Thread Pae Choi
- Hash: SHA1 Pae Choi wrote: mysql, sql, query What you advocate is the same as saying that you if stick a pirated copy of windows in with your software, but disclaim in your documentation that you're only paying for your software, not the copy of windows that is not following

Re: [OT] LEGAL information about MySQL.

2002-11-30 Thread Pae Choi
If MySQL plays so dirty, go with PostgreSQL. It's been known to be better and more acceptable in all platforms. Ex, they have triggers, etc that MySQL does not have. Pae - Original Message - From: Tonu Samuel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002

Re: [OT] LEGAL information about MySQL.

2002-11-30 Thread Pae Choi
One final thouhgt for the people who wish to sell your own products. You can distribute your own products, but let your customers download the GPL packages. In that way, you are not distributing that. And you can include your license saying that something like any utilziation of third-party

Re: [OT] LEGAL information about MySQL.

2002-11-30 Thread Pae Choi
. This is a warning! Pae - Original Message - From: Tonu Samuel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 7:59 AM Subject: Re: [OT] LEGAL information about MySQL. On Sat, 2002-11-30 at 14:46, Pae Choi wrote: If MySQL plays so dirty, go with PostgreSQL. It's been

Re: [OT] LEGAL information about MySQL.

2002-11-30 Thread Pae Choi
] To: Pae Choi [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 8:18 AM Subject: Re: [OT] LEGAL information about MySQL. Hi. On Sat 2002-11-30 at 06:43:11 -0500, [EMAIL PROTECTED] wrote: Didn't you the previous posting that contains two paragraphs from GPL? I saw

[FYI] All Innovative Product Inventors

2002-11-30 Thread Pae Choi
The following is the copyright note for PostgreSQL. That's simple and you can avoid all the obstacles to invent your products. It's free. Pae // # PostgreSQL Copyright ## PostgreSQL Database Management System (formerly known as Postgres, then as

Re: LEGAL information about MySQL.

2002-11-29 Thread Pae Choi
If your software utilize the software under GPL license, you can simply add those GPL licenses as well as make a note that you are only selling, i.e. the price is only for your own software, your own software, you should be fine. Just to pretect your own benefit, you can add a statment saying

Re: MySQL secure access

2002-11-28 Thread Pae Choi
If I am your customer and the data related to my web contents and/or services stored(this is more than likely if the hosting service is used) in the database at your site, I would definitely claim that the access to data will be appropriate. Ex, You have Web services using a hosting service. And

Re: Application level security

2002-11-28 Thread Pae Choi
I've done a similar work in 1997 for one of my clients. The password method will be just part of the security system. But you may want to consider to implement the RBAC in the database. In that way, the users whether they are applications, e.g., business objects, DB interactive tool by human user,

[MySQL v3.23.53a] BLOB Data and Table Size

2002-11-26 Thread Pae Choi
I have two tables containing a BLOB cloumn as; -- supposed to be able to handle up to about 16MB CRETAE TABLE gallery1 ( idINTEGER, titleVARCHAR(255), mediumimageMEDIUMBLOB ); -- supposed to be able to handle up to about 4GB CRETAE TABLE gallery2 ( idINTEGER,

Re: [MySQL v3.23.53a] BLOB Data and Table Size

2002-11-26 Thread Pae Choi
not decresed. It remains as it was. Any comments? Thanks. Pae P.S.: The table is created with type=bdb option as: CREATE TABLE ... TYPE=BDB; On 26 Nov 2002, at 8:52, Pae Choi wrote: Q: How come the size of table does not decrease after deletion? MySQL will reuse that space

Re: SQL Row Counting in MySQL

2002-11-26 Thread Pae Choi
There is SQL function called COUNT. Check it out and see of that helps you. Pae Hi All, Is there a simple way in MySQL to only select the first x rows that meet a specified criteria. For example in Oracle the following would work: Select * from Blah where stuff=true and rownum = 10

Re: [MySQL v3.23.53a] BLOB Data and Table Size

2002-11-26 Thread Pae Choi
Paul, It really did the trick. Thanks. Regards, Pae - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Pae Choi [EMAIL PROTECTED]; Keith C. Ivey [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 10:59 AM Subject: Re: [MySQL v3.23.53a] BLOB Data and Table

MySQL v3.23.52-MAX on Win32

2002-11-24 Thread Pae Choi
I have created a test table for different data types as follows: CREATE TABLE AllDataTypes ( id INTEGER, col_bit BIT, col_boolean BOOL, col_tinyint TINYINT, col_smallint SMALLINT, col_int INT, col_integer INTEGER, col_bigint BIGINT, col_float FLOAT, col_double DOUBLE, col_char

Re: MySQL v3.23.52-MAX on Win32

2002-11-24 Thread Pae Choi
Thanks. That explains it. Pae The first column of type timestamp will always be initialized with the current timestamp. See the fourth and fifth paragraphs of the following link. http://www.mysql.com/doc/en/DATETIME.html Isn't it suppose to be 'NULL'? Thanks -- Linux: Because

[Feature or Bug] Data Types: DECIMAL and DOUBLE

2002-11-18 Thread Pae Choi
Say we create a table as follows: CREATE TABLE account (id INTEGER, balance DECIMAL(20, 2), col_double DOUBLE(20,2)); And we insert 6 rows as follows: INSERT INTO account (id, balance, col_double) VALUES (1, 12345678901234567890.56, 12345678901234567890.56); INSERT INTO account (id, balance,

Re: mysql return days in month?

2002-11-18 Thread Pae Choi
Not all Feb. has 28 days. It depends on whether it is a lunar year or not. So Some Feb. will have 28 days and some have 29 days. Pae - Original Message - From: Andrew Braithwaite [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: 'Roger Baklund' [EMAIL PROTECTED] Sent: Monday, November 18,

Re: [Feature or Bug] Data Types: DECIMAL and DOUBLE

2002-11-18 Thread Pae Choi
No execuse! My appologies for the cross posting. Your advice is well accepted. Also thank you for your explaination regarding on my inquiry as well. Regards, Pae - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: Pae Choi [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent

Re: [Feature or Bug] Data Types: DECIMAL and DOUBLE

2002-11-18 Thread Pae Choi
Where can we find the info regardng on the DOUBLE precision 15 or 16? I searched the doc. and unable to locate it. JDBC mm.mysql-2.0.14-bin.jar + MySQL v3.23.52-MAX on WinNT. Regards, Pae CREATE TABLE account (id INTEGER, balance DECIMAL(20, 2), col_double DOUBLE(20,2)); And we insert

Re: Re: Age calculation

2002-05-15 Thread Pae Choi
You probably need a computational module that calculates age with leap year calculation support. :-) Pae - Original Message - From: Kittiphum Worachat [EMAIL PROTECTED] To: Nick Stuart [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 6:38 PM Subject: Re: Re: Age