Search Results

Search found 68715 results on 2749 pages for 'mysql data'.

Page 256/2749 | < Previous Page | 252 253 254 255 256 257 258 259 260 261 262 263  | Next Page >

• 1TB data on disk with around 1KB per data record. How to find duplicates using 512MB RAM and infinit

  - by user288609

  1TB data on disk with around 1KB per data record. How to find duplicates using 512MB RAM and infinite disk space?

  Read the article

• Import Data Wizard Does Not Like Data Type I Choose For A Column

  - by Haoest

  Does anybody else have this same problem, when you import data from Excel file to MSSQL Server 2005, if some column contains mostly numeric data, but even if you set the column type to varchar, the wizard fails to import those fields that fail to parse as numbers?

  Read the article

• compressing non-binary data in java http client

  - by wo_shi_ni_ba_ba

  I plan to use java.util.zip to compress http post data when sending it from a java client to the server(java servlet in this case). is this the best approach for reducing data load? should I use gzip as the compression alg?

  Read the article

• Database design (MySql)::should we put html data in text field inside database table or more efficie

  - by meyosef

  Hi, We building big Web Application and we use mysql, we want to make mysql database more fast. Some of us think if we will put message html body inside table and not inside text.txt in will make database heavy and not fast. Thanks, *Part of main table that hold message: option 1:hold html message body inside database message { id (int) subject (varchar) body (text) } option 2: hold html message body inside body1.txt file message { id (int) subject (varchar) file_body_path (varchar) } *

  Read the article

• MySQL UPDATE clause removes slashes in values - any way to disable the sensitivity to slashes?

  - by Jeremy Rudd

  A MySQL UPDATE clause removes slashes in values, although double slashes ensures that the values save correctly. Any way to disable the sensitivity to slashes? Can I disable it in my connector? I'm using the official connector "MySql.Data" for C#.

  Read the article

