Search Results

Search found 25547 results on 1022 pages for 'table locking'.

Page 399/1022 | < Previous Page | 395 396 397 398 399 400 401 402 403 404 405 406  | Next Page >

• MySQL: How can I select only the last update for each user?

  - by KeyStroke

  Say I have a 'user_log' table with the following field: id user_id status_text timestamp How do I write a query that selects only the last update for all the users in that table? Appreciate your help :)

  Read the article

• Query on Vertical partitioning in Sybase

  - by Sairam

  hi, Am working with sybase.In that i have a table A of some 2 million records containing some columns which i want to move out and make it as a separate table B. I have some questions in this process... 1. I have decided to use vertical partitioning.Is that ok? 2.Or what other technique can i go about using in this process? Please provide your valuable inputs in this. Thanks.

  Read the article

• Query to check the consistency of records

  - by orunner

  I have four tables TableA: id1 id2 id3 value TableB: id1 desc TableC: id2 desc TableD: id3 desc What I need to do is to check if all combinations of id1 id2 id3 from table B C and D exist in the TableA. In other words, table A should contain all possible combinations of id1 id2 and id3 which are stored in the other three tables.

  Read the article

• Is existed web markup languages with possibility insert sql query?

  - by MercurieVV

  Actually what I want - simple DB with simple User Interface. Like MS Access, but for web and it can be without Dragn n Drop, but described with markup language. For example if I want to create list report, then i need to write something like: <table query="SELECT * from mytable"></table> It needed for simple data applications. In that kind application no programming logic required. Just working with DB. Changing DB data and showing it.

  Read the article

• Problem with MySQL query

  - by Psyche

  This time my setup looks like this: one table with galleries names (gallery_id, gallery_name) and another table with galleries photos (photo_id, photo_gallery_id, photo_name). What I need is to get all the galleries with one random picture for each gallery. Is it possible to do this with a single query?

  Read the article

• ms-access: report that displays records only within a certain date

  - by every_answer_gets_a_point

  i have a very simple report that is generated from just one table. one of the columns in the table is a date. i need to be able to allow the user of the report to enter a range of dates and display data only between those dates. how do i do this?

  Read the article

• NHibernate find

  - by Cory

  I have a 'Customer' table with 'FirstName' and 'LastName' columns. I have to execute a search on the 'Customer' table after 'FirstName', 'LastName' and 'FirstName + LastName' depending on a TextBox text. What's the besty way/query to implement this using NHibernate or SQL query?

  Read the article

• PHP MYSQL SIMPLE SEARCH ISSUE

  - by Kunal

  Hi I have a table with the following structure: id int(11), name varchar(250) I have lots of records in the table but when I am trying to find a particluar record which has the following value on the name field: Lorem ipsum d\'olor sit amet The query is simply returning a blank recordset. I am not being able to figure out this weird behaviour, when my query is as simple as follows: SELECT * FROM slot_games WHERE name='Lorem ipsum d\'olor sit amet' Would appreciate your help please! Thanks in advance.

  Read the article

• Randomly selecting a limited number of records with two conditions in MySQL

  - by andyashton

  I have a MySQL table with a column called "priority". The column can have two values: high or low. I want to select 8 records from the table at random, but I want 6 of them to be high priority, and 2 of them to be low priority. If possibly, I would like to do it in one SQL statement. Is there any way to do two LIMITS in one query based on this kind of criteria?

  Read the article

• sql exception handling

  - by christine33990

  CREATE OR REPLACE PROCEDURE p_createLocaltable IS table_already_exist EXCEPTION; PRAGMA EXCEPTION_INIT (table_already_exist, -00955); BEGIN create table local_table as select * from supplied_table where rownum < 1; EXCEPTION when table_already_exist then DBMS_OUTPUT.put_line('Table already exists , does not need to recreate it'); END; can anyone see any problem of the above code?

  Read the article

• SQL Server > Query > Column Names

  - by pojomx

  Hi, I'm here again- I have something like this Select A.a, A.b, A.a+A.b as c, (A.a+A.b*2)+A.d as d from Table But i want to know, if it is possible, to make it work with something like this: Select A.a,A.b,A.a+A.b as c, (c*2)+A.d as d from Table Thank you

  Read the article

• rollback not working in mysql

  - by Bharanikumar

  i have user table, i have 5 records , i delete two records , then executed the rollback command, rollback command executed successfully. But that deleted two records not recovered , user table engine is innodb...

  Read the article

• SQL Server dilemma, performance

  - by Woland

  Hello I am creating app where user can save options witch one is better? to save into user table varchar feeld smthing like ('1,23,4354,34,3') query for this is select * from data where CHARINDEX ( 'L', Providers , 0 ) 0 create other table where user options are and just add rows select * from data where Providers in (select Providers from userdata where userid=100) thanks for help

  Read the article

• Fetching Cassandra row keys

  - by knorv

  Assume a Cassandra datastore with 20 rows, with row keys named "r1" .. "r20". Questions: How do I fetch the row keys of the first ten rows (r1 to r10)? How do I fetch the row keys of the next ten rows (r11 to r20)? I'm looking for the Cassandra analogy to: SELECT row_key FROM table LIMIT 0, 10; SELECT row_key FROM table LIMIT 10, 10;

  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

• 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

• 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

• 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

• 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

• 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

• 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

• Make a set from CSV values in TSQL

  - by rossfabricant

  If I want to see which values from an Excel spreadsheet column don't match values in a table, I can easily create a table with Bulk Import. Is there a simpler way? EG, I want to do a query like: select into #temp from ('a', 'b', 'c') as 'Id' select * from #temp where Id not in (select Id from MyTable)

  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

< Previous Page | 395 396 397 398 399 400 401 402 403 404 405 406  | Next Page >