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: http://lists.m

Re: Primary Key question

ries would 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 -

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: 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 hav

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 check

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

mysql 4.x for debian linux

Anyone know where I can find a compiled version of mysql 4.x for debian linux? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request th

How to insert entire text file in a table column

I have the following table, CREATE TABLE cp ( id INT(11) NOT NULL auto_increment, fileVARCHAR(128) NOT NULL, content LONGTEXT, UNIQUE KEY keyword(id,file), PRIMARY KEY (id) ) TYPE=INNODB; I want to insert into "content" an entire text document. How do I do that wit

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.

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,