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 Today, 09:56 AM
Post #25


Newbie [ Level 2 ]
Group Icon

Group: [HOSTED]
Posts: 16
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(3)
  3. Recover Tables From A MySQL .frm File(6)
  4. Mirror My MySQL Database To Another Mysql Server(4)
  5. How To Connect MySQL With Flash?(8)
  6. Linking Two Tables(12)
  7. Is It A Good Practice To Store Image Or Other Binary Files Directly In A Mysql Database(4)
  8. Navcat For MySQL(7)
  9. Permission Problem With Mysql Database Creation(8)
  10. Mysql And Php(15)
  11. Problems With Php Saving Data Into Mysql(6)
  12. Login System Using A Mysql Db(4)
  13. Oracle Vs. Mysql Vs. Postgresql(9)
  14. Mysql Query Question(3)
  15. Lost Connection To Mysql ,..., System Error: 111 In(3)
  1. Subqueries In Mysql(1)
  2. Apache Php With Mysql On Windows [solved](9)
  3. Not Understanding Mysql(4)
  4. Mysql Script Help(3)
  5. Mysql - So Hard(14)
  6. Mysql Problem(1)
  7. Sun Bought Mysql(6)
  8. Mysql Backup With Another Address?(4)
  9. I Have An Error With My Mysql Connection(7)
  10. Mysql And User File_priv(0)
  11. Mysql Database Management(1)
  12. Mysql Database Entry By Excel Sheets(2)
  13. Mysql On Computer(9)


 

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: 24th July 2008 - 02:11 PM
Powered By IP.Board 2.2.1 © 2008  IPS, Inc.
Licensed to: Xisto Corporation