{"id":25816,"date":"2024-03-16T05:36:51","date_gmt":"2024-03-16T05:36:51","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/"},"modified":"2024-03-22T07:05:12","modified_gmt":"2024-03-22T07:05:12","slug":"how-do-you-make-mysql-database-table-names-case-insensitive","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/","title":{"rendered":"How do you make MySQL database table names case-insensitive?"},"content":{"rendered":"

In MySQL, case sensitivity is enabled by default. However, it can be disabled by modifying the MySQL configuration file.<\/p>\n

To achieve case-insensitive table names, you can follow these steps:<\/p>\n

    \n
  1. Open the configuration file my.cnf for MySQL (typically named my.ini on Windows systems).<\/li>\n
  2. Locate the [mysqld] section and add the following configuration items underneath it:<\/li>\n<\/ol>\n
    lower_case_table_names=1\r\n<\/code><\/pre>\n
      \n
    1. Save and close the configuration file.<\/li>\n
    2. Restart the MySQL service.<\/li>\n<\/ol>\n
      Please take note:<\/p>\n
        \n
      1. After modifying the configuration file, it may be necessary to restart the MySQL service for the changes to take effect.<\/li>\n
      2. Changing the lower_case_table_names parameter will impact the case sensitivity of the database, so it is important to carefully consider and evaluate whether it will affect the existing business logic before making any changes.<\/li>\n<\/ol>\n
        When creating or querying tables without case sensitivity, table names will no longer be case sensitive. However, correct capitalization is still needed when referencing column names during queries.<\/p>\n","protected":false},"excerpt":{"rendered":"
        In MySQL, case sensitivity is enabled by default. However, it can be disabled by modifying the MySQL configuration file. To achieve case-insensitive table names, you can follow these steps: Open the configuration file my.cnf for MySQL (typically named my.ini on Windows systems). Locate the [mysqld] section and add the following configuration items underneath it: lower_case_table_names=1 […]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-25816","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nHow do you make MySQL database table names case-insensitive? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How do you make MySQL database table names case-insensitive?\" \/>\n<meta property=\"og:description\" content=\"In MySQL, case sensitivity is enabled by default. However, it can be disabled by modifying the MySQL configuration file. To achieve case-insensitive table names, you can follow these steps: Open the configuration file my.cnf for MySQL (typically named my.ini on Windows systems). Locate the [mysqld] section and add the following configuration items underneath it: lower_case_table_names=1 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T05:36:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T07:05:12+00:00\" \/>\n<meta name=\"author\" content=\"Jackson Davis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jackson Davis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/\"},\"author\":{\"name\":\"Jackson Davis\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\"},\"headline\":\"How do you make MySQL database table names case-insensitive?\",\"datePublished\":\"2024-03-16T05:36:51+00:00\",\"dateModified\":\"2024-03-22T07:05:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/\"},\"wordCount\":162,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/\",\"name\":\"How do you make MySQL database table names case-insensitive? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T05:36:51+00:00\",\"dateModified\":\"2024-03-22T07:05:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How do you make MySQL database table names case-insensitive?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\",\"name\":\"Jackson Davis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"caption\":\"Jackson Davis\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How do you make MySQL database table names case-insensitive? - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/","og_locale":"en_US","og_type":"article","og_title":"How do you make MySQL database table names case-insensitive?","og_description":"In MySQL, case sensitivity is enabled by default. However, it can be disabled by modifying the MySQL configuration file. To achieve case-insensitive table names, you can follow these steps: Open the configuration file my.cnf for MySQL (typically named my.ini on Windows systems). Locate the [mysqld] section and add the following configuration items underneath it: lower_case_table_names=1 […]","og_url":"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T05:36:51+00:00","article_modified_time":"2024-03-22T07:05:12+00:00","author":"Jackson Davis","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Jackson Davis","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/"},"author":{"name":"Jackson Davis","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350"},"headline":"How do you make MySQL database table names case-insensitive?","datePublished":"2024-03-16T05:36:51+00:00","dateModified":"2024-03-22T07:05:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/"},"wordCount":162,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/","url":"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/","name":"How do you make MySQL database table names case-insensitive? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T05:36:51+00:00","dateModified":"2024-03-22T07:05:12+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-make-mysql-database-table-names-case-insensitive\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How do you make MySQL database table names case-insensitive?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350","name":"Jackson Davis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","caption":"Jackson Davis"},"url":"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/25816","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=25816"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/25816\/revisions"}],"predecessor-version":[{"id":59947,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/25816\/revisions\/59947"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=25816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=25816"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=25816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}