uncleflo
Registered since September 28th, 2017
Has a total of 4246 bookmarks.
Showing top Tags within 6 bookmarks
howto information development guide reference administration design website software solution service product online business uk tool company linux code server system application web list video marine create data experience description tutorial explanation technology build blog article learn world project boat download windows security lookup free performance javascript technical control network beautiful support london tools course file research purchase library programming image youtube example php construction html opensource quality install community profile computer feature power browser music platform mobile work user process manage database share hardware professional buy industry internet dance advice installation developer 3d camera search material access customer travel test standard money documentation review css engineering engine develop webdesign device photography digital api speed source management program phone discussion question event client story simple water marketing app content yacht setup package fast idea interface account communication cheap script compare study market live easy google resource operation startup monitor training
Tag selected: insert.
Looking up insert tag. Showing 6 results. Clear
PHP Fine Diff
Saved by uncleflo on December 28th, 2017.
This page demonstrate the FineDiff class (as in “fine granularity diff”) I wrote – starting from scratch – to generate a lossless (won't eat your line breaks), compact opcodes string listing the sequence of atomic actions (copy/delete/insert) necessary to transform one string into another (thereafter referred as the “From” and “To” string). The “To” string can be rebuilt by running the opcodes string on the “From” string. The FineDiff class allows to specify the granularity, and up to character-level granularity is possible, in order to generate the smallest diff possible (at the potential cost of increased CPU cycles.)
php fine differential text operation workflow code development collaberate operational collaboration granular paragraph sentence generate refer build insert start lossless atomic action transformation compact scratch develop implement project demonstration demo howto setup diff
Alexander Stetsenko » MySQL: how to ignore checking of foreign key constraints for InnoDB tables
Saved by uncleflo on February 16th, 2015.
There is a session variable FOREIGN_KEY_CHECKS which allows to ignore checking of foreign key constraints for InnoDB tables. If set to 1 (the default), foreign constraints are checked. If set to 0, they are ignored. Setting FOREIGN_KEY_CHECKS to 0 also affects data definition statements like DROP TABLE which drops tables that have foreign keys that are referred to by other tables. Disabling foreign key checking can be useful for reloading InnoDB tables in an order different from that required by their parent/child relationships.
mysql insert foreign ignore key constraint check sql dump import database solution problem drop flag
Import CSV file directly into MySQL | a Tech-Recipes Tutorial
Saved by uncleflo on January 24th, 2014.
Instead of writing a script to pull in information from a CSV file, you can link MYSQL directly to it and upload the information using the following SQL syntax. To import an Excel file into MySQL, first export it as a CSV file. Remove the CSV headers from the generated CSV file along with empty data that Excel may have put at the end of the CSV file.
sql mysql insert csv local file development administration import command run table populate guide howto solution
php - How to 'insert if not exists' in MySQL? - Stack Overflow
Saved by uncleflo on January 24th, 2014.
I started by googling, and found this article which talks about mutex tables. I have a table with ~14 million records. If I want to add more data in the same format, is there a way to ensure the record I want to insert does not already exist without using a pair of queries (ie, one query to check and one to insert is the result set is empty)? Does a unique constraint on a field guarantee the insert will fail if it's already there? It seems that with merely a constraint, when I issue the insert via php, the script croaks.
exist insert mysql php sql script javascript ignore development solution question query duplicate
None
Saved by uncleflo on August 19th, 2013.
I do a lot of work with subdomains, managing them locally on my development and test machines has always been a bit of a pain. Going way back, I can remember manually editing the hosts file in system32\drivers\etc\ on Windows! On the Unix we have /etc/hosts. Unfortunately /etc/hosts doesn’t allow wildcard definitions for subdomains, so you have to manually specify each one.
host wildcard automatic dns edit add dnsmasq script linux database localhost file domain subdomain insert infrastructure bash administration
How to write flexible INSERT and UPDATE statements in MySQL at Xaprb
Saved by uncleflo on January 21st, 2013.
MySQL provides several variations on INSERT and UPDATE to allow inserting and updating exactly the desired data. These features provide a lot of power and flexibility, making MySQL significantly more capable than it otherwise might be. In this article I’ll give an overview of each feature, help you understand how to choose among them, and point out some things to watch out for.
flexible transaction database query insert update mysql data overview information opinion blog dataµ
No further bookmarks found.