Setting up version 5

2006-12-18 Thread Karl Larsen
Is there a paper I can d/l that covers intalling MYSQL on Red Hat Linux? Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How a VIEW is stored

2006-08-26 Thread Karl Larsen
other VIEW. Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

First View

2006-08-24 Thread Karl Larsen
I wrote my first VIEW in version 5 and it works just fine. It will be a powerful way to generate output for the Bosses. Why it was taken out on version 4 I have no idea. Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Help Thanks!

2006-08-21 Thread Karl Larsen
e the Reference Manual in Info form will allow me to correct these. For some reason unknown $ mysqladmin -U make new password for root doesn't work. and I can't get other things to work until I get this fixed. But the work is for tomorrow. I'm 71 years old and yes I am slowing

Punt Worked

2006-08-21 Thread Karl Larsen
s now running. None of the above is in the referance manual. It's no wonder very few ever use mysql... Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Back up and punt

2006-08-21 Thread Karl Larsen
s for root and k5di.com. Let you all know how this works out. Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Become mysql user

2006-08-21 Thread Karl Larsen
I think I need to su - mysql and it askes for a password. What is that password? Karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can't get mysqld to run

2006-08-21 Thread Karl Larsen
out saying it can't use the /var/run/mysald/mysqld.pid file. This is because there is no mysqld.pid in that directory. The directory has root permissions. What have I done wrong? Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Getting 5 to run

2006-08-20 Thread Karl Larsen
am doing wrong? I'm just following the info instructions. Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query

2006-08-04 Thread Karl Larsen
with Fedora Core 4. Has anyone got mysql version 5 to work on my version of Linux? Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

yum version 5.*

2006-07-26 Thread Karl Larsen
could not see a way to do that. Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

CREATE VIEW xxxx

2006-07-17 Thread Karl Larsen
I'm using mysql on Linux and all is going well but I can't find the proper way to write a CREATE VIEW. I'm using 4.1 and is this function still in mysql? Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://

log

2006-07-11 Thread Karl Larsen
I have found that \T /home/karl/sql_log will cause evcrything I do to be saved in the file sql_log. Alas if I turn off mysql as I do daily, the log is lost and I have to do it again. Is there a way to get a log like this to be perminant :-) Karl Larsen -- MySQL General Mailing List

Money

2006-07-04 Thread Karl Larsen
s like money. I have not yet found how I can put a $ in front of all the money columns :-) But to date I have become real pleased with mysql and all the SQL I learned from using Oracle works fine. Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: PostgreSQL or mySQL

2006-07-03 Thread Karl Larsen
this is a fine comparison and worth reading. Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Bookbiz DB

2006-06-29 Thread Karl Larsen
read this it is obvious what is going to happen. When you have multiple SELECT and get an output from several tables you see the power of SQL. Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to get bookbiz.sql

2006-06-28 Thread Karl Larsen
If you happen to have "The Practical SQL Handbook" of 1996 it comes with a DB called bookbiz.sql which was current for MySQL of 1996. A lot has changed so the file had to be re-written to work on MySQL version 4.1.x. I did this and you can have my file by going to my web page and d/l it.

Re: multi-column indexes on InnoDB tables

2006-06-27 Thread Karl Larsen
Chris White wrote: On Tuesday 27 June 2006 10:22 am, Asif Lodhi wrote: ALL I am asking is how strong you think MySQL stands up in such a business scenario. I have even created the manual business procedures for power-failure scenarios. I DO need to know HOW gracefully MySQL will recover aft

Re: mysqld refuses to run on boot

2006-06-25 Thread Karl Larsen
Karl Larsen wrote: Duncan Hill wrote: On Saturday 24 June 2006 12:49, Karl Larsen wrote: Hi Joerg, I'm using Ferdora Core 4 of Red Hat and I have in /etc/rc.d/init/ a file mysqld which when I use ./mysqld start does start the system. But it has to be done every time I turn o

Re: QUERY

2006-06-24 Thread Karl Larsen
John Hicks wrote: Karl Larsen wrote: I and a friend have written SQL to big Oracle DB but not much to MySQL on our own computers. I find that there is a QUERY in the list for MySQL but it does nothing much. Also I was glancing through the mamouth MySQL reference manual and saw there are a

