100,000 row limit evil rumor spread by Larry Ellison and B. Gates
_ 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:http://lists.mysql.com/[EMAIL PROTECTED]
date conversion
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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
from my rdb review (get ready for that RDB interview) avail upon request
(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 location(precise) now running mysql under RH 8...having a blast _ Working moms: Find helpful tips here on managing kids, home, work and yourself. http://special.msn.com/msnbc/workingmom.armx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
date and not null
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 table
create table log_book (fdate date, actype varchar2(16), acid varchar(16),
nlandings number, nhours number);
create table salesreps
(empl_num int(8) not null,
name varchar(15) not null,
age int(8),
rep_office int(8),
title varchar(10),
hire_date date not null,
manager int(8),
quota float(10,2),
sales float(10,2) not null,
primary key (empl_num ));
must be the not null!!!
mysql desc log_book;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| fdate | date| YES | | NULL| |
| actype| varchar(16) | YES | | NULL| |
| acid | varchar(16) | YES | | NULL| |
| nlandings | int(11) | YES | | NULL| |
| nhours| double(8,2) | YES | | NULL| |
+---+-+--+-+-+---+
5 rows in set (0.00 sec)
mysql desc salesreps;
++-+--+-++---+
| Field | Type| Null | Key | Default| Extra |
++-+--+-++---+
| empl_num | int(8) | | PRI | 0 | |
| name | varchar(15) | | || |
| age| int(8) | YES | | NULL | |
| rep_office | int(8) | YES | | NULL | |
| title | varchar(10) | YES | | NULL | |
| hire_date | date| | | -00-00 | |
| manager| int(8) | YES | | NULL | |
| quota | float(10,2) | YES | | NULL | |
| sales | float(10,2) | | | 0.00 | |
++-+--+-++---+
9 rows in set (0.00 sec)
_
Have fun customizing MSN Messenger learn how here!
http://www.msnmessenger-download.com/tracking/reach_customize
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
where is mysql.server???
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. http://special.msn.com/msnbc/workingmom.armx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Oracle date
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 program to change the format on 500 insert statements
any suggestions
_
Enjoy the holiday season with great tips from MSN.
http://special.msn.com/network/happyholidays.armx
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
trying to sell a VP on using mysql under Redhat...no problem under Redhat 7.3
(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 mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h landon password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd /usr ; /usr/bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com (2) safe_mysqld produces landon (root) /usr/bin [311]safe_mysqld [1] 3247 landon (root) /usr/bin [312]Starting mysqld daemon with databases from /var/lib/mysql 031219 00:25:56 mysqld ended [1]+ Donesafe_mysqld (3)cat /var/lib/mysql/xxx.log produces: /usr/libexec/mysqld, Version: 3.23.52-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument (4) here is what mysql.sock looks like landon (root) /usr/bin [303]lsa /var/lib/mysql total 20 drwxr-xr-x4 mysqlmysql4096 Dec 18 23:42 ./ drwxr-xr-x 29 root root 4096 Jul 8 18:31 ../ drwx--2 root root 4096 Dec 18 21:21 mysql/ srwxrwxrwx1 mysqlmysql 0 Dec 18 23:42 mysql.sock= drwx--2 root root 4096 Dec 18 21:21 test/ -rw-rw1 mysqlmysql 156 Dec 18 22:52 xxx.log (5) also tried ./bin/safe_mysqld --user=mysql same result (6) tried safe_mysqld --debug couldn't find the mysqld.trace file (7) safe_mysqld is in /usr/bin ... /usr/bin is in the PATH _ Get dial-up Internet access now with our best offer: 6 months @$9.95/month! http://join.msn.com/?page=dept/dialup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
can't start the server
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] section of init parameters in your my.cnf 873 or my.ini. If you want to use InnoDB tables, add to the [mysqld] 874 section, for example, 875 innodb_data_file_path = ibdata1:10M:autoextend 876 But to get good performance you should adjust for your hardware 877 the InnoDB startup options listed in section 2 at 878 http://www.innodb.com/ibman.html 879 031219 20:52:52 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 880 031219 20:52:52 /usr/libexec/mysqld: Normal shutdown 881 882 031219 20:52:52 mysqld ended I've even tried moving host.frm around. The manual says that mysql_install_db may not have run or to try ./bin/safe_mysqld I've tried all combinations of the above. ps -ef | grep -i sql shows nothing so the server is NOT running mysql does not work ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) .. PREVIOUS HISTORY (1) performed a standard install of Redhat Linux 9 months ago (I found mysql 3.23.52 installed) I executed mysql_install_db successfully (manual says it is safe to rerun) installing all prepared tables 031219 0:44:16 /usr/libexec/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h landon password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd /usr ; /usr/bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com (2) safe_mysqld produces landon (root) /usr/bin [311]safe_mysqld [1] 3247 landon (root) /usr/bin [312]Starting mysqld daemon with databases from /var/lib/mysql 031219 00:25:56 mysqld ended [1]+ Donesafe_mysqld (3) tried debug landon (root) /usr/bin [316]!305 cat /var/lib/mysql/xxx.log /usr/libexec/mysqld, Version: 3.23.52-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument (4) here is what mysql.sock looks like landon (root) /usr/bin [303]lsa /var/lib/mysql total 20 drwxr-xr-x4 mysqlmysql4096 Dec 18 23:42 ./ drwxr-xr-x 29 root root 4096 Jul 8 18:31 ../ drwx--2 root root 4096 Dec 18 21:21 mysql/ srwxrwxrwx1 mysqlmysql 0 Dec 18 23:42 mysql.sock= drwx--2 root root 4096 Dec 18 21:21 test/ -rw-rw1 mysqlmysql 156 Dec 18 22:52 xxx.log (5) also tried ./bin/safe_mysqld --user=mysql same result (6) tried safe_mysqld --debug couldn't find the mysqld.trace file (7) mysql doesn't work ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) _ Grab our best dial-up Internet access offer: 6 months @$9.95/month. http://join.msn.com/?page=dept/dialup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
