Re: Newbie SELECT problem

2003-07-02 Thread William R. Mussatto
and Time values. c. something else entirely. Also, are you running this in a procedureal language (e.g., perl, java)? This will give us other options. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http

Re: Newbie SELECT problem

2003-07-02 Thread William R. Mussatto
solution to this I noticed that you have a separate date and time field. Is there a reason for this. It would be easier to get single row for each sessionID if they were one field. Otherwise I think you will have to go with the method Peter proposed above. William R. Mussatto, Senior Systems

Re: Newbie SELECT problem

2003-07-02 Thread William R. Mussatto
tea.. ok how about this: select sessionID,max(concat(idate,' ',itime)) from test group by sessionID Note I thought date and time were reserved so I substituted.. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list

Upgrade from mm to Connector/J under tomcat

2003-06-18 Thread William R. Mussatto
? Anyone done this? William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: RAID hardware suggestions/experience

2003-06-17 Thread William R. Mussatto
I'm wrong). So, unless you have a spare in the back you will end up replacing 3 drives (assuming Raid 5). That may be why the WD model has such low capacity compared with the normal IDE drives. Just my 2 cents worth. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909

Re: Java/JDBC - Connection refused on Linux

2003-06-17 Thread William R. Mussatto
= DriverManager.getConnection(this.DBUrl,this.dbuser,this.dbpasswd); } catch (Exception e) { e.printStackTrace(); } Hope this helps.. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives

Re: Which version do I install?

2003-06-12 Thread William R. Mussatto
. -- This is a x86 (32 bit) chip. It may or may not have 'hyperthreading' where it can act as two processors. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: MySQL Connector/J

2003-06-10 Thread William R. Mussatto
Somehow you are still using the older org.gjt.mm.mysql drivers not connector/J. When I asked many moons ago I was told that they could not both be used at the same time by Tomcat even in separate contexts, but YMMV. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608

How to make Cascade Update?

2003-06-10 Thread William IT
I just migeate from MS SQL to MySQL but have problem on Cascade Update. Suppose I have BOOK and LIST_TYPE tables like this: BOOK, field: Book_Name, Book_Type LIST_TYPE, field: Book_Type If I already define Cascade Update between BOOK and LIST_TYPE, then when I update the content of Book_Type

Copy database to another Server

2003-06-10 Thread William IT
I do mysqlamin shutdown and copy all /var/lib/mysql file from another MySQL server. And then run: chmod -R 660 * chown -R mysql:mysql * shutdown now -r But I can't logon to Mysql. What's wrong? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Why does auto increment not take into account deleted rows?

2003-06-03 Thread William R. Mussatto
there not that a new one had been substituted. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SQLyog can not insert/update Table w/o Primary Key

2003-06-03 Thread William IT
Why SQLyog can not insert/update Table w/o Primary Key? Is there additional setting to enable this?

Re: Join problem

2003-05-31 Thread William R. Mussatto
users.username='sator') Susan Ator Online Services Engineer National Public Radio Distribution Division [EMAIL PROTECTED] Short answer is mysql does not do sub-selects (i.e., a select inside of a select). The join part is not this issue. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154

Re: Join problem

2003-05-31 Thread William R. Mussatto
- Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com I sit corrected, 4.1x but its alpha from the manual: Subqueries are supported in MySQL version 4.1. I run a production IPP so we run debian with is very far BACK from the bleeding edge. William R. Mussatto, Senior Systems

RE: Join problem

2003-05-31 Thread William R. Mussatto
this in the past. For speed recommend user_id's in all tables be indexed. Obviously replace 'WHATEVER' with the userID value. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Migrating to Connector/J

2003-05-30 Thread William R. Mussatto
We run Tomcat4. Currently we are using the older mm- drivers. Is there anyway to move to connector /J one context at a time rather than all at once? William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http

RE: Can't create thread error

2003-04-01 Thread Mike William
/2003 -0600, Don Read wrote: On 31-Mar-2003 Mike William wrote: Hi Don, Thanks for the suggestions. Here's what happened. Your pconnects are probably sleeping too long. in /etc/my.cnf: [mysqld] set-variable = wait_timeout=10 I tried this, and it was a mixed bag. On the one hand

RE: Can't create thread error

2003-04-01 Thread Mike William
I am now pretty sure that I have got my previous problem licked. I am posting the following additional information to the list in order to help others in the future who have the same problem and come across this thread in the list archives. Here's a really interesting experiment I just did.

Can't create thread error

2003-03-31 Thread Mike William
After a routine restart of our MySQL 3.23 server today, we began getting the following PHP error message during times of moderately high database server load: Warning: MySQL Connection Failed: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the