Re: mysqld refuses to run on boot

2006-06-24 Thread Karl Larsen
Duncan Hill wrote: On Saturday 24 June 2006 12:49, Karl Larsen wrote: Hi Joerg, I'm using Ferdora Core 4 of Red Hat and I have in /etc/rc.d/init/ a file mysqld which when I use ./mysqld start does start the system. But it has to be done every time I turn on the computer. I d

Re: mysqld refuses to run on boot

2006-06-24 Thread Karl Larsen
Joerg Bruehe wrote: Hi Fredrik, all! Fredrik Andersson wrote: Hi all I have problems getting MySQL autoboot on my RedHat installation. [[...]] In addition to permissions (see the other posts), there is another possible problem: Depending on how your environment is set up, the MySQL server

Re: Math problem

2006-06-23 Thread Karl Larsen
sales * price AS `Turnover $` From titles; HTH, Cor - Original Message - From: "Karl Larsen" <[EMAIL PROTECTED]> To: "Chris W" <[EMAIL PROTECTED]> Cc: "MYSQL General List" Sent: Thursday, June 22, 2006 10:04 PM Subject: Re: Math problem Chris

Re: Autoindexing

2006-06-23 Thread Karl Larsen
Hi Remo, your method works fine on version 4.1 and the one shown for version 5 does not work here. Nice to know there is a SQL word AUTO_INCREMENT to do the job. Karl Remo Tex wrote: If you are using autoincrement filed you could try this: ALTER TABLE `my_database`.`my_table` AUTO_I

Re: Exclusion Query

2006-06-22 Thread Karl Larsen
Jeremy Rottman wrote: I am working on an MLS Exclusion report. In on table1 I have all the information we collect for our files. Each day I download an update our mls table (table2). what I am trying to do is find all the records in table2 that are not in table1. This is the query that I am

Re: Importing large data sets

2006-06-22 Thread Karl Larsen
Scott Haneda wrote: I have two chunks of data to import, one is in this format: "01001 - AGAWAM, MA","01001",0,0,291,249,0,"42.070206","-72.622739" Where it is comma sep and partially quoted The other is in this format "99502 ANCHORAGE, AK","256","265","1424","1962","1131","528","643","6209","9

Re: Math problem

2006-06-22 Thread Karl Larsen
Chris W wrote: Karl Larsen wrote: I'm trying to multiply numbers one of which is money. The money looks like this: SELECT price FROM titles; | price | ++ | $20.00 | | $19.99 | | $7.99 | | $19.99 | | $11.95 | | $19.99 | | $14.99 | | $11.95 | | $22.95 | | $2.99 | | $

Math problem

2006-06-22 Thread Karl Larsen
I'm trying to multiply numbers one of which is money. The money looks like this: SELECT price FROM titles; | price | ++ | $20.00 | | $19.99 | | $7.99 | | $19.99 | | $11.95 | | $19.99 | | $14.99 | | $11.95 | | $22.95 | | $2.99 | | $10.95 | | $7.00 | | $2.99 | | $20.95 | | NULL

The Practical SQL Handbook

2006-06-21 Thread Karl Larsen
I have the subject book and I want to learn SQL from this book. Alas the bookbiz.sql file on the cd-rom was last updated in 1996 :-) 10 years ago. I tried to load it on my version 4 mysql and it would not get far at all. It appears that the software has changed since 1996. I did the te

Copy database to a file

2006-06-20 Thread Karl Larsen
I have been reading the Reference and saw how to convert my database tables and stuff to the words that made them and puts it into a file. But now I need it I can't find it. If you know how please send along how or a page(s) in the Reference. Karl -- MySQL General Mailing List For list

QUERY

2006-06-19 Thread Karl Larsen
of the interpreter and one has in it's title query. It seems this software will do a job like the Oracle QUERY. I have not verified this but hope to do so soon. If anyone on this list has done serious QUERY with MySQL I would sure like to know how you did it. Karl Larsen --

localhost

2006-06-16 Thread Karl Larsen
DB and every time I get ERROR 1044 and so of course I can't use mysql. Does anyone know what error I have made? I loaded mysql from the Linux version I'm using and had the problem. I then deleted all and yum got the latest version which is up now. Karl Larsen -- MySQL Ge