MYSQL Inserting rows that reference main rows.
- by Andrew M
I'm transferring my access logs into a database.
I've got two tables:
urlRequests
id : int(10)
host : varchar(100)
path: varchar(300)
unique index (host, path)
urlAccesses
id : int(10)
request : int(10) <-- reference to urlRequests row
ip : int(4)
query : varchar(300)
time : timestamp
I need to insert a row into urlAccesses for every page…