Pam Astor schrieb:
Hi,
I have about a half dozen small databases associated with a
couple of small shopping carts, discussion forums, etc. All six databases have
usernames and
passwords associated with them, and all the databases are connected to the php
based forums and shopping carts, no pro
Hello,
My mysql table has been created for long time, it increases day by day,
and become huge.
Right now a full scan to the table for the first time is very slow.
So I was thinking to optimize it.
This table is stored in many non-sequential disk fragments I think.
I want to make this table to be
See Thread at: http://www.techienuggets.com/Detail?tx=32975 Posted on behalf of
a User
select userId, picture, MAX(datePosted) from A order by datePosted;
In Response To:
Hello everyone,
I have a table A:
userId long
picture MeduimBlob
datePosted DateTime
A userId can have many pictures
See Thread at: http://www.techienuggets.com/Detail?tx=32975 Posted on behalf of
a User
Hello everyone,
I have a table A:
userId long
picture MeduimBlob
datePosted DateTime
A userId can have many pictures posted. I want to write a query that returns a
distinct userId along with the most recent
Complementing the post above:
I have found that SUM(DISTINCT xxx) is valid with v.5x, not so in v.4x.
While I am trying to convince my ISP to switch the database to a v.5x
server, I would like some help with a workaround - please excuse my
newbness. I have tried :
(select sum(#variables.tablepre
Complementing the post above:
I have found that SUM(DISTINCT xxx) is valid with v.5x, not so in v.4x.
While I am trying to convince my ISP to switch the database to a v.5x
server, I would like some help with a workaround - please excuse my
newbness. I have tried :
(select sum(#variables.tablepre
hi all,
after a little 'research' and consultation with friends, i come up with
these tables for my database project.
table Item(ItemID,warehouse,ShapeID,weight,category,description)
table Shape(ShapeID,physical shape)
table Dimension(DimensionID,dimension)
table ShapeDimension(ShapeDimensionI
At 12:49 PM -0400 4/17/08, Pam Astor wrote:
Hi,
Is there a way to view mysql user passwords once logged in as the
MySQL root user in v 5.0.22? Or are they encrypted even from the
MySQL toot user?
It's one-way encryption. You cannot see them.
http://dev.mysql.com/doc/refman/5.0/en/encryptio
Hi,
I have about a half dozen small databases associated with a
couple of small shopping carts, discussion forums, etc. All six databases have
usernames and
passwords associated with them, and all the databases are connected to the php
based forums and shopping carts, no problems wi
Hi,
Is there a way to view mysql user passwords once logged in as the MySQL root
user in v 5.0.22? Or are they encrypted even from the MySQL toot user?
_
More immediate than e-mail? Get instant access with Windows Live Messenger.
Greetings,
Microolap Technologies is happy to announce that the version 2.6.2 of
MicroOLAP DAC for MySQL is available.
This release brings several optimizations and bugfixes.
TmySQLUpdateSQL component supports BLOB parameters now, so it can be
used with Image, Memo and RichText DB controls.
>>>
Hello Jim,
> > > sounds like you are using the wrong value for the length of a utf8
> > > field, where the number of characters is being divided by the max
> > > character length. (10 / 3 = 3, 80 / 3 = 26)
> > >
> > > or it could be the server returning the wrong length. use "mysql
> > > --column-
12 matches
Mail list logo
