Search Results

Search found 26878 results on 1076 pages for 'temp table'.

Page 425/1076 | < Previous Page | 421 422 423 424 425 426 427 428 429 430 431 432  | Next Page >

• MySQL: How to do a conditional update?

  - by Tom

  Hi, I'm trying to a create an update statement along the following lines: TABLE car: id | owner_id | type | status An owner can have multiple cars. UPDATE car c SET c.type = 1 WHERE c.owner_id IN ($ids) AND c.status = [1 IF IT EXISTS, ELSE 0] $ids is reasonably small (under 50 values). It seems simple but I can't seem to get my head around it because I can't use a SELECT subquery with an UPDATE to the same table. Anyone? Thanks

  Read the article

• New help with SQL Server select statement

  - by gio_333m

  I need help with select statement in SQL Server / T-SQL My table looks like this: Id (int) QuestionId (int) GenreId (int) I want to select random N rows from this table so that maximum number of same GenreId in the result set is less than X for all GenreId-s except one. For that one GenreId, I need row count with that GenreId to be equal to Y.

  Read the article

• sql delete from start

  - by Luke

  Is there anyway I can restrict the amount of rows allowed in a table to say 40, and then when 41st is added, the table deletes the first one?

  Read the article

• selection of drop down restriction on association tables

  - by venkatakrishna

  hello ! languages table(languagename,languagecode(pk),part); parts table(subjectype,part(pk)); I want to access only perticular subject type into drop downs... How can i do this.

  Read the article

• LOAD DATA LOCAL INFILE custom value

  - by NR03

  How to add a custom value using LOAD DATA LOCAL INFILE? The column time_added is the 7th column and the file has only 2 values for the first and the second column. For the 7th column, time_added I want to use the unix timestamp when loading from file. This code isn't working: $result = mysql_query("LOAD DATA LOCAL INFILE '{$myFile}' INTO TABLE {$table} FIELDS TERMINATED BY ':' LINES TERMINATED BY '\n' SET `time_added`=unix_timestamp()");

  Read the article

• How to read large number of rows efficiently using Zend_Db?

  - by Alex N.

  Is there a simple :) and efficient way or reading very large number of rows sequentially using Zend_Db? Basically I need to process entire table, row by row. Table is large, primary key sequence is not guaranteed(i.e. not an autoincrement, but is UNSIGNED INT). What's the best way to approach this? Environment: PHP 5.2, Zend Framework 1.10, MySQL 5.1

  Read the article

• MySQL: NOW() giving me zeros

  - by Tunji Gbadamosi

  I have a table which I want to record the timestamp of every order at every insertion time. However, I'm getting zero values for the timestamps. Here's my schema: CREATE TABLE IF NOT EXISTS orders( order_no VARCHAR(16) NOT NULL, volunteer_id VARCHAR(16) NOT NULL, date TIMESTAMP DEFAULT NOW(), PRIMARY KEY (order_no), FOREIGN KEY (volunteer_id) REFERENCES volunteer(id) ON UPDATE CASCADE ON DELETE CASCADE)

  Read the article

• regular expression breaking on new line

  - by shyam

  I'm trying to use a regular expression as below: preg_match_all('|<table.*</table>|',$html,$matches, PREG_SET_ORDER); But this is not working, and I think the problem is the new line inside the string $html. Could someone tell me a work around?

  Read the article

• Copy huge tables data from one database to another in SQL Server.

  - by Narasimhulu

  I have two database say DB_A and DB_B. In DB_A database, table having huge data (few tables are having 2 to 10 million data). I want to move the all table data from DB_A to DB_B database. Please help me on writing stored procedures to move efficiently (fast) the data from one database to another.

  Read the article

• How do I check to see if a column is in an xsd?

  - by Timmy

  Is there a simple way to see if the xsd code generating C# code has a particular column? Or if you can reference a variable column? table.getColumn("column") instead of table.column?

  Read the article

• sql - Update Trigger to populate a ModifyDate field

  - by hamlin11

  I'm looking for an example of a good update trigger to update the ModifyDate field of a table. It would be nice to handle the case where an update command updated more than one record in the table. Is there a good template or tutorial for this? Thanks

  Read the article

• T-SQL Query to Get SUM(COUNT())

  - by Ted

  Hi, I am planning to get a report for a table with following table structure: ID RequestDate ----------------------------- 1 2010/01/01 2 2010/02/14 3 2010/03/20 4 2010/01/07 5 2009/03/31 I want the results as: I D_Count RequestDate Sum ----------------------------------------- 2 2010/01 2 1 2010/02 3 2 2010/03 5 Pls help.

  Read the article

• chaining and getting the value of an input

  - by cf_PhillipSenn

  This code gets the text that's in a certain column of a table row: var keyA = $(a).children('td').eq(column).text().toUpperCase(); Q: How do I rewrite this to get the value of an input tag that's in the table cell? var keyA = $(a).children('td').eq(column).('input').val().toUpperCase();

  Read the article

