{"id":14883,"date":"2022-10-09T12:58:31","date_gmt":"2022-10-09T07:28:31","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/"},"modified":"2022-10-09T12:58:31","modified_gmt":"2022-10-09T07:28:31","slug":"solved-creating-multiple-tables-and-inserting-data-into-them-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/","title":{"rendered":"[Solved] Creating multiple Tables and inserting Data into them [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-50548733\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"50548733\" data-parentid=\"50544190\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>Your issue &#8220;there is always only one table created&#8221;, will be due to the very common misconception that the <strong><code>onCreate<\/code><\/strong> method, in <strong>DatabaseHelper.java<\/strong> (generally termed the Database Helper) runs every time the App is run. Actually the <code>onCreate<\/code> method is only automatically invoked once for the lifetime of the database.<\/p>\n<p>If the <strong>data held in the database can be lost<\/strong> then the fix is simply, delete the database.<\/p>\n<ul>\n<li>this can be done by either\n<ul>\n<li>deleting the App&#8217;s data from settings\/Apps or<\/li>\n<li>uninstalling the App from settings\/Apps<br \/>\nWhen the App is then rerun the <code>onCreate<\/code> method will then be invoked.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>In your situation the <code>onUpgrade<\/code> drops the tables, if they exist, and then invokes the <code>onCreate<\/code> method. As such an alternative to deleting the App&#8217;s data\/uninstalling the App, would be to increase the Database Version, which will then cause the <code>onUpgrade<\/code> method to be run, and thus recreating the tables.<\/p>\n<p><strong>Note<\/strong> this would still result in any existing data being lost.<\/p>\n<p>e.g. :-<\/p>\n<pre><code>public DatabaseHelper(Context context) {\n    super(context, DATABASE_NAME, null, 2); \/\/&lt;&lt;&lt;&lt; CHANGED 1 to 2\n    Log.d(\"MeineAPP\", \"DB angelegt\");\n}\n<\/code><\/pre>\n<h2>Testing of your code<\/h2>\n<p>The actual table create statements work and using logDatabaseInfo from this a clean run produces :-<\/p>\n<pre><code>05-26 20:52:24.618 1398-1398\/? D\/MeineAPP: DB angelegt\n05-26 20:52:24.622 1398-1398\/? D\/SQLITE_CSU: DatabaseList Row 1 Name=main File=\/data\/data\/jannikokan.de.stundenplan\/databases\/Stundenplan.db\n    Database Version = 1\n    Table Name = android_metadata Created Using = CREATE TABLE android_metadata (locale TEXT)\n05-26 20:52:24.626 1398-1398\/? D\/SQLITE_CSU: Table = android_metadata ColumnName = locale ColumnType = TEXT Default Value = null PRIMARY KEY SEQUENCE = 0\n    Table Name = Fach_table Created Using = CREATE TABLE Fach_table(IDINTEGER PRIMARY KEY,FACHNAMETEXT,FACHKUERZEL TEXT,FACHRAUMTEXT,FACHLEHRER TEXT)\n    Table = Fach_table ColumnName = IDINTEGER ColumnType =  Default Value = null PRIMARY KEY SEQUENCE = 1\n    Table = Fach_table ColumnName = FACHNAMETEXT ColumnType =  Default Value = null PRIMARY KEY SEQUENCE = 0\n    Table = Fach_table ColumnName = FACHKUERZEL ColumnType = TEXT Default Value = null PRIMARY KEY SEQUENCE = 0\n    Table = Fach_table ColumnName = FACHRAUMTEXT ColumnType =  Default Value = null PRIMARY KEY SEQUENCE = 0\n    Table = Fach_table ColumnName = FACHLEHRER ColumnType = TEXT Default Value = null PRIMARY KEY SEQUENCE = 0\n    Table Name = Lehrer_table Created Using = CREATE TABLE Lehrer_table(ID_LINTEGER PRIMARY KEY,LEHRERNAMETEXT,LEHRERKUERZELTEXT,LEHRERRAUMTEXT,LEHRERMAILTEXT)\n    Table = Lehrer_table ColumnName = ID_LINTEGER ColumnType =  Default Value = null PRIMARY KEY SEQUENCE = 1\n    Table = Lehrer_table ColumnName = LEHRERNAMETEXT ColumnType =  Default Value = null PRIMARY KEY SEQUENCE = 0\n    Table = Lehrer_table ColumnName = LEHRERKUERZELTEXT ColumnType =  Default Value = null PRIMARY KEY SEQUENCE = 0\n    Table = Lehrer_table ColumnName = LEHRERRAUMTEXT ColumnType =  Default Value = null PRIMARY KEY SEQUENCE = 0\n    Table = Lehrer_table ColumnName = LEHRERMAILTEXT ColumnType =  Default Value = null PRIMARY KEY SEQUENCE = 0\n<\/code><\/pre>\n<p>However, looking at your code you do have an issue with two methods (<code>zeigeFaecher<\/code> and <code>zeigeLehrer<\/code>) in that you have omitted a space between <strong><code>*<\/code><\/strong> and <strong><code>from<\/code><\/strong> i.e. you have <strong><code>*from<\/code><\/strong> which should be <strong><code>* from<\/code><\/strong>.<\/p>\n<ul>\n<li><strong><em>Note<\/em><\/strong> testing was limited to this issue specifically and that the testing is by no means saying that there are not other aspects that will or will not result in issues.<\/li>\n<\/ul>\n<hr>\n<h3>Additional &#8211; Retaining Data (simple solution)<\/h3>\n<p>If you have data that needs to be kept then you will have to devise a method of keeping the data.<\/p>\n<p>It could be as simple as adding a check to see if the expected tables exist and if not to create them e.g. you could have\/add the following in Databasehelper.java :-<\/p>\n<p>e.g. :-<\/p>\n<pre><code>\/\/ This is the publicly accessible driver that has the core lists\n\/\/ i.e. the list of tables that should exist and the\n\/\/ corresponding table create statements which are passed to\n\/\/ the createTablesThatDoNotExist method\npublic void addAnyNewTables() {\n    String[] required_tables = new String[]{\n            TABLE_NAME,\n            TABLE_LEHRER\n    };\n\n    String[] table_create_statements = new String[] {\n      create_Table,\n      create_Table2\n    };\n    createTablesThatDoNotExist(required_tables,table_create_statements);\n}\n\n\n\/\/ This method checks the validity lengths and count of the 2 arrays\n\/\/ loping through them if valid pass the table and the create statement to the\n\/\/ doCheckAndCreateOfTable method.\nprivate void createTablesThatDoNotExist(String[] required_tables, String[] table_create_statements) {\n\n    \/\/ If no tables or table create statements then finish\n    if (required_tables.length &lt; 1 || table_create_statements.length &lt; 1) {\n        return;\n    }\n    \/\/ elements in arrays must match\n    if (required_tables.length != table_create_statements.length) {\n        return;\n    }\n    SQLiteDatabase db = this.getWritableDatabase();\n    String whereclause = \"name\";\n    for (int i=0; i &lt; required_tables.length;i++) {\n        if (required_tables[i].length() &gt; 0 &amp;&amp; table_create_statements[i].length() &gt; 0) {\n            doCheckAndCreateOfTable(\n                    required_tables[i].toString(),\n                    table_create_statements[i].toString()\n            );\n        }\n    }\n}\n\n\/\/ This does the real work by interrogatin sqlite_master to see if the table\n\/\/ exists. If not then it runs the query to create the table using the\n\/\/ create_statement passed.\nprivate void doCheckAndCreateOfTable(String table,String create_statement) {\n    SQLiteDatabase db = this.getWritableDatabase();\n    String whereclause = \"name=? AND type=?\";\n    String[] whereargs = new String[]{table,\"table\"};\n    String table_to_query = \"sqlite_master\";\n    Cursor csr = db.query(table_to_query,null,whereclause,whereargs,null,null,null);\n    if (csr.getCount() &lt; 1) {\n        db.execSQL(create_statement);\n    }\n    csr.close();\n}\n<\/code><\/pre>\n<p>You could then invoke this in the initial activity after getting an instance of the DatabaseHelper e.g. :-<\/p>\n<pre><code>    mDBHlpr = new DatabaseHelper(this);\n    mDBHlpr.addAnyNewTables();\n    SQLiteDatabase db = mDBHlpr.getWritableDatabase();\n    CommonSQLiteUtilities.logDatabaseInfo(db);\n<\/code><\/pre>\n<p>The above was tested by commenting out the creation of the second table, deleting the App&#8217;s data (and therefore the database) and then running the App using the following in the <code>onCreate<\/code> (to purposefully NOT create the 2nd table)<\/p>\n<pre><code>public void onCreate(SQLiteDatabase db) {\n\n    Log.d(\"MeineAPP\", \"Tabelle angelegt\");\n    \/\/  db.execSQL(\"create table \" + TABLE_NAME + \"(ID INTEGER PRIMARY KEY AUTOINCREMENT, FACHNAME TEXT, FACHKUERZEL TEXT, FACHRAUM TEXT, FACHLEHRER TEXT)\");\n    db.execSQL(create_Table);\n    \/\/db.execSQL(create_Table2); \/\/&lt;&lt;&lt;&lt; COMMENTED OUT FOR TEST\n\n}\n<\/code><\/pre>\n<p>The resultant output was :-<\/p>\n<pre><code>05-26 21:16:07.672 1742-1742\/? D\/MeineAPP: DB angelegt\n05-26 21:16:07.672 1742-1744\/? D\/dalvikvm: GC_CONCURRENT freed 236K, 10% free 6158K\/6791K, paused 11ms+0ms, total 15ms\n05-26 21:16:07.708 1742-1742\/? D\/SQLITE_CSU: DatabaseList Row 1 Name=main File=\/data\/data\/jannikokan.de.stundenplan\/databases\/Stundenplan.db\n    Database Version = 1\n    Table Name = android_metadata Created Using = CREATE TABLE android_metadata (locale TEXT)\n    Table = android_metadata ColumnName = locale ColumnType = TEXT Default Value = null PRIMARY KEY SEQUENCE = 0\n    Table Name = Fach_table Created Using = CREATE TABLE Fach_table(IDINTEGER PRIMARY KEY,FACHNAMETEXT,FACHKUERZEL TEXT,FACHRAUMTEXT,FACHLEHRER TEXT)\n    Table = Fach_table ColumnName = IDINTEGER ColumnType =  Default Value = null PRIMARY KEY SEQUENCE = 1\n    Table = Fach_table ColumnName = FACHNAMETEXT ColumnType =  Default Value = null PRIMARY KEY SEQUENCE = 0\n    Table = Fach_table ColumnName = FACHKUERZEL ColumnType = TEXT Default Value = null PRIMARY KEY SEQUENCE = 0\n    Table = Fach_table ColumnName = FACHRAUMTEXT ColumnType =  Default Value = null PRIMARY KEY SEQUENCE = 0\n    Table = Fach_table ColumnName = FACHLEHRER ColumnType = TEXT Default Value = null PRIMARY KEY SEQUENCE = 0\n    Table Name = Lehrer_table Created Using = CREATE TABLE Lehrer_table(ID_LINTEGER PRIMARY KEY,LEHRERNAMETEXT,LEHRERKUERZELTEXT,LEHRERRAUMTEXT,LEHRERMAILTEXT)\n    Table = Lehrer_table ColumnName = ID_LINTEGER ColumnType =  Default Value = null PRIMARY KEY SEQUENCE = 1\n    Table = Lehrer_table ColumnName = LEHRERNAMETEXT ColumnType =  Default Value = null PRIMARY KEY SEQUENCE = 0\n    Table = Lehrer_table ColumnName = LEHRERKUERZELTEXT ColumnType =  Default Value = null PRIMARY KEY SEQUENCE = 0\n    Table = Lehrer_table ColumnName = LEHRERRAUMTEXT ColumnType =  Default Value = null PRIMARY KEY SEQUENCE = 0\n    Table = Lehrer_table ColumnName = LEHRERMAILTEXT ColumnType =  Default Value = null PRIMARY KEY SEQUENCE = 0\n<\/code><\/pre>\n<p><strong>i.e. both tables have been created<\/strong><\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">5<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Creating multiple Tables and inserting Data into them [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] Your issue &#8220;there is always only one table created&#8221;, will be due to the very common misconception that the onCreate method, in DatabaseHelper.java (generally termed the Database Helper) runs every time the App is run. Actually the onCreate method is only automatically invoked once for the lifetime of the database. If the data held &#8230; <a title=\"[Solved] Creating multiple Tables and inserting Data into them [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/\" aria-label=\"More on [Solved] Creating multiple Tables and inserting Data into them [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[452,1352,546,707],"class_list":["post-14883","post","type-post","status-publish","format-standard","hentry","category-solved","tag-android","tag-android-sqlite","tag-database","tag-sqlite"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Creating multiple Tables and inserting Data into them [closed] - JassWeb<\/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:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Creating multiple Tables and inserting Data into them [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Your issue &#8220;there is always only one table created&#8221;, will be due to the very common misconception that the onCreate method, in DatabaseHelper.java (generally termed the Database Helper) runs every time the App is run. Actually the onCreate method is only automatically invoked once for the lifetime of the database. If the data held ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-09T07:28:31+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Creating multiple Tables and inserting Data into them [closed]\",\"datePublished\":\"2022-10-09T07:28:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/\"},\"wordCount\":400,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"android\",\"android-sqlite\",\"database\",\"sqlite\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/\",\"name\":\"[Solved] Creating multiple Tables and inserting Data into them [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-10-09T07:28:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Creating multiple Tables and inserting Data into them [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Creating multiple Tables and inserting Data into them [closed] - JassWeb","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:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Creating multiple Tables and inserting Data into them [closed] - JassWeb","og_description":"[ad_1] Your issue &#8220;there is always only one table created&#8221;, will be due to the very common misconception that the onCreate method, in DatabaseHelper.java (generally termed the Database Helper) runs every time the App is run. Actually the onCreate method is only automatically invoked once for the lifetime of the database. If the data held ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/","og_site_name":"JassWeb","article_published_time":"2022-10-09T07:28:31+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Creating multiple Tables and inserting Data into them [closed]","datePublished":"2022-10-09T07:28:31+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/"},"wordCount":400,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["android","android-sqlite","database","sqlite"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/","name":"[Solved] Creating multiple Tables and inserting Data into them [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-10-09T07:28:31+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-creating-multiple-tables-and-inserting-data-into-them-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Creating multiple Tables and inserting Data into them [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/14883","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=14883"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/14883\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=14883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=14883"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=14883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}