Nov 22, 2009

A Simple Query For Those That Know - I have users that want to do the below:

free web hosting
Open Discussion & Free Web Hosting > Computers & Tech > Programming > Programming General > SQL (Structured Query Language)

A Simple Query For Those That Know - I have users that want to do the below:

Houdini
I Make ported mods for the PHP-Nuke and this means first of all I need to change the prefixes to al the tables that are in the phpbb database, because Nuke uses the prefix of nuke (of course) but there are nuances such as the users table in nuke is just nuke_users

Let me start again, all phpbb or phpbb2 tables as created by the install unless changed by the user in the config.php file are phpbb_forum this or phpbb_users that but nuke has other tables in its database structure the data in those table by whatever name remains the same nuke_users has exactly the same structure as phpbb_users.

What I basically do when I port a mod that requires a prefix or table name change is using an editor to globally replace all phpbb to nuke which work 9 of 10 times but I need to know a little more about MySQL to for instance modify a phpbb sql to work with my nuke sql queries, and actually work, and I am sure it is possible if the right commands are given in the php or txt or sql file.

Comment/Reply (w/o sign-up)

oncombeureum
i can't get it.

are u asking a question or just make a comment.

i read it many times but still doesn't get the picture of it.

i don't know if my suqqestion here worth while.

1. is it possible for u to use a phpMyAdmin ?
2. create an alter table query for all the table.
3. run it using phpMyAdmin.
4. that will rename all the table from phpbb to phpbb2

that's all

danke

Oncom Beureum
The Best Place in the City

Comment/Reply (w/o sign-up)

vhortex
QUOTE (oncombeureum @ Apr 27 2005, 11:47 AM)
i can't get it.

are u asking a question or just make a comment.

i read it many times but still doesn't get the picture of it.

i don't know if my suqqestion here worth while.

1. is it possible for u to use a phpMyAdmin ?
2. create an alter table query for all the table.
3. run it using phpMyAdmin.
4. that will rename all the table from phpbb to phpbb2

that's all

danke

Oncom Beureum
The Best Place in the City
*


there is a much better and shorter way if the database allows remote connection..
goto webyog.com...

download sqlyog and logon into your database..

if you want to rename the table then just click and right click on the table name and presto select rename and you can rename..

or if they really look alike and you want to append the contents of the other parallel table then.. select copy database to new location.. etc etc..

he seems to be quoting or something but defintely not questioning coz he is already giving out his opinions

 

 

 


Comment/Reply (w/o sign-up)


Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

This textarea will convert to Rich-Text automatically (IE, Firefox, Chrome)


See Also,

*SIMILAR VIDEOS*
Searching Video's for simple, query, users
advertisement



A Simple Query For Those That Know - I have users that want to do the below:

Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com