Search Results

Search found 40581 results on 1624 pages for 'mysql select db'.

Page 241/1624 | < Previous Page | 237 238 239 240 241 242 243 244 245 246 247 248  | Next Page >

• Delete record in MySQL with php targeting auto_incremented int?

  - by Chris_45

  Why doesnt this delete work to delete the whole record: $query = 'DELETE FROM tblEvents WHERE index = $_GET["id"]'; $result = mysql_query($query, $db) or die(mysql_error($db)); Where index is variable of type int, auto_incremented in MySQL?

  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 can I connect to a mysql db from a different server ?

  - by HJ-INCPP

  Hello, I have, let's say, a root website with mysql db on a remote server. I want to connect to that particular database (to make queries), from many other little websites (with lower priviledges). Can this be done? Language: jsp,java,php Thank you

  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

• 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

• 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

• best way to change the date format in mysql SELECT?

  - by Chakrapani

  Can any one please let me know, i need to change the data format 2010-05-14 17:53 to 14/05/2010 17:53 using mysql select query

  Read the article

• Is it possible to apply the Replication mechanism on single MySQL server?

  - by Parth

  Is it possible to apply the Replication mechanism on single MySQL server? I want to replicate the changes done in test db to Main db in the same server, so can i use this Replication mechanism on same server?

  Read the article

• How to use Triggers for Logging History of database change in MySQL?

  - by Parth

  How to use Triggers for Logging History of database change in MySQL? If yes, then is it possible to create a sepearte db for trigger tables for tracking history of other Db tables??

  Read the article

• How to get a list of unrepeatable date from my db in PHP?

  - by SzamDev

  Hi in my db there are 5 fields (id, list_date, amount, total, m_from) and contain data, for example : 1 - 1/1/2010 - 10 - 50 - 'example111' 1 - 1/1/2010 - 10 - 50 - 'example111' 1 - 1/4/2010 - 10 - 50 - 'example154 1 - 1/1/2010 - 10 - 50 - 'example111' 1 - 1/5/2010 - 10 - 50 - 'test' I need to know how I can get dates from list_date but without repeatable dates like '1/1/2010, 1/5/2010, 1/4/2010' Thanks in Advance.

  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

• 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

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

• 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

• 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

• 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 can we re-use the deleted id from any MySQL-DB table?

  - by Parth

  How can we re-use the deleted id from any MySQL-DB table? If I want to rollback the deleted ID , can we do it anyhow?

  Read the article

• Hows does Drupal 6 interact with MySQL for connections and transactions?

  - by Mike Munroe

  Hows does Drupal 6 interact with MySQL for connections and transactions? Does connection pooling get used? How are transactions handled? At what level are these things managed by Drupal vs being handed off to be handled by MySQL? I did a good amount of searching on the web and within Stack Overflow, but mainly, I only found articles for tweaking Drupal performance and scaling needs.

  Read the article

• C# MySQL Connector works in IDE, not after publish?

  - by MTBPatriot

  For some reason I can't seem to get the MySQL Net Connector to work with C# outside of the IDE. I have a very simple program working just fine in the IDE (connecting to the database and everything) but when I publish the code and run the .application file (on my local computers desktop or off the company server) it says it can't connect to any of the specified MySQL hosts. Any help would be greatly appreciated! :( Thank you

  Read the article

• what mysql format should i use for these decimals? (Google Maps co-ords)

  - by Haroldo

  I have these two values i want to store: $a = '51.480092'; $b = '-2.589397'; However I've been getting mysql errors, how should i have the decimal col setup in mysql?

  Read the article

• Is there a way to copy all the data in a mysql database to another? (phpmyadmin)

  - by ggfan

  I want to copy all the tables, fields, and data from my local server mysql to my hosting sites mysql. Is there a way to copy all the data? (It's only 26kb, very small)

  Read the article

< Previous Page | 237 238 239 240 241 242 243 244 245 246 247 248  | Next Page >