Search Results

Search found 11644 results on 466 pages for 'column defaults'.

Page 280/466 | < Previous Page | 276 277 278 279 280 281 282 283 284 285 286 287  | Next Page >

• batch update mysql table

  - by Yang

  I have a table with a column called time, "HH:MM:SS". How can I do a batch update so that the value increment by 1 hour? Is it something like: update <table_name> set <time_column> = <time_column> + 3600 where ...

  Read the article

• postgresql drop table

  - by Russell

  I have two tables (tbl and tbl_new) that both use the same sequence (tbl_id_seq). I'd like to drop one of those tables. On tbl, I've removed the modifier "not null default nextval('tbl_id_seq'::regclass)" but that modifier remains on tbl_new. I'm getting the following error: ERROR: cannot drop table tbl because other objects depend on it DETAIL: default for table tbl_new column id depends on sequence tbl_id_seq After reviewing http://www.postgresql.org/docs/9.1/static/sql-droptable.html It looks like there is only CASCADE and RESTRICT as options.

  Read the article

• what does 'legend' mean in sql?

  - by every_answer_gets_a_point

  im doing some practice sql problems one of the questions is: Prepare a shipping statement for customer 'C001' it should show the date, the legend 'Delivery' and the total value of the products shipped on each day. 'delivery' is not a table nor is it a column in any table. what does legend mean??

  Read the article

• how to implement multivalued attribute in oracle ?

  - by Vishwanath dalvi

  I want to store more than 1 Email ides in Email id Column of table as multivalued attribute .. hoW can i do this in oracle ?

  Read the article

• Gnuplot - splot matrix csv data

  - by Jakub Czaplicki

  How can I plot (a 3D plot) a matrix in Gnuplot having such data structure. I cannot find a way to use the first row and column as a x and y ticks (or to ignore them) ,5,6,7,8 1,-6.20,-6.35,-6.59,-6.02 2,-6.39,-6.52,-6.31,-6.00 3,-6.36,-6.48,-6.15,-5.90 4,-5.79,-5.91,-5.87,-5.46 Is the splot 'data.csv' matrix the correct parameter to use ?

  Read the article

• sort arrow is always showing up once sorting is used

  - by kksachin

  we have several pages as tabs where datatable is used in most of the pages.when we sort on a particular coulmn and exit the page and re enter this page the arrow appears(up /down based on how we left) Although the data is not sorted in the direction the arrow shows.i have set preserveSort and preserveDataMode to false. The arrow is set to true in the column's t:commandSortHeader tag in all the pages. is this a bug or am i missing any setting?I have tried to set forceId to false in t:commandSortHeader but of now use.

  Read the article

• Is it possible to plot a single density over a discrete variable?

  - by mattrepl

  The x-axis is time broken up into time intervals. There is an interval column in the data frame that specifies the time for each row. Plotting a histogram or line using geom_histogram and geom_freqpoly works great, but I'd like to use geom_density to get a filled area. Perhaps there is a better way to achieve this. Right now, if I use geom_density, curves are created for each discrete factor level instead of smoothing over all of them.

  Read the article

• How do you read a cell's value from an OpenOffice Calc .ods file with python?

  - by user329257

  I have been able to read an excel cell value with xlrd using column and row numbers as inputs. Now I need to access the same cell values in some spreadsheets that were saved in .ods format. So for example, how would I read the value stored in cell E10 from a .ods file from python?

  Read the article

• Determine stale data

  - by Andrei

  Say I have a file of this format 12:04:21 .3 12:10:21 1.3 12:13:21 1.4 12:14:21 1.3 ..and so on I want to find repeated numbers in the second column for, say, 10 consequent timestamps, thereby finding staleness. and I want to output the beginning and and end of the stale timestamp range Can someone help me come up with it? You can use awk, bash Thanks

  Read the article

