(This is the official perlfaq answer, minus any subsequent edits) The basic idea of inserting, changing, or deleting a line from a text file involves reading and printing the file to the point you want to make the change, making the change, then reading and printing the rest of the file. Perl doesn’t provide random … Read more
Quickest way would be with some regex: Where n is the number n.replace(/(\d{3})(\d{3})(\d{4})/, “$1-$2-$3”); Example: http://jsfiddle.net/jasongennaro/yXD7g/ var n = “1234567899”; console.log(n.replace(/(\d{3})(\d{3})(\d{4})/, “$1-$2-$3”));
For MS SQL Server: SCOPE_IDENTITY() will return you the last generated identity value within your current scope: SELECT SCOPE_IDENTITY() AS NewID
If table_2 is empty, then try the following insert statement: insert into table_2 (itemid,location1) select itemid,quantity from table_1 where locationid=1 If table_2 already contains the itemid values, then try this update statement: update table_2 set location1= (select quantity from table_1 where locationid=1 and table_1.itemid = table_2.itemid)
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
You want to check out django.db.transaction.commit_manually. http://docs.djangoproject.com/en/dev/topics/db/transactions/#django-db-transaction-commit-manually So it would be something like: from django.db import transaction @transaction.commit_manually def viewfunc(request): … for item in items: entry = Entry(a1=item.a1, a2=item.a2) entry.save() transaction.commit() Which will only commit once, instead at each save(). In django 1.3 context managers were introduced. So now you can use transaction.commit_on_success() in a … Read more
Try something like this: DECLARE @userData TABLE( name varchar(30) NOT NULL, oldlocation varchar(30) NOT NULL ); INSERT INTO @userData (name, oldlocation) SELECT name, location FROM myTable INNER JOIN otherTable ON … WHERE age > 30;
Use an INSERT … SELECT statement where you are selecting constant values as well as data from products_temp: INSERT INTO products (product_data, vendor_id) SELECT data, ‘1’ FROM products_temp
The mysqli_num_rows() function returns the number of rows in a result set. For insert, update and delete use mysqli_affected_rows
You can always use String.format(….). i.e., String string = String.format(“A String %s %2d”, aStringVar, anIntVar); I’m not sure if that is attractive enough for you, but it can be quite handy. The syntax is the same as for printf and java.util.Formatter. I’ve used it much especially if I want to show tabular numeric data.