3,436 reputation
1025
bio website
location
age
visits member for 3 years, 7 months
seen yesterday

Currently writing code for apps using & managing Postgres and mySQL databases, and involved in some data modeling efforts in the science informatics community, but in the past:

  • PL/SQL programmer & DB admin in Oracle 8/8i/9i days.
  • VBA programming in MS Access (sometimes w/ mysql or MSSQL backends)
  • LDAP administration (Novell & iPlanet)
  • Did some work w/ FileMaker databases (both standalone and dedicated server)

Aug
7
awarded  Enlightened
Jun
13
awarded  Enlightened
Jun
13
awarded  Nice Answer
Jan
7
comment Inventory Management DB Design
Yes ... it'd then have foreign keys to the tables it's joining. Minimally, it's just foreign keys to the tables it's joining, but it might also have some attributes itself (eg, tracking how many of the item are in a given bin).
Jan
7
comment Inventory Management DB Design
then you might want a join table between the item table and the table to track bins. (and it might make sense to call that one 'locations', or at least not call the bins table 'locations'). Join tables will slow down queries, but you won't be able to track items in more than one bin without it or allow duplicate skus in the items table.
Jan
7
comment Inventory Management DB Design
can bins be moved between shelves? can an item be in more than one bin (eg, if you have too much of something, might it be spread across two bins?)
Jan
3
awarded  Yearling
Oct
28
awarded  Nice Answer
Aug
14
awarded  Nice Answer
Aug
9
awarded  Nice Answer
May
26
comment MySQL CSV LOAD DATA INFILE … doesn't want to load more than 72 lines
Any reason you're doing this in php? If you can, that take that out of the picture and just send the command using the command line mysql client. (otherwise, I'd try a load w/ lines 1 to 72 removed, and see it it still loads ~72 lines (memory issue) or none (a problem w/ the input file).
Feb
2
awarded  Nice Answer
Jan
3
awarded  Yearling
Aug
20
awarded  Popular Question
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
Feb
13
awarded  Taxonomist
Jan
3
awarded  Yearling
Nov
13
awarded  Nice Answer
Nov
5
comment Small Squares or Blocks after string in table field
When you say 'The ASCII equivalent is CHAR(32)' ... are you saying it's a 32 character long string, or that the strange character is ASCII#32 (which, assuming decimal, 32, is a space)? Based on the 'small squares' description, I'd have assumed it's a character that doesn't exist in the font you're using, but space should exist, and I don't think Excel has the equivalent of BBEdit's 'Show Invisibles' feature.