Search Results

Search found 23614 results on 945 pages for 'update'.

Page 99/945 | < Previous Page | 95 96 97 98 99 100 101 102 103 104 105 106  | Next Page >

• How to optimize an update SQL that runs on a Oracle table with 700M rows

  - by Bruno Rothgiesser

  UPDATE [TABLE] SET [FIELD]=0 WHERE [FIELD] IS NULL [TABLE] is an Oracle database table with more than 700 million rows. I cancelled the SQL execution after it had been running for 6 hours. Is there any SQL hint that could improve performance? Or any other solution to speed that up?

  Read the article

• mysql command for update

  - by Mac Taylor

  hey guys i need to add a special text to all rows in my mysql table , how to add some text to the end of all rows' content in a table just for one field i used this code : UPDATE `blogs` SET `title`= `title`+ 'mytext'; but didnt work for me

  Read the article

• Cannot add or update a child row: a foreign key constraint fails

  - by Tom

  table 1 +----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+----------------+ | UserID | int(11) | NO | PRI | NULL | auto_increment | | Password | varchar(20) | NO | | | | | Username | varchar(25) | NO | | | | | Email | varchar(60) | NO | | | | +----------+-------------+------+-----+---------+----------------+ table2 +------------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+----------------+ | UserID | int(11) | NO | MUL | | | | PostID | int(11) | NO | PRI | NULL | auto_increment | | Title | varchar(50) | NO | | | | | Summary | varchar(500) | NO | | | | +------------------+--------------+------+-----+---------+----------------+ com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (myapp/table2, CONSTRAINT table2_ibfk_1 FOREIGN KEY (UserID) REFERENCES table1 (UserID)) What have I done wrong? I read this: http://www.w3schools.com/Sql/sql_foreignkey.asp and i don't see whats wrong. :S

  Read the article

• Drupal: update filesystem path in the database

  - by Patrick

  hi, how can I change my Drupal filesystem root in the database ? I moved Drupal to another path. I'm looking for this value to update in the database. thanks

  Read the article

• SQLite trigger to update Summary Counts

  - by jrhicks

  Consider the following two (hypothetical) tables Temperature * day * time * lake_name * station * temperature_f Temperature_summary * day * lake_name * station * count_readings_over_75f * count_readings_below_75f How can I write an SQLite Trigger to update the temperature_summary table on insert. I want to increment the count. Thank You, Jeff

  Read the article

• Drupal: update.php error...

  - by Patrick

  hi, I'm copying my Drupal installation to another folder and I've copied the related database. When I run update.php on the new copy I get the following error: http://dl.dropbox.com/u/72686/updateError.png should I disable some modules.. or is something about Drupal core ? thanks

  Read the article

• sqlite, UPDATE OR REPLACE

  - by acidzombie24

  I do something like UPDATE OR REPLACE someTable SET a=1, b=2 WHERE c=3 I expect if it doesnt exist it will be inserted into the DBs. But nothing happens and i get no errors. How can i insert data, replace it if it already exist and use a where for the condition (instead of replacing BC of a unique ID)

  Read the article

• How do I update a blog by sending an email, using php

  - by Jean

  Hello, I want to update a blog, by sending an email using php. This is not wordpress, tumblr, or the famous ones. I could set up an email id, with a specific code in the subject line, but how I get input the contents into the db? Thanks Jean

  Read the article

• update in the php

  - by DAFFODIL

  I wrote a code to insert data .When ,i enter the value in the form and click submit ,the data is getting into database. Now,i should make all those data to edit from from end and,if i click update button,it should be updated in database. Give a snippet for performing this task.

  Read the article

• How to do bulk update of views?

  - by Shaul

  My database has about 30 views, most of which have a reference to another database on this server (call it DB1). Now, without going into the reasons why, I need to update all those views to DB2, also on the local server. I would hate to have to do this manually on each view. Is there some SQL query I can run that will replace all occurrences of the string 'DB1' with 'DB2' in all my views?

  Read the article

• onchange event from select box to update field

  - by Andy

  On this page: http://www.blackdownluxurylettings.co.uk/place_booking/2010-3-18,2 I am using an onchange event on the "number of days" select box to update the "departure date" field. But currently nothing is happening. Any ideas?

  Read the article

• Update Database from Entity Data Model without loosing content

  - by user293818

  Hi there, my Topic should tell you already what i am asking for. Is there any way to update my database from an entity data model without lossing the inserted content? I can't be bothered copying all this stuff everytime i make a change. Thanks a lot. Chris

  Read the article

• MySQL: Update table column from subquery result

  - by Jhourlad Estrella

  On the Members table are columns "MemberID" and "PointsEarned". I want to update the PointsEarned column from the result of this query: SELECT m.MemberID, m.UserName, ( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=2)*10 ) + ( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=3)*3 ) + ( (SELECT COUNT(*) FROM ChatMessages as c WHERE c.MemberID=m.MemberID)*.1 ) as PointsEarned FROM Members as m Can anybody tell me how I should do it with a single query? Thanks!

  Read the article

