Converting Column to SET

2002-02-21 Thread Greg Willits
I'm converting a database where multiple selections from a valuelist were stored delimited within a single field with a \r. I imported this data into MySQL 3.23.46 and imported the valuelist selections as is into a VARCHAR field large enough to hold all selections. I'm fine storing selection

Re: memcpu usage (mysqld under Linux RH 7.2)

2002-02-21 Thread Dimitry
Mikhail V.Soloviev [EMAIL PROTECTED] wrote: Hello, I have a problem with mysqld (3.32.46 under Red Hat Linux 7.2, pIII-800 512K RAM). It starts and works fine until some time is passed, then it starts eating my memory and CPU. Try to run binaries from MySQL site - gcc 2.96 can be the

Question about displaying of 'timestamp' field

2002-02-21 Thread Clive Arnold
I've added a timestamp field to a table and when viewing the data stored in the field it looks like this . 19970523091528 .. but when I view the data in Access or Macromedia Dreamweaver it looks like this 05/23/1997 09:15:28 .. is there any way to make Access/Dreamweaver

Re: Question about displaying of 'timestamp' field

2002-02-21 Thread DL Neil
Clive, I've added a timestamp field to a table and when viewing the data stored in the field it looks like this . 19970523091528 .. but when I view the data in Access or Macromedia Dreamweaver it looks like this 05/23/1997 09:15:28 .. is there any way to make

Windows installation

