To extend a list, you just use list.extend. To insert elements from any iterable at an index, you can use slice assignment… >>> a = list(range(10)) >>> a [0, 1, 2, 3, 4, 5, 6, 7, 8, 9] >>> a[5:5] = range(10, 13) >>> a [0, 1, 2, 3, 4, 10, 11, 12, 5, 6, … Read more
You can do it like this: CREATE TABLE tablename SELECT * FROM othertable; tablename is the name of the new table you want to create, SELECT * FROM othertable is the query that returns the data the table should be created from.
Use MySQL’s STR_TO_DATE() function to parse the string that you’re attempting to insert: INSERT INTO tblInquiry (fldInquiryReceivedDateTime) VALUES (STR_TO_DATE(‘5/15/2012 8:06:26 AM’, ‘%c/%e/%Y %r’))
The create method takes also an array as parameter. VoteRecord.create( [ { :prospect_id => prospect.id, :state => “OH”, :election_type => “GE”, :election => “2011-11-08”, :party => row[82], :participate => participated(row[82]) }, { :prospect_id => prospect.id, :state => “OH”, :election_type => “PR”, :election => “2011-09-13”, :party => row[81], :participate => participated(row[81]) } … ] ) However, … Read more
According to MySQL documentation, you should be able to just enclose that datetime string in single quotes, (‘YYYY-MM-DD HH:MM:SS’) and it should work. Look here: Date and Time Literals So, in your case, the command should be as follows: UPDATE products SET former_date=”2011-12-18 13:17:17″ WHERE id=1
2147483647 is the largest int value for mysql. Just change the type from int to bigint.
For some databases, you can just explicitly insert a NULL into the auto_increment column: INSERT INTO table_name VALUES (NULL, ‘my name’, ‘my group’)
Use the DEFAULT keyword: $query = “INSERT INTO myTable VALUES (DEFAULT,’Fname’, ‘Lname’, ‘Website’)”; Also, you can specify the columns, (which is better practice): $query = “INSERT INTO myTable (fname, lname, website) VALUES (‘fname’, ‘lname’, ‘website’)”; Reference: http://dev.mysql.com/doc/refman/5.6/en/data-type-defaults.html
INSERT INTO TABLE SELECT value_for_column1, value_for_column2, … FROM wherever WHERE your_special_condition If no rows are returned from the select (because your special condition is false) no insert happens. Using your schema from question (assuming your id column is auto_increment): insert into orders (product_id, qty) select 2, 20 where (SELECT qty_on_hand FROM products WHERE id = … Read more
Try this: insert into [table] ([data]) output inserted.id, inserted.data into table2 select [data] from [external_table] UPDATE: Re: Denis – this seems very close to what I want to do, but perhaps you could fix the following SQL statement for me? Basically the [data] in [table1] and the [data] in [table2] represent two different/distinct columns from … Read more