table.
Dean Harding.
> -Original Message-
> From: Bryan Waters [mailto:[EMAIL PROTECTED]
> Sent: Sunday, 23 February 2003 1:33 pm
> To: [EMAIL PROTECTED]
> Subject: Re: Cumulative Balance Field
>
> That won't exactly work...first I insert the record...then I upd
MySQL guarantees that individual statements are atomic, so you can use
something like this:
UPDATE mytable SET balance = balance + 100
Of course, you'd have to provide the right WHERE clause...
Dean Harding.
> -Original Message-
> From: Bryan Waters [mailto:[EMAIL PROTEC
I just tried it myself and I get an empty set as expected.
What do you get when you do a 'select * from test'?
> -Original Message-
> From: Valdir Stiebe Junior [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 22 January 2003 5:48 am
> To: [EMAIL PROTECTED]
> Subject: Re: Hi and why
>
> > I
It's just that the number of rows in a table is stored directly in the
.MYD file (I believe) so a query like "select count(*) from table" will
just return that value, rather than counting all the rows. It's not
that the functions are "built-in", rather they're *optimized* - a
totally different thi
/web/users/xxx/mysql/database1 >
> /usr/local/mysql/lib/database1
>
> chown -R xxx.xxx /home/web/users/xxx/mysql/database1
>
> Wouldent mysql get permissions errors like that?
>
> /Steve
> - Original Message -
> > From: "Dean Harding" <[E
course, is that you have to limit it to one user per
database (but each user could have more than one database).
Dean Harding.
> -Original Message-
> From: Steven Adams [mailto:[EMAIL PROTECTED]]
> Sent: Monday, 9 December 2002 4:07 pm
> To: [EMAIL PROTECTED]
> Subject: Quot
t for it yourself, just
check out this page:
http://www.mysql.com/doc/en/Adding_character_set.html
Dean Harding.
> -Original Message-
> From: Alexander Barkov [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 26 November 2002 6:00 pm
> To: Shyamal Banerjee
> Cc: [EMAIL PROTECTED
full table
scan when it's going to be faster.
I guess I can see the point if the row is only *added* to the index if
it matches the WHERE clause. That'd speed up the index management as
well.
Dean Harding.
> -Original Message-
> From: Daniel Koch [mailto:[EMAIL PROTECTED]
> >In Oracle, because the ROWID is the actual physical address of the
row,
> >it provides O(1) access to a row, as opposed to O(log(n)) that an
index
> >provides. That's a pretty good benefit if you ask me.
> >
>
> I'd love to see the math on that proven; I'm running it through my
head
> now and
> >The thing with Oracle is that once a row is assigned a ROWID, it
never
> >changes. It doesn't matter if the row grows and has to move within
the
> >block (or if it has to move to another block, for that matter).
That's
> >why ROWIDs work in Oracle.
> >
>
> Neither does an auto_increment index
Hey,
The thing with Oracle is that once a row is assigned a ROWID, it never
changes. It doesn't matter if the row grows and has to move within the
block (or if it has to move to another block, for that matter). That's
why ROWIDs work in Oracle.
But apparently, that's not the case with MySQL (pe
lt in 4.x. The point of the
option is to stop people from doing silly things like "delete from
" without a WHERE clause.
Dean Harding
-Original Message-
From: Alan McDonald [mailto:alan@;meta.com.au]
Sent: Sunday, 10 November 2002 12:04 pm
To: 3mip1s4la-Emilio Pisanty
Cc: MySQ
Yeah, I've used Unicode with MySQL as well. All I was saying is that
you can't sort on Unicode fields. And I have a feeling they might not
be indexed correctly, either.
Dean Harding.
-Original Message-
From: toby gibbson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 8 October
According to the website, it'll be in version 4.1.
You can already use Unicode now, though, you just can't sort on it or
stuff like that...
Dean Harding.
-Original Message-
From: Schmid Manfred [mailto:[EMAIL PROTECTED]]
Sent: Monday, 7 October 2002 5:24 pm
To: [EMAIL
Hi,
According to InnoDB's page, the largest innodb database is currently a
bit over 1TB. This is in Mytrix's database (Mytrix provide site
tracking services for your website, see www.mytrix.com).
With a default page size of 16KB, you get a theoretical maximum database
size of about 60 TB. You
Hi,
Have you tried just putting greek characters directly in the page? That way you can
at least find out if the browser is at fault. Then try something like:
to rule out whether it's PHP. It's probably not MySQL if you can see them when just
using the command-line clien
Check out this article in MSDN:
http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml
/reference/charsets/charset4.asp
It describes how to set the character set for Internet Explorer. I'm
not sure of an equivalent for Netscape, but I assume there is one...
Dean Ha
he same thing anyway)
> 4.Is there any reason to fear, the blob data get corrupted while
inserting
> or selecting ?
> for eg. if I issue a statement like this from the command prompt
> select * from my_table ;
No, selecting (by definition) won't alter the data in the database.
Hey,
You can limit the size of the database by specifying a quota on the
directory created by MySQL for that database.
When you create a database, all MySQL does is create a directory under
the data directory for that database. You can then set a quota on that
directory using whatever tools you
If it's for a "linking table", you'd just have something like this:
CREATE TABLE linking_table (
first_id INTEGER,
second_id INTEGER,
PRIMARY KEY (first_id, second_id)
);
For an n-m relationship, that's the only way to do it.
Dean Harding.
P.S. The syntax
ingle field wich in turn is an
integer,
> how can i address to it's value?
Like this:
MYSQL_ROW row = mysql_fetch_row( result );
int value = atoi( row[0] );
Dean Harding
-
Before posting, please check:
http://www.m
That'll only work if the months are in the same year. Here's a more
general one:
SELECT PERIOD_DIFF( EXTRACT( YEAR_MONTH FROM date1 ),
EXTRACT( YEAR_MONTH FROM date2 ) );
Dean Harding.
-Original Message-
From: Dogaru Dragos [mailto:[EMAIL PROTECTED]]
Se
tually stored in the string).
My application uses Unicode for almost everything (though I don't need
to sort on any text fields so it's OK) and I've not had any problems...
Dean Harding.
-Original Message-
From: toby - [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 19 June 2
Unicode characters in the database. You
just can't sort on them, that's all :)
Dean Harding.
-Original Message-
From: Christian Nebenfuehr [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 29 May 2002 9:32 pm
To: [EMAIL PROTECTED]
Subject: Loading BLOB into a MySQL-DB
Hello Outthere!
Ma
24 matches
Mail list logo