Search Results

Search found 10060 results on 403 pages for 'column'.

Page 58/403 | < Previous Page | 54 55 56 57 58 59 60 61 62 63 64 65  | Next Page >

• MySQL - get all unique values of a column, check if has a specific value

  - by gamers2000

  First off - apologies for the poor title, I have no idea how to describe it in a one-liner. I have a table - snippet is below. mysql> select * from playlistfiles; +-----------------------+--------------+-----------+ | FileName | PlaylistName | FileIndex | +-----------------------+--------------+-----------+ | File1 …

  Read the article

• SQL for sorting boolean column as true, null, false

  - by petehern

  My table has three boolean fields: f1, f2, f3. If I do SELECT * FROM table ORDER BY f1, f2, f3 the records will be sorted by these fields in the order false, true, null. I wish to order them with null in between true and false: the correct order should be true, null, false. I am using PostgreSQL.

  Read the article

• sql jdbc getgeneratedkeys with mysql returns column "id" not found

  - by iamrohitbanga

  I want to retrieve the most recently updated value in the table using an insert query. these are the datatypes in my sql table. int(11) // primary key auto increment, not being assigned by sqlQuery varchar(30) timestamp // has a default value. but i am explicit assigning it using CURRENT_TIMESTAMP varchar(300) varchar(300) varchar(300) …

  Read the article

• How do I update a column in 3rd row the same as a column in 2nd row in MySQL?

  - by user198729

  I'm doing it this way,but get an error: mysql> update products set products_image=(select products_image from products where products_id=2) where products_id=3; ERROR 1093 (HY000): You can't specify target table 'products' for update in FROM clause

  Read the article

