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
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
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
?
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]
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
=
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
.
--
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
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
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
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:
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]
Why SQLyog can not insert/update Table w/o Primary Key? Is there additional setting to
enable this?
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
- 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
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
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
/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
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.
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
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
. 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
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
, 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
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
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
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
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
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
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
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
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
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
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
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
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
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
|
+-+
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
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
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 ++
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
(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
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
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
/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
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
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
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
- 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
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?
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
, 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
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
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
/ (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
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
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
[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
)
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
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
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
'] = 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
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
. 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
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
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
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
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
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
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
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
- 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
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
://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
. 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
/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
:
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
://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
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
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
-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
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
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
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
://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
)
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
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
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)
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':
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
/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
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
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
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
[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
)
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
(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
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
by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
___/ www.mysql.com
Sincerely,
William Mussatto, Senior Systems Engineer
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
]
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
201 - 300 of 415 matches
Mail list logo