Display sql of executed statement Yii

Question

I want to display sql code of the executed statement like SHOW CREATE TABLE my_table, but it return 1 meaning the exution was successful, so how I can see the code like

CREATE TABLE `my_table` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content` varchar(255) NOT NULL,

?

Suriyan Suresh · Accepted Answer · 2015-01-21 10:50:45Z

2

Better you can try http://www.yiiframework.com/extension/yii-debug-toolbar/ which will show you the all sql queries traces.

answered Jan 21, 2015 at 10:50

Suriyan Suresh

3,03414 gold badges55 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

nowiko Over a year ago

I need this code not for debug purposes. But thanks, I think toolbur will be useful too .)

Let me see · Accepted Answer · 2015-01-21 10:41:20Z

1

Try this

$result=Yii::app()->db->createCommand('SHOW CREATE TABLE my_table')->queryRow();

This will give you an array containing table name and the sql query for creating the table. Eg:-

array
(
'Table'=>'my_table',
'Create Table'=>'Query For Creating Table'
)

SO you can get the desired result using

$result['Create Table']

answered Jan 21, 2015 at 10:41

Let me see

5,0949 gold badges40 silver badges49 bronze badges

Collectives™ on Stack Overflow

Display sql of executed statement Yii

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related