• Rearrange a python list into n lists, by column

  - by Ben R

  Trying to solve this at this hour has gotten my mind into a tail-spin: I want to rearrange a list l into a list of n lists, where n is the number of columns. e.g., l = [1,2,3,4,5,6,7,8] n = 5 ==> [[1,6][2,7][3,8][4][5]] another example: l = [1,2,3,4,5,6,7,8,9,10] n = 4 ==> [[1,5,9],[2,6,10],[3,7][4,8] Can someone please help me…

  Read the article

• Get row where datetime column = today - SQL server noob

  - by Chin

  In sql 2005, instead of building a query from dateparts year, month and date, is there an more succinct way of writing the where clause? many thanks

  Read the article

• T-SQL Query, combine columns from multiple rows into single column

  - by Shayne

  I have seeen some examples of what I am trying to do using COALESCE and FOR XML (seems like the better solution). I just can't quite get the syntax right. Here is what I have (I will shorten the fields to only the key ones): Table Fields ------ ------------------------------- Requisition ID,…

  Read the article

• Update a column based on a field from another table

  - by Sergio

  Hi: I'd like to update values in one table based on corresponding values from other tables. Say you want to update prices of pieces provided by one specific manufacturer whose name is in the table Manufacturers with the Pieces table containing only the id of the manufacturer. I've seen several solutions for MySQL here and for MS SQL Server…

  Read the article

• SQLite SQLite column can't be updated to any value but zero (real type)

  - by user1065320

  Hi I'm trying to create a three fields table (date,text,real), I can insert and update the first two fields but can't set or update the last one. createSQL = @"CREATE TABLE IF NOT EXISTS ACTIVITIES (MYDATE DATETIME PRIMARY KEY, ACTIVITY TEXT , LENGTH REAL);"; try to insert char *update = "INSERT OR REPLACE INTO ACTIVITIES (MYDATE,…

  Read the article

• Creating an Order Column for encrypted data

  - by SetiSeeker

  I am saving encrypted data to a database. Is there a way I can create a "hashcode" or fingerprint or checksum of the plain text data, that if I sort / order by on the "hashcode" the order would be the same as if I had saved the plain text data and perform the same sort / order by operation on it? I basically need a SOUNDEX() type…

  Read the article

• row number over text column sort

  - by Marty Trenouth

  I'm having problems with dynamic sorting using ROW Number in SQL Server. I have it working but it's throwing errors on non numeric fields. What do I need to change to get sorts with Alpha Working??? ID Description 5 Test 6 Desert 3 A evil Ive got a Sql Prodcedure CREATE PROCEDURE [CRUDS].[MyTable_Search] --…

  Read the article

• Why MySQL multiple-column index is overpopulated?

  - by actual

  Consider following MySQL table: CREATE TABLE `log` ( `what` enum('add', 'edit', 'remove') CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `with` int(10) unsigned NOT NULL, KEY `with_what` (`with`,`what`) ) ENGINE=InnoDB; INSERT INTO `log` (`what`, `with`) VALUES ('add', 1), ('edit', 1), ('add', 2), …

  Read the article

• Get row where date column = today - SQL server noob

  - by Chin

  In sql 2005, instead of building a query from dateparts year, month and date, is there an more succinct way of writing the where clause? many thanks

  Read the article

• MySQL: Ignore a selected column when using DISTINCT

  - by John Leonard

  Let's say: I want to query colA, colB and colC in my table. I want to see DISTINCT values but I don't want colA to be a criteria for distinction. Omitting colA isn't an option. What's the best way to structure that query?

  Read the article

• c# finding matching words in table column using Linq2Sql

  - by David Liddle

  I am trying to use Linq2Sql to return all rows that contain values from a list of strings. The linq2sql class object has a string property that contains words separated by spaces. public class MyObject { public string MyProperty { get; set; } } Example MyProperty values are: MyObject1.MyProperty = "text1 text2 text3…

  Read the article

• MySQL: SELECT highest column value when WHERE finds similar entries

  - by Ike

  My question is comparable to this one, but not quite the same. I have a database with a huge amount of books, with different editions of some of the same book titles. I'm looking for an SQL statement giving me the highest edition number of each of the titles I'm selecting with a WHERE clause (to find specific book series).…

  Read the article

• Hibernate, select by id or unique column

  - by Nican

  I am using hibernate for Java, and I want to be able to select users by id or by name from the database. Nice thing about Hibernate is that it caches the result by id, but I seem to be unable to make it cache by name. static Session openSession = Factory.openSession(); public static User GetUser(int Id) { return…

  Read the article

• Unit Testing a CSV Parser and Column Mapping Tool

  - by PieterG

  I am really starting to enjoy unit testing and have the following question to the gurus of unit testing. Let's for example say I have the following class public class FileMapper { public Dictionary<string, string> ReadFile(string filename, string delimeter){} } How do you guys generally go about unit…

  Read the article

• A column of a table needs to stay in one line (HTML/CSS/Javascript)

  - by Julien

  Hi Folks ! So I am having an issue on my entrepreneur business opportunity rating matrix : I would like the radio buttons to stay on the same line. The problem is that I don't know how I should process because if I give a fixed minimum width for the cell, i'm not sure it will display properly on other browsers,…

  Read the article

• column data in tooltip overflows.

  - by xrx215

  I want to show the data in the tooltip when a columns has long sentences because of width constrints. for this i am using a renderer function as follows { header: xppo.st('SDE_INCIDENT_DESCRIPTION1'), width: 175, sortable: true, groupable: false, dataIndex: 'IncidentDescription', renderer: function(value,…

  Read the article

• Multiple column subselect in mysql 5 (5.1.42)

  - by rubber boots

  This one seems to be a simple problem, but I can't make it work in a single select or nested select. Retrieve the authors and (if any) advisers of a paper (article) into one row. I order to explain the problem, here are the two data tables (pseudo) papers (id, title, c_year) persons (id, firstname, lastname)…

  Read the article

• Selecting rows from DataTable by DateTime column (hours)

  - by nCdy

  DatarowsForOneDay = dt.Select( dt.Columns[0].Caption + "='" + x.ToString("dd/MM/yyyy HH") + "'"); doesn't work, but DatarowsForOneDay = dt.Select( dt.Columns[0].Caption + "='" + x.ToString("dd/MM/yyyy") + "'"); works. So how can I select the date with a same hour? Variable x type is DateTime.

  Read the article

• join 3 files by first Column with awk ?

  - by noinflection

  i have three similar files, they are all like this: File A ID1 Value1a ID2 Value2a . . . IDN Value2n and i want an output like this Output ID1 Value1a Value1b Value1c ID2 Value2a Value2b Value2c ..... IDN ValueNa ValueNb ValueNc Looking to the first line, i want value1A to be the value of id1 in…

  Read the article

• ndarray field names for both row and column?

  - by Graham Mitchell

  I'm a computer science teacher trying to create a little gradebook for myself using NumPy. But I think it would make my code easier to write if I could create an ndarray that uses field names for both the rows and columns. Here's what I've got so far: import numpy as np num_stud = 23 num_assign = 2 grades…

  Read the article

• Unique constraint with nullable column

  - by Álvaro G. Vicario

  I have a table that holds nested categories. I want to avoid duplicate names on same-level items (i.e., categories with same parent). I've come with this: CREATE TABLE `category` ( `category_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `category_name` varchar(100) NOT NULL, `parent_id` int(10)…

  Read the article

< Previous Page | 54 55 56 57 58 59 60 61 62 63 64 65  | Next Page >