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-type-info to see
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.
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.
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
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.
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
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
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
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
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
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
11 matches
Mail list logo
