Otdfbt

Multi tool use

Why do Ryanair allow me to book connecting itineraries through a third party, but not through their own website?

Looking for a soft substance that doesn't dissolve underwater

At what point in European history could a government build a printing press given a basic description?

Employer demanding to see degree after poor code review

Caught 2 students cheating together on the final exam that I proctored

Why did David Cameron offer a referendum on the European Union?

How to patch glass cuts in a bicycle tire?

Why does this if-statement combining assignment and an equality check return true?

Can a person survive on blood in place of water?

Any advice on creating fictional locations in real places when writing historical fiction?

Is the derivative with respect to a fermion field Grassmann-odd?

Inclusion of standard error in regression equation

Where can I find visible/radio telescopic observations of the center of the Milky Way galaxy?

Using credit/debit card details vs swiping a card in a payment (credit card) terminal

Maxima of Brownian motion

Count rotary dial pulses in a phone number (including letters)

Why is this Simple Puzzle impossible to solve?

Can I tell a prospective employee that everyone in the team is leaving?

Where is the logic in castrating fighters?

How to invert colors of a picture on Mac?

I know that there is a preselected candidate for a position to be filled at my department. What should I do?

Is DateWithin30Days(Date 1, Date 2) an Apex Method?

Is the Indo-European language family made up?

How to respond to an upset student?

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

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 May 13 at 4:52

NewBieNewBie

635

closed as too broad by Shoaib Munir, Manashvi Birla, saravanavelu, Muhammad Hasham, HelgeB May 13 at 7:11

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  you mean column type ???
  
  – Rk Rathod
  May 13 at 4:57
  

  
  
  
  

add a comment | 

1

I want get type columns of table in sql ?

---

magento2

share|improve this question

asked May 13 at 4:52

NewBieNewBie

635

closed as too broad by Shoaib Munir, Manashvi Birla, saravanavelu, Muhammad Hasham, HelgeB May 13 at 7:11

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  you mean column type ???
  
  – Rk Rathod
  May 13 at 4:57
  

  
  
  
  

add a comment | 

I want get type columns of table in sql ?

---

magento2

share|improve this question

asked May 13 at 4:52

NewBieNewBie

635

share|improve this question

asked May 13 at 4:52

NewBieNewBie

635

share|improve this question

asked May 13 at 4:52

NewBieNewBie

635

asked May 13 at 4:52

NewBieNewBie

635

asked May 13 at 4:52

NewBieNewBie

635

2 Answers
2

active

oldest

votes

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 May 13 at 5:13

PawanPawan

2,3892721

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thank your answer but i want get data_type of table for add columns!
  
  – NewBie
  May 13 at 6:37
  

  
  
  
  

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 = "DESCRIBE $tableName";
$connection->query($sql);

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

share|improve this answer

edited 15 hours ago

answered May 13 at 5:10

MR.R DNATHMR.R DNATH

37117

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  it does not working. i want get type of catalog_product_entity table.
  
  – NewBie
  May 13 at 6:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  please check my edited answer.
  
  – MR.R DNATH
  15 hours ago
  

  
  
  
  

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 May 13 at 5:13

PawanPawan

2,3892721

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thank your answer but i want get data_type of table for add columns!
  
  – NewBie
  May 13 at 6:37
  

  
  
  
  

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 May 13 at 5:13

PawanPawan

2,3892721

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thank your answer but i want get data_type of table for add columns!
  
  – NewBie
  May 13 at 6:37
  

  
  
  
  

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 May 13 at 5:13

PawanPawan

2,3892721

DESCRIBE table_name;

 DESCRIBE core_config_data; 

share|improve this answer

answered May 13 at 5:13

PawanPawan

2,3892721

answered May 13 at 5:13

PawanPawan

2,3892721

answered May 13 at 5:13

PawanPawan

2,3892721

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 = "DESCRIBE $tableName";
$connection->query($sql);

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

share|improve this answer

edited 15 hours ago

answered May 13 at 5:10

MR.R DNATHMR.R DNATH

37117

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  it does not working. i want get type of catalog_product_entity table.
  
  – NewBie
  May 13 at 6:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  please check my edited answer.
  
  – MR.R DNATH
  15 hours ago
  

  
  
  
  

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 = "DESCRIBE $tableName";
$connection->query($sql);

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

share|improve this answer

edited 15 hours ago

answered May 13 at 5:10

MR.R DNATHMR.R DNATH

37117

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  it does not working. i want get type of catalog_product_entity table.
  
  – NewBie
  May 13 at 6:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  please check my edited answer.
  
  – MR.R DNATH
  15 hours ago
  

  
  
  
  

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 = "DESCRIBE $tableName";
$connection->query($sql);

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

share|improve this answer

edited 15 hours ago

answered May 13 at 5:10

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 = "DESCRIBE $tableName";
$connection->query($sql);

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

share|improve this answer

edited 15 hours ago

answered May 13 at 5:10

MR.R DNATHMR.R DNATH

37117

answered May 13 at 5:10

MR.R DNATHMR.R DNATH

37117

answered May 13 at 5:10

MR.R DNATHMR.R DNATH

37117