AaronJAnderson

240 reputation

bio	website
	location
	age
visits	member for	2 years, 1 month
	seen	May 14 at 18:19
stats	profile views	14

	240 reputation	bio	website		visits	member for	2 years, 1 month
18 badges		location			seen	May 14 at 18:19

summary answers questions tags badges favorites bounties reputation activity

54 Actions

suggestions reviews revisions comments badges posts accepts all

May 15	awarded	Popular Question
Apr 22	awarded	Popular Question
Feb 5	comment	Need to migrate SQL Server to MySQL How much data are we talking about? 5mb? 3TB?
Jun 26	comment	How do you load a data file into a specific field? You rock Rolando!
Jun 26	accepted	How do you load a data file into a specific field?
Jun 26	comment	How do you load a data file into a specific field? That's not really what I wanted. I want the entire log file in one record, not a new record for each line of the log file. Is that possible? It would also be something like "INTO TABLE jobs (Log); WHERE TaskName = 'LouPrMgt004.Backup' - So I guess it should really be an update statement... but either way, I want the entire log file in one "cell" or field.
Jun 26	comment	How do you load a data file into a specific field? "SELECT * from jobs" is what I used to get the table above.
Jun 26	revised	How do you load a data file into a specific field? added 1222 characters in body
Jun 26	asked	How do you load a data file into a specific field?
Jun 26	asked	Store a small log file as a blob in sqlite
Jun 26	awarded	Yearling
Dec 29	answered	Is there a tool or library to extract data from Mysql database files without having the database engine available?
Dec 28	comment	How to design this simple DB? This is pretty good. I'm not sure it's totally compatible with the web applications I'm using (PHP Maker and AppGini) but that's not your fault. Great code that I'm saving in my local repo.
Dec 28	accepted	How to design this simple DB?
Dec 28	revised	How to design this simple DB? added 96 characters in body
Dec 28	accepted	INSERT INTO without duplicates
Dec 28	comment	How to design this simple DB? So, what I'm saying is that under no circumstance should a system exist on Matrix, and NOT on "Updates" or whatever we decide to call this thing.
Dec 28	comment	How to design this simple DB? I don't think we're on the same page; but I like your answer. A little background to help clarify how I use the data. The "Matrix" is my master inventory of systems. When it's time to update code and install updates I have to do maintenance to a certain subset of servers. (ie, anything with "pr" in the name) - So I want to head over to this other table we're talking about to see what work needs to be done. I'd like it to be pre-populated with server names so I know which ones need to be updated. Does that make sense?
Dec 27	comment	How to design this simple DB? Should I just add the fields to my main table "Matrix" and not create a separate table for this?
Dec 27	comment	How to design this simple DB? Matrix is a table name. There are hundreds of servers in it. The example I gave only shows 1 server and a cropped set of fields that accompany it. The relationship between the tables, if I am using that word properly, is the "Name" of the server.