Equivalent to F#’s Seq.scan() method in Python?
- by tk
is there a function like a F#'s Seq.scan() in python?
i want to do some cumsum() or cumproduct() kind of things without looping.
Search Results
Search found 27118 results on 1085 pages for 'mysql python'.
Page 223/1085 | < Previous Page | 219 220 221 222 223 224 225 226 227 228 229 230 | Next Page >
-
-
merging in python
- by Abruzzo Forte e Gentile
Hi all I have the following 4 arrays ( grouped in 2 groups ) that I would like to merge in ascending order by the keys array. I can use also dictionaries as structure if it is easier. Has python any command or something to make this quickly possible? Regards MN # group 1 [7, 2, 3, 5] #keys [10,11,12,26] #values [0, 4] #keys [20, 33] #values # I would like to have [ 0, 2, 3, 4, 5, 7 ] # ordered keys [20, 11,12,33,26,33] # associated valuesRead the article
-
Set given time to 00:00:00 in PHP/MySQL
- by hypnocode
Hi, I'm retrieving a date from a MySQL database that shows up like this: '2010-03-09 09:11:30' How can I change the date to '2010-03-09 00:00:00'? I'm using PHP to perform the query. Thanks!Read the article
-
MySQL: Digits (1.75) to Friendly Time (1 hour and 45 minutes)
- by Nick
In my MySQL database, I have a float field named "HoursSpent" with values like "0.25", "1.75", "2.5", etc. Is there a way that I can have my SELECT statement format those values in a friendly format like this?: 0.25 = 15 minutes 1.75 = 1 hour and 45 minutes 2.5 = 2 hours and 30 minutes The "HoursSpent" field is supposed to only have values in 0.25 increments, but if somebody were to put something random like 0.16, it would be nice if the SELECT statement handled that by rounding it up to the nearest 0.25 (so in this case 0.16 would become 0.25, or 15 minutes).Read the article
-
How to transfer data from MYsql server to iphone
- by creator7
Hi All, I created a webservice in RDB with .Net.I able to transfer data from iphone to mysql and it returns the data. But i need to transfer data from RDB to iphone whenever i need (i am strucked by the ip address of iphone which one is dynamic to connect the device from a RDB) Please tell me how i will do it otherwise tell is any other way. Thanks in AdvanceRead the article
-
Add windows commands in python
- by geocheats2
Can anyone tell me how to add the shutdown.exe to python and how . i also want to set and variables like shutdown.exe -f -s -t 60Read the article
-
How to sort MySQL query by two columns
- by user334269
The following is my DB data, how can I sorting it by sid and prev_sid with php/mysql!? sid prev_sid type 000 197 app_home 197 198 page_teach 198 218 page_teach 199 211 page_step 211 207 link 218 559 page_step 559 199 page_step Result: sid prev_sid type 000 197 app_home 197 198 page_teach 198 218 page_teach 218 559 page_step 559 199 page_step 199 211 page_step 211 207 link 000 197 198 218 559 199 199 211 207Read the article
-
query mysql table and fetch rows posted in 3 days
- by Mac Taylor
Hey guys how can i query my mysql database and fetch rows which are posted in earlier 3 days i know how to fetch todays's rows but not 3 days ago time will save in my table like this : 2010-01-20 19:17:49 and this is what i know : SELECT id FROM pages WHERE date=now() but i need to show posts in 3days and im looking for a simple and straight solution ,because i know how to do so in long php codesRead the article
-
C++ code generation with Python
- by norapinephrine
Can anyone point me to some documentation on how to write scripts in Python (or Perl or any other Linux friendly script language) that generate C++ code from XML or py files from the command line. I'd like to be able to write up some xml files and then run a shell command that reads these files and generates .h files with fully inlined functions, e.g. streaming operators, constructors, etc.Read the article
-
mysql procedure call in codeigniter
- by ASD
Any simple example of mysql stored procedure and example to show how to call that procedure from codeigniter php. Any help?Read the article
-
summing two colums total in mysql
- by JPro
I want a resultset for this table : ID Number_of_posts Number_of_user 1 100 21 2 23 34 as ID Number_of_posts Number_of_user Number_of_posts_AND_Number_of_user 1 100 21 178 2 23 34 178 ----------------------------------------------- 123 55 Is it possible to get the sum of two colums as another column/ as output in mysql?Read the article
-
Where to find Python CouchDB tutorials?
- by Cap
I've been hunting around for a Python CouchDB tutorial and haven't been able to find anything very thorough. The only thing I've really found is this site, which I haven't gotten to work because I keep getting a 'connection refused' error when I try to create a database. Does anyone know where I would look for a tutorial to help me with this?Read the article
-
logarithms in python
- by Srikanth
write a program to find the sum of the logarithms of all the primes from 2 to some number n, and print out the sum of the logs of the primes, the number n, and the ratio of these two quantities in pythonRead the article
-
Rails and Python hosting problem
- by maxxtack
I am trying to host some files/rails app in the port 8080 for external access. For python I am using the SimpleHTTPServer module, and for rails, webrick. However, both of them does not work very well. I don't get the response back, and, sometimes, if I get it, it's VERY slow. Nevertheless, apache works very well on the port 8080 (i am not running them at the same time). What is going on?Read the article
-
Getting single value from a single row with Mysql/PHP
- by Ghostrider
Often I just need to get a single value from MySQL that I know exists there. I use the following construct: $result = end(mysql_fetch_array(mysql_query('SELECT FOUND_ROWS()', $db))); Is there a proper single function in PHP that would do this?Read the article
-
Time not entered in mysql ? Java
- by Nitesh Panchal
Hello, I have a datetime field in mysql table and i am using JPA for persisting data but only date goes in database. Time always shows 00:00:00. What should i do? I am not doing any manipulation with Date. All i do is to assign new Date() to a variable and store it in database. What am i doing wrong?Read the article
-
mysql query fails.It gives me invalid result
- by user2941349
I have to write mysql query for fetching result from my database with a specified date and code like ABH18 or ABH17 or ABH19.I write the querly like below. select * from tbl_transaction where trans_name like 'ABH19%' or trans_name like 'ABH18%' or trans_name like 'ABH17%' or trans_name like 'ABH15%' and date_of_vazhipad='2013-11-20' and trans_status='Completed successfully.' There are no result in the DB satisfying all above conditions.But i got result with different dates.But i want to ensure the date_of_vazhipad='2013-11-20' so that the query may work properly Thanks in advanceRead the article
-
Error #1064 in mySQL Query
- by William
I get the following error in the query below: #1064 - 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 ')))' at line 1 Code Snippet: INSERT INTO test_bans( ip, Expiration ) VALUES ( "0.0.0.0", DateAdd( "d", 1, Date( ) ) ) Table creation query CREATE TABLE test_bans ( ID smallint(6) NOT NULL AUTO_INCREMENT, IP text NOT NULL, Expiration DATETIME NOT NULL, PRIMARY KEY (ID) ) TYPE=MyISAM; What am I missing?Read the article
-
Favourite Open Source Google App Engine apps (Java or Python)
- by flybywire
To learn from good examples, what are the best open source Google App Engine applications out there? I don't care if it is Java or Python based. Please one app per answer. Feel free to add a link to the live app (if there is) and to the project page.Read the article
-
mysql select from one server insert to another mysql server ?
- by Shvilam
I wont to do insert to one mysqll server to and get the data or do the select part of the insert into select from anther mysql server not just copy entire tables is this possible in my sql I know that in MS Sql server you can do a linked server thanksRead the article
-
Sort MySQL result set using comparison between 2 columns of same value type
- by Kyobul
Hello, I have a table containing last_updated_1 and last_updated_2 columns, used respectively for text and images update time on a post. I wish I could get a result set of 10 rows based on all time last updated records contained in the 2 columns, ex. row 1 = last_updated_1 record, row 2 = last_updated_2 record, row 3 = last_updated_1 record, etc. How could I compare inside a MySQL query the both columns values, to get unique & mixed result set ? Thank you in advance for your helpRead the article
-
Receiving XML document with python via HTTP
- by Kerby82
I want to do a very simple webserver in python able to receive XML document over HTTP and then to send as response XML document. Do you have any example? just to understand How arrange the work... many thanks!Read the article
-
MySQL 5.1 Schema Installer
- by sergiogx
I need to make an installer for a MySQL 5.1 Database, but I'm totally a noob when it comes to installers. I've been looking at NSIS and learned a little but I don't really know how to use it to just to execute a script. Anyone out there has experience installing database schemas in multiple computers? thanksRead the article
-
mySQL convert varchar to date
- by Jeff V
I need to convert a varchar value of 1/9/2011 to a date in mySQL and I want only the month and year. So that I can then use the PERIOD_DIFF function (so I would need the above to be converted to 201101). I've tried various ways using the STR_TO_DATE function: SELECT STR_TO_DATE(CYOApp_oilChangedDate, '%m/%Y') FROM CYO_AppInfo But I get weird results... (for example: 2009-01-00) What am I doing incorrectly?Read the article
-
Practicing BDD with python
- by JtR
Which are the most advanced frameworks and tools there are available for python for practicing Behavior Driven Development? Especially finding similar tools as rspec and mocha for ruby would be great.Read the article