• in mysql table update 'a' record with 'b' and 'b' with 'a'

  - by chetan

  IN my table there are two field one is name and other is gender I want to fire query so that every male is update with female and vice a versa. I don't want to use procedure ,trigger or function.I have to do this only with simple query.

  Read the article

• Javascript update before page loads in ASP.NET

  - by user204588

  Hello, I'm trying to update values from a xml file into textboxes. I have this javascript being called in the Page_Load event this.Page.ClientScript.RegisterStartupScript(this.GetType(), "Script", sb.ToString(), true); I click the continue button which does a post back but the values are not updated until I refresh the page again which makes me think the js isn't being run until after the page is returned. I'm wondering how to have the values updated when the page is refreshed after the button postback. thanks

  Read the article

• HTML: Update Google Search Title and Summary

  - by Patrick

  hi, I want to change the title and summary of my website on google search results. Is enough to change the meta-data and title on my html files, and wait few weeks to let google update the results ? (how long does it take on average ?) thanks

  Read the article

• Update ListView in the main thread from another thread

  - by Wilson

  I have a separate thread running to get data from the internet. After that, I would like to update the ListView in the main thread by calling adapter.notifyDataSetChanged(). But it does not work. Any workaround for that? Thanks.

  Read the article

• Update a Google Doc (or file stored with Docs) with PHP

  - by tb

  It seems Zend Gdata doesn't provide a way to interface with the PUT API for Google Docs. I'd like to clear a document with a known id and update its contents. Should I authenticate with Zend's Gdata and use an HTTP PUT request? How?

  Read the article

• Symfony2: update query with query builder

  - by Ichigo Kurosaki

  This is my query $id contains primary key and $status contains new status public function updateStatus($id,$status) { $qb=$this-createQueryBuilder('b') -update() -set('b.status',$status) -where('b.id='.$id); echo $qb; return $qb-getQuery() -getResult(); } Problem I am facing is [Semantical Error] line 0, col 56 near 'Complete WHERE': Error: 'Complete' is not defined.

  Read the article

• why is ADODB inserting NULL values on update?

  - by every_answer_gets_a_point

  i have: With rs .AddNew ' create a new record ' add values to each field in the record .Fields("datapath") = dpath .Fields("analysistime") = "atime" .Fields("reporttime") = "rtime" .Fields("lastcalib") = "lcalib" .Fields("analystname") = "aname" .Fields("reportname") = "rname" .Fields("batchstate") = "bstate" .Fields("instrument") = "NA" .Update ' stores the new record End With when i check the database, it looks like it ONLY inserted the last field! has anyone encountered this problem?

  Read the article

• How to update sharepoint list data with TeamCenter Data

  - by hellboy406

  Hi, I have a sharepoint List.We will get the data from TEAMCENTER from there we will enter manually into the List. Inorder to automatically update the sharepoint List with Teamcenter data is there any way????

  Read the article

• Update existing pdf with C#

  - by Prashant

  I have an existing pdf file which needs to be updated with information which varies with each client. There are around 50 clients. I have to update the pdf with these. How can I acheive the same in C#. The pdf has to be shown in the browser (only IE) Is there a third party dll which could be used, which would parse the pdf. Then write to the pdf.

  Read the article

• Error during data UPDATE in php

  - by Piyush

  $sql = "UPDATE tblprofile SET name = '$membername' , f_h_name = '$fathername', maritalS = '$mstatus' , dob = '$dob' , occupation = '$occupation' , nominee = '$nominee' , address1 = '$address1' , address2 = '$address2', city = '$city', district = '$district', state = '$state', pin = '$areapin', mobile = '$mobileno', email = '$email', PANno = '$panno', bankname = '$bankname', branch = '$branch', accountno = '$accountno' WHERE userId = '$_SESSION['UserId']' "; //line 212 if(mysql_query($sql)) { echo "Updation Done."; } Error comes in browser : Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\xampp\htdocs\303\saveEditProfile.php on line 212

  Read the article

• update Eclips Plugin with JDE4.7

  - by Master

  Hello every one I am using eclipse with JDE4.5 plugin, i want to update eclips plugin with jde 4.7. what should i do Thanks

  Read the article

• how to update newly exposed area of a scrolled widget

  - by yan bellavance

  I have setAttribute(Qt::WA_OpaquePaintEvent,true) on a widget. From a mouseMoveEvent, I scroll the widget. Now what I need to do is to update the newly exposed area, but it seems that doing this from the paintevent function create an artifact because there is a delay created when the user keeps scrolling. In other words, the widget seems to have scrolled again between the call to scrool and the call or end of paintevent. For example, while the paint event is trying to draw the desired area, the widget is still scrolling

  Read the article

< Previous Page | 95 96 97 98 99 100 101 102 103 104 105 106  | Next Page >