Administrative Login
This comes in handy when performing a mass insert from a table without a primary key to a table with an AUTO_INCREMENT value. A common tecnique simply inserts blank values to the AUTO_INCREMENT column. Doing so generates a warning for each row. Generating a bunch of warnings makes it difficult to identify and address the other warnings that may occur. Using my tecnique to generate incremental values addresses this problem.
Recently I used MySQL Query Browser for some data import. I had a couple of spreadsheets and some word documents. It’s really not so tough to import data into a database, but I’d like a lightning fast GUI that opens CSV files and creates DB tables to match. Unfortunately, the MySQL GUI Tools don’t provide this convenience. I did, however run across the RegEx Text Importer and used it to parse a couple of text lists. I don’t do a ton of work with regular expressions. So I like to use the most obvious notation and keep notes.
The contents, design, and development of this site are all done by me, Ethan Kent.
The contents of my site, ethanmultimedia.com, are for general information only and provided strictly as is. I do my best to be truthful and accurate, but I must expressly disclaim any implied warranties of non-infringement, merchantability and fitness for a particular purpose. Browse this site at your own risk. If you’re looking for safety and assurance you should probably seek the advice of an appropriate professional.