On Wed, Jun 27, 2001 at 01:45:27PM +0100, Tim Bunce wrote:
>
> You'll find mysqldumpslow (in the mysql distribution) does all that and
> much much more
>
> It's a pity that it's not mentioned in the online documentation
> since it's a _very_ useful tool.
I've submitted a patch against the manual
Dear Chetan,
which version did you download (and from which site :)?
What OS are you running on? Can you give an exact
transscript of the command you used and the output it
generated? (Eventually parts of config.log might help
as well.)
(Checked the archive at www.mysql.com, but could not find
a
On Wed, Jul 11, 2001 at 12:54:58PM -0500, Vien Huynhle wrote:
>
> How did some of you load balance your mysql servers.
Replication is a common approach.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 <--
On Thu, Jul 19, 2001 at 04:21:05PM -0700, Mike Wexler wrote:
>
> We currently have a dedicate server for MySQL. The server is a dual
> pentium III (1Ghz) with 2GB of RAM in it. It also has 2 18GB 10,000
> RPM drives in it arranged in a Raid 1 configuration (mirror).
> Sometime in the next 3-6 mont
On Tue, Jul 17, 2001 at 09:37:19PM -0700, Ricardo Kleemann wrote:
>
> Hi everyone,
>
> I'm wondering how I should configure my.cnf if I have a master-slave
> scenario where I would like to declare the slave master if the
> master goes down.
>
> What I mean is, let's say I have 2 database server
On Wed, Jul 18, 2001 at 12:45:57PM +0200, Werner Stuerenburg wrote:
> What I am stumbling about is this:
>
> > PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND
> >> 22889 root 30 330 801M 11M cpu0 23.6H 26.75% mysqld
>
> Is this really true: size 801 M?
On Wed, Jul 18, 2001 at 12:09:23PM +0200, Stephan wrote:
> Hello all!
>
> How can this happen:
>
> - Table with 537 rows - value of column q02 is 10 in all rows
> - UPDATE table SET q02=q02+20 ;
>
> -> Query OK, 1074 rows affected (0.19 sec)
> Rows matched: 1074 Changed: 1074 War
Hello every/any-one,
hopefully someone can point me to a solution to this problem...
(As I'm not sure my subcription to the mysql list(s) is yet valid,
could you please respond to mail address "[EMAIL PROTECTED]".)
thank you.
Peter Gad
The problem: I'm trying to install/compile mysql 3.23.39
On Wed, Jul 18, 2001 at 11:14:51AM -0700, Ricardo Kleemann wrote:
> Thank you.
>
> But then how can mysql replication be used for high availability? If
> I always rely on 1 master only, what happens if the master goes
> down?
>
> I've tried two-way master-slave and I understand there are
> probl
On Wed, Jul 18, 2001 at 09:57:00AM -0800, Chris Lott wrote:
>
> Using the mysqhotcopy that came with the most recent MySQL (3.23.39)
> on a RedHat 7.1 box with perl 5.6.0, I am getting the following
> errors when trying to back up all databases:
>
> mysqlhotcopy --password="foo" --allowold --reg
hi,
i don't understand what does connecting from different host mean?
1. does it mean connecting from a different pc to the pc hosting the mysql
server through telnet?
2. connecting from the same pc hosting the mysql server and specifying the
host when connecting?
3. running
Hi,
I'm a beginner of MySql. I've just installed the lastest ver. MySql under RH7.1
Linux. When I tried to up the MySql server by running safe_mysqld, it fails and I've
got an error message logged as follows:
010718 18:10:05 mysqld started
010718 18:10:05 /usr/libexec/mysqld: Table '
Hello everyone,
I have two tables each with 12K records, I need to merge them into one single table
and also check for duplicates. I'm thinking in doing it with PHP and Mysql. My idea
involves one SELECT query and almost 12K insert query. Is there a faster way of doing
using only MySQL?
Thank
Van wrote:
>
> Michael Meltzer wrote:
> >
> > thought the list might want to know, this has been picked up by a trade
> > magazine, I got a copy of "interactive week" in sail mail today. (In my best
> I'd have never caught that but for the list. Thanks. Wonder what the audience
> for that si
Hi,
> > We currently have a dedicate server for MySQL. The server is a dual
> > pentium III (1Ghz) with 2GB of RAM in it. It also has 2 18GB 10,000
> > RPM drives in it arranged in a Raid 1 configuration (mirror).
> > Sometime in the next 3-6 months we will be maxing out its
> > capacity. (We wer
> should be an easy task to open a database and edit or create a new one
> should not need a server running for that. I do it all the time with Delphi
> maybe im not being clear
Well, delphi has access to the borland engine which is a server
in its own right. If you develop a delphi program which
Dear Sir/Madam,
I tried compiling the MySQL-3.23.39 on AIX 4.3.3.0 but failed. Attached
please find :
1.A script (mysql.sh) that I used to compile the software, following
the instructions given in your web page
http://www.mysql.com/doc/I/n/Installing_source.html
2.The error messages ob
I'm going to Spain today and cannot respond to any questions in the next
week. I was going to wait with this until I got home again, but what the
heck ;-)
Run the following script through your MySQL on an empty database with
mysql -uusername -ppassword dbname http://www.mysql.com/manual.php (t
[ database table sql ]
Van wrote:
>
> Michael Meltzer wrote:
> >
> > thought the list might want to know, this has been picked up by a trade
> > magazine, I got a copy of "interactive week" in sail mail today. (In my best
> I'd have never caught that but for the list. Thanks. Wonder what th
Pete Kuczynski writes:
> Hi,
> since Nusphere release the source code for gemini yesterday I believe it
> was, I was wondering if Mysql AB was going to incorporate it into a
> future release if it's database.
>
> I realise in light of recent .org events
>
>
> Pete
> --
> __
Wouldn't you do this in a loop? Where is the problem?
> I have two tables each with 12K records, I need to merge them into one single table
>and also check for duplicates. I'm thinking in doing it with PHP and Mysql. My idea
>involves one SELECT query and
> almost 12K insert query. Is there a f
Hello,
I have a problem, with %sub% - the compilation crash...
Can somebody help me, where is the problem?
gcc = 2.95.3
./configure --prefix=/usr/local/mysql-3.23.39c --enable-assembler --with-mys
qld-ldflags=-all-static
make
compiling is running to section makeing regex, and here compiling
See section: "7.21.1 INSERT ... SELECT Syntax"
Regards,
Johan Nilsson
Software Developer
BeCon Mobile Internet AB, Sweden
Web: http://www.beconmobile.com
E-Mail: [EMAIL PROTECTED]
Office: +46 457 44184
Cellular: +46 709 798897
> -Ursprungligt meddelande-
> Fran: Martin Cabrera Diaubalick
I would be grateful if someone could tell me how to replace a single
value in a table.
What i want to do is something like
REPLACE contacts (access) VALUE ('P') WHERE id=x
but this doesn't seem to work. (and i can't use REPLACE SELECT becasue
this would require selecting on same table as repla
You are correct ... you are not clear.
You cannot 'open a database' ... any database ... without some sort server.
Delphi has a built-in server of sorts. MySQL can be run standalone so it
only serves the local machine. The point is, something, somewhere has to
serve the database. It can be any
Thanks for your bug report.
I am sure Sergei will have the answer before you come back from Spain ...
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/
Hello all,
I have this two tables : table1,table2 . I would like to include all emails from
table2 into table1 removing duplicates.
INSERT INTO table1 (email) SELECT email from table2 where table1.email <>
table2.email;
MYSQL says: ERROR 1109: Unknown table 'table1' in where clause
Both ta
Can I use mysql with magic 8 (www.magic-sw.com) ?
Does anyone make it work ?
[]´s
Pessin
Brazil
Linux Registered User 154424
"Um passo a frente e já não estamos mais no mesmo lugar." (Che Guevara)
-
Before posting, please che
Hi!
Ok, confirmed (finally :-) )
My fault was that I was using our latest developmnet tree.
When I've tried this on 3.23.39 as went public, the bug appeared.
So, looks like the bug was fixed even before it was found :-)
Probably, it is somehow related to over bug I've fixed
since 3.23.39 relea
BTW: As I've stated earlier, the error goes away, if you either remove the
FULLTEXT index or let the affected fields accept NULL values.
- Carsten
- Original Message -
From: "Carsten Gehling" <[EMAIL PROTECTED]>
To: "Sergei Golubchik" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Fri
On Thu, Jul 19, 2001 at 09:17:31AM -0400, Bob Hall wrote:
>
> I think I've made it clear that I'm not enamored of NuSphere's
> recent actions, which I think are remarkably bone-headed. At
I'm afraid the emotions aroused by recent events have stripped
away my thin veneer of reasonable civility
Hi,
I've just tested with MySQL 4.0, no error, but strange result :
mysql> insert into visitkort (kategori_id) values (108);
Query OK, 1 row affected (0.00 sec)
mysql> update visitkort set navn = 'test5' where id = last_insert_id();
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed:
Which dev. tree is that? 3.23 or 4.0?
- Carsten (who hasn't left yet ;-)
- Original Message -
From: "Sergei Golubchik" <[EMAIL PROTECTED]>
To: "Carsten Gehling" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 1:22 PM
Subject: Re: Bug report: FULLTEXT index corrup
Hi!
3.23 (but 4.0 hasn't that bug either).
Will be 2.23.40 soon.
And have nice trip, btw.
On Jul 20, Carsten Gehling wrote:
> Which dev. tree is that? 3.23 or 4.0?
>
> - Carsten (who hasn't left yet ;-)
>
> - Original Message -
> From: "Sergei Golubchik" <[EMAIL PROTECTED]>
> Subject
Hi.
On Thu, Jul 19, 2001 at 07:24:17PM +0100, [EMAIL PROTECTED] wrote:
>
> I have been searching through the manual and the list archives for the last
> few days regarding a problem I have with the SET column type.
>
[...]
> For example
>
> UPDATE users SET user_flags = CONCAT(user_flags,'pass
INSERT INTO table1 (email)
SELECT email FROM table1, table2 WHERE table1.email <> table2.email;
the select is a "new" query, you have to join table1 and table2...
Regards,
Johan Nilsson
Software Developer
BeCon Mobile Internet AB, Sweden
Web: http://www.beconmobile.com
E-Mail: [EMAIL PROTECTED]
This is the feedback from repair:
mysql> repair table hits
-> ;
+--++--+
-+
| Table| Op | Msg_type | Msg_text
|
+--++--+
-+
| counter.hit
I've installed mysql and PHP4 according to instructions at mysql.com, but
I'm getting the following error when I try to start httpd:
Cannot load /etc/httpd/modules/libphp4.so into server:
libmysqlclient.so.10: cannot open shared object file: No such file or
directory [FAILED]
So, it's locatin
Hi all
When I start mysqld using /etc/rc.d/init.d/mysqld start it starts ok alhtough when I
say mysqld status I get the following error :
mysqld dead substatus locked
i cannot connect to the server at all
please help
thanks
Barry
You can use Windows explorer to create new database (Not tables).
Just create new subfolder of mysql\data on your system.
-Original Message-
From: Donald Dahlman [mailto:[EMAIL PROTECTED]]
Sent: petak, 20. jul 2001 22:03
To: [EMAIL PROTECTED]
Subject: mysql manager
does anyone have
Hi
Where can we get V4.0?
Thanks Simon
-Original Message-
From: Fournier Jocelyn [Presence-PC] [mailto:[EMAIL PROTECTED]]
Sent: 20 July 2001 12:30
To: Carsten Gehling; Sergei Golubchik
Cc: [EMAIL PROTECTED]
Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
TEXT fie
I added comments and a recipe to my debug function collection.
You can download at the address
http://pferdezeitung.de/php3/toosDebug.zip
> Well, I don't know about David, but I'd be very interested in your
> stopwatch program
table, sql
--
Herzlich
Werner Stuerenburg
Take a look at :
http://www.mysql.com/doc/I/n/Installing_source_tree.html
- Original Message -
From: "Simon Green" <[EMAIL PROTECTED]>
To: "'Fournier Jocelyn [Presence-PC]'" <[EMAIL PROTECTED]>; "Carsten
Gehling" <[EMAIL PROTECTED]>; "Sergei Golubchik" <[EMAIL PROTECTED]>
Cc: <[EMAIL PR
Jeremy Zawodny wrote:
>
> On Thu, Jul 19, 2001 at 04:21:05PM -0700, Mike Wexler wrote:
> >
> > We currently have a dedicate server for MySQL. The server is a dual
> > pentium III (1Ghz) with 2GB of RAM in it. It also has 2 18GB 10,000
> > RPM drives in it arranged in a Raid 1 configuration (mir
> i don't understand what does connecting from different host mean?
Where do you have this problem?
> 1. does it mean connecting from a different pc to the pc hosting the mysql
> server through telnet?
Why would you like to do that? looks like a masochistic
approach to me, under no
Sorry, I didn't use replace yet, I always work with update which
is what I want. Are you sure you want to use replace? See the
differences in the manual. The syntax for update is
UPDATE table_name
SET col1 = '$val1',
col2 = '$val2',
col3 = '$val3'
WHERE p
Basil Hussain wrote:
>
> Hi,
>
> > > We currently have a dedicate server for MySQL. The server is a dual
> > > pentium III (1Ghz) with 2GB of RAM in it. It also has 2 18GB 10,000
> > > RPM drives in it arranged in a Raid 1 configuration (mirror).
> > > Sometime in the next 3-6 months we will b
The web site is a off shot of the magazine, Ziff-Davis publishes most of the
"tech" magazines on the new racks. They Been doing it for a long time. The
class that this one is in I will call the "Movers and Shakers".
"Interactive week" they claim is a 200$ a year subscription, but I doubt
anyone ev
The Best:
By Dave Carter
SELECT * FROM tbl_experience
WHERE knowledge like '%SQL%'
ORDER BY least_expense
GROUP BY by no_equal;
Result: MySQL
Ok so it's a little hokey, but it was the best I could after the conversion
project I just got out of, thank god for MySQL.
Dave Carter
Chief Web Archi
> It's normal that the mysqld is 795M big? If is not normal which could be the
> cause of this size?
Certainly not. But Jeremy gave some comments; I don't know
anything about this, I wonder myself. My processes are between
8 and 25 MB.
> PID USERNAME THR PRI NICE SIZE RES STATE TIMEC
>
>
> Yes, you should definitely look at option #9 first. Here's a few pointers to
> some things that immediately spring off the screen at me:
>
> | Open_tables | 1296 |
> | Open_files | 2180712|
> | Open_streams | 0 |
> | Opened_tables
--
>Description:
I get errors when I try to compile the distribution. The first one happens
in the gemini tree and is caused by a prototype mismatch between the bzero()
defined in and the one defined in the mysql source. Apparently,
the one on my system takes a vo
Hi,
> Thank you very much for the detailed analysis! One question:
> where did he get all this data from?
You can show all of MySQL's status and configuration parameters by issuing
these statements:
SHOW STATUS;
SHOW VARIABLES;
Also, the following can come in handy if you want to see info abo
I experience something similar for a long time and try to find
out what's happening. I cannot see any rule, so far. Any ideas
what I could do to find out?
For some days now, I didn't have problems now except for a
duplicate entry error which shouldn't occur at all. Before, this
indicated a corrup
Michael Taney <[EMAIL PROTECTED]> writes:
> I've installed mysql and PHP4 according to instructions at mysql.com,
> but I'm getting the following error when I try to start httpd:
>
> Cannot load /etc/httpd/modules/libphp4.so into server:
> libmysqlclient.so.10: cannot open shared object file: No
Absolutely great! You are so keen and brave - I wouldn't dare to
and some others obviously neither!
We need people who calm things down to make negotiations and an
agreement possible, that's absolutely true, but we also need
people to emphasize the frontiers to make a correct agreement
possible i
Hi boys,
I have a problem when I make mysql++-1.7.9 API with gcc 3.0.
Can somebody help me, where is the problem ?
Is mysql++-1.7.9 compatible with the last ANSI/ISO C++ rules ?
Matteo Limonta
-
Before posting, please check
hello,
I'm running mysql 3.23.39. Could anybody explain me how to do this in mysql
(without sub-selects):
delete from IP where id in ( select id from USERS where MK='0032' )
Thanks.
.:: Andrius Armonas ::.
.:: [EMAIL PROTECTED] ::.
.:: http://baubas.andrius.org ::.
--
If you are running Linux, man ldconfig.
add the path to /etc/ld.so.conf
and run ldconfig.
Michael Taney wrote:
> I've installed mysql and PHP4 according to instructions at mysql.com,
> but I'm getting the following error when I try to start httpd:
>
> Cannot load /etc/httpd/modules/libphp4.so
My website, which included a Microsoft Access database, was on a server that
went bye-bye. I signed up with a new host that doesn't support MS
Access...and they suggested that I contact you to convert my database to
Mysql.
What do I do next?
Please respond ASAP!
Don Moor
[EMAIL PROTECTED]
http
Hi,
> Strange. My understanding was that RAID 5 was good for read bandwidth
> but that keeping the parity disk uptodate slowed it down for write
> bandwidth.
Well, what you say is almost true to a certain extent. Firstly, with RAID 5
parity is striped across the disks too, so there is no bottlen
I don't investigate the error -- why don't you put a unique index
on email? That's how you get what you want.
> I have this two tables : table1,table2 . I would like to include all emails from
>table2 into table1 removing duplicates.
> INSERT INTO table1 (email) SELECT email from table2 wher
Under solaris 8 you can use
pmap -x 22889
which will give address space map.
-Igor
On Fri, 20 Jul 2001, Jeremy Zawodny wrote:
> On Wed, Jul 18, 2001 at 12:45:57PM +0200, Werner Stuerenburg wrote:
> > What I am stumbling about is this:
> >
> > > PID USERNAME THR PRI NICE SIZE RES STATE
Thanks to Steve and Jeff for your replies.
A spreadsheet is how I've handled this for several years now.
Responses came in via a Scantron card reader (or manually) and the
resulting text file was fed into an Excel spreadsheet for graphic
output. I was in mind of the spreadsheet when devising
I am a newbie to linux and mysql and would like some advice re
installing mysql source code on corel linux.
I have successfully installed a binary version of Mysql (now
deleted) but need to compile and install a source version, as I want
to next install PHP.which I understand needs the source
Hi everybody,
I use Replication on a windows NT4 Server.
There are 1 master and 2 slaves, all on the same machine.
One slave is started with the option skip-name-resolve, not the other.
For the 2 slaves : master-host=localhost
When adding a user (MYSQL.User), the replication is OK but,
when
Quick question about the SHOW TABLE STATUS command and the Data_free info in
particular.
You say: "If it is high, then it's time to run OPTIMIZE TABLE..."
What is considered high? As I'm looking at my output, I see that most of my
tables show a value of 0, however, some have a value around 300 a
hi.
ok, first actual question to the list, hope someone can help:
the following query -
select
pn.number,
c.ID,
c.cost,
c.days_valid,
c.description
from
pinnumbers pn,
Hello there.
When I install Mysql-3.23.39 at my OpenBSD 2.9 server, it works perfectly..
until i restart the server.. does anyone have had the same problems as I ?
plz write back.. I just get this command, when i try to start the mysqld
server. with safe_mysqld
# safe_mysqld
/usr/libexec/ld.so:
"Andrius Armonas" <[EMAIL PROTECTED]> wrote:
> I'm running mysql 3.23.39. Could anybody explain me how to do this in
mysql
> (without sub-selects):
>
> delete from IP where id in ( select id from USERS where MK='0032' )
One solution is to build a list of id values from the users table in your
app
MySQL AB and NuSphere had a meeting over the phone, we exchanged
information and opinions and NuSphere will propose times for the
next meeting.
Britt...
--
D. Britton Johnston 603-578-6707 Nashua
Chief Technology Officer 781-280-4954 Bedford
NuSphere Corporation 781-280-4600 Main
14
On Fri, Jul 20, 2001 at 06:20:00AM -0700, Mike Wexler wrote:
>
> I already increased table_cache from 128 to 2048. Which helped. And
> last night I increase key_buffer from 16MB to 64MB. Maybe it should
> be even larger?
Oh, you can easily make it quite a bit higher. On my 1GB systems, I
have i
I have been trying for some months to use the C api with Borland
builder, so far with only limited success.
I can write a console application in the Builder environment, compile
it, but not link it. The error says the library routines are not found.
If I export the make file, edit it to includ
At 08:50 AM 7/20/01 -0600, you wrote:
>My website, which included a Microsoft Access database, was on a server that
>went bye-bye. I signed up with a new host that doesn't support MS
>Access...and they suggested that I contact you to convert my database to
>Mysql.
First off, download mysql from
At 12:30 PM 7/20/01 -0400, you wrote:
>on 7/20/01 12:32 PM, Erich Kolb at [EMAIL PROTECTED] wrote:
>
> > When you query a MySQL Database, how do you set the order alphabetically?
>
>
>If it's a text field just say DESC
>
>Susan
>
isn't that reverse alphabetical
ASC is (default) alphabetical
Joh
> What do I do next?
Check in to mysql.com, look for AccessToMySQL tools, fget a
distribution, set it up and convert your data.
--
Herzlich
Werner Stuerenburg
_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407
Hello.
[...]
> Here is the query
>
[query reformatted... btw, it would have been nice if you had done this at first]
SELECTbrand.brandname,
SUM((productorders.quantity)*(productorders.price)) AS turnover
FROM orders
LEFT JOIN productorders ON productorders.orderid =
Dear Don,
congrats for changing from Access to a real DBMS!
I am not informed how complex your tables are (relations etc.). As for
the data concerned, simply export the Access tables into CSV format.
MySQL can import CSV very easily. Try PhpMyAdmin, a browser based PHP
tool with a graphical inte
Hi everyone,
Is there a way to NOT select the last row that was inserted into a table? I
want everything before it.
I know how I could do this using 2+ queries, but can it be done by issuing
just 1 query?
Thanks everyone,
Tyler
---
On 20-Jul-2001 Nelson Goforth wrote:
> Thanks to Steve and Jeff for your replies.
>
>
> The new system will store the data in MySQL table(s) for retrieval
> not only of specific survey results, but (as I'm collecting industry
> type and demographic data as well) in more complex ways as well
Dear Frederic,
>localhost | jkasas | 1896f443280395b3
> And what I do and get :
>mysql> GRANT SELECT ON MEMBERS.users TO jkasas@'localhost';
>ERROR 1133: Can't find any matching row in the user table
Try GRANT SELECT ON MEMBERS.users TO jkasas@localhost (w/out quotes)! :)
On Fri, Jul 20, 2001 at 06:44:29AM -0400, Jonathan Buhacoff wrote:
> --
> >Description:
> I get errors when I try to compile the distribution. The first one happens
> in the gemini tree and is caused by a prototype mismatch between the bzero()
> defined in and the
At 12:25 PM 7/20/01 -0500, Tyler Longren wrote:
>Hi everyone,
>
>Is there a way to NOT select the last row that was inserted into a table? I
>want everything before it.
>
>I know how I could do this using 2+ queries, but can it be done by issuing
>just 1 query?
>
>Thanks everyone,
>Tyler
Assumin
That should work just fine. :)
Thanks!
- Original Message -
From: "John Meyer" <[EMAIL PROTECTED]>
To: "Tyler Longren" <[EMAIL PROTECTED]>; "MySQL List"
<[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 3:21 PM
Subject: Re: not selecting last row
> At 12:25 PM 7/20/01 -0500, Tyler Longr
Hello guys...
I'm having problem with the auto_increment feature.
I have a table like this...
++-+--+-+++
| Field | Type| Null | Key | Default| Extra
|
++-+--+-+--
> I added comments and a recipe to my debug function collection.
> You can download at the address
> http://pferdezeitung.de/php3/toosDebug.zip
Sorry - in adding comments I inadvertently dropped several lines
in function debugMsg. So if you downloaded version 0.4, please
fetch version 0.
Well, it's a feature not a bug, and you are right too. auto_increment
remembers the last value and keeps increasing it, no matter how many
"holes" are created. So when use it, better to create a status column to
change flag as deleted other than real delete it.
"William N. Zanatta" wrote:
>
>
hi.
from the manual:
If you delete the row containing the maximum value for an AUTO_INCREMENT
column, the value will be reused with an ISAM, or BDB table but not with a
MyISAM or InnoDB table. If you delete all rows in the table with DELETE FROM
table_name (without a WHERE) in AUTOCOMMIT mode, t
I have a hit counter script that logs all its hits in one table, one row per
hit.
Currently, I have been counting the rows in PHP in order to get the value of
the last hit_id in the database like this:
$sql4 = "SELECT hits.hit_id from hits";
$result = mysql_query ($sql4, $connection)
or die("e
Hi Benjamin,
Thanks for reading my message an taking some time to give some help/sugggestion..
First you are right that I should have written the query in a readable form..
You gave some comments:
> SELECTbrand.brandname,
> SUM((productorders.quantity)*(productorders.price)) AS t
It is not a bug, it is a bug fix. The auto_increment is based on the last
number used. It is not supposed to decrement.
j- k-
On Friday 20 July 2001 11:53, William N. Zanatta wrote:
> Hello guys...
>
> I'm having problem with the auto_increment feature.
> I have a table like this...
In the last episode (Jul 20), Ravi Raman said:
> ok, first actual question to the list, hope someone can help:
> the following query -
>
> select pn.number, c.ID, c.cost, c.days_valid, c.description from
> pinnumbers pn, cardtype c where pn.cardtypeID = c.ID and pn.tmaster = 0
> order by c.ID, pn.
OK guys,
Thank you all...
That's it... the problem is that I'm using MyISAM at this time and the
other tables I have are of ISAM type.
Sorry and thank you again!
William N. Zanatta
Ravi Raman wrote:
>
> hi.
>
> from the manual:
>
> If you delete the row containing the maximum value for a
I'm sure I'm just missing something basic, but here goes...
I need to create a table, populated with data, from an existing table.
Easy enough:
"create table TEST select * from OLD_DATA"
Most cool. Now, let's say OLD_DATA has three columns: A, B, & C. I
want to create new table TEST, with a
I have two tables and both tables have a field name thats the same. I
need to display
both those field names back to the browser using PHP. I have used php to
display all
the other fields but I can't display these fields, because of the
identical name. I know you can us the Select statement with
> The problem is...if I delete the third entry (Edicao = 3), the next
> entry inserted should be 3, right?! Well it is not! It is 4.
Well, this may be debated. I suffered a lot from the behaviour
you want to have. I considered it bad design ...
An autoincrement field should not serve for counti
OK, I found some...
>From the manual at "MyISAM tables"...
"Internal handling of one AUTO_INCREMENT column. MyISAM will
automatically update this on INSERT/UPDATE. The AUTO_INCREMENT value can
be reset with myisamchk. This will make AUTO_INCREMENT columns faster
(at least 10 %) and old numbers w
On Fri, Jul 20, 2001 at 12:29:52PM -0400, Britt Johnston wrote:
> MySQL AB and NuSphere had a meeting over the phone, we exchanged
> information and opinions and NuSphere will propose times for the
> next meeting.
Since these issues are between two private companies, please take
your discussions
I have been trying to install MySQL on my Cobalt RAQ3 and I seem to have
lost my mysql.sock file. I get the following error message when I tray to
carryout any mysql activity.
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
Pls advise
Michael J
LAST_INSERT_ID is the value of the auto increment field in the table that was last
inserted into. You probably want:
$sql4 = "SELECT MAX(hits.hit_id) as max_hit_id
as pixels
from hits;";
--jfarr
-
Before posting, please chec
1 - 100 of 135 matches
Mail list logo
