Jump to content

Recommended Posts

Hi all,

 

I'm hoping someone will be able to help me with this. I'm using MySQL via phpMyAdmin.

 

At the moment I am using the following table for a resonably small database (which only contains one table):

 

ForumUsername

Email

Phone

Address

Paid

Dispatched

 

However the table no longer suits my needs, and I can't figure out how to add/delete rows, so I am creating a new table to replace the old one. It will look like this:

 

ForumUsername

Email

Address

Paid

Dispatched

MembershipNumber

Expires

 

Could anyone tell me how I can create a query to put the information from the first table (from ForumUsername, Email, and Address) into the new table?

 

Any help much appreciated.

 

Cheers.

 

Link to comment
https://forums.phpfreaks.com/topic/80957-solved-transfering-data-between-tables/
Share on other sites

Hm the alter table stuff in that link doesn't make a lot of sense to me..

 

I've been searching for ages in phpMyAdmin for an easy way to do it but there doesn't seem to be an option  :-\ Am I missing something? Or does a query have to be written to do it?

You need to add/delete columns, not rows .. is that's why it's not making sense?  Columns describe the format of the data, rows are actual pieces of data.

 

Oh, yeah i'm aware of that. I tried writing a query to move the data over but I can't get it to work  :-X My SQL knowledge is limited.

 

So I was just trying to find an option in phpMyAdmin to do it. There seems to be options for everything BUT that  :-[

You'll just have to add the additional columns to the table in phpMyAdmin, click on the table which is in the left panel,

 

on the right side the description will come, there will be a "Add" <inputtextbox> field(s) then checkboxes at the beginning or at the end, enter 2 in the inputtextbox and at the end of the table and click on go after that enter the required fields and click on save

 

Hope its helpful

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.