Dear Sir,
I want to update one table. situation is like this. i have a table with 3
columns.
tablename - sample
Fields
no - integer
str1 - varchar(100)
str2 - varchar(100)
Now i want to update the table contents like str1 = str1 + str2 for all the
records.
I used the update statement like th
Why does anyone need lessons in how to lose $400 in 14 days? I can do it
easily.
Terence
- Original Message -
From: "Colin Faber" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 1:46 PM
Subject: Re: turn $2000.00 into $1600.00 in 14 d
Give this a try. I used table aliases out of habit.
SELECT table1.id FROM table1 A
LEFT JOIN table2 B ON A.UserName = B.username
AND B.Group != 'Dedicated'
WHERE B.username IS NULL
AND A.StopTime = 0;
- Scott
> Hi I was wondering if anyone could help m
[EMAIL PROTECTED] wrote:
> where i live this is illegal.
> i hope these jerks don't have my email address.
> can you do anything about this TEnon?
>
This is a problem everywhere. If you notice 90% of spam is useless even if
you're interested in the crap product being "marketed" to you; becau
>Hello,
>
>
>I have a table which consists of 5 columns.
>There are a large number of rows that have the same values for the
>first 4 columns and the last column is the only thing that differs.
Sir, this can be interpreted two different ways. Either
col1=col2=col3=col4, or row1.col1=row2.col1, r
>I have a GROUPing question on the following query:
>
>SELECT HOUR(closedtime) AS hour, COUNT(assignedto) AS count FROM db WHERE
>(closedtime >='2001-01-01' AND closedtime <= '2001-01-31 23:59:59') AND
>assignedto='person' GROUP BY hour;
>
>give something like this:
>
>+--++---
Hi--
I saw in the manual that there's some strangeness in how ORDER BY
works. What I'm seeing doesn't seem to match either the manual nor the
posted comments. I'm using 3.23.
I'm doing an "ORDER BY col_1 DESC,col_2". What I want is for the
output to be sorted on col_1 de
Hi Noah Romer,
I got the same problem as yours. I think some of the "words" or "variables"
can't be used in MySQL-3.23.32 as in the previous version of MySQL-3.22.xx. The only
think you have to do is to change the "variables" in 3.23.32. In your case, may be
who or when is not allowed to
Just take the .rpm off the end, and any additional platform information
like i386, etc. It would just be, for example, rpm -e MySQL-3.23.32-1
Sean
On Fri, 2 Feb 2001, Abby Jiang wrote:
> Hi,
>
> I installed MySQL on Red Hat 6.2. Now I am having
> trouble with uninstalling it. If I do rpm -era
Hi,
I installed MySQL on Red Hat 6.2. Now I am having
trouble with uninstalling it. If I do rpm -erase
MySQL-version.rpm, the message saying "no rpm package
is installed". If I do rpm -i MySQL-version.rpm, the
message says that the rpm package is already
installed. what should I do to uninstall
anyone know how to repair a corrupt user table? I edited the user.ISD file
and I can make changes via mysql but cannot do a select * from user;
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
Can anyone explain the following results to me?
I am trying to find all values +/- 30% from a number...
value is declared as: | value | int(10) unsigned
Note that 1.3*63000 is 81900...
The first two are apparently correct:
mysql> SELECT count(*) FROM bench WHERE year = 95 and
-> value >=
On Fri, 2 Feb 2001, Siim Einfeldt aka Itpunk wrote:
>
> I get an awful lot of spam to my private email as well, I could filter
> them, but does anyone know what is the best way to actually get to know
> where and from who the email has come from (as the from addresses lie
> 99% of the cases)?
>
>
Hello, I have one question about the 'load data' function.
Below is the what I have for 'actor.txt' for a text file I want to load to table
'actor'
| ID | fFirst | Last
---
Thank you, I learned that I needed:
Drop *table* tablename
Thanks for your help, guys. I appreciate it
Joel
- Original Message -
From: <[EMAIL PROTECTED]>
To: Joel Holtzman <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 3:51 PM
Subject: Re: Deleting table
Dear Benjamin.
I firstly very very thanks for your interest.
This is my 3'rd mail with same question and you 're the first one who
reply.
- Original Message -
From: Benjamin Pflugmann <[EMAIL PROTECTED]>
To: Yusuf Incekara <[EMAIL PROTECTED]>
Cc: Mysql Mailing list <[EMAIL PROTECTED]>
Sen
Philip Mak wrote:
> I'm suddenly getting "Got error 28 from table handler" from a MySQL script
> that used to work fine. On searching the MySQL list archives, I determined
> that means I'm out of disk space.
>
> Something's weird here though:
>
> root@trapezoid [~]# df
> Filesystem 1k-b
why don´t you try
use database
drop tablename
Mensaje citado por: Joel Holtzman <[EMAIL PROTECTED]>:
> Hello, via telnet with mysql server on linux, I try
> to delete a table, but it won\'t work. I\'m browsing
> the documentation, I can\'t see what will work. I can
> do this via asp, but I\'d
I'm having a little trouble running a program I made with mysql++1.7.8, when
I run the app it segment faults when the connect object is created.
this is what I am running
Red Hat Linux release 7.0 (Guinness)
Kernel 2.2.16-22 on an i586
Mysql 3.23.32
mysql++1.7.8
gcc 2.96.2
here is how I compile
Joel Holtzman wrote:
>
> Hello, via telnet with mysql server on linux, I try to delete a table, but it won't
>work. I'm browsing the documentation, I can't see what will work. I can do this via
>asp, but I'd love to know the command for something that should be as simple as
>
> mysql> Delete (
Hello, via telnet with mysql server on linux, I try to delete a table, but it won't
work. I'm browsing the documentation, I can't see what will work. I can do this via
asp, but I'd love to know the command for something that should be as simple as
mysql> Delete (tablename) from (Database name);
I'm suddenly getting "Got error 28 from table handler" from a MySQL script
that used to work fine. On searching the MySQL list archives, I determined
that means I'm out of disk space.
Something's weird here though:
root@trapezoid [~]# df
Filesystem 1k-blocks Used Available Use% Mo
What is host.frm and why can host.frm not be located where I want to
be?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
We are getting thse errors. Can anyone point me in the right direction?
DBI->connect(database=whois;host=www5) failed: Host 'www5' is blocked
because of many connection errors. Unblock with 'mysqladmin flush-hosts' at
/usr/lib/perl5/site_perl/5.005/PEC.pm line 731
Thanks,
CC
---
Ok, being careful to try and avoid any naughty words that might trigger the
bleeding spam filter.
The Tilghman wrote:
>
> 'when' is a reserved word in 3.23
Well, that would explain that. Arrrgghh! I even spent a couple of hours going
through the "upgrading from 3.22"/"major new features of 3.23
SELECT
t1.id
FROM
table1 t1,
table2 t2a,
table2 t2b
WHERE
t1.StopTime = 0 AND
(t2a.Group != 'Dedicated' AND t2a.UserName != t2b.Username) AND
t2a.UserName = t1.UserName
Not sure if you need those () though.
On 2 Feb 2001, Drew Wilder-Goodw
I didn't receive this e-mail back after I sent it...
- Original Message -
From: "Fábio Ottolini" <[EMAIL PROTECTED]>
To: "Paul DuBois" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: "Fowler, J.T." <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 7:20 PM
Subject: Re
Brazil: US$0,825/litre - That's really expensive!!!
BR,
Fábio Ottolini
- Original Message -
From: "Solomon Sokolovsky" <[EMAIL PROTECTED]>
To: "Marko Sarunac" <[EMAIL PROTECTED]>; "Redvers Davies"
<[EMAIL PROTECTED]>
Cc: "mySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, February
Hello, and thanks for your time.
Basically, I am using telnet to create tables/columns, and all is ok, except
I do not know the correct syntax for using blob text.
For example, if I create a table named 'members' with id/name/description
it would look like:
CREATE TABLE movieform (
I
I have a GROUPing question on the following query:
SELECT HOUR(closedtime) AS hour, COUNT(assignedto) AS count FROM db WHERE
(closedtime >='2001-01-01' AND closedtime <= '2001-01-31 23:59:59') AND
assignedto='person' GROUP BY hour;
give something like this:
+--++---+
| hour
>Description:
my error-log show me "Can't connect ... on '206709' (22)(107) retry in 3306 sec
And really, it is connecting 3306 seconds later. Obviously, this is the port-number
and the delay should be 60 seconds
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Or
On Fri, Feb 02, 2001 at 03:38:09PM -0500, Noah Romer wrote:
> mysql> insert into bugs_activity (bug_id,who,when,field,oldvalue,newvalue)
> values (334,18,20010131145149,'bug_status','NEW','RESOLVED');
> ERROR 1064: You have an error in your SQL syntax near
> 'when,field,oldvalue,newvalue) values
>
But,
I understand that some of these junkers/spammers are just trawling for addresses
that they only later learn are real when the recipient replies to the remove link.
>From that point, they're latched unless they change their e-mail addres.
I think it's reprehensible to be spamming people. The
So that looks like it does a select for all in table2 who DO have
dedicated and just excludes those matches... thats an interesting way of
doing it.. but that would still return a row for the other groups that
the username belongs to in table2 right? so for instance if there is 2
entries in table
> "NR" == Noah Romer <[EMAIL PROTECTED]> writes:
mysql> insert into bugs_activity (bug_id,who,when,field,oldvalue,newvalue)
NR> values (334,18,20010131145149,'bug_status','NEW','RESOLVED');
NR> ERROR 1064: You have an error in your SQL syntax near
NR> 'when,field,oldvalue,newvalue) values
NR>
Have you tried something like this?
SELECT * FROM table_name where col1=col2 and col2=col3 and col3=col4 and
col4!=col5;
Greg Skouby wrote:
>
> Hello,
>
> I have a table which consists of 5 columns.
> There are a large number of rows that have the same values for the
> first 4 columns and the
'when' is a reserved word in 3.23
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From: Noah Romer [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 02, 2001 14:38
>
> In the process of moving a database to a new server
In the process of moving a database to a new server, I decided to upgrade to
the 3.23 series MySQL, as it had been declared "stable" and has some new
features I want to investigate. However, I've had to drop back to 3.22.22, as I
started getting an "invalid SQL syntax" error on certain insert comm
SELECT t1.id FROM table 1 t1
LEFT JOIN table2 t2 ON t1.UserName = t2.UserName
AND t2.Group = 'Dedicated'
AND t1.StopTime = 0
WHERE t2.id IS NULL;
--Greg Johnson
-Original Message-
From: Drew [mailto:[EMAIL PROTECTED]
Hi I was wondering if anyone could help me find the most efficient.. or
at least A efficient way to preform the following task:
I have a table that has some data, one of which is a UserName column. I
have another table that has multiple rows for that UserName. So table
one looks like:
id
At 10:25 PM +0200 2/2/01, Siim Einfeldt aka Itpunk wrote:
>I get an awful lot of spam to my private email as well, I could filter
>them, but does anyone know what is the best way to actually get to know
>where and from who the email has come from (as the from addresses lie
>99% of the cases)?
I p
Hello,
I have a table which consists of 5 columns.
There are a large number of rows that have the same values for the
first 4 columns and the last column is the only thing that differs.
I would like to grab all the rows that have these identical
columns so I can store it into one rows with all
Platform Suse 7.0,
AMD 450 KIII+,
128MB Ram
Linux on 10 Gig system harddrive
with 45 Gig additional drive mounted as /dbshare.
I have created a symbolic link in /var/lib of mysql-> /dbshare.
then
RPM -Uhv --force MySQL*-3.23.32-1.i386.rpm to install the files
from
MySQL-3.23.32-1.i386.rpm
M
I get an awful lot of spam to my private email as well, I could filter
them, but does anyone know what is the best way to actually get to know
where and from who the email has come from (as the from addresses lie
99% of the cases)?
yeah, I know this is offtopic, but still!
Siim Einfeldt
> wh
Hello everyone.
I'm hoping the developer of MyODBC hangs out on this list, but here goes. I
browsed through the sources a bit, and I noticed several places where you
are mapping SQL_BIT type to TinyINT. It appears this is only a one way
mapping (software->odbc->mysql) and not the other way.
Wh
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Anybody knows where I can find a list with all SQL syntax -es. Eventually
explained.
Thanks
-
Before posting, please check:
http://www.mysql.com/man
mysqldump -hhost -uuser -ppw --opt --all-databases >all-dbs.sql
mysql -hnewhost -uuser -ppw http://www.mysql.com/documentation/mysql/bychapter/manual_Tools.html#m
ysqldump
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Original Message
- Original Message -
From: "René Tegel" <[EMAIL PROTECTED]>
To: "Jeff Harris" <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 9:09 PM
Subject: Re: system requirements?
> Jeff,
>
> yes the win32 version of mysql runs perfectly under nt.
>
> Some notes about mysql, php and nt:
> -php
At 2:54 PM -0500 2/2/01, Hardy Merrill wrote:
>Are incremental backups possible in MySQL? I haven't seen any
>reference to "incremental" in the mysqldump or anywhere else for
>that matter.
You can take a full dump, and then treat the contents of the update
logs from that point on as incremental
Hello,
I am trying to export several databases from one mysql server on one linux
box and import them all to another mysql server on another linux box. I just
completely forgot what the syntax is. Would someone be able to help me? Thanks!
Sincerely,
Tom Cruickshank
--
Are incremental backups possible in MySQL? I haven't seen any
reference to "incremental" in the mysqldump or anywhere else for
that matter.
TIA.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
--
can mysql be run on windows 2000 or nt 4.0
is there any issues mixing ms sql and mysql?
or running php files on iis4 or 5?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
Hi List,
Whem I will go start the MySQL in Linux, receive a error:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock`(111)
What I do?
Thanks
Edgard Arthur Michel
[EMAIL PROTECTED]
Brazil
Hi,
> Is it possible to put comments against a table and column that are persistent;
> so that when you run 'explain' or 'describe', these comments will display.
Tables in MySQL (version 3.23 at least - not sure about 3.22) do actually
have a comment 'field' built in. You specify your initial c
Hi folks,
I got a strange problem, we're running a webhosting company and during peekhours,
mysql really hits the cpu peek. I do believe there
is one or more clients that are running high loads of querys without actually closing
them, or perhaps even running querys that
dosn't timeout. Is there
will you all be doing anything for OS X?
At 8:01 AM + 2/2/01, John Dean wrote:
>Hi
>Hopefully, we plan to include Dezign for Databases in our new GUI
>client, but this is not yet embedded in stone.
>
>At 23:54 01/02/2001 -0500, Michael Lépine wrote:
>>I've tried searching the archives, but I
where i live this is illegal.
i hope these jerks don't have my email address.
can you do anything about this TEnon?
At 11:14 PM -0500 2/1/01, <[EMAIL PROTECTED]> wrote:
>New Concept in Gifting!
>Join A Team Of 6 And 7 Figure Earners
>
>The sole purpose of this Activity is to enable us to bless m
On Fri, Feb 02, 2001 at 05:48:41PM +0100, Marcello Giovagnoli wrote:
> >
> > Do you mean that mysql_store_result() should store everything to a
> > local file and and mysql_fetch... should read from this file?
> > This should not be that hard to do.
Like SQL_BUFFER_RESULT, but at the client inst
It works without the group by clause also.
As in:
select max(debt) from users;
Roger Ramirez wrote:
>
> http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Gro
> up_by_functions
>
> max(x) works with the group by clause.
>
> > -Original Message-
> > From: Roman Are
If you want to use a number with 10 digits and no decimal places, try using one
of the following:
intvalue range -2147683648 to 2147683647
int unsigned value range 0 to 4294967295
bigint value range -9223372036854775808 to 9223372036854775807
bigint unsignedva
At 6:41 AM -0800 2/2/01, Labs Racing wrote:
>First excuse me for my english,
>
> I should like of knowing if the mysql ago connection
> with the jsp, what if if he may do, drop of knowing
> where I could meet any tutorial, if exist.
> Thank you by attention.
> Sara.
If you are familiar with
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Gro
up_by_functions
max(x) works with the group by clause.
> -Original Message-
> From: Roman Arefiev [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 02, 2001 10:25 AM
> To: [EMAIL PROTECTED]
> Subject: Max valu
Hi,
I have two production machines with mysql running, and I'd like to
set up a third on which does backups with replication.
As far as I know, one mysqld can not replicate from two different master.
But I need DB1 from HOST1 and DB2 from HOST2 to be replicated, so I've
used mysqld_multi to star
I use ./safe_mysqld --datadir=/.../... to put the data onto another disk.
Manfred
Howard Miller schrieb:
> Hi,
>
> I have installed mysql on SuSE Linux from an rpm. It works but I
> want to move the data directory to a larger disk on my machine.
>
> How do I do it??
>
> If I create a symbolic l
Hi,
Is it possible to put comments against a table and column that are persistent; so that
when you run 'explain' or 'describe', these comments will display.
Rob
Hi, readers of the mailing list!
I promised to report to the mailing list how the interfacing of MySQL
and Innobase engine progresses. Innobase will provide transactions,
rollback, row level locking, and Oracle-style non-locking consistent read
to MySQL. It currently runs on Intel Linux and NT.
>
> Do you mean that mysql_store_result() should store everything to a
> local file and and mysql_fetch... should read from this file?
> This should not be that hard to do.
>
Yes, you can use the actual SQL_CURSOR_FORWARD_ONLY that is
unused at this moment, to call mysql_store_result_on_file()
I can run mysqld by the book on MacOS X but trying to shut it down with "mysqladmin -u
root -p shutdown" timeout after a long time, leave the daemon running... What can I do
?
TIA
Greg
-
Before posting, please check:
http:/
> "RH" == Rolf Hopkins <[EMAIL PROTECTED]> writes:
RH> That also depends on your definition of *PRODUCTION* status. If you are
RH> going to make a profit using MySQL then you need to purchase a license.
Not any more; MySQL is GPL in the current version.
--
Hello, I'm a newbie in MySql, it would be great if you can help me ..
the problem is :
I have a Mysql table like:
create table users (user varchar(20), debt int(10));
How can I select user with the greatest value of debt ?
I have this function (max) in MS Access database and it works perfectly.
Platform Suse 7.0,
AMD 450 KIII+,
128MB Ram
Linux on 10 Gig system harddrive
with 45 Gig additional drive mounted as /dbshare.
MySQL needs to keep its database files in dbshare but I have not been
able to make it work.
>From what I have read in this maillist it would appear that some
combination
I'm currently evaluation mysql, on a MacOS X machine. It compiles OK, but the test
requires DBD, which I wasn't able to compile:
- while running "perl Makefile.PL" I get:
Note (probably harmless): No library found for -lm
Note (probably harmless): No library found for -lz
I'm evaluation mysql for a product which need both a local database and a remote
database access. The product will be shipped on CD, running a windoze machine which
could or not have TCP/IP installed.
- will mysqld run from a locked media (both the binary and the database)?
- is it possible to m
I'm fairly new to MySQL, and I've read some documentation that
says that "skip-locking" is the default on Linux. I'm trying
to set up a table maintenance/backup strategy, and I'd like
to use "myisamchk" and "mysqldump".
1. Can I run myisamchk *without* shutting mysql down? I don't
want t
>Description:
The mysql initialisation fails on coda filesystems.
Apparently CREATE TABLE creates just the *.frm files,
but silently won't create the *.ISM and *ISD,
resulting in a subsequent message
"ERROR: 1033 Incorrect information in file: './mysql/db.frm'"
>How-To-Repeat:
The
First excuse me for my english,
I should like of knowing if the mysql ago connection
with the jsp, what if if he may do, drop of knowing
where I could meet any tutorial, if exist.
Thank you by attention.
Sara.
__
Get personalized email ad
Hi,
I have installed mysql on SuSE Linux from an rpm. It works but I
want to move the data directory to a larger disk on my machine.
How do I do it??
If I create a symbolic link to the /var/lib/mysql directory, the
mysql.sock (don't really understand what this file does) file
vanishes and I
HI! I'm new on the mailing list and I would to know how install mysql on
Linux. Moreover, if someone could explain me how to recognize this
package by php4, I would be the most happy boy in the world. Excuse my
english but I'm french and I'm 19 years old.
Hello,
I have a bunch of tables running on 3.22.32 and they work fine. When I
tried creating these tables on 3.23.32 I get the following message for given
fields.
"Incorrect column specifier for column 'ACCOUNT_ID'" (or whatever the
column id is.)
Here is a the table syntax: The error occurs o
[EMAIL PROTECTED] writes:
> >Description:
> When I make a "SELECT count(*) AS Anzahl, ELT(FIELD(kundentyp, ... ), ... ) as
>Kundentyp,kategorie FROM table WHERE ... GROUP BY kundentyp,kategorie ORDER BY
>kategorie" the Server response with:
>
> mysql> SELECT count(*) AS Anzahl,
>ELT(FI
>Description:
When I make a "SELECT count(*) AS Anzahl, ELT(FIELD(kundentyp, ... ), ... ) as
Kundentyp,kategorie FROM table WHERE ... GROUP BY kundentyp,kategorie ORDER BY
kategorie" the Server response with:
mysql> SELECT count(*) AS Anzahl,
ELT(FIELD(kundentyp,'PP','PPA','PG','PGA','FK','FK
David Brown writes:
> I have a quick lookup table of about 500,000 records.
>
> The table consists of just 3 fields medium int fields, and indexed on just
> one of them - So the records are small, as is the index.
>
> The data won't have any inserts/updates throughout the day, and will be
John,
To avoid the issues you mentioned, each table requires an AUTO_INCREMENT
column and a TIMESTAMP(14) column.
We have been coding with VC++ and using various third party ODBC clients,
including MS Access, pretty much since the inception of MyODBC. When using
the Jet Database Engine (MS Acce
Progetto 2000 writes:
> Hi,
> I'm trying to install MySQL Client (rpm -i MySQL-client-3.23.29-1.i386.rpm).
> The MySQL is just installed because if I run the commands:
> mysql_install_db
> safe_mysqld &
>
> The daemon runs.
>
> But if I insert a normal command like: "mysqladmin version"
[EMAIL PROTECTED] writes:
> Hello,
> I've run into some difficulty compiling mysqlgui-1.7.4 on RedHat 6.2.
> I am using gcc 2.95.2, which I have recently compiled installed to /opt/gcc.
>
> After running make, I receive the following error:
>
> g++ -o mysqlgui about.o db_tree.o Fl_NSlider
Hi
I'm doing a simple query using the function STD but I'm getting zeros as
answer. I know that zero is a perfectly good answer for standart
deviation but in this case I should get some positive values :-)
Is there something wrong with this function ?
My sql string is the folowing and I'm using
Hi,
> Monty mentioned that they're looking at making virtually all of the
> run-time variables changeable WITHOUT a server restart. Once that
> happens, it's just a matter of programming and benchmarking to have a
> self-tuning system (to some degree).
I hadn't really thought about the concept i
_ip,count(src_i
p) as val,count(distinct dst_ip) as tot from ipchains where time>='20010202
438 system localhost mysql Query 396 Opening tables SELECT User,
Select_priv FRO
M user where User = 'dbmaster&#x
Hi again,
I solved the weird thing but the original myODBC error is still there. How
do I know what values are suitable for my application. I'm using MediumBlob
to store my data so at any one time, the max amount of data to insert would
be 16M. So am I supposed to set max_allowed_packet to 16M, a
I have a quick lookup table of about 500,000 records.
The table consists of just 3 fields medium int fields, and indexed on just
one of them - So the records are small, as is the index.
The data won't have any inserts/updates throughout the day, and will be
built once a day. It's not a problem i
On Fri, Feb 02, 2001 at 10:18:42AM +0100, Manfred Meier wrote:
>
> My problem is, that I have a delphi program, that has this state
> "reading from net" long after the query has been completed and the
> result is on the screen. The program works very slow and i hoped
> that this state information
"Jeremy D. Zawodny" schrieb:
> They both do, really. The server reads the request and the client
> reads the response.
>
> In this case, though, you are looking at the status of various
> connections from the server's point of view, right?
>
> Jeremy
Yes, thank you very much. You are right, I'
Hi All,
I have one doubt.
What is the maximum no of records that can be added to the
table,in mysql database?(i.e)Maximun number of rows.
If any one knows the answer please send me to the following mail-id
amar
-
Hi,
Thanks Miguel, I'll look through the manual.
Another weird thing came up while I was testing the following code. The
cbData in the following line of code always turns up as 8164. Previously,
the cbData will indicate the size of the data to be retrieved.
-
On Fri, Feb 02, 2001 at 09:11:39AM +0100, Manfred Meier wrote:
> Who reads from the network? The client or the server?
They both do, really. The server reads the request and the client
reads the response.
In this case, though, you are looking at the status of various
connections from the server
At 08:37 02/02/2001 +0100, Lars-Olof Albertson wrote:
Hi,
Maybe you had an ancient distribution stuff. The best thing to
make is the download of the last version at:
http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.32-win.zip
Remove the MySQL installation using the Control Panel Add/Remove
Very "erstaunlich"! I really didn't thought that!
I think we all could live without(!) such answers.
Who reads from the network? The client or the server? And if the client, why does it
read from the net after the SQL-Statement is already completed? Is there anybody who
has an answer with more in
98 matches
Mail list logo
