How to find min() value in MYSQL -

-

मेरे पास मेरे डीबी में varchar प्रकार का एक कॉलम है।

तालिका नाम: ट्रांससीशन

कॉलम का नाम: authprocess

मुझे varchar स्तंभ पर न्यूनतम () मान ढूंढना है। 

  authprocess A1D1 A1D3 A1D4 ए 1 डी 1 ए 1 बी 1 ए 1 डी 5 ......   
 मैं कमांड का उपयोग कर रहा हूं / ट्रांस्किकेशन से न्यूनतम (authprocess) चुनें - फिर इसे "0000" मान दे  
 कृपया मुझे कमांड में बताएं MySQL।   
 
 
 MIN () एक चरित्र स्ट्रिंग के लिए कोई वास्तविक अर्थ नहीं है, आपका सर्वोत्तम शर्त है तार आरोही मूल्यों के आधार पर क्रमबद्ध करें और सबसे ऊपर का चयन करें ??  
  तालिका ORDER एएससी से टॉप 1 का चयन करें;

Comments

Post a Comment

Popular posts from this blog

mysql - BLOB/TEXT column 'value' used in key specification without a key length -

-
I have developed an extension which works up to 1.6 on Magren (I'm trying Enterprise Edition, And I think the community is the same problem, because it is the same code). In my install script, I see the $ installer-> gt; CreateEntityTables ($ this- & gt; getTable ('alphanum / info')); The installation is done until it is not in the _text unit table. It crashed there! It turns out that when I log in to SQL and run it via PHPmyadmin, then this error is: Blob / Text column 'value' is used without the key 'key' . I saw the code there, and this is what is trying to create an index on the value column: -> addIndex ($ this- & gt; getIdxName ($ eavTableName, array ( 'attribute_id array (' attribute_id ',' value ')) - & gt; addIndex ($ this- & gt; getIdxName ($ eavTableName, array (' entity_type_id ' , 'Value')), array ('entity_type_id', 'value')) If there is no if statement is n...
Read more

ruby on rails - Convert a Activerecord result with has_one associations into a single hash per record -

-
If I have any results from the Active Records, then I have an array of hashes, if I have a reliable load, then every Each organization hash in record hash has a nested hash of its associated records My question is, is there a quick rail system that allows you to merge these nested hashes into a hash per record? An analogy will be changing the records table rows Another resemblance will be converted into a hash at one level of nested hashes. approach 1: select them in the section Include class user has_one: profile end is for square profile: user # street 1, street 2, city etc. end profile = profile.junks (user :). Selection ("User. *, Profile. *") All profiles. First.login Approach 2: Use delegation for class profiles : User # Street 1, Road 2, City etc. Representative: Name ,: name =,: email,: email = ,: from = to & gt; : End of user
Read more

javascript - Read complete data from stream from onMessage -

-
How to read event.data from a web site entirely using javascript ? On Message: Function (Event) {var msg = event.data; Warning (msg); } In the above code, variable msg shows only partial data How to obtain complete data from websicet server? event.data contains complete information; It depends only on your output how much you will see. A warning box only contains a special number of characters, because more characters do not fit in the warning box only. Warning ing is not a good practice to display large data. A more convenient way to save the length and to check that, for example: On Message: Function (Event) {var msg = event.data; Warning (msg.length); } The length should be just the right length, that is the length of the characters you sent.
Read more