• PHP or MySql error; Possible to display an "error page" in browser?

  - by Camran

  My classifieds website uses mainly PHP and MySql. On error, (for example if a variable isn't found), I would like to have an error-page to show, is this possible? And I mean for every error to point to the same error-page. I am thinking about htaccess, but maybe there are other ways also? Same with MySql, how is it done there? Thanks

  Read the article

• how to solve syntax error in procedure in mysql?

  - by Shooter

  Hi all, i am executing a procedure in mysql, procedure is- delimiter $$ create procedure getFacility (in id int, out MyFacility VARCHAR(200)) begin select Facility into MyFacility from facilities where FacilityID = id ; end $$ delimiter ; and it is giving error below- Error Code : 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 'end $$ delimiter' at line 1 (0 ms taken) how to solve this error? Thanks, Yugal

  Read the article

• MySQL very slow compared to MS Access when inserting hundred of thousands of rows ! So is there a my

  - by asksuperuser

  I am currently adding hundred of thousands of rows of data to a table first on a MS Access Table then on a MySQL Table. I first tried with MS Access, it tooks less than 40 seconds. Then I tried exactly with the same source and with the same table structure to MySQL and it took 6 min and 40 seconds that is 1000% slower !!! So is there a myth that a database server is more performant ?

  Read the article

• Easiest way to activate PHP and MySQL on Mac OS 10.6 (Snow Leopard)?

  - by matt

  What is the easiest way to activate PHP and MySQL on Mac OS 10.6 (Snow Leopard)? I'd prefer to use any built in versions before resorting to downloading from the PHP or MySQL websites. I'm comfortable at the command line in Terminal.

  Read the article

• Best approach to developing a cross-browser javascript widget that populates from a MySQL database?

  - by MindSculpt

  I'm currently researching the best way to approach building a javascript widget someone can embed on their site, which would retrieve and display information from an external MySQL database. The gist of the widget would mimic the needs/functionality of Twitter's widget (http://twitter.com/about/resources/widgets), where it uses some combination of JS, PHP and/or AJAX and retrieves information from a MySQL DB with secure (or at least somewhat safe) cross-browser access. Thoughts or ideas on the best and most reliable way to approach something like this?

  Read the article

• There is 1TB data on disk with around 1KB per data record. How to find duplicates using 512MB RAM an

  - by user288609

  There is 1TB data on a disk with around 1KB per data record. How to find duplicates using 512MB RAM and infinite disk space?

  Read the article

• how do i specify connection parameters on the command line to run mysql in batch mode?

  - by hmak

  I need to be able to write a script to automatically connect mysql in batch mode so that I can run some .sql files. I tried to enter the following at the prompt: ./mysql -u root -p mypassword but I keep getting a "Enter password: " prompt. What am I doing incorrectly? Thanks.

  Read the article

• pass string or data of local file between viewcontrollers

  - by Jonathan

  In my last question i asked how to best send a string from one view controller to another, both which were on a navigation stack: http://stackoverflow.com/questions/2898860/pass-string-from-tableviewcontroller-to-viewcontroller-in-navigation-stack However I just realised I can either pass the path to the file in the app's document's folder as the first (the table view) has already accessed the data in the file should I pass viewcontroller the data to the pushed VC?

  Read the article

• Delphi, read data from 3rd party data field

  - by donaldadams1951

  I am writing an application that needs to read a data field on another Delphi program and I do not have access to the source code of the 3rd party program. The data field contains the "foreign key" to a record I need to retrieve or create in my application. I would appreciate any links to knowledge or components that will help me with my program.

  Read the article

• Php/MySQL to ASP.NET/MSSQL, Suggest if its worth the trouble.

  - by user302656

  Hello Guys, We have been using PHP/MySQL for our web application which has been growing a lot, the database is around 4-5GB and one of the table is 2GB sometimes, hence slowing down whenever any queries to that table is called. Should we just try to optimize, or are we using MySQL above its limit? Will switching our web app to .NET/MSSQL resolve the issues? Thanks

  Read the article

• Isolate large amounts of data w/ jQuery

  - by Bry4n

  I work for a transit agency and I have large amounts of data (mostly times), and I need a way to filter the data using two textboxes (To and From). I found jQuery quick search, but it seems to only work with one textbox. If anyone has any ideas via jQuery or some other client side library, that would be fantastic.

  Read the article

• Connection to mysql works through php but not through a form submission?

  - by Legend

  I have a download.php file that connects to a remote mysql database. If I run it using php download.php it works fine. But if I create another php file form.php and then submit the form to this download.php, it complains the following: Can't connect to MySQL server on '<IP_ADDRESS>' (13) Does anyone know why this might be happening? I can't see a reason why this works directly but fails to work upon form submission...

  Read the article

• Best ressources for learning Core Data?

  - by mystify

  I want to use Core Data on the iPhone. Do you know great tutorials, videos and ressources for learning Core Data in depth?

  Read the article

• How do I split a large MySql backup file into multiple files?

  - by Brian T Hannan

  I have a 250 MB backup SQL file but the limit on the new hosting is only 100 MB ... Is there a program that let's you split an SQL file into multiple SQL files? It seems like people are answering the wrong question ... so I will clarify more: I ONLY have the 250 MB file and only have the new hosting using phpMyAdmin which currently has no data in the database. I need to take the 250 MB file and upload it to the new host but there is a 100 MB SQL backup file upload size limit. I simply need to take one file that is too large and split it out into multiple files each containing only full valid SQL statements (no statements can be split between two files).

  Read the article

• Data Storage question

  - by Nano8Blazex

  Another newbie question: What's the best way to store data in a Cocoa application written in Obj-C? For example if I want to create a sort of "quizzer" that quizzes the user with pre-written (and user-written) questions? How would I store these questions and answers? Core Data? Thanks!

  Read the article

• Is there a way to get a MySQL table defined encoding in PHP ?

  - by Brad

  I see i can get a MySQL database defined encoding in PHP using the function mysql_client_encoding(...), but is there a way to get a MySQL table defined encoding in PHP ?

  Read the article

• What is the use of "Partition" keyword in MySQL?

  - by chandru_cp

  As I am a MySQL newbie. What does PARTITION mean in this MySQL statement? CREATE TABLE employees ( id INT NOT NULL, fname VARCHAR(30), lname VARCHAR(30), hired DATE NOT NULL DEFAULT '1970-01-01', separated DATE NOT NULL DEFAULT '9999-12-31', job_code INT NOT NULL, store_id INT NOT NULL ) PARTITION BY RANGE (store_id) ( PARTITION p0 VALUES LESS THAN (6), PARTITION p1 VALUES LESS THAN (11), PARTITION p2 VALUES LESS THAN (16), PARTITION p3 VALUES LESS THAN (21) );

  Read the article

• where should I do the calculating stuff,PHP or Mysql?

  - by SpawnCxy

  I've been doing a lot of calculating stuff nowadays.Usually I prefer to do this job in PHP rather than Mysql though I know PHP is not good at this cuz I thought mysql may be worse.But I found some performance problem :some pages were loaded so slowly that 30 seconds' timelimit is not enough for them!So I wonder which is the better practice to do the calculations,and any princles for that?Suggestions would be appreciated.

  Read the article

• how to add prefix in auto incremanet field in mysql?

  - by I Like PHP

  hello All, i just want to know that can we add a prefix to auto increment field of a table in mysql? like my auto increment field of tbl_user is user_id( auto increment). i want this shoud be comes in below way user_id( auto incremant field) user1 user2 user3 user4 user5 please suggest me to do this thing by anothey way if it is not possible with auto increment field in mysql??

  Read the article

• creating instance of labeled fields data type

  - by sisif

  how do i instance a "labeled fields data type"? data InputData = InputData { events :: [Event], newResources :: [Resource] } = where myInputData = ???

  Read the article

< Previous Page | 252 253 254 255 256 257 258 259 260 261 262 263  | Next Page >