MySQL optimised code for 2 tables?

Posted by David19801 on Stack Overflow See other posts from Stack Overflow or by David19801
Published on 2010-12-25T09:36:28Z Indexed on 2010/12/25 9:54 UTC
Read the original article Hit count: 225

Filed under:
|

Hi,

I have 2 tables,

Table1: id,int1,int2,int3,int4,int5

Table2: integers (autoincrement),blobdata

The query I want to use is given the id I want to get the blobdata from table2 associated with the 5 integers in table1. I've only ever used one table in mysql so have no idea how to do this properly.

Is it possible?

EDIT: id is username, integers in table2 is just integers. but have not built the tables yet, so can change if need to.

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql