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 >

• 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

• 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

• MySQL Date_Format based on today's date and another column?

  - by JM4

  I am aware of the MySQL Date_Format function but am looking to achieve the following: I have on column with a day date in 2 digit format (01-30). I am trying to update another date formatted field with the current year, the next month (m+1) and the day field mentioned previously. In PHP i would do this using mktime function but this must be done using mysql calls only. Is it possible to transform in this way?

  Read the article

• Merge two data frames together that have the same variable names and data types

  - by Brandon

  I have tried the merge function to merge two csv files that I imported. They both have the same variable names and data types but each time I run merge all that I get is an object that contains the names of the two data frames. I have tried the following: # ex1 obj <- merge(obj1, obj2, by=obj) # ex2 obj <- merge(obj1, obj2, all) and several other iterations of the above. Is merge the correct function? If so, what am I doing wrong?

  Read the article

• How to manually add Core Data to project?

  - by marko

  E.g. what "Use Core Data for storage" checkbox option means when creating new Window or Navigation based project? How to add Core Data for Tab Bar Application? How to initialize managedObjectModel, managedObjectContext, persistentStoreCoordinator?

  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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• Is there a Veil-like plug-in for MySQL?

  - by Kevin

  We have a MySQL database and would like to have row-level security implemented at the database level. I have been playing with the Veil plug-in for PostgreSQL and like what it does. Is there something similar for MySQL so we do not have to convert over to PostgreSQL?

  Read the article

• Is this safe? Is this OK to do in MYSQL?

  - by alex

  I have always done this: mysqldump -hlocalhost -uuser -ppass MYDATABASE > /home/f/db_backup/MYDATABASE.sql mysql -uuser -ppass MYDATABASE < MYDATABASE.sql But, if I do this instead...is this safe? Is this identical to the above??? mysqldump -hlocalhost -uuser -ppass MYDATABASE | gzip > /home/f/db_backup/MYDATABASE.sql.gz zcat MYDATABASE.sql.gz | mysql -uuser -ppass MYDATABASE

  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

• 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

• 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

• 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

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