_
Tired of slow downloads? Compare online deals from your local high-speed
providers now. https://broadband.msn.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
found out that 4.0 has a date format converter
thanks for the Perl
actually I wrote a Qt/C++ program to convert the date
_
Worried about inbox overload? Get MSN Extra Storage now!
http://join.msn.com/?PAGE=features/es
--
MySQL
(2) What normal form is violated here?
A telephone call is uniquely identified by telephone number and time of
call. These* candidate keys compose the primary key. There is an
attribute/column telephone location.
* *
telephone number|time of call | telephone
why did this date work:
insert into log_book values ('08-12-1973','C150','N5787G',1,1.8);
date looks good in table...has been rearranged to std format
and this didn't
insert into salesreps values (109,'Mary Jones',31,11,'Sales
Rep','10-12-1989',106,30.00,392725.00);
date is -00-00 in
landon (root) /usr [632]find / -name mysql.server -print
find: /proc/1437/fd: No such file or directory
_
Working moms: Find helpful tips here on managing kids, home, work and
yourself.
sql from Oracle
insert into log_book values
(TO_DATE('08/12/1973','MM/dd/'),'C150','N5787G',1,1.8);
would like
insert into log_book values
(STR_TO_DATE('08-12-1973','%m-%d-%Y'),'C150','N5787G',1,1.8);
according to the manual, STR_TO_DATE is not until 4.0...I have 3.23.52
hate to write a
(1) performed a standard install of Redhat Linux 9 months ago...now
(I found mysql 3.23.52 installed)
Under root, I executed mysql_install_db successfully:
showing:
installing all prepared tables
031219 0:44:16 /usr/libexec/mysqld: Shutdown Complete
To start
I run safe_mysqld out of /usr with ./bin/safe_mysqld
/var/log/mysqld.log
868 031219 20:52:52 mysqld started
869 Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
870 If you do not want to use transactional InnoDB tables, add a line
871 skip-innodb
872 to the [mysqld]