Mrthdrb

What's the metal clinking sound at the end of credits in Avengers: Endgame?

How can Republicans who favour free markets, consistently express anger when they don't like the outcome of that choice?

Python "triplet" dictionary?

How to set printing options as reverse order as default on 18.04

Confused by notation of atomic number Z and mass number A on periodic table of elements

What does 「再々起」mean?

Is GOCE a satellite or aircraft?

Phrase for the opposite of "foolproof"

Given what happens in Endgame, why doesn't Dormammu come back to attack the universe?

"ne paelici suspectaretur" (Tacitus)

How does a Swashbuckler rogue "fight with two weapons while safely darting away"?

How to create an ad-hoc wireless network in Ubuntu

How can I get precisely a certain cubic cm by changing the following factors?

Modify locally tikzset

Is it possible to Ready a spell to be cast just before the start of your next turn by having the trigger be an ally's attack?

Confusion about capacitors

Transfer over $10k

When and why did journal article titles become descriptive, rather than creatively allusive?

Do I have an "anti-research" personality?

Why is current rating for multicore cable lower than single core with the same cross section?

Airbnb - host wants to reduce rooms, can we get refund?

If Earth is tilted, why is Polaris always above the same spot?

Why does processed meat contain preservatives, while canned fish needs not?

Has any spacecraft ever had the ability to directly communicate with civilian air traffic control?

echo my sql query in magento

Magento: unable to create table from local extensionMYSQL ERROR [1045] Acces denied for user 'username'@'localhost' (using password: YES)Direct sql query in magento not workingCustom module table not found, the install is not executed$_SERVER['DOCUMENT_ROOT'] path issue in magentoMagento model not fetching dataSQL Query While uploading sql fileMagento Full Text Search through APIGenerate Chart in Magento 1.9Magento 1.9 : sales_flat_order and sales_flat_order_grid tables are not updating

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

here is some minor question but it always bother me while doing the code with magento.

$resource = Mage::getSingleton('core/resource');
$write = $resource->getConnection('core_write');
$table = $resource->getTableName('your/model');

$write->delete(
 $table,
 ['entity_id IN (?)' => [123, 456]]
);

$write->update(
 $table,
 ['column_1' => 3, 'column_2' => 4],
 ['entity_id = ?' => 123]
);

If I use above code to write into DB and I am not sure which query will be formed actually. How would I print the formed SQL through above write object.

I just know this one:

echo $collection->getSelect() 

In which I can get the select query printed on the screen.

Can you please suggest me so that I can get the query which is going to execute or which is executed in last.

Thank you :)

magento-1.9 database delete

share|improve this question

asked Apr 25 at 5:48

Mansi RajaMansi Raja

688

add a comment | 

1

here is some minor question but it always bother me while doing the code with magento.

$resource = Mage::getSingleton('core/resource');
$write = $resource->getConnection('core_write');
$table = $resource->getTableName('your/model');

$write->delete(
 $table,
 ['entity_id IN (?)' => [123, 456]]
);

$write->update(
 $table,
 ['column_1' => 3, 'column_2' => 4],
 ['entity_id = ?' => 123]
);

If I use above code to write into DB and I am not sure which query will be formed actually. How would I print the formed SQL through above write object.

I just know this one:

echo $collection->getSelect() 

In which I can get the select query printed on the screen.

Can you please suggest me so that I can get the query which is going to execute or which is executed in last.

Thank you :)

magento-1.9 database delete

share|improve this question

asked Apr 25 at 5:48

Mansi RajaMansi Raja

688

add a comment | 

here is some minor question but it always bother me while doing the code with magento.

$resource = Mage::getSingleton('core/resource');
$write = $resource->getConnection('core_write');
$table = $resource->getTableName('your/model');

$write->delete(
 $table,
 ['entity_id IN (?)' => [123, 456]]
);

$write->update(
 $table,
 ['column_1' => 3, 'column_2' => 4],
 ['entity_id = ?' => 123]
);

If I use above code to write into DB and I am not sure which query will be formed actually. How would I print the formed SQL through above write object.

I just know this one:

echo $collection->getSelect() 

In which I can get the select query printed on the screen.

Can you please suggest me so that I can get the query which is going to execute or which is executed in last.

Thank you :)

magento-1.9 database delete

share|improve this question

asked Apr 25 at 5:48

Mansi RajaMansi Raja

688

$resource = Mage::getSingleton('core/resource');
$write = $resource->getConnection('core_write');
$table = $resource->getTableName('your/model');

$write->delete(
 $table,
 ['entity_id IN (?)' => [123, 456]]
);

$write->update(
 $table,
 ['column_1' => 3, 'column_2' => 4],
 ['entity_id = ?' => 123]
);

echo $collection->getSelect() 

share|improve this question

asked Apr 25 at 5:48

Mansi RajaMansi Raja

688

share|improve this question

asked Apr 25 at 5:48

Mansi RajaMansi Raja

688

asked Apr 25 at 5:48

Mansi RajaMansi Raja

688

asked Apr 25 at 5:48

Mansi RajaMansi Raja

688

1 Answer
1

active

oldest

votes

1

try as below

echo $collection->getSelect()->__toString();

share|improve this answer

answered Apr 25 at 5:50

PiyushPiyush

4,85972054

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for the comment but this is not what I am looking for. I want to print the query which is being executed through core_write object
  
  – Mansi Raja
  Apr 25 at 7:28
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  @MansiRaja give this a try
  
  – Piyush
  Apr 25 at 9:58
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It works.. exactly what I need.. found in log.. thanks buddy :)
  
  – Mansi Raja
  Apr 25 at 13:27
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f272360%2fecho-my-sql-query-in-magento%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

try as below

echo $collection->getSelect()->__toString();

share|improve this answer

answered Apr 25 at 5:50

PiyushPiyush

4,85972054

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for the comment but this is not what I am looking for. I want to print the query which is being executed through core_write object
  
  – Mansi Raja
  Apr 25 at 7:28
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  @MansiRaja give this a try
  
  – Piyush
  Apr 25 at 9:58
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It works.. exactly what I need.. found in log.. thanks buddy :)
  
  – Mansi Raja
  Apr 25 at 13:27
  

  
  
  
  

add a comment | 

1

try as below

echo $collection->getSelect()->__toString();

share|improve this answer

answered Apr 25 at 5:50

PiyushPiyush

4,85972054

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for the comment but this is not what I am looking for. I want to print the query which is being executed through core_write object
  
  – Mansi Raja
  Apr 25 at 7:28
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  @MansiRaja give this a try
  
  – Piyush
  Apr 25 at 9:58
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It works.. exactly what I need.. found in log.. thanks buddy :)
  
  – Mansi Raja
  Apr 25 at 13:27
  

  
  
  
  

add a comment | 

try as below

echo $collection->getSelect()->__toString();

share|improve this answer

answered Apr 25 at 5:50

PiyushPiyush

4,85972054

echo $collection->getSelect()->__toString();

share|improve this answer

answered Apr 25 at 5:50

PiyushPiyush

4,85972054

answered Apr 25 at 5:50

PiyushPiyush

4,85972054

answered Apr 25 at 5:50

PiyushPiyush

4,85972054