Hello.
This is not a step by step instructions. But taking into an account that you're a MySQL beginner, in my opinion, you should read some parts of the manual: http://dev.mysql.com/doc/mysql/en/string-functions.html http://dev.mysql.com/doc/mysql/en/insert-select.html http://dev.mysql.com/doc/mysql/en/numeric-types.html http://dev.mysql.com/doc/mysql/en/show-warnings.html http://dev.mysql.com/doc/mysql/en/string-types.html I recommend you to upgrade your MySQL to the latest release (4.1.14 now). See: http://dev.mysql.com/doc/mysql/en/upgrade.html Dave <[EMAIL PROTECTED]> wrote: > MySQL General List, > > Server specifications: > MySQL 4.1.3-beta, phpMyAdmin 2.5.7-pl1, PHP 4.3.8 > My specifications: > MySQL beginner, PHP intermediate, HTML and CSS advanced. > > The situation: > I have recently installed a forum ( http://www.simplemachines.org/ ) > on my web site. I already have about 150 users on my site, and I want to > transplant their information from their current table into the members > table used by the forum. > With many of the necessary fields, this means I have to take the > format of the current data and put it into a the new field with a > different format. > > The Questions: > In the following 5 cases, will it be safe to copy data directly, or > will there be data loss or scrambling: > > 1. In the first case, the id number for the original table is an > INT, with a length of 11. In the target table, it's a MEDIUMINT with a > length of 8. Since I only have 150 members starting at an id of 1, I'm > assuming I can just copy the numbers without fear of truncation > > 2. The username in the source table is a VARCHAR with a length of > 80, but the destination has a length of 16. What will happen to the data > in the destination table if it's longer than 16? Will it be truncated or > rejected? > > 3. The third case I'm a little confused about. In the source table, > I have a field for recording the date that the member joined. This is > stored in DATE format. The destination table uses a simple INT with a > length of 10. I this is a Unix time stamp format, because according to > the forum web site, you can access it from PHP using the time() > function. So would the command be something like: > COPY DATE(members.joindate) TO > UNIX_TIMESTAMP(forum_members.dateRegistered) > ...? > > 4. For storing email addresses, the source table uses a VARCHAR > field with a length of 100. In the destination it's a TINYTEXT. If I > understand correctly, TINYTEXT should hold 256 characters, so there > should be enough room. > > 5. The last case I need to combine two fields into one. The source > table uses seperate fields for first name and last name, and each is a > VARCHAR with a length of 100. In the destination table, first and last > names are stored in the same field, with a TINYTEXT format. > However, despite the fact that I've looked up "combine fields" and > "concatenate fields" on Google, I can't find instructions on how to do > that in reference to merging two fields into one, or copying from one > field to another. All the references I found are for querying the > database, combining data at the point of user input. How do I combine > two fields from one table, and put them into another? > > Any assistance is much appreciated. Thank you. > > Dave > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
