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
sarcastic voice)As they say in Hollywood Any Publicity is good as long as
your spell the names right. Found a web version
[This is an email copy of a Usenet post to mailing.database.mysql]
In article 9j81uc$2bie$[EMAIL PROTECTED], Steve Werby
[EMAIL PROTECTED] wrote:
Nelson Goforth [EMAIL PROTECTED] wrote:
My client conducts a number of surveys or questionnaires for THEIR
Seems like the simple way would be to
At 17:51 19.07.2001 +0200, you wrote:
okay, i see this output on my sco-machine:
'2001071614' '2001-07-19 14:00:00'
if i try the same with mysql-front on my win2k machine:
'2001071914' '2001-07-19 14:00:00'
Somehow your sample data doesn't look right: shouldn't it be
'2001071614'
Hi,
i've installed mysql on a win2000 os and downloaded myodbc zip file and went
through the process of setting it up. it says sucessful installation but the
environment tab of my mysqladmin says that myodbc is not found. what do i
need to do?
thks
shane
Here is the one...it looks lists.mysql.com is filtering the attachments.
--
import java.sql.*;
public class TestMySQL
{
public static void main(String[] Args)
{
try {
// The newInstance() call is a work around for some
// broken Java implementations
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 to
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
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 months
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 servers:
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 How
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 Warnings: 0
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
problems.
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.
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?
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 site is.
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 were maxed
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
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 scriptname
and the last command
[ 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 the audience
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
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
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
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
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
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
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: Friday, July
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: 1
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 corrupts the
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: Re: Bug
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 =
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.hits
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
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 PROTECTED]
Sent:
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 (mirror).
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
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
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 be maxing out
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 ever
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
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 TIMECPU
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 strings.h and the one defined in the mysql source. Apparently,
the one on my system
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
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
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 such
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
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
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]
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
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 where
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 TIME
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
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,
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
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
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
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
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 it
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
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
John Meyer
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 =
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.
snip
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 strings.h and
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
Assuming you had
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 Longren wrote:
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
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,
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
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
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,
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 an
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 all
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
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 will
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
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
Read the manual again on last_insert_id(). That function only gives you the
unique id of the last insert *for that thread* If you connect, don't do any
inserts, and select last_insert_id, there is no guarentee what you will get.
If you are trying to find the number of rows, it would be much
1 - 100 of 130 matches
Mail list logo