Mfcttrf

Could there be a material that inverts the colours seen through it?

Formal Definition of Dot Product

Anatomically Correct Carnivorous Tree

Program which behaves differently in/out of a debugger

Will a coyote attack my dog on a leash while I'm on a hiking trail?

How can a layman easily get the consensus view of what academia *thinks* about a subject?

What kind of SATA connector is this?

Why is it harder to turn a motor/generator with shorted terminals?

Why are solar panels kept tilted?

Why does the headset man not get on the tractor?

Where to find every-day healthy food near Heathrow Airport?

Would an 8% reduction in drag outweigh the weight addition from this custom CFD-tested winglet?

When a land becomes a creature, is it untapped?

Jumping frame contents with beamer and pgfplots

Why was Thor doubtful about his worthiness to Mjolnir?

using `is` operator with value type tuples gives error

In books, how many dragons are there in present time?

If the square of a time series is stationary, is the original time series stationary?

What's tha name for when you write multiple voices on same staff? And are there any cons?

Find hamming distance between two Strings of equal length in Java

Is taking modulus on both sides of an equation valid?

Unexpected Netflix account registered to my Gmail address - any way it could be a hack attempt?

Developers demotivated due to working on same project for more than 2 years

Are there any established rules for splitting books into parts, chapters, sections etc?

Magento 2: How to get type columns of table in sql?

Change type columns on Adminhtml Magento 2How to get and set custom field of customer_group table Magento 2How to get invoice item list using sql query?In Magento2 UpgradeSchema, Don't we have addColumns to add more columns to a table?How to log all Magento 2 SQL queries?How can I add UNIQUE Constraint in table via 'InstallSchema'?How to get datas from this table 'directory_currency_rate'How to get All Column names of table in magento 2Indexing the Core Magento 2 table columns without effecting the update query performancesql query in cms_block table in magento 2

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

1

I want get type columns of table in sql ?

---

magento2

share|improve this question

asked 1 hour ago

NewBieNewBie

334

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  you mean column type ???
  
  – Rk Rathod
  56 mins ago
  

  
  
  
  

add a comment | 

1

I want get type columns of table in sql ?

---

magento2

share|improve this question

asked 1 hour ago

NewBieNewBie

334

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  you mean column type ???
  
  – Rk Rathod
  56 mins ago
  

  
  
  
  

add a comment | 

I want get type columns of table in sql ?

---

magento2

share|improve this question

asked 1 hour ago

NewBieNewBie

334

share|improve this question

asked 1 hour ago

NewBieNewBie

334

share|improve this question

asked 1 hour ago

NewBieNewBie

334

asked 1 hour ago

NewBieNewBie

334

asked 1 hour ago

NewBieNewBie

334

2 Answers
2

active

oldest

votes

1

*Try To run Following code to get column datatype by Magento way.*

$objectManager = MagentoFrameworkAppObjectManager::getInstance();
$resource = $objectManager->get('MagentoFrameworkAppResourceConnection');
$connection = $resource->getConnection();
$tableName = $resource->getTableName('core_config_data');

$sql = "SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS 
 WHERE table_name = " . $tableName ." AND COLUMN_NAME = 'scope'";
$connection->query($sql);

**NOTE: Don't use direct ObjectManager try to use di.**

share|improve this answer

answered 43 mins ago

MR.R DNATHMR.R DNATH

37117

add a comment | 

1

I think you want to check type of column like varchar(255), int(11) etc.

You can use:

DESCRIBE table_name;

for example:

 DESCRIBE core_config_data; 

it will show :

Hope above will help!

share|improve this answer

answered 40 mins ago

PawanPawan

2,3192721

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%2f274313%2fmagento-2-how-to-get-type-columns-of-table-in-sql%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

*Try To run Following code to get column datatype by Magento way.*

$objectManager = MagentoFrameworkAppObjectManager::getInstance();
$resource = $objectManager->get('MagentoFrameworkAppResourceConnection');
$connection = $resource->getConnection();
$tableName = $resource->getTableName('core_config_data');

$sql = "SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS 
 WHERE table_name = " . $tableName ." AND COLUMN_NAME = 'scope'";
$connection->query($sql);

**NOTE: Don't use direct ObjectManager try to use di.**

share|improve this answer

answered 43 mins ago

MR.R DNATHMR.R DNATH

37117

add a comment | 

1

*Try To run Following code to get column datatype by Magento way.*

$objectManager = MagentoFrameworkAppObjectManager::getInstance();
$resource = $objectManager->get('MagentoFrameworkAppResourceConnection');
$connection = $resource->getConnection();
$tableName = $resource->getTableName('core_config_data');

$sql = "SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS 
 WHERE table_name = " . $tableName ." AND COLUMN_NAME = 'scope'";
$connection->query($sql);

**NOTE: Don't use direct ObjectManager try to use di.**

share|improve this answer

answered 43 mins ago

MR.R DNATHMR.R DNATH

37117

add a comment | 

*Try To run Following code to get column datatype by Magento way.*

$objectManager = MagentoFrameworkAppObjectManager::getInstance();
$resource = $objectManager->get('MagentoFrameworkAppResourceConnection');
$connection = $resource->getConnection();
$tableName = $resource->getTableName('core_config_data');

$sql = "SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS 
 WHERE table_name = " . $tableName ." AND COLUMN_NAME = 'scope'";
$connection->query($sql);

**NOTE: Don't use direct ObjectManager try to use di.**

share|improve this answer

answered 43 mins ago

MR.R DNATHMR.R DNATH

37117

*Try To run Following code to get column datatype by Magento way.*

$objectManager = MagentoFrameworkAppObjectManager::getInstance();
$resource = $objectManager->get('MagentoFrameworkAppResourceConnection');
$connection = $resource->getConnection();
$tableName = $resource->getTableName('core_config_data');

$sql = "SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS 
 WHERE table_name = " . $tableName ." AND COLUMN_NAME = 'scope'";
$connection->query($sql);

**NOTE: Don't use direct ObjectManager try to use di.**

share|improve this answer

answered 43 mins ago

MR.R DNATHMR.R DNATH

37117

answered 43 mins ago

MR.R DNATHMR.R DNATH

37117

answered 43 mins ago

MR.R DNATHMR.R DNATH

37117

1

I think you want to check type of column like varchar(255), int(11) etc.

You can use:

DESCRIBE table_name;

for example:

 DESCRIBE core_config_data; 

it will show :

Hope above will help!

share|improve this answer

answered 40 mins ago

PawanPawan

2,3192721

add a comment | 

1

I think you want to check type of column like varchar(255), int(11) etc.

You can use:

DESCRIBE table_name;

for example:

 DESCRIBE core_config_data; 

it will show :

Hope above will help!

share|improve this answer

answered 40 mins ago

PawanPawan

2,3192721

add a comment | 

I think you want to check type of column like varchar(255), int(11) etc.

You can use:

DESCRIBE table_name;

for example:

 DESCRIBE core_config_data; 

it will show :

Hope above will help!

share|improve this answer

answered 40 mins ago

PawanPawan

2,3192721

DESCRIBE table_name;

 DESCRIBE core_config_data; 

share|improve this answer

answered 40 mins ago

PawanPawan

2,3192721

answered 40 mins ago

PawanPawan

2,3192721

answered 40 mins ago

PawanPawan

2,3192721