Search Results

Search found 27691 results on 1108 pages for 'multi select'.

Page 676/1108 | < Previous Page | 672 673 674 675 676 677 678 679 680 681 682 683  | Next Page >

• Check value existance while performing a UPDATE query

  - by nimo

  Hi, I need to perform a simple update query where the update should only be done, if there is no value with updating value (item_name). For example, DB table [item_types] item_id(PK) | item_name Assuming there exist item_id with 6, My attempt is UPDATE item_types as k SET k.item_name = 'item_1' WHERE NOT EXISTS (SELECT * FROM item_types as a WHERE a.item_name = 'item_1') AND k.item_id = '6' But this gives me error "You can't specify target table 'k' for update in FROM clause" Could you please explain the error here and how can I achieve this ? Thank you

  Read the article

• CONCAT_WS rows in JOIN

  - by Alex Kiselev

  i have tables profiles (id, name, deleted) categories (id, name, deleted) profiles_categories (id, profile_id, category_id, , deleted) I have wrong query SELECT p.id, p.name CONCAT_WS(', ', c.name) AS keywords_categories FROM profiles p LEFT JOIN profiles_categories pc ON p.id = pc.profile_id LEFT JOIN categories c ON pc.id = c.id WHERE p.deleted = FALSE So, i want have result with all profiles with concan categories.name. Thanks

  Read the article

• Excluding records based upon a one to many SQL join

  - by tequila2k

  How would I write a SQL query that excludes a record if one (external) record from a one to many join matches a certain condition? For example: Details ID 1 2 Items DetailID Item 1 A 1 B 2 B 2 C How would I select the detail records where the Items do not include 'A'?

  Read the article

• Mysql Count

  - by Buda

  I have the following query: select MIN(q.a), * FROM ( sub-query1 ) as q UNION sub-query2 How can I return the number of elements in query1 as a row of master-query? If i use count (*) i´ve only the count CountElementSub-Query1 i need some like that rowA, rowB, rowC, CountElementSub-Query1 rowA, rowB, rowC, CountElementSub-Query1 rowA, rowB, rowC, CountElementSub-Query1 rowA, rowB, rowC, CountElementSub-Query1

  Read the article

• quickest way of deleting data from mysql

  - by every_answer_gets_a_point

  i am doing this: delete from calibration_2009 where rowid in (SELECT rowid FROM `qcvalues`.`batchinfo_2009` where reporttime like "%2010%"); i need to have about 250k rows deleted. why does it take such a long time? is there a quicker way to do this?

  Read the article

• Python BeautifulSoup Parse String

  - by user1159901

  string = ' onchange="_Pd.passAttr(this.value,'size','p0_v0_bd');" Select </option> size 6 </option> size 7 </option> size 9 </option> ' I want to extract a list [size 6, size 7, size 8]. How to do and thanks!

  Read the article

• Change query to use a LEFT join

  - by Craig

  I have a query which is failing, as it needs to be using LEFT JOIN, as opposed to the default INNER JOIN used by the 'join' syntax: var users = (from u in this._context.Users join p in this._context.Profiles on u.ProfileID equals p.ID join vw in this._context.vw_Contacts on u.ContactID equals vw.ID orderby u.Code select new { ID = u.ID, profileId = p.ID, u.ContactID, u.Code, u.UserName, vw.FileAs, p.Name, u.LastLogout, u.Inactive, u.Disabled }).ToList(); How would i re-write this so that is utilises a LEFT join?

  Read the article

• Connecting Id field with name field

  - by sts

  Hi, Am having a table with quetion_id , nominees and vote_count. In which the values for question_id and nominees are prepopulated from other tables with vote_count as zero. If the users select some nominees the vote count should be incresed by one. The problem is How to connect the question_id and nominees like for this question_id this nominee is selected . can some one give example for this situation..

  Read the article

• How do I take a slice of a list (A sublist) in scheme?

  - by troelskn

  Given a list, how would I select a new list, containing a slice of the original list (Given offset and number of elements) ? EDIT: Good suggestions so far. Isn't there something specified in one of the SRFI's? This appears to be a very fundamental thing, so I'm surprised that I need to implement it in user-land.

  Read the article

• List component to bring up InputText boxes

  - by user1760403

  I'm creating a list component with different numbers on each label ranging from 1 to 10. When clicked on a number I need it to bring up that many inputtext boxes one after another.. It's pretty much a multiplayer game that you select how many players are playing, then you input each name.. I'm so stuck it's ridiculous.. if anyone has a solution, or a different idea please help me out, thank you so much in advance.

  Read the article

• how to check log in mysql

  - by joe

  How would i monitor a MySQL to detect SELECTs which are running slowly? Having identified a poorly performing SELECT, how would i analyse it with a view to improving it?

  Read the article

• How do you query a MySQL table columns highest entry and store it in a variable.

  - by user315819

  How do you query a MySQL table columns highest entry and store it in a variable. Here is what I have but it is not working. $query = "SELECT MAX(date) FROM Records WHERE ips='$currentip'"; $result = mysql_query($query) or die(mysql_error()); echo $result;

  Read the article

