network profile
| bio | website | |
|---|---|---|
| location | USA | |
| age | 24 | |
| visits | member for | 7 months |
| seen | May 13 at 12:37 | |
| stats | profile views | 5 |
Newbie Developer
|
May 10 |
comment |
Optimising table efficiency format integers only apologies, they are select queries, update queries and insert queries. I will be updating single columns and and selecting numbers where as inserting lots of columns as this table is a connector table that connects a details table to a product table.the indexes i think i would need on 3 of the columns as there is alot of addition and selection from this table. |
|
May 1 |
comment |
XML Data convert to SQL database, Is there a way does anyone know? |
|
Apr 25 |
comment |
XML Data convert to SQL database, I am currently using mysql |
|
Feb 6 |
comment |
MySQL Left Join Select all rows Also sandwich type is not part of the problem as the problem resides in the sald_type table |
|
Feb 6 |
comment |
MySQL Left Join Select all rows Apologies i removed active by mistake. I have tried with INNER JOINS and still the only rows that appear are ones that have a count() that notes NULL |
|
Jan 17 |
comment |
Storing Different Products and Joining on table Names thanks, That does seem like an effective method there will be other products added to the database at later dates and other types but that can be just added into the tables im guessing. Also the books will have authors, ISBN10s and 13s which is another thing to consider but this is a good starting point for me |
|
Nov 1 |
comment |
Mysql database connector table or keys thank you , that is what I currently have in place just wanted to be sure there was not a better method before went on to develop the system more. thanks |
|
Oct 2 |
comment |
Resolving MySQL Process ID to page that ran it? Thanks for the response that what I was fearing. I will look into implementing your advice |
