Search Results

Search found 20838 results on 834 pages for 'mysql num rows'.

Page 132/834 | < Previous Page | 128 129 130 131 132 133 134 135 136 137 138 139  | Next Page >

• How do I generate site map from MySQL database

  - by mathew

  Hi all I am new to Php and working on a project which needs to generate sitemaps from URLS which stored in MySQL database. how can I do this?? Is there any one have any idea?? site maps can be in php extension too and only requirement is list of sites display in each page

  Read the article

• passing LIMIT as parameters to MySQL sproc

  - by Kyle

  I'm creating a paging class and need to pass in two parameters to my MySQL stored procedure for the LIMIT clause. I'm passing them in as INTs and trying something like this SELECT * FROM `MyTable` LIMIT MyFirstParamInt, MySecondParamInt it gives me an error when I try and save the sproc though. Is there a way to do this that I'm just missing? Or am I going to have to EVAL the whole query and EXECUTE it?

  Read the article

• MySQL: Updating entry WITHOUT updating timestamp

  - by Yongho

  I have a timestamp in a mysql table with attribute "ON UPDATE CURRENT_TIMESTAMP". Is there a way to manually disable updating the timestamp on a special occasion? (eg: updating the entry to revise a blog post, but not to re-date it)

  Read the article

• How to kill locked mysql queries

  - by jcure

  Hi, I am creating and testing a mysql join query but each time so far it causes the database tables to lockup and the site hangs. I have to then call the host and they kill the locked queries. Is this something I can do from phpmyadmin so not to bother them while I tweak the script to work? Thanks for any reply.

  Read the article

• Repeating events in a MySQL DB

  - by kylex

  I'm needing to create a MySQL database that is capable repeating events in the exact same way that google calendar repeats events. What is the best way to structure the table(s) to do this?

  Read the article