• Is this select possible in sql?

  - by chandru_cp

  Consider a table, Id columnA 1 a 2 b 3 c Select ColumnA from table gives the result as below, columnA a b c Is it possible to get ColumnA a,b,c

  Read the article

• [MYSQL] select statement that combines similar rows with certain ids ?

  - by vegatron

  hi I have a warehouse_products table which defines how many products in the warehouses so lets say I have 20 records/rows in the table, some rows may contain the same product id but in a different warehouse I need to create select statement that give every product one row, and in this row I must have the quantity in warehouse A and warehouse B .. so in the end I will get for example 10 rows that contain all the data id domain_id warehouse_id wh_product_id quantity 2 1 2 2 84 3 1 1 3 221 4 1 3 3 0 5 1 1 3 14 6 1 1 2 73 7 1 1 1 123

  Read the article

• How to insert data only if data doesn't already exist in MYSQL?

  - by Lost_in_code

  This is what I'm doing right now: Execute a query and check if the date to be inserted already exists in a table. If date doesn't exist: Another query will insert the date into the table. How can these two query be combined?

  Read the article

• error on ExecuteNoQuery()

  - by AZIRAR

  hey, i'am trying to update a row in a table using : command.ExecuteNoQuery() it's not giving me an error but it's not updating the row This is my code : Dim req As String = "Update Table Set Id= 5" Dim cmd As New OleDb.OleDbCommand(req, connect()) cmd.ExecuteNonQuery() disconnect() thanks

  Read the article

• Rails - single ID for multiple models

  - by user352351

  I'm building an app which will allow a user to scan the barcode on a 'shelf', 'box' or 'product' which will then bring up that particular item or all the associated items. As these are all separate models with their own ID's, I need a global ID table. I was thinking of a polymorphic table called 'barcodes' barcodes id barcode_number barcodable Is there an easy way to do this? Or is polymorphic the best way?

  Read the article

• Find column that contains a given value in MySQL

  - by shuby_rocks

  Hello all I have a table in a MySQL database. I am given a value that occurs as a cell value in that table but I do not know which cell is it i.e. the row and column of that cell. What is the most efficient way to find the column to which that value belongs? Thanks in advance.

  Read the article

• How to generate report

  - by user692495

  I have problem in generate report. I use crystal report 8.5 with vb.net 2008,what I want is when I generate report it will appear red value, if the value is more or less than actual value else it will give default value but when I put this code it give me wrong result If {Intake.wheatType} = {Spec.WheatType} AND {Intake.HB43} >={Spec.M_Min} AND{Intake.HB43} >={Spec.M_Max} Then Red Else DefaultAttribute this report is related with two tables, which is table Spec and table Intake. Could anyone help/teach me how to fix this problem

  Read the article

• Join two results sets to make one result set in T-SQL

  - by Michael Kniskern

  What would be the best approach to combine the two results sets in one result set in T-SQL? SQL statment #1: SELECT COUNT(t.col1) as 'Number of Responses', t.col2 as 'Department' FROM table t WHERE col3 IS NOT NULL GROUP BY t.col1 ORDER BY t.col1 SQL Statment #1: SELECT COUNT(t.col1) as 'Total number of participants', t.col2 as 'Department' FROM table t GROUP BY t.col1 ORDER by t.col1 Desired result set Number of Responses | Total Number of participants | Department

  Read the article

• How do I delete every row except the last one for each day?

  - by A B

  I have a table with stock quotes that looks something like this: id, date, stock_id, value Every day has several rows for each stock_id (it is automatically updated every five minutes), so the table is rather big at the moment. How do i delete every row but the last one each day for every stock_id?

  Read the article

• help for a query

  - by stighy

  Hi, i've a problem for a table update. follow table structure: Table1 tableid ... ... productID_1 productID_2 productID_3 Table2 productID Total I've to totalize each product in table2. For example: SELECT COUNT(*) as tot, ProductID_1 FROM Table1 GROUP Table1 then the UPDATE table2 SET total =..??? (how can i do) WHERE productID_1 = .... Hope you can help me. Thank you

  Read the article

• SQL Syntax for multiple conditions in the same field

  - by Jonathan

  I can't seem to find this in the mysql manual: How do you enter multiple conditions for the same field in a select statement? e.g.: SELECT * FROM table WHERE ID = '1, 2, 3, 4' Is there a way to do this without using this: SELECT * FROM table WHERE ID = '1' OR ID = '2' OR ID = '3' OR ID = '4'

  Read the article

• Trying to make models in Kohana, relations problem.

  - by Asaf

  I have a table of Hits, Articles and Categories Now, a Hit belongs_to an Article/Category (depends on where it was done). so I have a column on Hits table with the name 'parenttype' That tells me 'Article' or 'Category'. I wrote in the Hit model (extends ORM) protected $_belongs_to= array( 'page' => array('model'=> $this->parenttype) ); Now it complains about $this-parenttype not being expected?

  Read the article

< Previous Page | 421 422 423 424 425 426 427 428 429 430 431 432  | Next Page >