• Windows thinks outgoing connections are incoming connections?

  - by Slayer537

  I have a rather weird issue.. I'm trying to configure Windows Firewall to block all outgoing connections to a certain app, but allow all incoming. This app is used to transfer files across a network. The reason for this type of setup is to only allow certain users (IP Address) access to the files I have, but to still allow others to see what's available. Since Windows Firewall defaults to allowing all outgoing connections, I made a rule to deny all outgoing connections that were not in the IP ranges I specified. For the incoming connections, I'd like to leave it at allow all, but at the moment it is set to only allow the connections that also have outgoing permissions set. If I blanket say allow all incoming connections, I observe that unauthorized IP Address are able to actually download files, even though their IP was blocked in the outgoing connections. To shed a little more visibility on this, I used NetLimiter to see what was going on. NetLimiter showed me that the connection was an incoming connection. Shouldn't this be an outgoing connection, as I am uploading files to them, not the other way around? Is there a way to make the connection type be correct and show up as outgoing instead of incoming?

  Read the article

• In sql server, is there any way to check whether the schema change will impact on the stored procs?

  - by ziang

  In SQL Server, is there any way to check whether the changes in the schema will impact Stored Procedures (and/or Views)? For example a change of the column name in one table, may break some Stored Procedures; how to check the impacted stored procs?

  Read the article

• Crystal reports CSV incorrect generation

  - by yauhen

  When setting ExportFormatType.CharacterSeparatedValues crystal report generates every row of data prefixed with column names (Report Headers). Why it does this? How it could be fixed? Usually it is preferred to have single header. For excel export type - generated report looks ok (only single header for all rows). I am using crystal reports 11.5.3700.0. Visual studio 2008, .net 3.5 sp1

  Read the article

• How to SELECT the last 10 rows of an SQL table which has no ID field?

  - by Edward Tanguay

  I have an MySQL table with 25000 rows. This is an imported CSV file so I want to look at the last ten rows to make sure it imported everything. However, since there is no ID column, I can't say: SELECT * FROM big_table ORDER BY id DESC What SQL statement would show me the last 10 rows of this table? The structure of the table is simply this: columns are: A, B, C, D, ..., AA, AB, AC, ... (like Excel) all fields are of type TEXT

  Read the article

• Ruby: Dynamically calling available methods raising undefined method (metaprogramming)

  - by user94154

  I have an Activerecord object called Foo: Foo.attribute_names.each do |attribute| puts Foo.find(:all)[0].method(attribute.to_sym).call end Here I'm calling all attributes on this model (ie, querying for each column value). However, sometimes, I'll get an undefined method error. How can ActiveRecord::Base#attribute_names return an attribute name that when converted into its own method call, raises an undefined method error? Thank

  Read the article

• Can I create a table with check constrain whose values are dependent on sql query

  - by Shantanu Gupta

  Is it possible to create a table which has a check constraint on one of the column whose value lies within the result set given by another sql query eg. create table tablename ( name varchar(10), rollno int )check rollno in (select rollno from anotherDatabase.TableName,candidateRoll) or any thing like that. I dont have to use it anywhere but still want to know.

  Read the article

• Arrangement of n objects in a n x n square

  - by Hwang

  if have multiples object, how to arrange it so that each number of object in row x column will form a near square? exp:14 objects arrange to something like this: 0 0 0 0 0 0 0 0 0 0 0 0 0 0

  Read the article

• What's making my page extend slightly beyond the viewport? [CSS]

  - by Jack W-H

  Basically I'm a tad confused. You'll see at http://furnace.howcode.com , in the second column, the bottom scrollbar button is extended slightly beyond the end of the viewport. I'm pretty confused as I've been examining the CSS and can't find anything that's causing this. Can you have a look? It's probably something simple that I've just missed! :) Screenshot:

  Read the article

• Developing iPhone Application, How do i get video "length" from a video saved to my app docs folder?

  - by mrburns05

  Basically i record / import video , it saves to the docs folder and im trying to figure out how to get the length (time) so i can display it for each individual video.. I have a column in the database for it and the neccessary code to display it, just not sure how to get it.. Any help is greatly appreciated

  Read the article

