Search Results

Search found 20931 results on 838 pages for 'mysql insert'.

Page 336/838 | < Previous Page | 332 333 334 335 336 337 338 339 340 341 342 343  | Next Page >

• Calculating average (AVG) and grouping by week on large data set takes too long

  - by caioiglesias

  I'm getting average prices by week on 7 million rows, it's taking around 30 seconds to get the job done. This is the simple query: SELECT AVG(price) as price, yearWEEK(FROM_UNIXTIME(timelog)) as week from pricehistory where timelog > $range and product_id = $id GROUP BY week The only week that actually gets data changed and is worth averaging every time is always the last one, so this calculation for the whole period is a waste of resources. I just wanted to know if mysql has a tool to help out on this.

  Read the article

• problem with date() function

  - by Syom

  i save in mysql database the time using NOW() function. how can i change the value returned of NOW() function? i want to add 6 hours. example if now() returns 2010-04-03 20:16:27, i want to save 2010-04-04 02:16:27

  Read the article

• Solr autocommit and autooptimize?

  - by Camran

  I will be uploading my website to a VPS soon. It is a classifieds website which uses Solr integrated with MySql. Solr is updated whenever a new classified is put or deleted. I need a way to make the commit() and optimize() be automated, for example once every 3 hours or so. How can I do this? (Details Please) When is it ideal to optimize? Thanks

  Read the article

• How to renumber primary index.

  - by Kamil Mroczek

  I have got a simple MySQL table and primary index (id) is not numbered one by one (1, 31, 35, 100 etc.). I want them to be numbered like (1, 2, 3, 4). Please tell me how to do it. I would also like to point that I am aware of possible consequences of the operation, but I just want to tidy up the table.

  Read the article

• CodeIgniter: Storing an image in the database?

  - by thedp

  Hello, I would like to store images in my mySQL database using the CodeIgniter PHP framework. How do I write and read the image? Thank you.

  Read the article

• Select number of rows in all tables in the database

  - by Alex N.

  I wonder if this is possible with straight SQL on MySQL. I need to do SELECT COUNT(*) FROM on each table in the database and output results in one result set. Is it possible to do with just SQL?

  Read the article

• php code for inserting text file into the database

  - by rabeea

  hey i have form which has a file field. After selecting a file,i want to insert the selected file into the database column. how do i do it?

  Read the article

• Can php query the results from a previous query?

  - by eaolson

  In some languages (ColdFusion comes to mind), you can run a query on the result set from a previous query. Is it possible to do something like that in php (with MySQL as the database)? I sort of want to do: $rs1 = do_query( "SELECT * FROM animals WHERE type = 'fish'" ); $rs2 = do_query( "SELECT * FROM rs1 WHERE name = 'trout'" );

  Read the article

• How to sort it!?

  - 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 207

  Read the article

• System date capturing in to data base

  - by user335103

  i create a registration form in my jsp project.mysql be the database.i want to insert system date automatically in datebase in the registration time.

  Read the article

• What is wrong with this SQL syntax?

  - by Finbarr

  UPDATE files SET filepath = REPLACE(filepath, `sites/somedomain.com/files/`, `sites/someotherdomain.com/files/`); I have a table called files with a field called filepath. MySQL returns this error: Unknown column 'sites/somedomain.com/files/' in 'field list'

  Read the article

• limiting user actions by months

  - by Ahmet vardar

  hi my users upload photo and all uploads recorded in mysql with the date info. i want to limit uploads by the months. user may just upload 3 pics in a month. what is the best way to do this ? cheers

  Read the article

• duplicate record

  - by user349953

  Insert into Attendancemst ( emp_code , name, date , timetable , on_duty,out_duty,clockin , clockout, late, early, mis_in , mis_out , absent , halfday, total_time ) values (pemp_code,pname,pdate,ptimetable,pon_duty,pout_duty ,pclockin,pclockout,plate, pearly, pmis_in,pmis_out,pabsent,phalfday,ptotal_time )ON DUPLICATE KEY UPDATE emp_code=pemp_code and date = pdate;

  Read the article

• How to check how many characters in variable, and add space between characters in that var?

  - by Camran

  I have a 'price' variable that contains some integer number from a MySQL database. I want to check how many numbers the 'price' variable contains, and add a space in the variable depending on how many numbers. See below: Example: If 'price' is 150000 I would like the output to be 150 000 (notice the space). OR, if it is 19000 I would like it to output 19 000... How would you do this the easiest way?

  Read the article

