Dozens of questions which I cannot find. v_v

Orc · 01-31-2008, 03:03 AM

Heres some questions which I cannot find online, cause it's all about crap PHP Tutorials with MySQL. Now

How would I insert two querys at once? in the same variable:

PHP Code:


			
$query = "SELECT * FROM `table`,
          INSERT INTO `table` (id,name,blah) VALUES(, 'blah', 'blah', 'blah');

How would I assign tables/columns/etc to a different column, say I wanted to inherit some columns like so:

PHP Code:


			
// I want t1's users to be t2's users
$query = " SELECT t1.users,t2.users FROM t1,t2
SET `table1` AS `t1` AND `table2` AS `t2`";

How would I edit columns in the tables?

PHP Code:


			
 $query = "TRUNCATE `table` WHERE `blah`='$blah'";

How would I move values from columns to other columns?

That's all the questions I have for now, I might ask some more later.. HALP!

Orc · 01-31-2008, 03:06 AM

If someone helps me out, they get a cookie! :D

Orc · 01-31-2008, 03:11 AM

We need a MySQL Guru. -_-

Village Idiot · 01-31-2008, 03:22 AM

Surely you can wait 10min..... Its 24/7 staff you seem to want.

1. You cant execute more then one query though mysql_query, here some code I wrote that can enable you to do this in a different way Multiple mysql queries

2. I dont get what you are trying to do, why not select both via aliasing?
// I want t1's users to be t2's users
$query = " SELECT t1.users AS t1_users,t2.users AS t2_users FROM t1,t2;

3. Modify an existing MySQL column - Tech-Recipes.com

A quick google serach could have answered the second two

Salathe · 01-31-2008, 03:32 AM

Quote:

Originally Posted by Orc

How would I assign tables/columns/etc to a different column, say I wanted to inherit some columns like so:

PHP Code:


			
// I want t1's users to be t2's users

$query = " SELECT t1.users,t2.users FROM t1,t2

SET `table1` AS `t1` AND `table2` AS `t2`";

From your code, it looks like you might be wanting to use something like the following:

SQL Code:

SELECT
    t1.users,
    t2.users
FROM
    table1 AS t1,
    table2 AS t2
;

Please be patient when asking questions; even though some of us are on the forums very often, we're not here to drop everything and respond immediately to new posts. Even if that were the case, it does indeed take a few minutes to draft a post.

Orc · 01-31-2008, 04:09 AM

Quote:

Originally Posted by Salathe

From your code, it looks like you might be wanting to use something like the following:

SQL Code:

SELECT
    t1.users,
    t2.users
FROM
    table1 AS t1,
    table2 AS t2
;

Please be patient when asking questions; even though some of us are on the forums very often, we're not here to drop everything and respond immediately to new posts. Even if that were the case, it does indeed take a few minutes to draft a post.

Okay, but thanks for answering one of my questions. :D

Orc · 01-31-2008, 04:59 AM

I think I figured out that Inner join can be used to combine data from other tables to make one table :D

Orc · 01-31-2008, 10:58 AM

I'm wondering if I have to use queries for listing rows in a table, and updating, deleting, or inserting into tables. -_- I said I'm a newbie at MySQL. :/

buggabill · 01-31-2008, 01:10 PM

I believe...if I am wrong, someone correct me, please..to insert data from a SELECT query into another table do something like the following:

SQL Code:

INSERT INTO 
    generals (name, rank, serialnum) 
SELECT 
    name, rank, serialnum 
FROM 
    allsoldiers
WHERE 
    rank="General"

The field names do not have to match, but the data type should.

By editing columns in a table, to what are you referring? Do you wish to change the data type or just the data in a specific column/field?

Orc · 01-31-2008, 01:12 PM

Quote:

Originally Posted by buggabill

I believe...if I am wrong, someone correct me, please..to insert data from a SELECT query into another table do something like the following:

SQL Code:

INSERT INTO 
    generals (name, rank, serialnum) 
SELECT 
    name, rank, serialnum 
FROM 
    allsoldiers
WHERE 
    rank="General"

The field names do not have to match, but the data type should.

By editing columns in a table, to what are you referring? Do you wish to change the data type or just the data in a specific column/field?

I was trying to list some news entries, then show a checkbox to delete it or edit it. :/

buggabill · 01-31-2008, 02:42 PM

Sorry for all the questions, but I have one more. Were you planning on adding or removing a column for each news story? Am I misunderstanding you? Are you actually trying to add or delete rows?

TRUNCATE will clean the table out and leave the structure intact. I don't think that is what you want to do...

To delete a row, here is a small example(assuming you had the id of the story):

SQL Code:

DELETE FROM
    newsstories
WHERE
    id=idofstory

Changing data in a column requires you to do an UPDATE query.

example:

SQL Code:

UPDATE 
    stories
SET
    body=bodyofstory
WHERE
    id=idofstory

wGEric · 01-31-2008, 07:50 PM

Quote:

Originally Posted by Orc

I think I figured out that Inner join can be used to combine data from other tables to make one table :D

Yes, also LEFT JOIN and RIGHT JOIN. You can also do SELECT queries within other queries (as pointed out by buggabill). There's also UNIONs to do two queries at once.

Code:

SELECT name FROM cia WHERE population > (SELECT population FROM cia WHERE name='United States');
SELECT * FROM t1 UNION SELECT * FROM t2 UNION SELECT * FROM t3;