Search Results

Search found 36762 results on 1471 pages for 'common table expression'.

Page 282/1471 | < Previous Page | 278 279 280 281 282 283 284 285 286 287 288 289  | Next Page >

• How do I modify an attribute across all rows in a table?

  - by prgmatic

  Hi folks, My apologies for asking such a novice question but, I need help building a script using either PHP or directly in MySQL that can do the following: Take the values of a column in a table (text) Change them into capitalized words (from "this is a title" to "This Is A Title") Replace the old values (uncapitalized) with the new values (capitalized). Thanks for the help and support.

  Read the article

• How can I INSERT rows into a new table and update the primary key of the transported items?

  - by ggg

  The new table has an auto-increment that I want to use for the data that I'm transferring. Here is the query I want to run. INSERT INTO `xyz_1mydata` SELECT * FROM `xyz_1production` WHERE `xyz_1production.Id` > '12000'; I don't want to replace the existing items in #_1mydata.

  Read the article

• How do i select the 1st and then every 4th row in a html-table with nth-child()-selector?

  - by Nils

  Ok, math isn't my strong side, I admit it. All I want to do is to select the first, 5th, 9th, 13th, 17th etc row in a html-table. Can anybody with better math-skills point me in the right directionor perhaps supply a "nth-child-for-dummies" guide? I tried nth-child(1n+4) (which selects the 4th row and everyone after), and i also tried nth-child(0n+4) which selects the fourth row and nothing after that. Thanks in advance.

  Read the article

• How do I replicate a table to all nodes in a DB2 DPF instance?

  - by brianegge

  I have a dpf instance with a few large tables, which are partitioned, and a number of small tables which are not. I'd like the small table to fully exist on each node of the partition for performance reasons. How do I make db2 fully replicate these small tables to each node?

  Read the article

• IN MSSQL 2008 is there a way to generate a report as to how much space on disk each table takes?

  - by Matt

  IN MSSQL 2008 is there a way to generate a report as to how much space on disk each table takes? I can do it one by one by checking the storage properties, but I was wondering if there was a way, maybe even a query to generate such a report.

  Read the article

• Inability to delete table cells after a certain point.

  - by Sahil Lavingia

  I have built an app which has the ability to delete cells from a table, but only if there are more than two cells. If there are two or less cells, it only lets me select them. Any ideas? Here's a video to visualize it: http://slavingia.com/etc/helpme.mov

  Read the article

• How to create a database table in an installation file for a Drupal Module?

  - by Koning WWWWWWWWWWWWWWWWWWWWWWW

  I am creating a module for Drupal 7.x, and I want to create a database table when the module is installed (enabled for the first time). How can I do this? Thanks.

  Read the article

• Is it possible to alter the table in admin interface with SQL?

  - by Eric

  In our projects table we have every version of a project. Is it possible to show only those projects where max(version_id) in the admin interface? Thanks! :) Eric

  Read the article

• loading data from a flat file to table using informatica, having both english and foreign language c

  - by Manish

  I am loading data from a flat file to table using informatica, the file has both english and foreign language characters like chinese, and others. The foreign language characters are not getting displayed properly after loading. How can this problem be solved ? I could solve it by using code page UTF - 16 Encoding of Unicode Platform Endian, earlier i was using different code page UTF-8.

  Read the article

• How do map 1-to-1 relationship in grails to just 1 table under the covers?

  - by egervari

  Let's say I have a UserAccount domain class that has a UserPreferences domain class. I do this to separate the fields for organization purposes. Is there a way to tell grails/gorm that I really want it to map these domain classes to just the user_account table under the covers? Thanks!

  Read the article

• How to dump temporary MySQL table into a file?

  - by Alex N.

  Is there a way to create a dump/export/save a temporary MySQL table into a file on disk(.sql file that is, similar to one that is created by mysqldump)?

  Read the article

• how to insert an integer value from a Grid to Sql table?

  - by z-chaos

  Hi, I have a AdvWebGrid where the 7th coloumn is DynEdit where user will enter the value.Now I have to take the enetered value and insert into the Sql tablel. For example i have 7 records in the grid the user will enter some comments for the first three record and save.Now i have to insert/update the first three comments in the table.

  Read the article

• how to run Make table query that i have in access in C# code ?

  - by Gold

  hi i have query (DO2) in access that makes a table and inserting any data. how to run this query in C# code ? i try this: SQL = "Select * from DO2"; Cmd = new OleDbCommand(SQL, Conn); Cmd.ExecuteNonQuery(); Cmd.Dispose(); but i get error

  Read the article

