Search Results

Search found 25640 results on 1026 pages for 'alter table'.

Page 5/1026 | < Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >

• Create user in Oracle 11g with same priviledges as in Oracle 10g XE

  - by Álvaro G. Vicario

  I'm a PHP developer (not a DBA) and I've been working with Oracle 10g XE for a while. I'm used to XE's simplified user management: Go to Administration/ Users/ Create user Assign user name and password Roles: leave the default ones (connect and resource) Privileges: click on "Enable all" to select the 11 possible ones Create This way I get a…

  Read the article

• Inheritance Mapping Strategies with Entity Framework Code First CTP5: Part 2 – Table per Type (TPT)

  - by mortezam

  In the previous blog post you saw that there are three different approaches to representing an inheritance hierarchy and I explained Table per Hierarchy (TPH) as the default mapping strategy in EF Code First. We argued that the disadvantages of TPH may be too serious for our design since it results in denormalized schemas that can become a major…

  Read the article

• How to delete child table records during the update of parent table using Hibernate

  - by Harsha

  I have a Parent Table A and child tables B,C with many to one relations. Lets say I have data like, for primary key 1 in parent table A I have 3 rows in child table B and 4 rows in child table C. Now if I want to delete the rows of the child table during an update of the parent table(that means Now, I want to update the table only with one row…

  Read the article

• How to convert a table column to another data type

  - by holden

  I have a column with the type of Varchar in my Postgres database which I meant to be integers... and now I want to change them, unfortunately this doesn't seem to work using my rails migration. change_column :table1, :columnB, :integer So I tried doing this: execute 'ALTER TABLE "table1" ALTER COLUMN "columnB" TYPE integer USING CAST(columnB…

  Read the article

• INSERT 0..n records into table 'A' based on content of table 'B' in MySql 5

  - by Robert Gowland

  Using MySql 5, I have a task where I need to update one table based on the contents of another table. For example, I need to add 'A1' to table 'A' if table 'B' contains 'B1'. I need to add 'A2a' and 'A2b' to table 'A' if table 'B' contains 'B2', etc.. In our case, the value in table 'B' we're interested is an enum. Right now I have a stored…

  Read the article

• mysql master slave "table already exists" but table not exists

  - by Korjavin Ivan

  I have 1 master mysql process, and 2 slave. Today on both slaves i see : Error 'Table 'bgbilling.contract_status_balance_dump' already exists' on query. Default database: 'bgbilling'. Query: 'CREATE TABLE contract_status_balance_dump( UNIQUE(cid) ) SELECT cid, MAX(yy*12+(mm-1))%12 + 1 AS mm,FLOOR(MAX(yy*12+(mm-1)) / 12) AS yy FROM…

  Read the article

• Vaadin table hide columns and container customization

  - by Alex

  Hello I am testing a project, using Vaadin and Hibernate. I am trying to use the HbnContainer class to show data into table. The problem is that I do not want to show all the properties of the two classes in the table. For example: @Entity @Table(name="users") class User { @Id @GeneratedValue(strategy=GenerationType.AUTO) private…

  Read the article

• Dojo Table not Rendering in IE6

  - by Mike Carey

  I'm trying to use Dojo (1.3) checkBoxes to make columns appear/hide in a Dojo Grid that's displayed below the checkBoxes. I got that functionality to work fine, but I wanted to organize my checkBoxes a little better. So I tried putting them in a table. My dojo.addOnLoad function looks like this: dojo.addOnLoad(function(){ …

  Read the article

• How to resize table via javascript in IE?

  - by MartyIX

  I've got this table: <table id="correctness" style="overflow: hidden;"> <tr><td style="overflow: hidden;"> <div id="correctness-message"></div> <span class="hide"> <button type="button" class="hide" onclick="new DisplayEffect('correctness').Hide(500);">Hide</button> …

  Read the article

• When to use SQL Table Alias

  - by Rossini

  I curious to know how people are using table alias. The other developers where I work always use table alias, and always use the alias of a, b, c, ect. Here's an example SELECT a.TripNum, b.SegmentNum, b.StopNum, b.ArrivalTime FROM Trip a, Segment b WHERE a.TripNum = b.TripNum I disagree with them, and think…

  Read the article

• Adjust width of td to make make row widths even

  - by user1729886

  I am trying to produce a table with a different number of cells in each row. The first row is a header row (every other row contains cells). This header is the width of the table. The second row has 2 cells in it... the third has 1 cell... the fourth has 4 cells... the fifth and final row has 3 cells. I…

  Read the article

• Can we solve the table row background image problem, in chrome, in multi celled tables??

  - by Ya'el

  It is frequently asked – but I haven’t seen a good answer yet (and I looked). If you set a background image in CSS to a table row- the image will repeat itself in every cell. If you set the position: relative (for the row) and set the background-image: none (for the cells) it solves the problem on IE but not…

  Read the article

• Insert Query for table

  - by shanks

  How to add data from one table to another table with new data in sql

  Read the article

• Using list() to extract a data.table inside of a function

  - by Nathan VanHoudnos

  I must admit that the data.table J syntax confuses me. I am attempting to use list() to extract a subset of a data.table as a data.table object as described in Section 1.4 of the data.table FAQ, but I can't get this behavior to work inside of a function. An example: require(data.table) ## Setup some…

  Read the article

• HTML Email template Table help needed

  - by user1870691

  I need help setting up an email newsletter template as one of the columns is not being displayed properly, the column containing heading 2 is not being displayed properly it is being displayed towards right side of the page instead of aligning with the template elements. Here is the code: <!DOCTYPE…

  Read the article

• sfdisk restore partition table if two hardisk have different sizes

  - by MA1

  What will happen if i try to restore the partition table of a larger hard disk to smaller hard disk, for example: partition table of 250GB hard disk to a 80GB hard disk using sfdisk like this. sfdisk /dev/sda < PartitionTable250.txt Will sfdisk detect it? I think there will be no problem if the…

  Read the article

• Is there a way to model table inheritance using MySQL Workbench?

  - by Wraith

  Is there a way to model table inheritance using MySQL Workbench? I'd like the ERD to look similar to the left side of this image:

  Read the article

• Jquery Session & Table Filtering

  - by Bry4n

  This is my Jquery <script type="text/javascript"> $(function() { var from = $.session("from"); var to = $.session("to"); var $th = $('#theTable').find('th'); // had to add the classes here to not grab the "td" inside those tables var $td =…

  Read the article

• IE8 isn't resizing tbody or thead when a column is hidden in a table with table-layout:fixed

  - by tom

  IE 8 is doing something very strange when I hide a column in a table with table-layout:fixed. The column is hidden, the table element stays the same width, but the tbody and thead elements are not resized to fill the remaining width. It works in IE7 mode…

  Read the article

• How to get the text content on the swt table with arbitrary controls

  - by amarnath vishwakarma

  I have different controls placed on a table using TableEditor. ... TableItem [] items = table.getItems (); for (int i=0; i<items.length; i++) { TableEditor editor = new TableEditor (table); final Text text1 = new Text (table, SWT.NONE); …

  Read the article

• HTML prevent line break (between two table tags)

  - by arik-so

  Hello, I have following code: <table> <tr> <td>Table 1</td> </tr> </table> <table> <tr> <td>Table 2</td> </tr> </table> Very…

  Read the article

• Master Page: Dynamically Adding Rows in ASP Table on Button Click event

  - by Vincent Maverick Durano

  In my previous post here, I wrote an example that demonstrates how are we going to generate table rows dynamically using ASP Table on click of the Button control. Now based on some comments in my previous example and in the forums…

  Read the article

• How do you make a CSS-defined table-cell scroll?

  - by Giffyguy

  I want to be able to set the height of the table, and force the cells to scroll individually if they are larger than the table. Consider the following code: (see it in action here) <div style="display: table; position:…

  Read the article

• How do you make a CSS-defined table-cell scroll?

  - by Giffyguy

  I want to be able to set the height of the table, and force the cells to scroll individually if they are larger than the table. Consider the following code: (see it in action here) <div style="display: table; position:…

  Read the article

• Rotate Windows.Documents.Table

  - by Neverrav

  I need to rotate a table clockwise up to 90 degrees. It's one of the blocks of a FlowDocument. Is there a way to apply some kind of rotation to a Table? The possible solution of creating TextEffect like this: var table…

  Read the article

< Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >