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
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;
I want get type columns of table in sql ?
magento2
asked 1 hour ago
NewBieNewBie
334
add a comment |
I want get type columns of table in sql ?
magento2
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
asked 1 hour ago
NewBieNewBie
334
I want get type columns of table in sql ?
magento2
magento2
asked 1 hour ago
NewBieNewBie
334
asked 1 hour ago
NewBieNewBie
334
asked 1 hour ago
NewBieNewBie
334
asked 1 hour ago
NewBieNewBie
334
asked 1 hour ago
NewBieNewBie
334
334
you mean column type ???
– Rk Rathod
56 mins ago
add a comment |
you mean column type ???
– Rk Rathod
56 mins ago
you mean column type ???
– Rk Rathod
56 mins ago
you mean column type ???
– Rk Rathod
56 mins ago
add a comment |
2 Answers
2
active
oldest
votes
*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.**
answered 43 mins ago
MR.R DNATHMR.R DNATH
37117
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!
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
);
);
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
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
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
*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.**
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.**
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.**
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.**
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
answered 43 mins ago
MR.R DNATHMR.R DNATH
37117
37117
add a comment |
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!
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!
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!
answered 40 mins ago
PawanPawan
2,3192721
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!
answered 40 mins ago
PawanPawan
2,3192721
answered 40 mins ago
PawanPawan
2,3192721
answered 40 mins ago
PawanPawan
2,3192721
answered 40 mins ago
PawanPawan
2,3192721
2,3192721
add a comment |
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
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
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
you mean column type ???
– Rk Rathod
56 mins ago