Bueno yo uso SQLite ... la orden que le envio es esta: SELECT id,superficie FROM %s WHERE planta="unaplanta" INTERSECT SELECT id,superficie FROM %s WHERE sala="unasala" INTERSECT SELECT id,superficie FROM %s WHERE uso="unuso" INTERSECT SELECT id FROM %s WHERE computa = "no" ORDER BY superficie DESC
pero me da la lista desordenada ... bueno en realidad me la ordena por orden alfabético por sala ... lo cual no deja de ser raro. El 19 de junio de 2010 18:32, Sergio Soto Núñez <[email protected]>escribió: > Si se puede. Eso no es cuestión de pySQL si no de Mysql: > http://dev.mysql.com/doc/refman/5.0/es/select.html > > __________________________________________________________ > Hay una fuerza motriz más poderosa que el vapor, la electricidad y la > energía atómica: la voluntad. > Albert Einstein (1879-1955) > > > > 2010/6/19 monoBOT <[email protected]> > > otra preguntilla de pysql >> >> cuando creo la tabla le pongo a las columnas que sean TEXT pero no se si >> es posible de esta forma solicitarle un ORDER BY ... es posible? es que no >> me lo hace y no me gustaría cambiarlas a FLOAT porque me da errores al >> cargar los datos desde python. >> >> >> 2010/6/18 monoBOT <[email protected]> >> >>> perdon ... a los 3!!!!!!!!!!!!! >>> >>> 2010/6/18 monoBOT <[email protected]> >>> >>> muchas gracias a los 2!!! >>>> >>>> >>>> 2010/6/18 Antonio Beamud Montero <[email protected]> >>>> >>>> monoBOT escribió: >>>>> >>>>>> Hola ... como puedo obtener la cantidad de columnas de una tabla? >>>>>> >>>>>> hice lo siguiente de modo rudimentario pero seguramente existe una >>>>>> forma mucho mas directa ... alguna pista? >>>>>> >>>>>> >>>>>> orden = 'SELECT * FROM nombretabla WHERE id = 1' cursor.execute(orden) >>>>>> for objeto in cursor: >>>>>> valor = len(objeto)-1 >>>>>> >>>>>> ------------------------------------------------------------------------ >>>>>> >>>>>> >>>>>> >>>>> >>>>> de http://www.python.org/dev/peps/pep-0249/: >>>>> >>>>> Cursor Objects should respond to the following methods and >>>>> attributes: >>>>> >>>>> .description This read-only attribute is a >>>>> sequence of 7-item >>>>> sequences. >>>>> Each of these sequences contains information describing >>>>> one result column: >>>>> (name, type_code, display_size, >>>>> internal_size, precision, >>>>> scale, null_ok) >>>>> >>>>> The first two items (name and type_code) are mandatory, >>>>> the other five are optional and are set to None if no >>>>> meaningful values can be provided. >>>>> >>>>> This attribute will be None for operations that >>>>> do not return rows or if the cursor has not had an >>>>> operation invoked via the .execute*() method yet. >>>>> The type_code can be interpreted by comparing it >>>>> to the >>>>> >>>>> >>>>> Es decir, si haces len(cursor.description) te dice el total de >>>>> columnas. >>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Python-es mailing list >>>>> [email protected] >>>>> http://mail.python.org/mailman/listinfo/python-es >>>>> FAQ: http://python-es-faq.wikidot.com/ >>>>> >>>> >>>> >>> >> >> _______________________________________________ >> Python-es mailing list >> [email protected] >> http://mail.python.org/mailman/listinfo/python-es >> FAQ: http://python-es-faq.wikidot.com/ >> >> > > _______________________________________________ > Python-es mailing list > [email protected] > http://mail.python.org/mailman/listinfo/python-es > FAQ: http://python-es-faq.wikidot.com/ > >
_______________________________________________ Python-es mailing list [email protected] http://mail.python.org/mailman/listinfo/python-es FAQ: http://python-es-faq.wikidot.com/