• Update Mysql database with dataset changings? (C#)

  - by Ases

  I'm changing my dataset in my program. And when my job was finished, I'm connecting to mysql database. I don't want to do this job again, how can I send changings to database like this mydatadapter.Update(dataset, " table"); I found this code, but I can't run it :S

  Read the article

• MySQL MATCH AGAINST functionality....

  - by Webnet

  Currently I have the following query... SELECT id, LOWER(title) as title, LOWER(sub_title) as sub_title FROM ebay_archive_listing WHERE MATCH(title, sub_title) AGAINST ("key" IN BOOLEAN MODE) However it is not finding rows where the title contains the word "key". "key" is generated dynamically based on a set of keywords, so sometimes it contains + and - symbols.

  Read the article

• php date will not insert into mysql database

  - by Piers Blinco

  this is a strange one. I have a date, that is converted to mm-dd-yyyy when posting it to mysql i have re-ordered it to yyyy-mm-dd but yet it still will not insert $date = date("Y-m-d", strtotime($_POST['leaving_date']) ); any advice? Cheers EDIT The actual query: mysql_query("INSERT INTO booking_info (customer_id, booking_ref, date_of_travel) VALUES (".mysql_real_escape_string($_POST['customer_id']).", ".mysql_real_escape_string($rnd).", ".mysql_real_escape_string($date).")");

  Read the article

• MySQL function to compare values in a db table against the previous

  - by Stuart

  Iam quite new to functions in SQL and I would like to create a function to compare values in a MySQL table against previous and I am not sure how to do this. For example (iId is the input value) DECLARE pVal INT(20); DECLARE val INT(20); SELECT price INTO pVal FROM products WHERE Id=iId; SELECT price FROM products; IF price == pVal THEN SET val = price; END IF; Thanks

  Read the article

• When is porting data from MySQL to CouchDB NOT advisable? Seeking cautionary tales

  - by dan

  I've dabbled in CouchDB and I have pretty good MySQL experience. I've also created one production application that uses both. I like MySQL but I've run into scaling/concurrency issues with MySQL that CouchDB advertises itself as a general solution for. The problem is that I have MySQL based applications that are pretty huge, and I don't really know whether it would be a good idea or not to try to port them over to a CouchDB datastore. I don't want to put in a lot of time and effort only to find out that my application is really not a good fit for CouchDB. Is there any sort of informed consensus on when porting a MySQL based app to CouchDB is NOT advisable? Any cautionary tales? I think CouchDB is really cool and want to use it more. I'd also like to know ahead of time what specific types of data querying scenarios CouchDB is really not good for, or if CouchDB can really replace MySQL for all the applications I create going forward.

  Read the article

• fastest way to copy a table in mysql

  - by Anon

  which one is the fastest way to completely copy a table on mysql ? CREATE TABLE copy LIKE original; INSERT INTO copy SELECT * FROM original; or CREATE TABLE copy SELECT * FROM original; ALTER TABLE copy ADD PRIMARY KEY (id); or theres another way ? PS. can't use command-line tools like mysqldump, must be on-the-fly.

  Read the article

• Where can I download sample Mysql database?

  - by monkey_boys

  Where can I download sample Mysql database? I would like to test some queries, but not have any data in the database. Where can I find it?

  Read the article

• opening pdf file using php that take data from mysql

  - by Sahar

  hello, anyone can plz help me? i wanted to create pdf file using php and have done it. now i want to create pdf file that get data from mysql table.. i've searched for the sample code for long time but didnt find even a single code related to my query.. thanx in advance

  Read the article

• PHP MySQL JavaScript or AJAX Image Slideshow

  - by medoix

  Hi all, i have searched Google and also searched Stack Overflow to no avail. I am looking for a PHP / MySQL driven dynamic image slideshow. One similar to 'lightcyclers.com', i have information stored in the DB and i just want to display random or popular content etc. I am also not interested in coding one myself as i am busy working on other features. Any links or help would be much appreciated.

  Read the article

• graphical relationship map for doctrine/mysql?

  - by ajsie

  i wonder if there is gui tools for creating a graphical map for the relationship between models/objects (doctrine) or tables (mysql)? it would be better than draw it manually. i´ve already have the models/objects and tables created.

  Read the article

• MySQL "extended" vs "show status"

  - by john a macdonald

  When I do mysqladmin extended from the command line, my Com_* counters differ completely from doing a show status when consoled into MySQL. Why is this?

  Read the article

• Maximum number of records in a MySQL database table

  - by pepernik

  What is the upper limit of records for MySQL database table. I'm wondering about autoincrement field. What would happen if I add milions of records? How to handle this kind of situations? Thx!

  Read the article

• Take data from an XML file and put it into a MySQL database

  - by Aidan

  Hi Guys, I'm looking to construct a script that would go through an XML file. Would find specific tags in it, put them in a table and fill the table with specific tags within them. I'm using MySQL 5.1 so loadXML isn't an option and I think that ExtractData() method wont be much use either.. but I don't really know. What would be the best way to go about this?

  Read the article

• Using MySQL variables in a query

  - by Jon Tackabury

  I am trying to use this MySQL query: SET @a:=0; UPDATE tbl SET sortId=@a:=@a+1 ORDER BY sortId; Unfortunately I get this error: "Parameter '@a' must be defined" Is it possible to batch commands into 1 query like this, or do I need to create a stored procedure for this?

  Read the article

• mySQL Inconsistent Performance

  - by Jon Hatfield

  Hi, I'm running a mySQL query that joins various tables of 500,000+ rows. Sometimes it takes a second, other times around 15 seconds! This is on my local machine. I have experienced similarly varied times before on other intensive queries, does anyone know why this is? Thanks

  Read the article

• mysql innodb:innodb_flush_method

  - by Daniel

  in the following link http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_flush_method it says:Different values of this variable can have a marked effect on InnoDB performance. For example, on some systems where InnoDB data and log files are located on a SAN, it has been found that setting innodb_flush_method to O_DIRECT can degrade performance of simple SELECT statements by a factor of three. Why O_DIRECT could slow down the select statement?

  Read the article

• Grails MySQL MaxPoolSize

  - by Bob Herrmann

  How do I increase the maxPoolSize in Grails when using mysql? It appears to be using a default connection pool only 8 connections.

  Read the article

• mysql circular dependency in foreign key constraints

  - by Flavius

  Given the schema: What I need is having every user_identities.belongs_to reference an users.id. At the same time, every users has a primary_identity as shown in the picture. However when I try to add this reference with ON DELETE NO ACTION ON UPDATE NO ACTION, MySQL says #1452 - Cannot add or update a child row: a foreign key constraint fails (yap.#sql-a3b_1bf, CONSTRAINT #sql-a3b_1bf_ibfk_1 FOREIGN KEY (belongs_to) REFERENCES users (id) ON DELETE NO ACTION ON UPDATE NO ACTION) I suspect this is due to the circular dependency, but how could I solve it (and maintain referential integrity)?

  Read the article

• how to use SMTP + PHP + MYSQL ?

  - by Ronnie Chester Lynwood

  Hello guys I've got a mass mail function that sends e-mail to all emails in my mysql table. but theyr all goes spam. I want to use smtp validate for this function. How can I use smtp validation with "mail($email, $subject, $message, $headers);" ? thank u

  Read the article

• Switching MySql Replication Format

  - by NNN

  I'm currently using statement-based replication. After upgrading to MySql 5.1, I'm considering using row-based replication. After reading the docs it seems that you can change the format of the master on the fly. Will the slave automatically adapt to whatever type of binary log it is sent? Do I have to make any changes to the slave or master to get ready for switching or can I simply modify the binlog_format variable on the master?

  Read the article

< Previous Page | 128 129 130 131 132 133 134 135 136 137 138 139  | Next Page >