MySQL Design Question

The real design problem is that I'm new to this. However, ... I'm putting together my own "knowledgebase" using MySQL and built from various sources including books and list groups of similar form to this one. It's basically an expanded bibliography. Different form would have different data el

GUIfront-end in Linux?

I'm moving from Win2k to Linux and was wondering if there was a GIU MySQL front-end in Linux similar to Mascon or mysqlfront for the windoz Oss. Thanks Frank - Before posting, please check: http://www.mysql.com/manual.php

RE: 0000-00-00 vs NULL in Date Field

Here's what I did: mysql> create database testnull; Query OK, 1 row affected (0.05 sec) mysql> use testnull; Database changed mysql> create table info (birth date); Query OK, 0 rows affected (0.03 sec) mysql> show tables; ++ | Tables_in_testnull | ++ | i

0000-00-00 vs NULL in Date Field

If I read a file into a database with a \N in an empty date field the field is populated with -00-00. If I insert a row into the same database with NULL in the date field it is populated with NULL. Programmatically is there a difference between the two? Thanks Frank --

Capture "SHOW VARIABLES" to fie

Is there a way to redirect the output of a MySQL statement like SHOW VARIABLES to a file? Thanks Frank - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (th

Newbie Permission Q

I've installed MySQL on Redhat 7.0 from a RPM. The install data directory is /var/lib/mysql. I have run mysql_install_db. From a user account I can run mysql and receive the mysql> prompt. However, when I attempt something like: mysql> create database new_db I receive the following error : "ER

RE: mysql Digest 24 Jun 2001 00:58:59 -0000 Issue 1353

You might want to try: http://www1.fatbrain.com/search/searchresults.asp?SearchFunction=key&qtext=m ysql+perl&Submit.x=11&Submit.y=11 Fatbrain has it at $35.99 (20% off list). Amazon has it at $44.99. Frank -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Su

RE: ArabiaSoft and NuSphere

Dylan, Can you comment on the use of Perl vs. PHP with either of these? Thanks Frank -Original Message- From: Dylan Shea [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 7:06 AM To: Frank J. Schmuck Cc: [EMAIL PROTECTED] Subject: Re: ArabiaSoft and NuSphere I've

ArabiaSoft and NuSphere

Any comments on the packages from ArabiaSoft and NuSphere? Thanks Frank - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this