Welcome Guest ( Log In | Register )



3 Pages V  < 1 2 3  
 Reply to this topicStart new topic
> MySQL, Multiple Tables
nightfox
post Aug 6 2006, 06:39 PM
Post #21


NiGHTFoX - Hiding in the dark
Group Icon

Group: Members
Posts: 680
Joined: 3-April 05
Member No.: 3,584
haha... well I guess I'll be a good programmer soon tongue.gif but first I need to build my libraries of code!

[N]F
Go to the top of the page
 
+Quote Post
vhortex
post Aug 7 2006, 03:55 AM
Post #22


Guilty Until Proven Innocent
Group Icon

Group: Members
Posts: 372
Joined: 13-April 05
Member No.: 3,937
i hope you wont get as lazy as i am..

darn.. i think i misunderstood a line or two of that saying..

------

if something is hard to do..
then it is not worth doing it.. LOL
Go to the top of the page
 
+Quote Post
iGuest
post May 16 2008, 05:29 AM
Post #23


Newbie [ Level 1 ]
Group Icon

Group: Members
Posts: 0
Joined: 1-November 07
Member No.: 25,869
its great site to help us
MySQL, Multiple Tables

All you have done a grate job for mysql users like us ... Thanks.
Go to the top of the page
 
+Quote Post
iGuest
post Jul 8 2008, 11:15 AM
Post #24


Newbie [ Level 1 ]
Group Icon

Group: Members
Posts: 0
Joined: 1-November 07
Member No.: 25,869
Retrieving Data from Multiple Table
MySQL, Multiple Tables

Table1
Id
Full_name

Table2
Id
Contact_address

Table3
Id
Products

Query option as below
I want to search
? full_name <>
? contact_address <>
? products <>

But record in the format of

Id | full_name | contact_address | products


Please help me the good performance tunning codes. (database in mysql and script language is PHP)

Thanks!

-question by Krishna Aryal
Go to the top of the page
 
+Quote Post
darkken
post Jul 24 2008, 09:56 AM
Post #25


Newbie [ Level 2 ]
Group Icon

Group: [HOSTED]
Posts: 26
Joined: 2-July 08
Member No.: 31,263
i would recommend reading up on the t1 t2 commands for mysql. it is in the mysql manuel files.
CODE
$sql = "SELECT t1.name, t2.location FROM users t1, profiles t2"
Go to the top of the page
 
+Quote Post
« Next Oldest · Databases · Next Newest »
 

3 Pages V  < 1 2 3
Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. MySQL - Trouble With Bulk Insert Statements(3)
  2. MySQL Realtime Replication(4)
  3. Recover Tables From A MySQL .frm File(8)
  4. Mirror My MySQL Database To Another Mysql Server(4)
  5. How To Connect MySQL With Flash?(8)
  6. MySQL Output Database Question(18)
  7. Linking Two Tables(12)
  8. Navcat For MySQL(8)
  9. Permission Problem With Mysql Database Creation(8)
  10. Mysql And Php(15)
  11. Login System Using A Mysql Db(5)
  12. Oracle Vs. Mysql Vs. Postgresql(9)
  13. Subqueries In Mysql(1)
  14. Apache Php With Mysql On Windows [solved](9)
  15. Not Understanding Mysql(4)
  1. Mysql Script Help(3)
  2. Mysql - So Hard(14)
  3. Mysql Problem(1)
  4. Sun Bought Mysql(6)
  5. Mysql Backup With Another Address?(4)
  6. I Have An Error With My Mysql Connection(7)
  7. Mysql And User File_priv(0)
  8. Mysql Database Management(1)
  9. Mysql Database Entry By Excel Sheets(2)
  10. Mysql On Computer(9)
  11. Any Website Provide Free Host Mysql Host?(4)
  12. Mysql Multiple Tables(1)
  13. Mysql Overhead(2)


 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

- Lo-Fi Version Time is now: 7th October 2008 - 11:59 PM
Powered By IP.Board 2.2.1 © 2008  IPS, Inc.
Licensed to: Xisto Corporation