• News Portals and database heaviness

  - by jasmine

  What is database design solutions for news portals with high trrafic? Could file system as a good solution? mysql > File system Thanks in advance

  Read the article

• Is there a way to figure out which web page is associated with which query?

  - by GregoryD

  I'm running a LAMP stack. When I go into phpmyadmin, I can see that there are quite a number of sleeping connections which probably should be closed. Is there a way, using either Apache or MySQL, to determine on which pages those connections are created?

  Read the article

• Is SQLlite strong enough to use as wordpress database ?

  - by justjoe

  i'm just curious. so i ask this particular question about SQLite. I haven't use this type of database extensively. but care to explain what is the basic different between SQLite and Mysql ? The reason behind all of this is i just want to know whether it possible to use it to store wordpress data and act as a database ?

  Read the article

• Problem in importing the CSV file containing multiple commas in a sigle field

  - by kakaajee

  Hi Experts, I am having an issue with importing a large(60MB) CSV file in MYSQL DB. The problem arises when an address field has multiple comma seperated values e.g. home no, street no, town etc. I tried to use BigDump for it but, the problem did not solved because of a single field containing multiple comma separated values. Any idea, suggestion or solution from experts how to handle it? Please reply, because I am sick of it. Thanks

  Read the article

• mysqldump problem with case sensitivity? Win->linux

  - by acidzombie24

  When i dump a table with uppercase letters using mysqldump it comes out as lower case in my dump.sql file. I found a report here in 2006, almost 4 years old http://bugs.mysql.com/bug.php?id=19967 A solution here suggest making linux insensitive. I rather not if possible. Whats the easiest way to copy a win32 db into linux?

  Read the article

• create procedure fails!?

  - by Mark

  Hi, when trying to create a simple procedure in mysql 5.1.47-community it fails everytime i've tried everything! even simple things like this! DELIMITER // CREATE PROCEDURE two () begin SELECT 1+1; end; //

  Read the article

• MySQL: host name universal change.

  - by ctrlShiftBryan

  I am making some updates to a php site which I did not design. I have a local copy of the site. At the top of each page there are settings for the host name for the db connection. Is there someway I can setup a pointer to the remote address. The address is 'mysqlhost' for example and I want that to point to 'mysql.myhost.com'. I tried creating a HOST record for mysqlhost pointing to the IP address it resolves to but that doesn't work. If I put 'mysql.myhost.com' in the connection it works. If I put that IP address it doesn't so that is probably why the HOST record idea doesn't work. Other than creating a local copy of the DB is there a quick way so that I don't have to modify each file in my dev environment and then again when I redeploy?

  Read the article

• Porting from MS Access

  - by lacqui

  I've recently been given a MS Access .mdb database file and asked to make it usable in a Linux system. What I'm looking for is a way to convert the Access database to an open-source database such as MySQL or PostGres. I don't have MS Office, and it's a one-time project for a volunteer organization so I don't want to spend money if it's avoidable. I'm running Vista x64, and have a Linux virtualbox, so something usable in either one will be good.

  Read the article

• Database model for storing expressions and their occurrence in text

  - by lisak

  Hey, I'm doing a statistical research application. I need to store words according to 2 initial letters which is 676 combinations and each word has its number of occurrences (minimal, maximal, average) in text. I'm not sure how the model/schema should look like. There will be a lot of checking whether the keyword was already persisted. I appreciate your suggestions. Edit: I'll be using either mysql or postgresql + spring templates

  Read the article

• UPLOAD DATA IN DATA BASE

  - by rajson

  HI friends, i wish to store image and resume of user in the data base. i am using mysql data base and php5. i want to know that which field i set means data type.and how i set the range (maximum size) for uploaded data.

  Read the article

• Autopruning after a specified amount of row are created?

  - by Rob

  Basic question, sorry. Basically, I have a script that creates a MySQL entry each time someone visits the page. A logging script. However, I want to make it autoprune after, say, 100 visits. For example in pseudo code: if amount of rows > 100 { delete rows 1+ until amount of rows == 100 } So in a nutshell, each time a new row is added after 100, it needs to automatically remove the row with the smallest id (My primary key).

  Read the article

< Previous Page | 332 333 334 335 336 337 338 339 340 341 342 343  | Next Page >