• Cocoa: how to nest a button inside a Table View cell?

  - by underthetable

  Take a look at the top pane of the Xcode window. There's a table list, with checkboxes in one of the columns. That's the interface I want to do. So how do you nest a button in an NSTableView cell?

  Read the article

• How to use PHP Load Data Infile to replace the current copy of the table with the new one?

  - by NJTechGuy

  We get a new copy of data in a pipe-delimited text file from time to time. I have to refresh the table or in other words, replace the existing copy with that of the newly generated copy (output.txt). Any ideas are highly appreciated. Thank you..

  Read the article

• C# SQL: What is the best way to implement a dynamic table?

  - by SirMoreno

  I want to allow the user to add columns to a table in the UI. The UI: Columns Name:__ Columns Type: Number/String/Date My Question is how to build the SQL tables and C# objects so the implementation will be efficient and scalable. My thought is to build two SQL tables: TBL 1 - ColumnsDefinition: ColId, ColName, ColType[Text] TBL 2 - ColumnsValues: RowId, ColId, Value [Text] I want the solution to be efficient in DB space, and I want to allow the user to sort the dynamic columns. I work on .NET 3.5 MSSQL 2008. Thanks.

  Read the article

• How do I make a table from a List MVC?

  - by user54197

  I have a List(Name, Item, Group#) that I would like to display in a table. How do I display this data with all the names in the 1st row, item in the 2nd, and group number in the 3rd row. Name: | Jon | Tom | Kate | Brian | Item: | Cup | Hat | Door | Store | Group#:| 2 | 8 | 10 | 154 |

  Read the article

• How to bind DataGrid to display only 25 records of a table having more than 1000 records ..??

  - by Devashri

  I have a datagrid control which is bound to a table which containing more than 1000 records. And i want to show only 25 records once a time. I have used paging in datagrid. But each time the next page index is set, query is fired again. This takes lots of time. So what is the easiest way to bound data in this case to improve performance..??

  Read the article

• SQL Server: Is it possible to get procedure or table creation and last alter date?

  - by Woland

  SQL Server: is it possible to get procedure or table creation and last alter date? If it is then how do to it? SQL Server 2005

  Read the article

• MySQL Sub-query.. Doesn't provide proper information after 3 entries into table.

  - by Chris Keefer

  After I get 3 rows in my forum_threads table this no longer does it's job; to organize a list of active forum threads and put the most recently responded-to thread at the top of the list, followed by second most recent posted-to thread, followed by third, fourth, etc. Like I said, the query works wonders up until there is a fourth row added to forum_threads. SELECT forum_threads.*, forum_posts.thread_id FROM forum_threads INNER JOIN (SELECT MAX(id) AS id, thread_id as thread_id FROM forum_posts group by thread_id order by id DESC) forum_posts ON forum_threads.id = forum_posts.thread_id

  Read the article

• Is there was way to get the leftmost column in a Google visualization table to stay fixed while side

  - by Ben

  I'd looking to emulate the standard google visualization table header row behavior, but have it apply to the first column. This doesn't seem to be a built-in feature, but I'm wondering if it can be accomplished with some custom CSS?

  Read the article

• What is the cleanest way to sort "describe table" query results ?

  - by Youssef AZARI

  Hello everyone, I'm working on "describe table" output to show a list of fields and their types, i want my primary keys to be at top of the list.. I think there's no way to sort describe's results using SQL (something like 'order by') rather than sorting it in PHP. what do you think guys ? thanks

  Read the article

• Postgresql: how to create table only if it does not already exist?

  - by Fredriku73

  I am totally new to postgresql. How can I do a condition to create a table only if it does not already exists? Code example appreciated.

  Read the article

• How to recover data from a table, and store that into list?

  - by Wilhelm

  How can I get ALL the data from a table of my DB (mySQL) using hibernate, and store the output into List of Objects? I'll use this List, to populate a JTable.

  Read the article

• Zend Framework: How to subtract amount from database table field ?

  - by NAVEED

  I want to subtract a amount from a table's field in Zend Framework. I can run it with SQL using following query: UPDATE `Person` SET credit=credit-50 where id=1 But how to write above SQL query in Zend Framework?

  Read the article

< Previous Page | 278 279 280 281 282 283 284 285 286 287 288 289  | Next Page >