• ASP.NET site errors output nothing on the page.

  - by d1k_is

  OK, i have been doing some work modding a pre-compiled ASP.NET application (VB codebehind) but i have come across something i have never seen before. When ever theres an error on the loading of a page, the page outputs nothing (no error message, no error message, nothing at all) firefox displays this error: XML Parsing Error: no element found Location: http://site.local/Checkout.aspx Line Number 1, Column 1: Because there is no html output. Is there some sort of setting that im missing that makes IIS/ASP.NET function like this?

  Read the article

• solr range query errors

  - by mquinsland

  http://localhost:8983/solr/select?wt=json&q=lat:[35%20to%2038] results in **org.apache.lucene.queryParser.ParseException: Cannot parse 'lat:[35 to 38]': Encountered " "38 "" at line 1, column 11. Was expecting: "]" This is a pretty basic range query and this error will prevent us from using SOLR for our projects

  Read the article

• PostgreSQL: Why does this simple query not use the index?

  - by David

  I have a table t with a column c, which is an int and has a btree index on it. Why does the following query not utilize this index? explain select c from t group by c; The result I get is: HashAggregate (cost=1005817.55..1005817.71 rows=16 width=4) -> Seq Scan on t (cost=0.00..946059.84 rows=23903084 width=4) My understanding of indexes is limited, but I thought such queries were the purpose of indexes.

  Read the article

• How to keep subtree removal (`rm -rf`) from starving other processes for Disk I/O?

  - by David Eyk

  We have a very large (multi-GB) Nginx cache directory for a busy site, which we occasionally need to clear all at once. I've solved this in the past by moving the cache folder to a new path, making a new cache folder at the old path, and then rm -rfing the old cache folder. Lately, however, when I need to clear the cache on a busy morning, the I/O from rm -rf is starving my server processes of disk access, as both Nginx and the server it fronts for are read-intensive. I can watch the load average climb while the CPUs sit idle and rm -rf takes 98-99% of Disk IO in iotop. I've tried ionice -c 3 when invoking rm, but it seems to have no appreciable effect on the observed behavior. Is there any way to tame rm -rf to share the disk more? Do I need to use a different technique that will take its cues from ionice? Update: The filesystem in question is an AWS EC2 instance store (the primary disk is EBS). The /etc/fstab entry looks like this: /dev/xvdb /mnt auto defaults,nobootwait,comment=cloudconfig 0 2

  Read the article

• nginx not starting at reboot after gitlab installation

  - by Luis Masuelli

  I installed nginx (1.6) in ubuntu server (14.04). After that, I installed gitlab. I didn't realize it came with its own nginx. I uninstalled gitlab later. After installing gitlab, my first nginx began to never start at boot as a service. This means: If I hit sudo netstat -anp I don't see the corresponding entry in 0.0.0.0:80. If I hit sudo nginx -s reload and then sudo netstat -anp I see the corresponding entry I mentioned. I thought I could fixing it by doing: sudo update-rc.d nginx remove sudo update-rc.d nginx defaults After removing gitlab, but it did not help me (i.e. after reboot, nginx does not automatically start). I revised the /etc/init.d/nginx just to see that $DAEMON is still /usr/sbin/nginx. Question: What should I check to see the problem here (or: what could the problem be)? sudo nginx -s reload works with no problems at all.

  Read the article

• MySQL More Tables or More Rows

  - by Pez Cuckow

  I am working on a game that I am going to open to the public to have on their game. The game stores lots of information (about 300 rows) per website and spends a lot of time updating values within this MySQL database. Is it better (faster/efficient) to add a new table for every website or to just have 1000's of rows in one table and add a column "website_id" or similar?

  Read the article

• Unique Constraint At Data Level in GAE

  - by Ngu Soon Hui

  It seems that the unique constraint is not natively supported in GAE, although one can enforce unique check before putting an object to store. But that was in January 2009, what about now? Can I specify unique constraint on a column during schema creation? i.e. class Account(db.Model): name = db.StringProperty() email = db.StringProperty() as unique # something like this @classmethod def create(cls, name, email): a = Account(name=name, email=email) a.put() return a

  Read the article

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