What does this query means? - GoFuckYourself.com

Klen · 08-02-2008, 10:25 AM

I installed one mod on one script and last step is adding sql but i dont know how to add it,i tried with sql query on phpmyadmin but it reports errors.
Here is info:
Query: [Select]
SHOW COLUMNS FROM {$db_prefix}members LIKE '$column'
Query: [Select]
SHOW COLUMNS FROM {$db_prefix}log_activity LIKE '$column'
Query: [Select]
ALTER TABLE {$db_prefix}log_activity ADD COLUMN $column $spec

pythonx · 08-02-2008, 10:38 AM

The first 2 just show the columns of the tables which have a name that contains the value of $column.

The last query adds a new column at the end of the table, named with the value of $column and with datatype specified in $spec.

Klen · 08-02-2008, 01:07 PM

Yes but can it be converted to phpmyadmin sql code ?

Eriic · 08-02-2008, 01:14 PM

It shows me tht you don't know what you are doing and need to hire someone.

ladida · 08-02-2008, 01:36 PM

It's a bit hillarious :P

"can it be converted to phpmyadmin sql code"

) LOL.

Ecchi22 · 08-02-2008, 02:10 PM

"In general, a query is a form of questioning, in a line of inquiry"

SQL = Structured Query Language

And yes, you can do that using PHPMyAdmin..

Bird · 08-02-2008, 02:13 PM

Whats the errors...

Klen · 08-02-2008, 03:20 PM

Quote:

Originally Posted by Eriic

It shows me tht you don't know what you are doing and need to hire someone.

Actualy i do know what i doing.I just dont know what fuck that means.

Klen · 08-05-2008, 02:37 PM

I got answer in phpmyadmin query form from author.Problem solved.

Eriic · 08-05-2008, 04:18 PM

Quote:

Originally Posted by KlenTelaris

Actualy i am stupid and don't know what i am doing.I just dont know what fuck life means.

It's obvious nimrod

08-02-2008, 10:25 AM	#1
Klen Industry Role: Join Date: Aug 2006 Location: Little Vienna Posts: 32,235	What does this query means? I installed one mod on one script and last step is adding sql but i dont know how to add it,i tried with sql query on phpmyadmin but it reports errors. Here is info: Query: [Select] SHOW COLUMNS FROM {$db_prefix}members LIKE '$column' Query: [Select] SHOW COLUMNS FROM {$db_prefix}log_activity LIKE '$column' Query: [Select] ALTER TABLE {$db_prefix}log_activity ADD COLUMN $column $spec

08-02-2008, 01:36 PM	#5
ladida Confirmed User Join Date: Nov 2005 Posts: 2,167	It's a bit hillarious :P "can it be converted to phpmyadmin sql code" ) LOL. __________________ agentGFY at gmail.com

08-02-2008, 02:10 PM	#6
Ecchi22 Too lazy to set a custom title Industry Role: Join Date: Nov 2005 Posts: 10,012	"In general, a query is a form of questioning, in a line of inquiry" SQL = Structured Query Language And yes, you can do that using PHPMyAdmin.. __________________

08-02-2008, 02:13 PM	#7
Bird Confirmed User Join Date: Jan 2005 Location: Stockton Posts: 4,365	Whats the errors... __________________ ICQ:268731675

08-02-2008, 10:38 AM	#2
pythonx Confirmed User Join Date: Aug 2004 Posts: 430	The first 2 just show the columns of the tables which have a name that contains the value of $column. The last query adds a new column at the end of the table, named with the value of $column and with datatype specified in $spec.

08-02-2008, 01:07 PM	#3
Klen Industry Role: Join Date: Aug 2006 Location: Little Vienna Posts: 32,235	Yes but can it be converted to phpmyadmin sql code ?

08-02-2008, 01:14 PM	#4
Eriic So Fucking Banned Join Date: Jan 2008 Posts: 2,995	It shows me tht you don't know what you are doing and need to hire someone.

08-05-2008, 02:37 PM	#9
Klen Industry Role: Join Date: Aug 2006 Location: Little Vienna Posts: 32,235	I got answer in phpmyadmin query form from author.Problem solved.