RE: Can't create thread error

2003-03-31 Thread Mike William
William wrote: After a routine restart of our MySQL 3.23 server today, we began getting the following PHP error message during times of moderately high database server load: Warning: MySQL Connection Failed: Can't create a new thread (errno 11). If you are not out of available memory, you can

Trouble creating foreign keys

2003-03-28 Thread William Hambleton
. Is there a problem in my alter statement? William Hambleton Humana Inc. Technical Analyst Pho. 502.580.1657 Fax. 502.580.1288 - - - - - - - - - - - - - - - - - - - - The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL

RE: Storing Images in MySQL

2003-03-28 Thread William R. Mussatto
and the image on the disk? Only case where this would be a problem would be if the numbers of images were so large that the file look up mechanism of the file system began to be a factor. In cases like that I use a tree of subdirectories tied to something like ISBM number. William R. Mussatto, Senior

RE: Slow Inserts

2003-03-27 Thread William R. Mussatto
, or blob type field then MySQL silently converts all character fields longer than one character to varchar. This may be why you see it sometimes converting the fields. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list

Using LOAD DATA IN FILE or SOURCE with MyODBC.

2003-03-25 Thread William Bailey
start adding an 'export directly to MySQL server' option want to know if it is possiable to issue the 'LOAD DATA IN FILE' or 'SOURCE' SQL commands to export the data from the Windows machine to the FreeBSD machine. -- Regards, William Bailey. Pro-Net Internet Services Ltd

RE: very slow mysql server, help please

