|
|
![]() |
| Thread Tools | Search this Thread |
#1
| |||
| |||
Mysql select from multiple tables for php. Hi, I want some help with PHP mySql. Can you please let me know how to make a query to talk with different tables? I have some problem with the 2 tables with id name field. How can I give it an auto_increment nature? please help me with the syntax atleast. Thanks in advance. |
#2
| |||
| |||
Re: Mysql select from multiple tables for php. SELECT from multiple MySQL Tables Code: SELECT fulltxt.pqid AS candidate_ft, citations.chid FROM citations,fulltxt WHERE citations.issn = fulltxt.issn AND citations.volume = fulltxt.volume AND citations.issue = fulltxt.issue AND citations.year = fulltxt.year AND citations.spage = fulltxt.spage AND citations.pqid = '' ; |
#3
| |||
| |||
Re: Mysql select from multiple tables for php. I have some huge database with around 50 tables & a another table to have the names of all those tables. I want to know a query that will select from these table & show me a list of results to see at a glance. Ill be able to look as a whole? Please help me if this can be done? |
#4
| |||
| |||
Re: Mysql select from multiple tables for php. hey bayz you need to learn: Database Normalization Normalization is a part of relational theory, which requires that each relation (AKA table) has a primary key. As a result, this article assumes that all tables have primary keys, without which a table cannot even be considered to be in first normal form. Database normalization is a process by which an existing schema is modified to bring its component tables into compliance with a series of progressive normal forms. |
#5
| |||
| |||
Re: Mysql select from multiple tables for php. SELECT Syntax for multiple mysql tables. Code: SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr ...] [FROM table_references [WHERE where_condition] [GROUP BY {col_name | expr | position} [ASC | DESC], ... [WITH ROLLUP]] [HAVING where_condition] [ORDER BY {col_name | expr | position} [ASC | DESC], ...] [LIMIT {[offset,] row_count | row_count OFFSET offset}] [PROCEDURE procedure_name(argument_list)] [INTO OUTFILE 'file_name' export_options | INTO DUMPFILE 'file_name' | INTO var_name [, var_name]] [FOR UPDATE | LOCK IN SHARE MODE]]
__________________ Grand Theft Auto 4 PC Video Game |
![]() |
|
Tags: mysql database, php, select from, tables |
Thread Tools | Search this Thread |
|
![]() | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
MySQL: Entering data in tables | Botan | Software Development | 2 | 22-12-2010 05:44 AM |
How to manage databases and tables in MySQL? | Aahlaadith | Software Development | 5 | 17-12-2010 07:18 AM |
How to detect failure of MySQL database tables | Agneya | Software Development | 5 | 27-02-2010 04:40 AM |
How to create MySQL Database and Tables in PHP? | Orton | Software Development | 4 | 23-02-2010 06:45 AM |
How to select multiple table in MySql | Doroteo | Software Development | 4 | 05-11-2009 09:28 PM |