Yes, host server means ISP.
I am able to view the logs because he lets me.
I agree with you, I think someone else is shutting down the database, but he
insists that my perl scripts are causing it to crash. The only proof I have
right now is the MySql error log, which lists the normal shutdown
I'm sure most people on this list aren't interested in your services. You
can start by reading the relevant manuals or you could hire a professional
to create the db for you.
This is a great list for getting help on specific problems provided you've
tried to help yourself first.
Also, if you
Ciao guys,
I am using MySQL 3.23 on a Linux with Apache/PHP. Last week I first run
it, and had a 'too many connections' warning. So, I just set the
max_connections variable to 200. And since then, no problem.
Here is the /etc/my.cnf file under the [mysqld] group:
Hi!
I have such SQL :
select CompanyName from Company where CompanyName like '%car%'
Really I need in query result all of companys, which contains symbols CAR in any case
(car, Car,CAr, CAR, e.t.c).
I think that I need Case insensitive records search.
Is it's possible and how?
Thanks a lot!
Hi
Can some one help me for this issue.
When I have multiple rows with the same duplicated
data in the table, how can I delete a perticular row
only ?
For example I have the table TABLE1 with C1 INT and C2
VARCHAR(20) with the following rows of data
C1 C2
=
10 MySQL
20
On Mon, Jun 11, 2001 at 02:13:25AM -0400, Chuck Lucas wrote:
Yes, host server means ISP.
I am able to view the logs because he lets me.
I agree with you, I think someone else is shutting down the
database, but he insists that my perl scripts are causing it to
crash. The only proof I
On Sun, Jun 10, 2001 at 09:29:15AM -0400, Granville A. Gayle Jnr. wrote:
I have just started to use MySQL and like the ease in which it does
it's one way replication. However I have a situation that has
multi-sites that would need to do local entry to a database and then
update the centreal
1, Install unixODBC (look at www.unixodbc.org)
2, Then compile MyODBC with --with-unixODBC switch (I'm not sure about
the syntax, look in ./configure -- help).
3, Setup odbc.ini propperly (here U can use ODBCConfig)
4, In StarOffice U should be able to create ODBC Database (select mysql
driver in
You could simulate a crash by deleting the mysql.sock file. If your ISP
allows you to access the logs, he may have inadvertently allowed others
access to them as well. Are you able to check if the system, especially
mysql, is all locked down properly. Correct permission, ownerships, etc.?
Only
Hi all,
I'd like to update my version of Mysql on linux.
How can I do it so that I don't have two copies of mysql on my machine ?
Do I have to clean up the folder mysql and then install the new version under it?
And what should I download -the source code or the binaries- in order to
update the
Hello All:
I am trying to access second mysql server which is running on port
3308 through java. Even when I specify port number in my connection,
it still connecting to the database running on port 3307.
When i try to access 2nd mysql server through command prompt it works!
This is the way i
The insert statement is valid (see http://www.mysql.com/doc/I/N/INSERT.html,
third example), just uncommon.
I can't help with the php...but I do know that insert statement
is invalid.
...
$sql = insert into sitesats set areview='$areview',
apositive='$apositive', anegative='$anegative',
Andis Grasis wrote:
Hi!
I have such SQL :
select CompanyName from Company where CompanyName like '%car%'
Really I need in query result all of companys, which contains symbols CAR in any
case (car, Car,CAr, CAR, e.t.c).
I think that I need Case insensitive records search.
Is it's
Im running some benchmarking tests on mysql, postgres and interbase
database servers.
does anyone know the reasons why or know where i can find out some
technical reasons why the mysql database server is particularly good in
relation to the others or just by itself e.g. use of query
Hi,
I have a database table, which was made with Microsoft Access and am to move
the data into a mysql database table. As there are some long entries, which
exceed the data size allowed in a table cell by Microsoft Excel I can't
export it via Excel and convert it from Excel into a Text
On Fri, Jun 08, 2001 at 07:26:55PM +, Ji-Qin Yang wrote:
Hi, Mysql guys:
I have problem to install mysql into my DEC-AlphaServer 800 which
run DEC-osf4.0d. I downloaded mysql source file:
mysql-3.22.30-dec-osf4.0f- alphaev6.tar.gz, after run #./configure,
then #make, it show the
At 09.42 11/06/01 +0200, Francesco Marchioni wrote:
Hi all,
I'd like to update my version of Mysql on linux.
How can I do it so that I don't have two copies of mysql on my machine ?
Do I have to clean up the folder mysql and then install the new version
under it?
I suggest you to dump all of
On Thu, Jun 07, 2001 at 05:42:40PM +0100, Nelson Gomes wrote:
I have a question:
On a cluster, is it possible to have several MySQL instances (one
per node) each having several mysqld processes, working concurrently
on NAS (network storage) device, that is mounted on every node, and
Dear,
I am preparing my web page to display search result. How could I use SQL
command to handle display specific row per page and next button at the
bottom page (like most search engine display result).
Sommai Fongnamthip
Remark: Could I use this SQL command with PHP or perl?
Hi,
I know this subject has been treated several times in this list (see e.g.
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:65398:200102:ipomopcphmhamkmigoob#b
), but I think it deserves further discussion.
My problem is the following: I have a rather large table
(~430M records in 21G with a
Try Limit 10,10 then Limit 20,10 or is it the other was around limit 10.20!
Well some thing like that..
Hope this helps
Simon
-Original Message-
From: Sommai Fongnamthip [mailto:[EMAIL PROTECTED]]
Sent: 11 June 2001 10:52
To: [EMAIL PROTECTED]
Subject: query to display per page
Dear,
[EMAIL PROTECTED] writes:
Im running some benchmarking tests on mysql, postgres and interbase
database servers.
does anyone know the reasons why or know where i can find out some
technical reasons why the mysql database server is particularly good in
relation to the others or just
In PHP, I used something like this:
?
$result = $db-query(select * from table limit $x,25);
while ($row=$db-fetch_array($result))
{
echo $row[column];
}
$next = ($x+25);
echo a href=\script.php?x=$next\Next/a\n;
?
So that's the idea...
Leon Mergen
[EMAIL PROTECTED]
President of Operations
Just out of interest
If you are selecting * then you are using all the records
What if you use are 'where'..?
Simon
-Original Message-
From: Lukas Knecht [mailto:[EMAIL PROTECTED]]
Sent: 11 June 2001 10:49
To: [EMAIL PROTECTED]
Subject: Again: ORDER BY key_part1,key_part2
Hi!
Does anybody knows how can I check whether the max value in some database's
field has
been reached?
For example, I have MEDIUMINT column and I want to reset its value once it
reaches its maximum, that is 8388607. How can I check which is the maximum
(min) value I can insert into field?
Bye!
I have some sort of problem too...
Look at this:
mysql explain select * from game3 order by memberid;
+---+--+---+--+-+--+--+-
---+
| table | type | possible_keys | key | key_len | ref | rows | Extra
|
Van writes:
Greetings:
With the following code, I have 3 problems:
1../client -psecret works, but, ./client --password=secret does not;
2.After calling load_defaults, the argument vector is getting parsed,
but, it's not making it into the switch processing. The values
Hi Sommai.
On Mon, Jun 11, 2001 at 04:52:01PM +0700, Sommai Fongnamthip wrote:
Dear,
I am preparing my web page to display search result. How could I use SQL
command to handle display specific row per page and next button at the
bottom page (like most search engine display result).
I seem to have a connectivity problem that I'm having trouble diagnosing.
I have an internal network (192.168.0.*) with mysql running fine on machine
A. The outside world can get to A fine, and ordinarily so can machine
Bhowever randomly and more often, I cannot log into A from B using
Saleel,
mysqld.exe was accidentally compiled with __NT__ defined.
You should use mysqld-max.exe.
The next version .39 will ask from the OS if it is Win 95, ...,
and this problem will not appear any more. I am sorry for the
inconvenience.
Regards,
Heikki Tuuri
Innobase Oy
Hello,
I was
I have a slackware box with Apache Perl 5.6, DBI and mod_perl. I can't get
the MYSQL DBI module to install. It's dieing on this line.
I'm very perplexed.
Ruben
umask -a
Linux vidor 2.2.13 #127 Thu Oct 21 13:13:20 CDT 1999 i686 unknown
make[1]: Entering directory
Ok. I have read the manual =) But one thing I am not clear on. Is if I can
create a user who can create their own database's..modify them..and drop them
if need be. But they wouldn't have access to any database on the server. I
am asking because I host 4 different sites and 3 of them want
At 15:04 11/06/2001 +0300, Heikki Tuuri wrote:
Hi,
Only to complete the Heikki's instructions, also you need to
edit on /my.cnf the variables:
[mysqld]
basedir=F:/mysql
datadir=F:/mysql/data
The above is necessary when MySQL was installed on different location
than the default c:\mysql.
hi.
check out a book or online tutorial on database normalization. even a mildly
normalized database will provide a way to uniquely reference a row.
otherwise, you can use:
delete from table1 where c1 = 10 and c2 = 'MySQL' limit 1;
that will delete one row only, and if the rows are truly
Could anybody e-mail me a copy of libmysqlclient.so for Solaris 7 -or- let me
know where I can get one?
Many Thanks,
=Adrian=
Information in this message is confidential and may also be legally privileged.
It is intended solely for the person to whom it is addressed. If you are not the
Our normally reliable back-end server for our web site has now gone
completely crazy ... it's falling over every few seconds. Automatic
restarts are nice, but it really makes the web site unusable.
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack
I recently downloaded the ODBC client software for windows, ran setup, then
went into the 'ODBC Data Source Administrator' from the control panel per
the readme. I tried to add a new datasource, but MySQL was not in the list
so apparently the setup program didn't work as expected.
Any
Hello,
I donwloaded the mysql 3.23.38 binary for AIX 4.3.3 and installed an IBM rs6000
workstation. When I started mysql server with safe_mysqld, I got following error
message:
Start MySQL server deamon
exec(): 0509-036 Cannot load program /usr/local/mysql/bin/my_print_defaults because of
Hi,
unfortunately my provider still runs My SQL version 3.22.32 on his server.
Apparently the LEFT JOIN statement does not work on this version.
Anybody knows a workaround?
Holger
-
Before posting, please check:
Doing that, I'm now seeing: ERROR 2013: Lost connection to MySQL
server during query after entering the password.
The problem above shouldn't be master.info related.
Sheesh, yeah, it's:
stunnel[7765]: Connection from xxx.xx.xxx.xx:1635 REFUSED by libwrap
which is the problem for
On Friday 08 June 2001 22:16, Rohit Peyyeti wrote:
Hello All:
I have two mysqld runnning in ports: 3307 3308 respectively. I started
the second one by using 'mysqld_multi start 2'. whereas mysqld running on
port 3307 is the default mysqld started at the boot time.
when i issue command
I had converted an Access Database into MySQL format and it used
autoincrement fields. I will try without the autoincrement and see what
happens.
Thanks
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 1:54 AM
To: Granville A. Gayle Jnr.
On Mon, 11 Jun 2001, h3rb wrote:
Ok. I have read the manual =) But one thing I am not clear on. Is if I can
create a user who can create their own database's..modify them..and drop them
if need be. But they wouldn't have access to any database on the server. I
am asking because I host 4
where can i found description of BDB messages writed in log and also what
must be done in the case
or maybe somebody can help and tell me what went wrong:
bdb: Log sequence error: page LSN 1:2043982; previous LSN 1 2074929010608
21:12:22
bdb: Log sequence error: page LSN 1:2043982; previous
Hello,
I always have my problem with the 31 tables in a join limitation.
In crash-me database comparaison page, I saw that mysqld 3.23.39 could
manage up to 63 tables in a join. I didn't see in history log that
the limite has been updated from 31 (in 3.23.36 version we use) to
Ok! thanks.
I tried and with the prompt it seems to work. Effectively i have this error
often, but sometime it works correctly.
Maybe the packet it's too big?
A.
Scrive Rolf Hopkins [EMAIL PROTECTED]:
You don't have to join the mailing list to send mail to the list. Send
it
to the list
Hi all,
My ISP provides me with MySql version 3.23.36 on Red Hat Linux 5.2 box,
gcc version is 2.7.2.1, libc version 5.
When I try to compile my C application I get lots of errors. What is
wrong ?
Since this is not my own server, what should I ask my ISP to do in order
to correct this? I mean, if
Hello,
I have been using JDBC with MySQL for the past couple of days without any user id or
password. After reading the directions in the privileges section I decided to change
the password for root. I used the following example from the online manual:
shell mysql -u root mysql
mysql UPDATE
Hi,
I downloaded the mysql-3.23.38 source rpm.
When I try to build it I get the error message:
checking for gcc... egcs
checking whether the C compiler (egcs -O3 ) works... no
configure: error: installation or configuration problem: C compiler cannot
create executables.
error: Bad exit status
From the docs, it doesn't look like too much has been done in the area of stored
procedures.
Are there any resources which would teach me or point me in the right direction to
writing procedures for mysql? The manual mentions that it has facility for c++
procedures, but if you want to learn
At 12:23 PM +0530 6/11/01, Rohit Peyyeti wrote:
Hello All:
I am trying to access second mysql server which is running on port
3308 through java. Even when I specify port number in my connection,
it still connecting to the database running on port 3307.
When i try to access 2nd mysql server
Hi folks,
just another question.
I have a lot of tables in one mysql-database (around 3200 for now) because
I am running Phorum with a lot of boards.
(yes I am working on it to split it in different databases but it can take
a while).
So my question is ... does that mass of tables in one
Doing that, I'm now seeing: ERROR 2013: Lost connection to MySQL
server during query after entering the password.
Right. That was a client error. The server is the only thing which
cares about the master.info file.
Okay, this is solved - stunnel works better when compiled without
this:
select tbl1.field1, tbl2.field2 from tbl1, tbl2 where tbl1.id = tbl2.id
is the same thing as:
select tbl1.field1, tbl2.field2 from tbl1 left join tbl2 on tbl1.id = tbl2.id
- TIM
Hi,
unfortunately my provider still runs My SQL version 3.22.32 on his server.
Apparently the LEFT
Hi
I and my friends we are going to write new JDBC driver for MySQL. Where can we get
description of communication protocol between client and MySQL server?
Tomek
At 07:39 11/06/2001 -0700, Bob Andrews wrote:
Hi,
Assuming that:
1- You have the ODBC Data Source Administrator, means that your
machine has already the ODBC core installed.
2- You ran the MyODBC setup for Win9x and something wrong happened.
If the item 2 is true, verify if the myodbc.dll
hi,
what did you assign the col type and what is the length...
- Original Message -
From: "Simon Abolnar" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 11, 2001 8:15 PM
Subject: Field length problem!
Hello!
When I add record in database everything works OK. When I modify
On Mon, 11 Jun 2001 17:15:09 +0200, Simon Abolnar
[EMAIL PROTECTED] wrote:
What kind of data type is the column in questions?? VAR, CHAR,...etc.??
Hello!
When I add record in database everything works OK. When I modify data in database
using
RS.Update
function everything works OK again
Is mysqlgui capable of connecting to the mysqld daemon via a unix
socket, or must it use the network. Mysqlgui appears to ignore
the 'socket' option in the my.cnf file. Am I out of luck, or did
I possibly make a mistake in the compile?
thanks,
bl
--
//== Brett G. Lemoine -=- [EMAIL
Yes
That was the trouble.
Thanks
I just upgraded the entire thing while I was at it,
perl 5.6, DBI, mod_perl, embperl
Thank you very much. I thought I did get the latest version. Maybe I go a
pre-release version.
Ruben
On 2001.06.11 11:06:01 -0400 Dave FitzPatrick wrote:
Ruben,
I ran
Hello,
I use 3.22.32 on WinNT. Left Join works perfectly (I have one stmt that has
10 left joins).
JohnC
-Original Message-
From: Holger Böhnke [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 7:44 AM
To: mysql
Subject: LEFT JOIN in MySQL Version 3.22.32
Hi,
Hello:
I was wondering if there is a simple way to put a ceiling on the maximun amount of
memory that can be allocated to the mysqld process?
Please advise.
Thanks,
jcd
We have linux/solaris mounted on the same data storage
unit and I would like to install the mysql server once
with the ability to evoke it from linux or solaris.
Is this possible?
---
--==- Sonia Van TasselSoftware Engineer
Hi
I and my friends we are going to write new JDBC driver for MySQL. Where can we get
description of communication protocol between client and server?
Tomek
Hello Dimitar
I'm not a great linux programmer but I had few days ago similar problem.
My advice is to try this:
gcc -o test.cgi test.c cgihtml.a
-I/usr/local/mysql/include -L/usr/local/mysql/lib -lz -lmysqlclient -lz
The only change here is twice use of -lz. In my case that was _very_
Well, getting stunnel clean now presents additional info in the *.err file
on the slave:
010611 13:35:41 Error reading packet from server: Access denied for user:
'ftp@localhost' (Using password: YES) (0)
This being repeated every minute implies it's from the replication
connection, which is
hallo
i use VB6 - ADO 2.6 with the newest MyODBC with options 16834
even when make a select on a date or time type columne i get the windows-format
24.12.2001 , but the format is realy -MM-DD. So i get a lot of trouble..
what i have to do, that i get the right
On Sun, Jun 10, 2001 at 01:15:38PM +0300, Sinisa Milivojevic wrote:
Hello,
I'm a database administrator for a hosting provider, and we have currently 2 SMP
MySQL-database servers. The one that is causing me problems, has at least 900
databases running on it. That's an dual PIII-550, with
I am running MySql 3.23.38, Slackware Linux 7.1 (custom Kernel 2.4.4), PhP
4.0.5, and Apache 1.3.19.
I have found what I believe is a bug with this release of MySql. When I try
to delete an entry from a table (DELETE FROM articles WHERE article_id =
'3') the database only deletes the article_id
Careful here, a left join is not necessarily the same as a join. In
particular a left join will return rows for the left table even if there are
no matching rows in the right table. Under many conditions the two are
identical but definitely not always. That being said, maybe one could use
temp
That would be an apache question. If you look in the Apache Docs for
instructions on how to do use directories (www.host.com/~user) I think that
might point you in the right direction. In short, getting Apache to read the
user's homedir out of a MySQL database would require modifying Apache
I downloaded the file mysql-3.23.38-sun-solaris2.7-sparc.tar.gz last
Friday. I followed the installation instructions, except that mysql is
installed in /export/mysql since I don't control /usr/local.
The file mysqlbug doesn't exist anywhere in my distribution. The
scripts subdirectory only
I didn't get a confirmation mail or anything so here goes ...
I'm trying to compile a simple C program to access a db and dump out the
info (for testing purposes). Here is what I get when I try to compile it:
ebulon:/var/www/www.miester.org/cgi-bin# gcc -g -o miesterc miesterc.c
Hi:
There is a perl module for MySQL you can download from cpan. It provides
the interface to MySQL database you can use to connect, execute SQL
statements from perl programs.
Seung-woo Nam
John Tsangaris wrote:
From the docs, it doesn't look like too much has been done in the area of stored
Hi,
I'm developing an application with mysqlclient library, my code is right but i get an
error:
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function 'my_uncompress':
my_compress.o(.text+0x9a): undefined reference to 'uncompress'
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
Hi all,
a bugfixed MySQL version 3.23.39 was announced on Freshmeat on June,
7th, but there is no announcement on the list and nothing on the site.
Was it a premature announcement?
Michael
-
Before posting, please check:
on 6/11/01 15:13, [EMAIL PROTECTED] at [EMAIL PROTECTED]
wrote:
I am running MySql 3.23.38, Slackware Linux 7.1 (custom Kernel 2.4.4), PhP
4.0.5, and Apache 1.3.19.
I have found what I believe is a bug with this release of MySql. When I try
to delete an entry from a table (DELETE FROM
I am running 3.23.33 master/ 1 slave config on Caldera eDesktop 2.4
system. I had not examined the error logs on the slave for sometime but
was looking them over because the slave thread crashed on a bad query
(not related to my question). I found the error message 'Received a
Signal 16 on
Hello all,
I use the bash shell and the vi editing mode (set -o vi) in my .inputrc.
On one of my boxes, I managed to get the command line tool (mysql) to honour
that setting. However, I have forgotten how I did that. Does anyone know how
to do that?
The table sitesats won't update and shows no errors! (even though there are two
instances of echo(mysql_error()))
html
body
?php require('../common.php');
if (!isset($areview)) {
echo(You must review the site); } else {
if (!isset($apositive)) {
echo(You must review the site); } else {
if
So I had some expensive fun, eh?
John 'TPG' Smith wrote:
Very nice of you to take your very expensive time to write me an idiotic
message.
TPG
- Original Message -
From: jay downs [EMAIL PROTECTED]
To: John 'TPG' Smith [EMAIL PROTECTED]
Sent: Monday, June 11, 2001 6:08 AM
You might have issues with the 'environment' you're setup with...
What 'shell' are you using (especially when you performed the installation)
??
Isn't /export an 'NFS mounted' area ? (will this cause issues with the
installation ?)
Can you 'resolve' (lookup) your system name yourself ? (i.e.
Hi all,
Installing mysql on solaris 6 sun4u sparc SUNW,Ultra-5_10
release:
-- mysql-3.23.38.tar.gz
via
./configure --prefix=/dir --with-low-memory
make
make install
I get to:
yacc -d sql_yacc.yy mv y.tab.c sql_yacc.cc
sql_yacc.yy, line 71: fatal: invalid escape, or illegal reserved word:
On Mon, Jun 11, 2001 at 01:49:48PM -0400, Jude C. Divierte wrote:
Hello:
I was wondering if there is a simple way to put a ceiling on the
maximun amount of memory that can be allocated to the mysqld
process?
The various memory related options in the my.cnf file give you a fair
amount of
Sinisa Milivojevic wrote:
Van writes:
Greetings:
With the following code, I have 3 problems:
1../client -psecret works, but, ./client --password=secret does not;
2.After calling load_defaults, the argument vector is getting parsed,
but, it's not making it into the
Here are some ideas for an improved debugging methodology.
First, take the query that you think should be working, substitute in
hard-coded values, and test it through the mysql command-line
client interface.
So, for example, run the update sitesats set... query and use
hard-coded values for
On Monday 11 June 2001 08:30, Haapanen, Tom wrote:
Our normally reliable back-end server for our web site has now gone
completely crazy ... it's falling over every few seconds. Automatic
restarts are nice, but it really makes the web site unusable.
mysqld got signal 11;
The manual section
Hi José
Could you give us some more information ?
Something like gcc -I/usr.
Generally you didn't point the compiler which library to use or where is it
or simply did it in wrong order.
I think so but I'm not 100% sure of it because I'm a novice too ;-)
Regards
Karol Majewski
query / sql
Is that a Red Hat gcc? There was a famous version they put out with 7.0
that's broken for a lot of things - but I don't recall the gcc version
number.
I've compiled MySQL just fine with gcc version 2.95.2 on Debian (aside from
MySQL needing some help finding zlib). If you go to gnu.org and
Ver 8.0, Distrib 3.22.32.
I have two fields in a table that are TIMESTAMP fields. I'd like to show
the amount of elapsed time between the two timestamps in a human readable
format. For example, I'd like to print 'Elapsed time: 1 year 4 months 27
days 9 hours 13 minutes 42 seconds. ' Or
Ver 8.0, Distrib 3.22.32
I have a customer file, keyed by an auto-increment customer
number. Customers can have orders. The order file is keyed by an
auto-increment order sequence number, which works fine, but is not
convenient. Rather, I would like the order sequence number to start at 1
Can someone please help with this database problem.
- Original Message -
From: [EMAIL PROTECTED]
To: Iceberg Media [EMAIL PROTECTED]
Sent: Monday, June 11, 2001 8:56 PM
Subject: Re: Please Help
Your message cannot be posted because it appears to be either spam or
simply off topic to
Okay, password was not recognized because I had the tunnel working with the
f.q. server name rather than localhost (whereas the mysql client on the
slave will _only_ work with the tunnel if it is by the fq server name, since
localhost just goes to the local machine regardless of socket).
But
There are settings that could probably fix the problem then but I would need
to RTFM.
- Original Message -
From: Aldo Spano [EMAIL PROTECTED]
To: Rolf Hopkins [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, June 12, 2001 0:03
Subject: Re: MYSQL error
Ok! thanks.
I tried and
SELECT max(fieldname) FROM table;
Hi!
Does anybody knows how can I check whether the max value in some
database's
field has
been reached?
For example, I have MEDIUMINT column and I want to reset its value once it
reaches its maximum, that is 8388607. How can I check which is the maximum
Will the update statement work under the mysql prompt?
- Original Message -
From: Vladimir Kravtsov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 12, 2001 8:39
Subject: Table won't update
The table sitesats won't update and shows no errors! (even though there are
two
I have a customer file, keyed by an auto-increment customer
number. Customers can have orders. The order file is keyed by an
auto-increment order sequence number, which works fine, but is not
convenient. Rather, I would like the order sequence number to start at 1
for each customer, and
Rich,
You can try TO_DAYS() first before finding the diff. of the two dates. Perhaps this
would give you a better solution.
Hasan
- Original Message -
From: Rich Duzenbury [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 12, 2001 5:22 AM
Subject: Elapsed time
Ver 8.0,
Trying to upgrade from 3.23.27 to 3.23.38 via rpm. The problem is then
Apache/PHP cannot connect to the database (using the mysql routines internal
to PHP), so I'm left having to --force --nodeps a downgrade to keep the
system up. Now, PHP can be compiled to use the current MySQL libraries, but
try download full windows odbc setup (not download only .dll). Then,
follow with Setup.exe.
Sommai Fongnamthip
At 07:39 11/6/2001 -0700, Bob Andrews wrote:
I recently downloaded the ODBC client software for windows, ran setup, then
went into the 'ODBC Data Source Administrator' from the
1 - 100 of 112 matches
Mail list logo
