Search Results

Search found 27118 results on 1085 pages for 'mysql python'.

Page 203/1085 | < Previous Page | 199 200 201 202 203 204 205 206 207 208 209 210  | Next Page >

• MySQL: Which is faster — INSTR or LIKE?

  - by Grekker

  If your goal is to test if a string exists in a MySQL column (of type 'varchar', 'text', 'blob', etc) which of the following is faster / more efficient / better to use, and why? Or, is there some other method that tops either of these? INSTR( columnname, 'mystring' ) > 0 vs columnname LIKE '%mystring%'

  Read the article

• Copy an entity in Google App Engine datastore in Python

  - by Gordon Worley

  In a Python Google App Engine app I'm writing, I have an entity stored in the datastore that I need to retrieve, make an exact copy of it (with the exception of the key), and then put this entity back in. How should I do this? In particular, are there any caveats or tricks I need to be aware of when doing this so that I get a copy of the sort I expect and not something else.

  Read the article

• Know if a MySQL server is overloaded with PHP

  - by Francesc

  Hi, It's possible to know if a MySQL server is overloaded (with PHP), and if it's overloaded show a static page (something like Twitter's fail whale)? How can I do it? Thanks!

  Read the article

• perl code to python code

  - by Eva

  can you convert this perl code to python code : $list = $ARGV[0]; open (PASSFILE, "$list") || die "[-] Can't open the List of password file !"; @strings = ; close PASSFILE; Thanks

  Read the article

• Mysql - Get # of months and years

  - by jwzk

  Is there any way to get the # of months and years since a date, using the mysql DATE column? So if I enter 1/1/2009.. I want 1 years, 3 months.. and so on.

  Read the article

• Simple web general localization/translation backend (using mysql)?

  - by Hendrik

  Hi is there a free avaible translation backend with database avaible which can handle multiple users(no login needed), multiple languages (UTF-8) and provides automatic google translation? I just need this tool to fill a database (preferable mysql) with simple tables like this: language | label | text english | _helloworld | Hello World! german | _helloworld | Hallo Welt! I don't care about export since this will have to be created anyways.. Thanks it would be a real timesaver if something with an usable UI exists already.

  Read the article

• PHP mySQL - replace some string inside string

  - by apis17

  i want to replace ALL comma , into ,<space> in all address table in my mysql table. For example, +----------------+----------------+ | Name | Address | +----------------+----------------+ | Someone name | A1,Street Name | +----------------+----------------+ Into +----------------+----------------+ | Name | Address | +----------------+----------------+ | Someone name | A1, Street Name| +----------------+----------------+ Thanks in advance.

  Read the article

• Best way to add a column in mysql query

  - by PHP-Prabhu

  Can any one please let me know that, I need to add a column dynamically when executing mysql query Table: Table1 -------------------------- col1 col2 col3 -------------------------- Test OK Test3 Test OK Test5 Test OK Test6 from the above example i need to introduce "col2" as new column and its value to be as "OK"

  Read the article

• Python operators returning ints

  - by None

  Is there any way to have Python operators line "==" and "" return ints instead of bools. I know that I could use the int function (int(1 == 1)) or add 0 ((1 == 1) + 0) but I was wondering if there was an easy way to do it. Like when you want division to return floats you could type from __future__ import division. Is there any way to do this with operators returning ints? Or could I make a class extending __future__._Feature that would do what I want?

  Read the article

• Difference between Python urllib.urlretrieve() and wget

  - by jrdioko

  I am trying to retrieve a 500mb file using Python, and I have a script which uses urllib.urlretrieve(). There seems to some network problem between me and the download site, as this call consistently hangs and fails to complete. However, using wget to retrieve the file tends to work without problems. What is the difference between urlretrieve() and wget that could cause this difference?

  Read the article

• MySQL query to order by parent then child places

  - by Swanny

  I have a table of pages in my database, each page can have a parent as below: id parent_id title 1 0 Home 2 0 Sitemap 3 0 Products 4 3 Product 1 5 3 Product 2 6 4 Product 1 Review Page What would be the best MySQL query to select all pages ordered by parent then child then child again if there is more than one level, there will be a maximum of three levels. The above example would produce the desired order: Home Sitemap Products Product 1 Product 1 Review Page Product 2

  Read the article

• time series in python up to microseconds

  - by Abruzzo Forte e Gentile

  Hi All I would like to handle time series in python. I have been suggested to use scikit.timeseries but I need to handle up to microseconds and this last, as far as I know, handles up to milliseconds. Do you know any other library able to do that? At some point I need to merge 2 time series sampled at different time, and I would like to avoid rewriting such kind of features or any new classes from scratch whenever it is possible. I thank you all AFG

  Read the article

• Accessing relative path in Python

  - by Aaron Hoffman

  Hi, I'm running a Mac OS X environment and am used to using ~/ to provide the access to the current user's directory. For example, in my python script I'm just trying to use os.chdir("/Users/aaron/Desktop/testdir/") But would like to use os.chdir("~/Desktop/testdir/") I'm getting a no such file or directory error when trying to run this. Any ideas?

  Read the article

• How to only select numeric data from mysql?

  - by liuxingruo

  Does mysql have a funcion like is_num() which can allow me determine the data is numeric or not? Thanks.

  Read the article

• How to implement a hub in Python

  - by j3d

  Dear all, I need to implement a TCP server in Python which receives some data from a client and then sends this data to another client. I've tried many different implementations but no way to make it run. Any help would be really appreciated.

  Read the article

• APE engine Mysql push data to channel on insert

  - by Fotis

  Hello, i am working with APE Engine (http://www.ape-project.org) and up until now i had no actual problem. The problem is that i would like to use the MySQL module and push data to a channel each time a row is inserted into a table. I've tried to setup a server side module, i created an SQL query but data is fetched only when the server boots. How can i make this work?

  Read the article

• Python and the Singleton Pattern

  - by dmanxiii

  What is the best way to implement the singleton pattern in Python? It seems impossible to declare the constructor private or protected as is normally done with the Singleton pattern...

  Read the article

• MySQL ORDER BY offset

  - by monk.e.boy

  In a MySQL query how would I select: all rows ordered by column 'name' where name 'f' so I'd get Gs, Hs ... Xs, Ys, Zs, As, Bs, Cs ... Fs.

  Read the article

• mySQL 1046 error when importing wordpress database

  - by j-man86

  I'm moving a locally developed wordpress site to a client's server so I'm trying to export the local database and import it to the server. I exported the .sql file according to the instructions here http://codex.wordpress.org/Backing_Up_Your_Database but I keep getting this error when importing: DROP TABLE IF EXISTS `wp_commentmeta` ; MySQL said: Documentation #1046 - No database selected Any help very much appreciated. Thanks!

  Read the article

• Controlling a browser using Python, on a Mac (Firefox or Safari or Chrome/ium or Opera)

  - by Gj

  I'm looking for a way to programatically control a browser on a Mac (i.e. not IE) using Python. The actions I need include following links, checking if elements exist in a page, and submitting forms. Which solution would you recommend? Thanks!

  Read the article

• Mysql count columns

  - by Sergio

  I have a table for image gallery with four columns like: foid | uid | pic1 | pic2 | pic3 | date | ----------------------------------------------- 104 | 5 | 1.jpg | 2.jpg | 3.jpg | 2010-01-01 105 | 14 | 8.jpg | | | 2009-04-08 106 | 48 | x.jpg | y.jpg | | 2010-08-09 Mysql query for the user's galleries looks like: SELECT * FROM foto WHERE uid = $id order by foid DESC The thing that I want to do is count the number of images (PIC1, PIC2, PIC3) in every of the listed galleries. What is the best way for doing that?

  Read the article

• script to convert mysql dump sql file into format that can be imported into sqlite3 db

  - by spudnik1979

  hi, i have an export sql file containing tables and data from mysql and i want to import it into a sqlite 3 db. please can you tell me the best way? i get error reading file in via sqlite3 binary.

  Read the article

• Looking for web hosting with php cUrl and MySql support

  - by embedded

  i'm developing an iPhone app which communicates with a remote DB. for that purpose I'm looking for a web hosting service which inclues the following specs: latest PHP cUrl SSL support mySql cron live support Max uptime great money per value ratio The main functionality is communication with the DB and displaying some info on the app. It is important that the web hosting provider will be highly reliable. Are there any providers who give some free usage before starting to pay? Thanks

  Read the article

• need a good frontend for MySQL for beginner user

  - by aadersh patel

  implementing a database and need an easy to use frontend. Have tried: HeidiSQL - editing fields was very tedious MySQL-Front - wasnt adding tables through the SQL Editior, and only updated when the prog was restarted. Can anyone recommend a Frontend which they think would be appropriate? Many thanks

  Read the article

• Accessing MySQL database from iphone

  - by Jayshree

  Hi i am trying to connect my iphone aap directly to the MySQL database. I did a lot of reading, and i found that by using MCPkit we can access the database. Now i also found that the mcpkit is not supported in iphone, while it runs in simulater. Can somebody tell me whats the deal with this. I know the other alternative is web services, but i have to directly connect to the DB. so please can somebody help me with this problem.

  Read the article

< Previous Page | 199 200 201 202 203 204 205 206 207 208 209 210  | Next Page >