• Can't create/write to file (Errcode: 22)

  - by magdmartin

  Quite new with SQL I'm looking to export some data from a MySQL database into a csv file. I'm working locally (localhost). Here is my SQL statement: SELECT DISTINCT * INTO OUTFILE 'C:\Users\Martin\Downloads\result.csv' FROM provider, location, provider_has_location WHERE provider.idprovider = provider_has_location.provider_idprovider AND location.idLocation = provider_has_location.location_idLocation LIMIT 20 MySQL return the following error: Can't create/write to file 'C:UsersMartinDownloads esult.csv' (Errcode: 22) Thanks for your help.

  Read the article

• calculate sum time with mysql

  - by kawtousse

  hi every one, RDBMS: mysql colonne names: Timefrom,timeuntill, timespent as the following type of the colonnes:Time. timefrom timeuntill timespent 10:00:00 12:00:00 02:00:00 08:00:00 09:00:00 01:00:00 how could i get the sum of the timespent. like this example it would be 03:00:00. when doing select sum(timespent) from mytable it display: 030000. please help. thanks.

  Read the article

• Does COUNT(*) always return a result?

  - by Click Upvote

  If a do a query such as: SELECT COUNT(*) as num FROM table WHERE x = 'y' Will it always return a result, even when the query doesn't match any record? Or do i need to validate and make sure a row is returned as the result?

  Read the article

• how should i get ONE row from mysql? ( fetch_array etc? )

  - by Haroldo

  I'm pretty sure i'm doing an extra loop here: $q = "SELECT * FROM genres WHERE genre.g_url = '$genre_url' LIMIT 1"; $res = mysql_query($q); while ($r = mysql_fetch_array($res, MYSQL_ASSOC)){ foreach( array_key_exists($r) as $k ){ $g[$k] = $r[$k]; } } return $g;

  Read the article

• Is there something in MySQL like IN but which uses AND instead of OR?

  - by Skatox

  I need a SQL statement to retrieve records where it key (or any column) is in a associate table, for example: documentId termId 4 1 4 2 3 3 5 1 This: SELECT documentId FROM table WHERE termId IN (1,2,3) ...will retrieve any documentid value where the termid value is 1 or 2 or 3. Is there something like this but return documentid values where the termid values are 1 and 2 and 3? Like an IN but with AND.

  Read the article

• Order results by another table?

  - by user3462020

  I'm working on a custom forum system and I'm trying to figure out how to put a thread on the top of the list if a user posts in it. I've got this for my query SELECT user_threads.threadID, user_threads.title, user_threads.uid, user_threads.postDate, thread_messages.posted FROM user_threads, thread_messages WHERE parent = :parent GROUP BY user_threads.title ORDER BY thread_messages.posted DESC Which doesn't appear to be working. if I post in a new thread, it remains where it is on the list.

  Read the article

• Search a full text index for 'c#'

  - by KKirk

  Hi I have a table (lets say it has one column called 'colLanguage') that contains a list of skills and has a full text index defined on it. One of the entries in the table is 'c#' but when I search for 'c#' (using the following SQL) I get no results back. select * from FREETEXTTABLE(tblList, colLanguage, 'c#') Can anyone help? Thanks K

  Read the article

• SQLite FTS3 sumulate LIKE somestrin%

  - by alex

  I'm writing a dictionary app and need to do the usual word suggesting while typing. LIKE somestrin% is rather slow (~1300ms on a ~100k row table) so I've turned to FTS3. Problem is, I haven't found a sane way to search from the beginning of a string. Now I'm performing a query like SELECT word, offsets(entries) FROM entries WHERE word MATCH '"chicken *"'; , then parse the offsets string in code. Are there any better options?

  Read the article

• Problem with PHP & MySQL

  - by Shahd

  I wrote this statements but it is not work :( ... can you tell me why? HTML: <form action="join.php" method="post"> <label name="RoomName">Room1</label> </form> PHP: $roomName = $_POST['RoomName']; $roomID = "SELECT RoomID FROM rooms WHERE RoomName = $roomName";

  Read the article

• SQL: column <> '%TEST%' does not work, why?

  - by Petr

  Hi, I do not understand why following code does not work? SELECT [column1], [column2] FROM table where Column1 <> ('%TEST%') ORDER BY 1 I want to have all rows where Column1 does not contain TEST Thanks

  Read the article

• MySQL Wildcards * and %

  - by RussellDias

  What is the difference between % and * wildcards in MySQL? In a query like so : "SELECT * FROM $table WHERE MATCH (message) AGAINST('$string*' IN BOOLEAN MODE)"

  Read the article

• What are JOINs in SQL (for)?

  - by sabwufer

  I have been using MySQL for 2 years now, yet I still don't know what you actually do with the JOIN statement. I really didn't come across any situation where I was unable to solve a problem with the statements and syntax I already know (SELECT, INSERT, UPDATE, ordering, ...) What does JOIN do in MySQL? (Where) Do I need it? Should I generally avoid it?

  Read the article

• [SQL server 2K] What is the impact coming from wildcard %

  - by user149578

  Hi guys: I need to add a new SELECT statement whose search condition include something like leagueCode='nba%'. I would like to know if the index against leagueCode is still exploitable or introduce any overhead after % is included in the target column.

  Read the article

< Previous Page | 672 673 674 675 676 677 678 679 680 681 682 683  | Next Page >