Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

MySQL create table containing values from a column in another table.

⇧
0
⇩
114 views

Lets say I have a table tilistings with a dozen columns, and about 2,000 rows there is one column cityname that has probably 50 different values in it. What I want to do, is search through the tilistings and create another table that just contains the 50 different values from cityname without duplicating any names....basically if cityname had the values a,b,a,c,b,b,d,a,a,d,d,c I would only want the new table to contain a,b,c. Is there a pre-built MySQL function to do so? Otherwise, just point me in the right direction to do this with PHP. I can create the table, just looking to populate it.

php mysql query table
asked January 28, 2011 5:58 pm CST
Mike L.
posted via StackOverflow

1 Answer

⇧
1
⇩
Best answer
 

You can get the unique city names by performing the following query:

SELECT DISTINCT cityname FROM tilistings

Then loop through those and INSERT them into your new table with PHP or INSERT INTO ... SELECT.

answered January 28, 2011 6:23 pm CST
webbiedave

Your answer

Join with account you already have

Sign in with Twitter account
Sign in with Facebook account
Sign in with Google Friend Connect

Preview
Similar questions
Create table from select then alter table by adding an auto increment column in mysql
January 11, 2011
MYSQL inserting records form table A into tables B and C (linked by foreign key) depending on column values in table A
January 7, 2011
PHP / MySQL - Create array of distinct values, query db table for data associated with those values, and loop for each
January 25, 2011
Can I change the datatype for the "Create Table" field in the Show Create Table function in MySQL?
January 10, 2011
Updating Column based on values from values in its own table
January 25, 2011
Mysql create table based on another table including indexes
January 25, 2011
Inserting data from one column from one table to another specific table column while ignoring duplicates.
January 17, 2011
Mysql: How do I fill in null values in one row with values from another row in the same table?
January 8, 2011
In sqlite How to add column in table if same column is not exists in table
January 8, 2011
How can I update a score column in Table A using a record count from Table B?
January 27, 2011
How do i pull data from one table and insert it into a column in another table?
January 25, 2011
How to create index in two table mysql?
January 13, 2011
MySQL - Aren't these privileges enough to create a table?
January 3, 2011
Mysql changing values in table?
January 7, 2011
Convert Simple T-SQL DDL to MySQL DDL (Create Table)
January 6, 2011
Mysql create a table character sets
January 25, 2011
Putting values into a MySQL table using a PHP form
December 29, 2010
How to create mysql table with many hasMany association in CakePHP?
January 18, 2011
Outputting a list of MySQL table values in PHP/HTML
January 7, 2011
Mysql: How to insert values in a table with foreign key reference
January 23, 2011
Using MySQL, I'm attempting to create a table in a db, and then insert into, but am getting a 'syntax' error
January 13, 2011
[MYSQL] how to add a primary key column in to a no primay key old table
January 1, 2011
MySQL Alter table, add column with unique random value
January 11, 2011
Mysql, storing multiple value in single column from another table
January 26, 2011
I have a table which contains data with a date column. Mysql Query help needed!
December 29, 2010
Change a mysql table column on slave then promote to master
January 23, 2011
Filtering for multiple values on one column based on values from another column
January 3, 2011
How to use constants in SQL CREATE TABLE?
December 31, 2010
[Solved] SQL CREATE TABLE Error
January 9, 2011
Trigger: after insert create a new table
January 7, 2011