Re: MySQL 5.0.51a and SHOW ENGINES
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 what it is returning. That doesn't work with 5.0 as far as I can tell. sorry, i think --column-type-info is new in 5.1. you can get the same effect using -T with 5.0, i believe. Thanks for the suggestion but the issue has been fixed for me. I reported it to the vendor that created the Delphi component-set to use MySQL and they supplied me with a fix. Apparently, something has changed between 5.0.45 and 5.0.51 that made their code fail, but it's all good now. Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[ANN]: MicroOLAP DAC for MySQL 2.6.2 released
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. Full changelog: http://microolap.com/products/connectivity/mysqldac/news/ Product page: http://microolap.com/products/connectivity/mysqldac/ Downloads: http://microolap.com/products/connectivity/mysqldac/download/ If you have any questions or require further assistance, please do not hesitate to create a support ticket at http://microolap.com/support/ Have a nice day, -- Mikhail Oleynik MicroOLAP Technologies [EMAIL PROTECTED] http://microolap.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
viewing passwords as root
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. http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_Refresh_instantaccess_042008
Can't get a login shell for some databases
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 with the php applications reading and writing data to them. I set the databases up a few weeks ago, the first one I set up, I can’t remember exactly how I set it up. Here is what I don’t understand. I’m able to login as root, and also the very first database I set up, I am able to log in to MySQL via shell using the username and password associated with that user. However for all the other databases, I am not able to log in to a MySQL shell using the other usernames associated with their databases – even though the php applications are configured to use the usernames, passwords and database names for those users which I can not log in to get a shell MySQL session. How is it that my php applications can log in to MySQL and I can’t get a terminal connection to them? I’m sure it’s something about granting a login shell but how would I do that? _ Get in touch in an instant. Get Windows Live Messenger now. http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_Refresh_getintouch_042008
Re: viewing passwords as root
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/encryption-functions.html#function_password -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
database design
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(ShapeDimensionID,ShapeID,DimensionID) table ItemShapeDimension(ItemID,ShapeDimensionID,value) ItemID,ShapeID,DimensionID, and ShapeDimensionID are primary keys, auto increment Shape Dimension are static tables Shape: Round, Hex, Angle, Channel, Pipe,..etc. Dimension: Diameter, Length, Width, Depth, Inner Diameter, Outer Diameter...etc. do you have any comment for this??? is there any potential structure problem with these relationship? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query OK in localhost, error on ISP server
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.tableprefix#threads.views) from #variables.tableprefix#threads where #variables.tableprefix#threads.forumidfk = #variables.tableprefix#forums.id) as views, instead of : sum(distinct #variables.tableprefix#threads.views) as views, but it returns a zero flat instead of, say, 8, (5+3). Thank You. -- View this message in context: http://www.nabble.com/Query-OK--in-localhost%2C-error-on-ISP-server-tp16738784p16753507.html Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query OK in localhost, error on ISP server
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.tableprefix#threads.views) from #variables.tableprefix#threads where t#variables.tableprefix#hreads.forumidfk = #variables.tableprefix#forums.id) as views, instead of : sum(distinct #variables.tableprefix#threads.views) as views, but it returns a zero flat instead of, say, 8, (5+3). Thank You. Walter conti contiw wrote: The following query run flawlessly in localhost but produces error on ISP server: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'distinct sf_threads.views) as views, ((count(distinct sf_messages.' at line 6 The actual behaviour here: http://eduforums.us or http://wconti.com/schoolsforums/index.cfm I am using the exact same database both in local and server. Running MySQL 5 in localhost and supposedly versions 4 and 5 sopported by the ISP server. Thanks for helping SELECT #variables.tableprefix#conferences.id, #variables.tableprefix#conferences.name, count(distinct #variables.tableprefix#forums.id)-1 as schools, count(distinct #variables.tableprefix#threads.id) as topics, count(distinct #variables.tableprefix#messages.id) as msgs, sum(distinct #variables.tableprefix#threads.views) as views, ((count(distinct #variables.tableprefix#messages.id) *2) +sum(distinct #variables.tableprefix#threads.views) ) as activity, 0 as hBarLength FROM ((#variables.tableprefix#conferences left JOIN #variables.tableprefix#forums ON #variables.tableprefix#conferences.id = #variables.tableprefix#forums.conferenceidfk) left JOIN #variables.tableprefix#threads ON #variables.tableprefix#forums.id = #variables.tableprefix#threads.forumidfk and #variables.tableprefix#threads.author 'admin') left JOIN #variables.tableprefix#messages ON #variables.tableprefix#threads.id = #variables.tableprefix#messages.threadidfk and #variables.tableprefix#messages.author 'admin' GROUP BY #variables.tableprefix#conferences.id -- View this message in context: http://www.nabble.com/Query-OK--in-localhost%2C-error-on-ISP-server-tp16738784p16753509.html Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A SQL Query Question
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 picture posted. Can someone suggest an elegant and fast query to accomplish this? Thanks Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: A SQL Query Question
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 posted. I want to write a query that returns a distinct userId along with the most recent picture posted. Can someone suggest an elegant and fast query to accomplish this? Thanks Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
optimize mysql table's physical storage
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 stored in disk with the sequential fragments.That will increase the scan speed. Is there any tool to do it? Thanks in advance. --ken Get the name you always wanted with the new y7mail email address. www.yahoo7.com.au/y7mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]