2003-03-07 Thread William Wang
mysql max out. When I did load test, There only one CUP is in use, but they switch to each other. Is this normal, or I did configure wrong for my FreeBSD box? Thanks again guys. William -Original Message- From: John Wards [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 6:31 AM

Re: Foreign keys and being FIRST index

2003-03-06 Thread William R. Mussatto
see why they have to be FIRST! Ugh. Major performance hit would be a guess. Otherwise the database would have to do a table scan. Think about how it would find the related record. I think is a requirement of db2 as well William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX

very slow mysql server, help please

2003-03-05 Thread william wang
mysql_connect(), but it's does not make big different.). Question 1: Does sleeping processes slow down database server? Question 2: Any ideas, why is the database so slow? Any suggestions? Thanks in advance and for Reading my message. William

very slow mysql server, help please

2003-03-05 Thread William Wang
mysql_connect(), but it's does not make big different.). Question 1: Does sleeping processes slow down database server? Question 2: Any ideas, why is the database so slow? Any suggestions? Thanks in advance and for Reading my message. William

Re: Temporary Tables

2003-03-04 Thread William R. Mussatto
each can create a TEMPORARY table with the same name. Only the table created by a given client is visible to that client. I use MySQL 4.0.7 on Red Hat. Thanks, Mamatha William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061

RE: MySQL or PostgreSQL

2003-02-28 Thread William R. Mussatto
Since you're posting on a MySQL list, you could probably expect some biased responses. Could you post more about what you need to use a database for, i.e., what are your needs, wants, what kind of data are you handling, connection rates, serving platform, code base, etc. Here are a few URLs

Re: count rows

2003-02-28 Thread William R. Mussatto
mysql_num_rows() In perl:$numRows = $sth-rows; Note the following warning from the DBI man page: Generally, you can only rely on a row count after a non-SELECT execute (for some specific operations like UPDATE and DELETE), or after fetching all the rows of a SELECT statement. Bye! William R

re: trouble setting key_buffer_size on a debian slave

2003-02-27 Thread William R. Mussatto
by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com William R. Mussatto, Senior Systems Engineer Ph

Re: Using MySQL to store email

2003-02-26 Thread William R. Mussatto
William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

C API Question

2003-02-19 Thread William R. Mattil
and mysql_fetch_row follow but nothing is ever returned. If I replace the mysql_list_fields with: if (mysql_query(mysql,Describe some_table_name)) everything works. Where am I missing the boat here ? Thanks Bill -- William R. Mattil | Statisticians define a lottery as a tax Sr. System

Re: Slower access from a client some router hops away from mysql server

2003-02-14 Thread William R. Mussatto
is much slower than local LAN. Also there is the possiblity of dropped packets and retransmittals. The more routers the slower this would be. Have you checked how busy the WAN is. Just my $0.02 worth. I will appreciate a lot any ideas about this. Thanks José Luis William R. Mussatto, Senior

Re: encrypted password

2003-02-07 Thread William R. Mussatto
this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061

Re: Help with SELECT, JOIN and WHERE query

2003-01-28 Thread William R. Mussatto
| +-+ Thanks for any hint Kind regards Heiko Mundle William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: Storeing images in Database

2003-01-24 Thread William R. Mussatto
from the database data to increase performance. The cost is bit of setup (have to create the directories) and programming. This should allow the database rows to be uniform in size which should help performance. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608

which tools to use to convert rows from a table into columns in a new table

2003-01-17 Thread William Wenbiao Zhang
Hi: I am newbie in this email list. I would like to convert rows from a table into columns in a new table, which is simliar to maxtrix transposition. What tools do you recommend to do it? In Oracle, we could use PL/SQL. In MySql, we certainly do not have such tools. Is MySQL ++

Re: Version 4 safe to use?

2003-01-09 Thread William R. Mussatto
google for that. Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Hiding the password

2003-01-06 Thread William R. Mussatto
(the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer

Re: Hiding the password

2003-01-06 Thread William R. Mussatto
On Mon, 6 Jan 2003, Mark wrote: Date: Mon, 6 Jan 2003 22:48:06 +0100 From: Mark [EMAIL PROTECTED] To: William R. Mussatto [EMAIL PROTECTED], Octavian Rasnita [EMAIL PROTECTED] Cc: Larry Brown [EMAIL PROTECTED], MySQL List [EMAIL PROTECTED] Subject: Re: Hiding the password

RE: Hiding the password

2003-01-06 Thread William R. Mussatto
To: William R. Mussatto; Octavian Rasnita Cc: Larry Brown; MySQL List Subject: Re: Hiding the password - Original Message - From: William R. Mussatto [EMAIL PROTECTED] To: Octavian Rasnita [EMAIL PROTECTED] Cc: Larry Brown [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent

Re: sql help

2002-12-23 Thread William R. Mussatto
/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems

A Newbie Question on Passwords

2002-12-21 Thread William Bradley
and later executions it would not accept this password. Any help would be appreciated. Thank you, -- William Bradley http://www.catholicmissionleaflets.org - Before posting, please check: http://www.mysql.com/manual.php

MySQL password confusion.

2002-12-21 Thread William Bradley
and later executions it would not accept this password. The above was installed as root. So now when I do the following: # or $ mysqld -p It asks for a password and I can't get it to work. To ensure the server is working if I do the following: $ps -aux | grep mysql It gives me: william 3083

Re: protecting ccard numbers

2002-12-02 Thread William R. Mussatto
PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http

Fw: SCHEMA, ARCHITECTURE ???

2002-11-13 Thread William Martell
- Original Message - From: William Martell [EMAIL PROTECTED] To: MySQL Main List [EMAIL PROTECTED] Sent: Monday, November 11, 2002 2:02 PM Subject: SCHEMA, ARCHITECTURE ??? Hello All, How do I determine the best architecture for my MySQL database? Do I create multiple databases

SCHEMA, ARCHITECTURE ???

2002-11-11 Thread William Martell
Hello All, How do I determine the best architecture for my MySQL database? Do I create multiple databases or do I create only one database with multiple tables? (Any general rules of thumb?) How do I know if I need to use Keys, Indexes or other features in order to optimize the database?

MySQL Crashes When a Remote Connection Is Made

2002-11-08 Thread william
Description: MySQL crashes when a remote computer attempts to make a standard connection. Making a local connection does not cause this problem, connecting to other systems does not cause this problem, but a connection from a remote computer to mySQL immediately crashes mySQL. The

RE: Removal of Primary Key in Mysql

2002-11-05 Thread William R. Mussatto
, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27

Re: users who can access a database

2002-10-10 Thread William R. Mussatto
Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Query Spans Multiple Pages

2002-10-08 Thread William Martell
the server. In other words. Does the result of the query get stored in a variable that is accessed on the client machine or does the php code return the limit per page and provide a link which acts as another query to display the next page of results. Thanks in advance. Sincerely William

Re: protecting CC numbers

2002-10-07 Thread William R. Mussatto
/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27

Fw: Three Tables. Please help

2002-10-04 Thread William Martell
is the same in all three tables. The other fields are different. I would like to display each tables data sorted by item number. I am having trouble with my select statement. Thank you for your time and assistance. Sincerely, William Martell

Fw: Three Tables

2002-10-03 Thread William Martell
Pass Filter: sql,query - Original Message - From: William Martell [EMAIL PROTECTED] To: MySQL Main List [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 1:48 AM Subject: Three Tables Hello All, I have three tables in my database t1, t2, and t3. Each table has records

Fw: Rename Database

2002-10-02 Thread William Martell
[FILTER:sql, query, database, MySQL] - Original Message - From: William Martell [EMAIL PROTECTED] To: win32 MySQL List [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 1:27 AM Subject: Rename Database Hello All, I am curious how to rename a database in MySQL 4.0 running on win2k

Re: Urgent!!

2002-09-30 Thread William R. Mussatto
) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies

Re: Mixing Linux and Windows and paying for it

2002-09-30 Thread William R. Mussatto
this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27

RE: SQL question

2002-09-27 Thread William McCormick
I don't know that there is knowing the way sorts usually work I'd say no. This is my first posting to this group and I am just in the initial phases of supporting MySQL as a backend for out application. If the numbers always precede the letters I would split them off into two separate columns

phpMyAdmin/MySQL Question

2002-09-25 Thread Easton, William
'] = array(); I have my login and password entered into the user/password area. Also, the actually database is online at mysql.iaacc.org and that might be different. If anyone can help, I would REALLY appreciate it. Thanks -Bill William Easton Creative Media Group The University of Iowa Room

Load Data from multiple sources

2002-09-25 Thread William Martell
Hello All, Can someone tell me if I can load only one column of data from a tab delimited text file into MySQL 4.0? If so, then can I assume that I can load data from multiple data stores, picking columns as I need to. Thank you for your assistance. William

Set Path Environment

2002-09-25 Thread William Martell
. But when I start another session of dos later the settings are gone. Does anyone know how to set this as the default path?? Thank you very much for your assistance and have a nice day. William - Before posting, please check

Fw: Set Path Environment

2002-09-25 Thread William Martell
This is more information regarding the Path for my machine. It shows the default PATH information and the PATH information after I perform the SET PATH command. It also shows how MySQL responds after I type MySQL at the command prompt. Thanks in Advance, William C:\path PATH=C:\WINNT

Dynamic Links

2002-09-24 Thread William Martell
Hello All, Can anyone tell me if I can make dynamic links between tables. Example. std_price in main_table = std_price in table2. So that if I change the price in the main table, It will be reflected throughout the database. Thank you in advance for your help. William (Filter: MySQL, SQL

Create Tables Dynamically

2002-09-24 Thread William Martell
checks with the manufacturers for new parts everyday. One day the robot says yes I found a new part that is not in our database. Can I write a script that will build a table in mySQL and will load the appropriate information. Thanks in advance, William (Filter: MySQL, SQL, Table, Query

ERROR 2006: MySQL server has gone away

2002-09-24 Thread William Blair Wagner
Uptime: 20 min 22 sec Threads: 1 Questions: 90 Slow queries: 0 Opens: 14 Flush tables: 1 Open tables: 8 Queries per second avg: 0.074 Memory in use: 46839K Max memory used: 46902K -- William Blair Wagner

Fractions

2002-09-19 Thread William Martell
in advance. William - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail

Fractions

2002-09-19 Thread William Martell
sql,query,database,odbc Hello All, Can anyone tell me whether I can represent fractions in MySQL 4. I have data representing different lengths of objects measured in inches. Can I load this data as is into a field in MySQL and still retain the same value or do I have to convert it first to a

Load Data from Different txt files.

2002-09-19 Thread William Martell
in Advance. William - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail

Re: Dynamic Links

2002-09-19 Thread William Martell
- Original Message - From: [EMAIL PROTECTED] To: William Martell [EMAIL PROTECTED] Sent: Thursday, September 19, 2002 2:33 PM Subject: Re: Dynamic Links Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must

Re: PD: The win admin for Mysql

2002-09-11 Thread William R. Mussatto
this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27

Re: Tape backups from live slave

2002-08-30 Thread William R. Mussatto
://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior

RE: Tape backups from live slave

2002-08-30 Thread William R. Mussatto
. I'd rather spend an hour restoring from tape and let replication catch me up. -J -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED]] Sent: Friday, August 30, 2002 1:57 PM To: Jeremy Tinley Cc: [EMAIL PROTECTED] Subject: Re: Tape backups from live slave

Re: MySQL and Service Pack 3 - OT comment

2002-08-29 Thread William R. Mussatto
/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: synopsis of the problem (one line)

2002-08-28 Thread William R. Mussatto
: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William

RE: View current connections

2002-08-15 Thread William R. Mussatto
://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Found cause of crash - simple SQL statement.

2002-08-12 Thread William R. Mussatto
check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William

RE: ERROR 1146: Table 'test.test' doesn't exist - Why is mysql adding a postfix to my USE request?

2002-08-10 Thread William dw
From: david [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 10, 2002 1:42 PM Subject: ERROR 1146: Table 'test.test' doesn't exist - Why is mysql adding a postfix to my USE request? Why is mysql adding a postfix to my USE request? I know that test.test doesn't exist, i don't want it to, i'm not

FW: Error: 7 - Error on rename ... (Errcode: 13)

2002-08-10 Thread William dw
-Original Message- From: William dw [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 10, 2002 5:34 PM To: Mysql Subject: FW: Error: 7 - Error on rename ... (Errcode: 13) Error code 13 = Permission denied. Check your permissions :) -Original Message- From: David yahoo [mailto

PHPMyAdmin and mySQL

2002-07-29 Thread William Bradley
From suggestions I received on this mySQL list I installed phpMyAdmin from the Mandrake 8.2 CDrom, which is the system I am running.So I am presuming that there are a number of members on the list using phpMyAdmin. When I use the following command in a browser, phpMyAdmin starts up and then

Re: Data Entry for a Newbie

2002-07-26 Thread William Bradley
Thank you for all the replies to my MySQL question above. They have been most helpful. Bill. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Data Entry for a Newbie

2002-07-25 Thread William Bradley
At the moment I have Mysql installed and understand command line entry of data, or entry via a text file. Either way, it is difficult, especially if you have been used to data entry screens. Is there a utility somewhere that would allow me to do this? Failing that, is it possible to write a html

Re: how to update time field with current time?

2002-07-24 Thread William R. Mussatto
://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920

Re: Fw: Problems with high-use tables

2002-07-18 Thread William R. Mussatto
) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27

A beginners proplems.

2002-07-14 Thread William Bradley
Your patience please :) I am an absolute newbie. When I setup Mysql I made some mistakes and now I can't seem to get out of them. When I login as root and type mysql on the command line as root, I get the following: [william@localhost william]$ su Password: [root@localhost william]# mysql

image data

2002-07-11 Thread William Miller
I am new to MySQL and I was trying to find out how to setup a record with a datatype as a image jpg etc... Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual)

hundreds of undefined references from innobase when linking mysql

2002-07-08 Thread William Barber
Description: While attempting to build mysql with Innobase, the final link step encounters hundreds (thousands?) of undefined references such as: ../innobase/srv/libsrv.a(srv0srv.o): In function `srv_get_n_threads':

Re: Dreamweaver MySql Databases

2002-07-05 Thread William R. Mussatto
archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27

Re: MySQL Question involving AUTO INCREMENT and PRIMARY IDs. - sql

2002-06-27 Thread William R. Mussatto
/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

RE: Is the order same?

2002-06-14 Thread William R. Mussatto
this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27

Re: alter column without dropping

2002-06-14 Thread William R. Mussatto
the parameters of the column. Currently, it is varchar(32), I need to change it to varchar(128). See alter table command in the docs. Can I do that without dropping the column? Thanks, Paul Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext

RE: Tables in MySQL

2002-06-12 Thread William Fears
thanks all! as Danny Meidell had pointed out for me, the space between MAX and (ID) i.e. MAX (ID) vs. MAX(ID) had caused the problem. After removing the space the query works fine. TA Bill -Original Message- From: Alan Munter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002

Re: JDBC connection to MySQL

2002-05-07 Thread William R. Mussatto
[EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27

Re: Scheduling with MySQL

2002-04-26 Thread William R. Mussatto
) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27

Re: mysql innodb error

2002-04-01 Thread William R. Mussatto
(the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer

Re: Report to Recipient(s)

2002-03-26 Thread William R. Mussatto
21:04:43 - Issue 1818 Message from [EMAIL PROTECTED] was quarantined because it contained banned content. I'm sorry, but I couldn't help it...This strikes me as something Microsoft would say. ;-) Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154

Re: Optimizing tables

2002-03-22 Thread William R. Mussatto
by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com Sincerely, William Mussatto, Senior Systems Engineer

Re: mysql 3.23.49-1 rpm fails with redhat 7 thu 7.2

2002-02-23 Thread S. William Schulz
On Sat, Feb 23, 2002 at 01:32:11PM +1300, [EMAIL PROTECTED] wrote: Hi all, The latest rpms for mysql 3.23.49 produce a signal 4 error when attempting to run the installed mysql server. on all our servers running redhat 7 thru 7.2. Obviously this can't be a kernel 2.2.x issue, since 7.2

RE: 3.22.32: max table size

2002-02-22 Thread William R. Mussatto
] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com

<    1   2   3   4   5   >