2002-02-21 Thread Geoff Davis
Hi Apols for being dense but I have basic problem with MySQL for Win98. I have downloaded and unzipped mysql-3.23.47-win-src.zip The next step is to do the setup.exe but there is no file called this. So how do I proceed? (There is a small zip program also on the download page, but this is 'not

mysql not using indexes if select * where a 5

2002-02-21 Thread Natalino Picone
Hi, I found that mysql doesn't used indexes if there is a in the where statement... for example mysql explain select * from testtable where id 5; +-+--+---+--+-+--+---++ | table | type | possible_keys | key | key_len | ref | rows |

Re: Windows installation

2002-02-21 Thread DL Neil
Hi Geoff, Apols for being dense but I have basic problem with MySQL for Win98. Perhaps not dense, just baffled by 'new' terminology. You appear to have downloaded the source code. If you want to download MySQL and not have the extra, compile, step to negotiate, then find the *-win.zip

Re: mysql not using indexes if select * where a 5

2002-02-21 Thread Georg Richter
On Thursday, 21. February 2002 12:46, Natalino Picone wrote: Hi, I found that mysql doesn't used indexes if there is a in the where statement... for example mysql explain select * from testtable where id 5; It would only make sense to use an index, when you want to select the id field

Upgrade problem from 3.22.27-2 - 3.23.37-8

2002-02-21 Thread Andreas Schlegel
Hi, I have the following problem: I had to install a complete new server with Suse 7.2 (MySql: 3.23.37-8). From the the old installation I only got the backup files (created with 'mysqldump database my_databases.sql') and the the database file (ISD, ISM, frm). My problem is: I can't read the

MySQL PHP Development IDE

2002-02-21 Thread Gerald R. Jensen
This off topic, but one of our programmers is interested in NuSphere's PHPEd development interface and I would liek some feed back from other users. His interest lies not so much in using for database table modeling, but for PHP and Perl development. I am well aware of the conflict a few months

Are there any other 'automatic' fields apart from timestamp ?.

2002-02-21 Thread Clive Arnold
Apart from timestamp are there any other fields that will automatically generate data for themselves when a new record is created ?. I'm having trouble using timestamp with Macromdia Dreamweaver so something that just generates a unique number for each record would be good e.g 1,2,3,4,5,6,7,

Re: MySQL PHP Development IDE

2002-02-21 Thread Robert Cross
His interest lies not so much in using for database table modeling, but for PHP and Perl development. How does PHPEd stack up compared to other PHP IDE's? What experience (good or bad) has anyone had with it? Is there another product that is better? I've just finished using Quanta+ for doing a

Master/Slave reversal in Replication

2002-02-21 Thread Victoria Reznichenko
Jorge, Wednesday, February 20, 2002, 7:44:50 PM, you wrote: JG Hello JG I'm new to MySQL, Unix and Replication. JG I would like to know if in a scenario where I have one master and JG several slaves I can convert one of the slaves to master in the event JG my master goes down. It will be added

CHECK constraints

2002-02-21 Thread Egor Egorov
Neil, Thursday, February 21, 2002, 12:18:27 AM, you wrote: NZ Hello, NZ I searched the manual but it seems like MySQL does not support ANSI SQL NZ CHECK constraints. These are often used to check that rows inserted into NZ tables meet specified criteria. For example table T created as follows

mysql not using indexes if select * where a 5

2002-02-21 Thread Victoria Reznichenko
Natalino, Thursday, February 21, 2002, 1:46:11 PM, you wrote: NP Hi, NP I found that mysql doesn't used indexes if there is a in the where NP statement... NP for example NP mysql explain select * from testtable where id 5; NP

Windows installation

2002-02-21 Thread Egor Egorov
Geoff, Thursday, February 21, 2002, 1:33:47 PM, you wrote: GD Hi GD Apols for being dense but I have basic problem with GD MySQL for Win98. GD I have downloaded and unzipped GD mysql-3.23.47-win-src.zip GD The next step is to do the setup.exe but there is no GD file called this. So how do I

Are there any other 'automatic' fields apart from timestamp ?.

2002-02-21 Thread Victoria Reznichenko
Clive, Thursday, February 21, 2002, 3:22:47 PM, you wrote: CA Apart from timestamp are there any other fields that will CA automatically generate data for themselves when a new record is CA created ?. CA I'm having trouble using timestamp with Macromdia Dreamweaver so CA something that just

print out the datastructure of tables

2002-02-21 Thread Egor Egorov
Theo, Wednesday, February 20, 2002, 6:37:15 PM, you wrote: TVS Hello, TVS I am new with MySQL and have it running on Windws 2000 server and TVS programming with VC++ 6.0 TVS Now converting from SQL 7.0 to MySQL TVS I wonder if there is a way to print out the data structure of the TVS table

Re: MySQL PHP Development IDE

2002-02-21 Thread Joel Wickard
This off topic, but one of our programmers is interested in NuSphere's PHPEd development interface and I would liek some feed back from other users. His interest lies not so much in using for database table modeling, but for PHP and Perl development. If he's not really that interested

RE: LOAD DATA LOCAL INFILE (Only loads 20,000 or 41,000 Records)

2002-02-21 Thread Johnny Withers
This worked for me: create table tblZips( id int unsigned not null auto_increment primary key, city char(24) not null default '', state char(2) not null default '', zip char(5) not null default '' ) Type=InnoDB; Saved CSV file as a UNIX (instad of DOS format file) LOAD DATA

Innodb Tables in MySql 4.0 ?

2002-02-21 Thread ROGGER ALEXIS VASQUEZ MARTINEZ
Ive just downloaded Mysql Max 4.0 binary distribution for Windows ... Does this distribution supports Innodb tables ? How do I turn on this feature ? I follow the instruction (modifying my.ini to include support for innodb ) buy Mysql does not start ( I am using Winmysqladmin ) and I am using

RE: MySQL PHP Development IDE

2002-02-21 Thread Craig Shepherd
InterAKT produce a Dreamweaver Ultradev extension called Phakt that is pretty good. It creates PHP scripts that manipulate MySQL databases. It is free and allows comparable functionality to the 'native' UltraDev languages (ASP, JSP, Cold Fusion). For more info -

PERL DBB::MYSQL MAKE TEST PROBLEM....

2002-02-21 Thread Darren Ball
I've been having some troubles install dbd::mysql on Solaris 2.4 - make test is failing and I can't figure out what is going wrong. The following shows the results coming back from make test If anybody can help me out here, I would appreciate it. Thanks. make[1]: Entering directory

RE: MySQL PHP Development IDE

2002-02-21 Thread Craig Shepherd
InterAKT produce a Dreamweaver Ultradev extension called Phakt that is pretty good. It creates PHP scripts that manipulate MySQL databases. It is free and allows comparable functionality to the 'native' UltraDev languages (ASP, JSP, Cold Fusion). For more info -

Logging problem with --log, my.cnf etc.

2002-02-21 Thread alastair
Hello, I am using MySQL 3.23.36 on Linux. This is a small gripe about a product I am otherwise very happy with. I hope I have not missed the obvious or been stupid some other way. The problem - I want to log somewhere other than $DATADIR. Things are set up like ; | log | ON

Re: MySQL PHP Development IDE

2002-02-21 Thread BD
At 06:37 AM 2/21/2002 , you wrote: This off topic, but one of our programmers is interested in NuSphere's PHPEd development interface and I would liek some feed back from other users. His interest lies not so much in using for database table modeling, but for PHP and Perl development. I am well

RE: MySQL PHP Development IDE

2002-02-21 Thread Gerald Jensen
Thanks for the advice ... I'll take a look at dbg2 ... if I get stuck, I'll shoot you a plea for help! Gerald Jensen -Original Message- From: BD [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 9:38 AM To: Gerald R. Jensen Cc: [EMAIL PROTECTED] Subject: Re: MySQL PHP

urgent problem with mysql and phpmyadmin

2002-02-21 Thread Victoria Reznichenko
Andrew, Thursday, February 21, 2002, 3:31:16 AM, you wrote: AB I have created a table in the mysql db, using phpmyadmin with the following AB statement: AB create table books AB ( isbn char(13) not null,author char(30),title(60),price float(4,2),primary AB key(isbn)); AB which works fine and

Re: PERL DBB::MYSQL MAKE TEST PROBLEM....

2002-02-21 Thread Ken Menzel
Hi Darren, The tests rely on the perl BDB and mysql-modules packages for perl. Have you installed and tested these? Ken - Original Message - From: Darren Ball [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 21, 2002 10:27 AM Subject: PERL DBB::MYSQL MAKE TEST

Gemini Tables and NuSphere Update

2002-02-21 Thread Scalper
I am a new MySQL user, so forgive my stupidity for asking the following question (perhaps taboo). What is the latest on NuSphere vs MySQL AB? What about Gemini. I have searched everywhere for info, but can't seem to find anything after November of last year. I have serious needs for

Re: PERL DBB::MYSQL MAKE TEST PROBLEM....

2002-02-21 Thread Darren Ball
Yes, this problem is happening at the 'make test' step while installing these modules... I have performed the perl Makefile.PL, and the make, they seem to go ok, just when I perform the make test, it seems to fail with this relocation and symbol errors --- Ken Menzel [EMAIL PROTECTED]

foreign keys to what end?

2002-02-21 Thread David Felio
I have a MySQL InnoDB table for ACH (checking account) transactions that includes, among other fields, the below: trans_id (PRIMARY KEY) cust_type routing_num status site_id payment_type auth_type trans_type trace_num All of the above fields (except the primary key) are related to other tables

Upgrade problem from 3.22.27-2 - 3.23.37-8

2002-02-21 Thread Andreas Schlegel
Hi, I have the following problem: I had to install a complete new server with Suse 7.2 (MySql: 3.23.37-8). From the the old installation I only got the backup files (created with 'mysqldump database my_databases.sql') and the the database file (ISD, ISM, frm). My problem is: I can't read the

Re: Gemini Tables and NuSphere Update

2002-02-21 Thread Jeremy Zawodny
On Thu, Feb 21, 2002 at 10:17:52AM -0600, Scalper wrote: I am a new MySQL user, so forgive my stupidity for asking the following question (perhaps taboo). What is the latest on NuSphere vs MySQL AB? What about Gemini. I have searched everywhere for info, but can't seem to find anything

Re: Mysql 4.0 or 3.23 with innodb?

2002-02-21 Thread Trond Eivind Glomsrød
Varshavchick Alexander [EMAIL PROTECTED] writes: Gentlemen, Can you advice please if I'd wish to change the database format from myisam to innodb should I upgrade to mysql 4.0 to get better performance and stability, or switching to innodb alone under 3.23 will do the trick? Switching to

mySQl JDBC connectivity in Windows.

2002-02-21 Thread Bill Fogarty
I am having problems connecting to the mysql databse from a Java application in Windows 2K, I am using JDBC and have the mySQL odbc software installed. I am running mysql from the command line prompt in Windows 2k. I fear I may be doing something wrong, if anyone has a step by step solution,

Non-Sequential Primary Key Index

2002-02-21 Thread Byron Scott
I have the following table: CREATE TABLE phpSP_users ( primary_key mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment, user varchar(50) NOT NULL, password varchar(30) NOT NULL, userlevel smallint(3) DEFAULT '0' NOT NULL, service_name varchar(50) DEFAULT 'A Childs Place',

mysqlbug: SIGALRM hangs read() on socket racecondition

2002-02-21 Thread cdaniel
Description: I'm seeing random hung reads() after a mysql insert that appears to be related to a sig alarm race condition. The basic workflow of this program is while (1) recvfrom() /* few hundred packets a sec */ parse packet insert into sql However, once per second a sig alarm is

Problems finding parts of mysql on FreeBSD

2002-02-21 Thread Luc Foisy
I didn't pick the operating system( I don't know it well at all ), and didn't do the install of mysql on this system, but now I have to figure out where things are and how to fix it. What I am use to, is installing on Red Hat with the rpm. ( if someone knows the differences in the operating

RE: Logging problem with --log, my.cnf etc.

2002-02-21 Thread Luc Foisy
Does mysql have permission to write to that location? -Original Message- From: alastair [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 10:33 AM To: [EMAIL PROTECTED] Subject: Logging problem with --log, my.cnf etc. Hello, I am using MySQL 3.23.36 on Linux. This is a

Re: Problems finding parts of mysql on FreeBSD

2002-02-21 Thread Dan Nelson
In the last episode (Feb 21), Luc Foisy said: I didn't pick the operating system( I don't know it well at all ), and didn't do the install of mysql on this system, but now I have to figure out where things are and how to fix it. What I am use to, is installing on Red Hat with the rpm. ( if

Re: Logging problem with --log, my.cnf etc.

2002-02-21 Thread alastair
On Thu, Feb 21, 2002 at 01:02:02PM -0500, Luc Foisy wrote: Does mysql have permission to write to that location? Yes. I'm starting and stopping MySQL using an init script a la Redhat. This calls 'safe_mysqld' with some args (e.g. --user,--pid-file etc.) - all started as user root as usual. The

RE: foreign keys to what end?

2002-02-21 Thread adam nelson
Using foreign keys is a really, really good idea. Programs can't be trusted (and what about running sql queries ad hoc). Even with a really big database I wouldn't get rid of the keys, just time to move to a bigger better machine/configuration. -Original Message- From: David Felio

Best solution for a very busy MySQL server

2002-02-21 Thread stef voxtel
Hello, Have a look at : http://www.compagnie.com/stef/solution1.jpg http://www.compagnie.com/stef/solution2.jpg I'm searching for a solution to change a high traffic mysql server with a distributed system. 1)Is the solution 1 is good for a writing + reading access ? Are there problems with

RE: Problems finding parts of mysql on FreeBSD

2002-02-21 Thread Luc Foisy
020221 13:12:19 mysqld started 020221 13:12:20 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020221 13:12:20 mysqld ended also it would be important to note /etc/my.cnf [mysqld] datadir=/usr/data/mysql pid-file=/usr/data/mysql/tmcdbs01.mysql.pid ahh could be a

MySQL Book

2002-02-21 Thread Danis Stéphane (NHQ-AC)
Any book you guys recommend for learning the specific strenght of MySQL, I'm have a Oracle background and would like to learn more on MySQL. Stephane SQL, Query - Before posting, please check:

Install Crash : MySQL-3.23.49-1 /RedHat 7

2002-02-21 Thread root
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Install Crash : MySQL-3.23.49-1 /RedHat 7 Severity: Priority: Category:

RE: MySQL Book

2002-02-21 Thread Rick Emery
MySQL by Paul DuBoise Paul monitors this mailing list, so if you have questions concerning what you've read, he may answer. -Original Message- From: Danis Stéphane (NHQ-AC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 1:08 PM To: Mysql (E-mail) Subject: MySQL Book Any

Re: Gemini Tables and NuSphere Update

2002-02-21 Thread Heikki Tuuri
Hi! Or should I look at the InnoDB tables (which are still considered beta). InnoDB tables are classified as gamma by Innobase Oy and MySQL AB. The text on the MySQL-Max download page is lagging behind (says beta), but to balance it, on the front page MySQL AB classifies MySQL-Max as stable

Re: Logging problem with --log, my.cnf etc.

2002-02-21 Thread alastair
On Thu, Feb 21, 2002 at 01:47:50PM -0500, Luc Foisy wrote: maybe the variable you are using is not right my 'show variables' indicates log with a value of OFF | log | OFF yet mysql still generates its standard error file Hi Luc, Thanks for the reply (but please

RE: MySQL Book

2002-02-21 Thread Gurhan Ozen
The bible is MySQL by PAul DuBois ISBN: 0735709211 homepage: http://www.kitebird.com/mysql-book/ Gurhan -Original Message- From: Danis Stéphane (NHQ-AC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 2:08 PM To: Mysql (E-mail) Subject: MySQL Book Any book you guys

MySQL replication error

2002-02-21 Thread Luc Foisy
Would anyone be able to tell me why this happened, and how I could fix it? mysql show slave status\G *** 1. row *** Master_Host: 209.217.92.34 Master_User: repslave2 Master_Port: 3306 Connect_retry: 60

Raw Devices in MySQL?

2002-02-21 Thread Lou Picciano / Essex Systems
Have a feeling I know the answer already, but ­ here goes! ... Does anyone know if (and how) MySQL supports raw devices? I¹ve been searching the docs; can find nothing... Thanks - Lou - Before posting, please check:

Newbie needs help with installation.

2002-02-21 Thread George Labuschagne
Hi, I am running SuSE 7.3 Professional and i downloaded the binary files for Max 4.0 version from here: http://www.mysql.com/downloads/mysql-max-4.0.html I followed the installation procudure to the letter from this file: /mysql-max-4.0.1-alpha-pc-linux-gnu-i686/INSTALL-BINARY in the archive.

-p password

2002-02-21 Thread James Austin
Hi all, A novice question: How can I do away with having to use the -u user and -p password arguments every time I execute the mysql command? When I create a table with a script the only way I can get it to work is with the command: $ mysql samp_db -u root -p create_member.sql $ Enter

Re: -p password

2002-02-21 Thread Van
James Austin wrote: Hi all, A novice question: How can I do away with having to use the -u user and -p password arguments every time I execute the mysql command? When I create a table with a script the only way I can get it to work is with the command: $ mysql samp_db -u root -p

Selecting set members

2002-02-21 Thread John Fulton
If I have a table with a set such as this: CREATE TABLE application ( application_num int(6) NOT NULL auto_increment, availability set('weekdays','weekends','mornings','afternoons') default NULL, PRIMARY KEY (application_num) ) TYPE=MyISAM; is it possible to search based on members of the

RE: MySQL Book

2002-02-21 Thread Paul DuBois
At 13:25 -0600 2/21/02, Rick Emery wrote: MySQL by Paul DuBoise Paul monitors this mailing list, so if you have questions concerning what you've read, he may answer. You added an e to my name deliberately just to see if I'd reply, didn't you! :-) -Original Message- From: Danis

RE: MySQL Book

2002-02-21 Thread Rick Emery
oops... Do I get credit for capitalizing the B in DuBois? GRIN -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 3:57 PM To: Rick Emery; 'Danis Stéphane '; Mysql (E-mail) Subject: RE: MySQL Book At 13:25 -0600 2/21/02, Rick Emery wrote:

Re: Fake interval data type

2002-02-21 Thread Tod Harter
On Thursday 21 February 2002 03:06, Heikki Tuuri wrote: Oh, Duh. The bigger Oops was mine. Doesn't help much to have a transaction if you don't ask for a lock! ;o). Thx. Oops, the syntax is SELECT ... FROM ... WHERE .. LOCK IN SHARE MODE; Heikki -Original Message- From:

Re: MySQL replication error

2002-02-21 Thread chad kellerman
Luc, I new to this mailinglist ( this is my first posting) But I have worked a little with replication. Try if the replicator is still down. set sql_slave_skip_counter = 1; slave start on the slave as long as you are sure the master is ok. Let me know is this worked. -chad On Thu,

RE: Selecting set members

2002-02-21 Thread John Fulton
Neil, Thank you for giving me that idea. That exact syntax did not work with = but using like worked well. Problem solved. Thanks, John mysql select availability FROM application; +---+ | availability

Linking tables using INNER JOIN

2002-02-21 Thread Christopher Thompson
I am trying to do an inner join between three tables. Here is what I have tried: select * from MapConfig LEFT JOIN ConfigString USING (id) LEFT JOIN ConfigInt USING (id) WHERE MapConfig.layername = Roads; What I am trying to do is to pull back all rows from MapConfig associated with

Re: MySQL Book

2002-02-21 Thread DL Neil
MySQL by Paul DuBoise Paul monitors this mailing list, so if you have questions concerning what you've read, he may answer. You added an e to my name deliberately just to see if I'd reply, didn't you! :-) Not really, but because he thinks you are Paul of Idaho! =dn

RE: Linking tables using INNER JOIN

2002-02-21 Thread Rick Emery
try: select * from MapConfig mc LEFT JOIN ConfigString USING (id) LEFT JOIN ConfigInt cf on mc.id=cf.id WHERE MapConfig.layername = Roads; -Original Message- From: Christopher Thompson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 4:24 PM To: [EMAIL PROTECTED] Subject:

Re: -p password

2002-02-21 Thread James Austin
Yes. Thank you. Just put a pair of around password and it works fine. I had thought this could be handled in mysql, but hey, this works. rc wrote: one way would bein bash - edit your .bashrc file to include the following: alias mysql='mysql -u username -p password' On Thu, 21

Re: -p password

2002-02-21 Thread rc
actually someone sent an email to the list suggesting using .my.cnf file, which is probably better than using the .bashrc file On Thu, 21 Feb 2002, James Austin wrote: Yes. Thank you. Just put a pair of around password and it works fine. I had thought this could be handled in mysql,

Re: Raw Devices in MySQL?

2002-02-21 Thread Jeremy Zawodny
On Thu, Feb 21, 2002 at 04:10:58PM -0500, Lou Picciano / Essex Systems wrote: Have a feeling I know the answer already, but ­ here goes! ... Does anyone know if (and how) MySQL supports raw devices? I¹ve been searching the docs; can find nothing... InnoDB can use raw devices. -- Jeremy D.

Re: MySQL Book

2002-02-21 Thread Paul DuBois
At 22:15 + 2/21/02, DL Neil wrote: MySQL by Paul DuBoise Paul monitors this mailing list, so if you have questions concerning what you've read, he may answer. You added an e to my name deliberately just to see if I'd reply, didn't you! :-) Not really, but because he thinks you are Paul

Re: Linking tables using INNER JOIN

2002-02-21 Thread Christopher Thompson
On Thursday 21 February 2002 3:29 pm, Rick Emery wrote: try: select * from MapConfig mc LEFT JOIN ConfigString USING (id) LEFT JOIN ConfigInt cf on mc.id=cf.id WHERE MapConfig.layername = Roads; Heh. It's been too long since I worked with SQL. Thanks, that worked perfectly.

Re: -p password

2002-02-21 Thread Paul DuBois
At 14:30 -0800 2/21/02, James Austin wrote: Yes. Thank you. Just put a pair of around password and it works fine. I had thought this could be handled in mysql, but hey, this works. I don't see how it *could* work. When the password is given on the command line, it must follow the -p with no

RE: Selecting set members

2002-02-21 Thread Paul DuBois
At 17:18 -0500 2/21/02, John Fulton wrote: Neil, Thank you for giving me that idea. That exact syntax did not work with = but using like worked well. Problem solved. You might find that using FIND_IN_SET('afternoons',availability) works as well. Thanks, John mysql select availability

Re: -p password

2002-02-21 Thread rc
shockingly enough it works like this: alias mysql='mysql -u username -ppassword' On Thu, 21 Feb 2002, Paul DuBois wrote: At 14:30 -0800 2/21/02, James Austin wrote: Yes. Thank you. Just put a pair of around password and it works fine. I had thought this could be handled in mysql, but

Re: -p password

2002-02-21 Thread James Austin
I put this line (with no space after the -p) in the .bashrc file and sourced it; alias mysql='mysql -u root -pbig_secret' It gets me in ok. Van suggested the mysql way putting this in a .my.cnf file in my home directory. [client] user=username password=big_secret I know this is basic stuff,

Re: Non-Sequential Primary Key Index

2002-02-21 Thread Arjen Lentz
Hi Byron, On Fri, 2002-02-22 at 03:23, Byron Scott wrote: I have the following table: CREATE TABLE phpSP_users ( primary_key mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment, [...] PRIMARY KEY (primary_key), KEY user (user), KEY primary_key (primary_key) ); You

Re: -p password

2002-02-21 Thread Van
James Austin wrote: I put this line (with no space after the -p) in the .bashrc file and sourced it; alias mysql='mysql -u root -pbig_secret' It gets me in ok. Van suggested the mysql way putting this in a .my.cnf file in my home directory. [client] user=username

Re: -p password

2002-02-21 Thread Shankar Unni
alias mysql='mysql -u root -pbig_secret' Another, more reliable way, is to use the long-form options and say mysql --user=root --password=big_secret -- Shankar. - Before posting, please check:

RE: -p password

2002-02-21 Thread Noel Clarkson
Hi there, the other comments may have got you where you want but as no one had mentioned your final option thought I'd mention (from /h at the mysql command line) source (\.)Execute a SQL script file. Takes a file name as an argument. so you can run the script from the mysql prompt.

MySQL 4.x Timeline

2002-02-21 Thread Anthony W. Marino
Is there a timeline/status for 4.x functionality available? I would like to use MySQL 4.x, however, I'm looking for some of the highly requested functionality (ie; subselects, SP's, triggers and Views) and would like to know where/when in the sequence of things todo does everything fall into

SQL query

2002-02-21 Thread RBRoa
Everyone, Have u encountered this kind of query? mysql select edate from traffic where year(edate)='2001' group by month(edate); ++ | edate | ++ | 2001-04-29 | | 2001-05-01 | | 2001-06-01 | | 2001-07-01 | | 2001-08-01 | | 2001-09-01 | | 2001-10-30 | | 2001-11-01 |

Can I do it with single query in mysql?

2002-02-21 Thread Alvis
Hello all, Suppose I have 3 tables, 1. master (auto_nr, link, dat) CREATE TABLE master ( auto_nr int(11) unsigned zerofill NOT NULL, link int(11) unsigned zerofill NOT NULL, dat DATE NOT NULL, PRIMARY KEY auto_nr(auto_nr), KEY link_key(link) ) 2. child1 (auto_nr, link1, value1) CREATE TABLE

RE: Can I do it with single query in mysql?

2002-02-21 Thread Daniel Rosher
If you only interested in getting the overall sum from the child tables you could try the following: 1) Change your child create statements to: CREATE TABLE child1 ( auto_nr int(11) unsigned zerofill NOT NULL, link int(11) unsigned , value int(11), PRIMARY KEY auto_nr(auto_nr), KEY

RE: SQL query

2002-02-21 Thread Daniel Rosher
I presuming you are expecting more results from the first select statement, hence the reason and indicating this in the second, should then your first statement be: select edate from traffic where year(edate)='2001' group by edate; ? Regards, Dan -Original Message- From: [EMAIL

RE: SQL query

2002-02-21 Thread Daniel Rosher
I can't see any way of making this statement faster, however: One method to increase speed, especially since the amount of data is large is to create seperate tables into your lowest common denominator, here year (e.g. traffic_2000,traffic_2001 etc). Then create a merge table with the same name

Re: SQL query

2002-02-21 Thread Arjen Lentz
Hi, On Fri, 2002-02-22 at 11:29, [EMAIL PROTECTED] wrote: Have u encountered this kind of query? mysql select edate from traffic where year(edate)='2001' group by month(edate); ++ | edate | ++ | 2001-04-29 | | 2001-05-01 | | 2001-06-01 | | 2001-07-01 |

ERD for MySQL?

2002-02-21 Thread Jeff Kilbride
Are there any open source ERD programs for MySQL for doing basic data modelling? I tried myERD at sourceforge and it couldn't parse the sql dump from my database. It died with a parse exception on the unsigned attribute for my int columns. Any other choices out there? Thanks, --jeff

Wide Indexes

2002-02-21 Thread Jeff Kilbride
For reporting purposes, I usually use a wide index across all the fields that are relevant to creating the reports. So, for example, my sales table has this type of data: sale_id sale_date salesperson_id product_id referral_id [other sales data] sale_id is an auto_incrementing primary key.

Finding overlapping intervals efficiently

2002-02-21 Thread Colin Dewey
Given two tables (t1 and t2) with fields start and end, what is the most efficient method of finding the all the intervals in the first table that overlap any interval in the second table? Right now, I use a query like: SELECT t1.name, t2.name FROM t1, t2 WHERE t1.start = t2.end AND t1.end =

Upgrade Problem

2002-02-21 Thread Andreas Schlegel
Hi, I have the following problem: I had to install a complete new server with Suse 7.2 (MySql: 3.23.37-8). From the the old installation I only got the backup files (created with 'mysqldump database my_databases.sql') and the the database file (ISD, ISM, frm). My problem is: I can't read the

Re: Wide Indexes

2002-02-21 Thread Jeremy Zawodny
On Thu, Feb 21, 2002 at 08:13:51PM -0800, Jeff Kilbride wrote: For reporting purposes, I usually use a wide index across all the fields that are relevant to creating the reports. So, for example, my sales table has this type of data: sale_id sale_date salesperson_id product_id

Re: Wide Indexes

2002-02-21 Thread Jeff Kilbride
Hmmm... Ok, my original assumption was that if I was grouping by those fields in my SELECT, then including them in the index would help -- if the order of my GROUP BY followed the order of the fields in the index. Your saying it doesn't make much of a difference whether I include them or not?