sql - Altering my datatypes in SQLite -

-

i following sqlite tutorial goal create simple student database uml diagram.

so lately i'm going through hell trying figure out how alter data types , hoped help. i'll post same question posted instructor.

unfortunately, messed on datatypes when trying follow instructor. video, if helps, can found here: http://www.youtube.com/watch?v=07nbszniwu8

++begin transcript++

thanks far, seems have mystery. first thing did copy uml, took break. upon return, figured i'd started uml while reloading video, first things did create student , sex_type table so:

sqlite> create table student(name varchar(23),    ...> sex character(1),    ...> id_number integer primary key);  sqlite> create table sex_type(sex_id text primary key, sex_type integer);

but realized, "oops forgot indicated want sex_id not null well."

"i'm forgot under ensure foreign key(sex) references sex_type(sex_id)."

so thought, reviewed sql books, , recalled known alter command. however, no matter how slice it, along these lines:

sqlite> alter table sex_type modify column sex_id text primary key not null;  error: near "modify": syntax error  sqlite> alter table sex_type change column sex_id text primary key not null;**  error: near "change": syntax error  sqlite> alter table sex_type drop sex_id;  error: near "drop": syntax error

always same supposed syntax error. thing has worked tonight:

sqlite> alter table sex_type rename gender;  sqlite> alter table gender_id rename sex_type;

so syntax error i'm overlooking, because going books syntax should fine. have insert these columns before modification can done (which admittedly, haven't tried yet)? or missing obvious alter/modify/change/drop command(s)?

sqlite's support alter table pretty limited, including rename to , add_column. you're getting syntax errors because you're issuing command that's not supported.

if don't have data lose, might better of dropping , recreating table.

if have data lose, might better off renaming table , creating replacement using insert select, seen in this example.


Comments

Post a Comment

Popular posts from this blog

python - Subclassed QStyledItemDelegate ignores Stylesheet -

-
i'm trying subclass qstyleditemdelegate remove focus rectangle in qcombobox . even though i'm calling base implementation of paint function , nothing else, result different. looks if parts of style-sheet influence bounding box of item taken consideration. class pstyleditemdelegate(qstyleditemdelegate): def __init__(self, *args, **kwds): super(pstyleditemdelegate, self).__init__(*args, **kwds) def paint(self, *args, **kwargs): qstyleditemdelegate.paint(*args, **kwargs) what have paint unmodified qstyleditemdelegate ? as suggested tried replacing pyside pyqt4 , works, appears bug. update pyside 1.1.2 1.2.1 result same. unfortunately switch breaks other parts of code, if there no other suggestions i'm going accept answer. edit bug tracked here
Read more

java - HttpClient 3.1 Connection pooling vs HttpClient 4.3.2 -

-
i have used httpclient3.1(java) connection pooling below : import org.apache.commons.httpclient.httpclient; import org.apache.commons.httpclient.multithreadedhttpconnectionmanager; import org.apache.commons.httpclient.params.httpclientparams; import org.apache.commons.httpclient.params.httpmethodparams; import org.apache.log4j.logger; public class httpclientmanager { private static logger logger = logger.getlogger(httpclientmanager.class); private static multithreadedhttpconnectionmanager connectionmanager = new multithreadedhttpconnectionmanager(); private static httpclientparams clientparams = new httpclientparams(); static { try { clientparams.makelenient(); clientparams.setauthenticationpreemptive(false); clientparams.setparameter(httpmethodparams.so_timeout, new integer(30000)); // set so_timeout clientparams.setparameter(httpmethodparams.head_body_check_timeout, new integer(3000)); // head responses ...
Read more

node.js - StackOverflow API not returning JSON -

-
i using node.js script gather data stackoverflow. know responses gzipped, put code in should take care of that. script follows: var request = require('request'); var zlib = require('zlib'); function getstackoverflowresponse(url, callback){ request(url, {encoding: null}, function(err, response, body){ if(response.headers['content-encoding'] == 'gzip'){ zlib.gunzip(body, function(err, dezipped) { callback(dezipped); }); } else { callback(body); } }); } var url = "https://api.stackexchange.com/docs/questions#pagesize=2&order=desc&min=2014-01-04&max=2014-02-02&sort=activity&tagged=apigee&filter=default&site=stackoverflow&run=true"; getstackoverflowresponse(url, function(questions) { console.log(questions); }); instead of getting json output, i'm getting following response: buffer 0d 0a 0d 0a 0d 0a 0d 0a 3c 21 44 4f 43 54 59 50 45 20 48...
Read more