olap

Does OLAP work with MySQL? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

What is a schema?

What is a schema? How is different from a database? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

IGNORE: test only

IGNORE: test only since I did not get my last posting. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Data type DOUBLE and DATETIME

I want to store a date of this format mmddhhmmss.ss Should I use DOUBLE as the data type? Yes I do need all the .sss's. Or should I use DATETIME and then have another column to store the fraction of seconds? -- MySQL General Mailing List For list archives:

Primary Key question

I've created the following table (server 4.1 in win2k) CREATE TABLE `os` ( `id` tinyint(10) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `description` varchar(255) default NULL, PRIMARY KEY (`id`,`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; and was very surprised

Re: Primary Key question

be: 1,winxp 2,winxp there's no key conflict/duplication there. by the way, you do realize what the max range is on the (signed) tinyint (for your id), correct? Original Message Date: Friday, July 01, 2005 10:04:01 AM -0400 From: Haisam K. Ido [EMAIL

Re: Nuke_

these are tables for either postnuke or phpnuke. Both are very nice content management systems: http://www.postnuke.com/ http://www.phpnuke.org/ This may be another silly question Looking at our dbase I noticed that a number of tables have been added The all start nuke_ I have no idea

To BLOB or not to BLOB

Is it wise to always assume that a file content is always binary and hence store it in a MySQL BLOB type, even if the file may be only a text file? Your thoughts on this would be appreciated. sql - Before posting, please

Re: How to insert entire text file in a table column

Excellent! It works. H M Kunzmann wrote: Yes there is ! Use LOAD_FILE(path_name) as the value component of the insert/update statement On Mon, 2003-01-13 at 00:41, Haisam K. Ido wrote: I have the following table, CREATE TABLE cp ( id INT(11) NOT NULL auto_increment, file

Re: Foreign Key problem? in MySQL 4.0.7

Heikki: Do you mean the PRIMARY KEY order? Heikki Tuuri wrote: Haisam, - Original Message - From: Haisam K. Ido [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, January 01, 2003 10:29 PM Subject: Foreign Key problem? in MySQL 4.0.7 I was able to create the gid

Foreign Key problem? in MySQL 4.0.7

I was able to create the gid table with no problem under mysql 4.0.7 CREATE TABLE gid ( id INT(11) NOT NULL auto_increment, groupname VARCHAR(128) NOT NULL, passwd VARCHAR(128) NULL, gidINT(11) NOT NULL, username VARCHAR(128) NULL,