{ "type": "MySQLNotebook", "version": "1.0", "caption": "DB Notebook", "content": "\\about\nSELECT * from banksfinders.banklatest bd \nLEFT OUTER JOIN banksfinders.banks bs on bs.bankname=bd.Bank\nWHERE idbanks is NULL\nSELECT from banksfinders.creditcards\nselect * from creditcards;\nalter table creditcards add column creditcardsimagename varchar(150);\nINSERT INTO `banksfinders`.`creditcards`(`creditcardscode`,`creditcardsname`,`creditcardsDetails`,`idcardtypes`,`idbanks`,`creditcardsimagename`,`MinimumSalary`,`AnnualFee`)\nSELECT'AAD', bd.CARD_name,bd.CARD_name,1,bs.idbanks,concat(bd.CARD_name,'.webp') creditcardsimagename,bd.Minimum_Salary,bd.Annual_Fee from banksfinders.banklatest bd \nLEFT OUTER JOIN banksfinders.banks bs on trim(bs.bankname)=trim(bd.Bank);\n\nCREATE TABLE `creditcardsfeturres` (\n `idcreditcardsbenefits` int NOT NULL AUTO_INCREMENT,\n `creditcardsfeturresDetails` varchar(45) DEFAULT NULL,\n `idcreditcards` int DEFAULT NULL,\n PRIMARY KEY (`idcreditcardsbenefits`),\n KEY `fk_creditcardsfeturres_1_idx` (`idcreditcards`),\n CONSTRAINT `fk_creditcardsfeturres_1` FOREIGN KEY (`idcreditcards`) REFERENCES `creditcards` (`idcreditcards`) ON DELETE RESTRICT ON UPDATE RESTRICT\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n", "options": { "tabSize": 4, "indentSize": 4, "insertSpaces": true, "defaultEOL": "LF", "trimAutoWhitespace": true }, "viewState": { "cursorState": [ { "inSelectionMode": false, "selectionStart": { "lineNumber": 20, "column": 1 }, "position": { "lineNumber": 20, "column": 1 } } ], "viewState": { "scrollLeft": 0, "firstPosition": { "lineNumber": 5, "column": 1 }, "firstPositionDeltaTop": 40 }, "contributionsState": { "editor.contrib.folding": {}, "editor.contrib.wordHighlighter": false } }, "contexts": [ { "state": { "start": 1, "end": 1, "language": "mysql", "result": { "type": "text", "text": [ { "type": 2, "content": "Welcome to the MySQL Shell - DB Notebook.\n\nPress Ctrl+Enter to execute the code block.\n\nExecute \\sql to switch to SQL, \\js to JavaScript and \\ts to TypeScript mode.\nExecute \\help or \\? for help;", "language": "ansi" } ] }, "currentHeight": 28, "currentSet": 1, "statements": [ { "delimiter": ";", "span": { "start": 0, "length": 6 }, "contentStart": 0, "state": 0 } ] }, "data": [] }, { "state": { "start": 2, "end": 4, "language": "mysql", "result": { "type": "resultIds", "list": [ "c450cea1-e019-44cd-f8f6-15f2e2f0ecec" ] }, "currentHeight": 234, "currentSet": 1, "statements": [ { "delimiter": ";", "span": { "start": 0, "length": 124 }, "contentStart": 0, "state": 3 } ] }, "data": [ { "tabId": "4505a0ea-96db-4ee3-d5de-1b543d5393fa", "resultId": "c450cea1-e019-44cd-f8f6-15f2e2f0ecec", "rows": [ { "0": "RAK BANK ", "1": "RAK Bank World Credit Card", "2": "20K", "3": "FYF then 950", "4": null, "5": null, "6": null, "7": null, "8": null }, { "0": "RAK BANK ", "1": "RAK Bank Titanium Credit Card", "2": "8k", "3": "Free for Life", "4": null, "5": null, "6": null, "7": null, "8": null }, { "0": "RAK BANK ", "1": "RAK Bank Air Arabia Platinum Credit Card", "2": "5K", "3": "AED 420*", "4": null, "5": null, "6": null, "7": null, "8": null }, { "0": "RAK BANK ", "1": "RAK Bank World Credit Card", "2": "20K", "3": "FYF then 950", "4": null, "5": null, "6": null, "7": null, "8": null }, { "0": "RAK BANK ", "1": "RAK Bank Titanium Credit Card", "2": "8k", "3": "Free for Life", "4": null, "5": null, "6": null, "7": null, "8": null }, { "0": "RAK BANK ", "1": "RAK Bank Air Arabia Platinum Credit Card", "2": "5K", "3": "AED 420*", "4": null, "5": null, "6": null, "7": null, "8": null } ], "columns": [ { "title": "Bank", "field": "0", "dataType": { "type": 17, "characterMaximumLength": 65535, "flags": [ "BINARY", "ASCII", "UNICODE" ], "needsQuotes": true, "parameterFormatType": "OneOrZero" }, "inPK": false, "nullable": false, "autoIncrement": false }, { "title": "CARD_name", "field": "1", "dataType": { "type": 17, "characterMaximumLength": 65535, "flags": [ "BINARY", "ASCII", "UNICODE" ], "needsQuotes": true, "parameterFormatType": "OneOrZero" }, "inPK": false, "nullable": false, "autoIncrement": false }, { "title": "Minimum_Salary", "field": "2", "dataType": { "type": 17, "characterMaximumLength": 65535, "flags": [ "BINARY", "ASCII", "UNICODE" ], "needsQuotes": true, "parameterFormatType": "OneOrZero" }, "inPK": false, "nullable": false, "autoIncrement": false }, { "title": "Annual_Fee", "field": "3", "dataType": { "type": 17, "characterMaximumLength": 65535, "flags": [ "BINARY", "ASCII", "UNICODE" ], "needsQuotes": true, "parameterFormatType": "OneOrZero" }, "inPK": false, "nullable": false, "autoIncrement": false }, { "title": "idbanks", "field": "4", "dataType": { "type": 4, "flags": [ "SIGNED", "ZEROFILL" ], "numericPrecision": 10, "parameterFormatType": "OneOrZero", "synonyms": [ "INTEGER", "INT4" ] }, "inPK": false, "nullable": false, "autoIncrement": false }, { "title": "bankcode", "field": "5", "dataType": { "type": 17, "characterMaximumLength": 65535, "flags": [ "BINARY", "ASCII", "UNICODE" ], "needsQuotes": true, "parameterFormatType": "OneOrZero" }, "inPK": false, "nullable": false, "autoIncrement": false }, { "title": "bankname", "field": "6", "dataType": { "type": 17, "characterMaximumLength": 65535, "flags": [ "BINARY", "ASCII", "UNICODE" ], "needsQuotes": true, "parameterFormatType": "OneOrZero" }, "inPK": false, "nullable": false, "autoIncrement": false }, { "title": "bankDetails", "field": "7", "dataType": { "type": 17, "characterMaximumLength": 65535, "flags": [ "BINARY", "ASCII", "UNICODE" ], "needsQuotes": true, "parameterFormatType": "OneOrZero" }, "inPK": false, "nullable": false, "autoIncrement": false }, { "title": "bankslocation", "field": "8", "dataType": { "type": 17, "characterMaximumLength": 65535, "flags": [ "BINARY", "ASCII", "UNICODE" ], "needsQuotes": true, "parameterFormatType": "OneOrZero" }, "inPK": false, "nullable": false, "autoIncrement": false } ], "executionInfo": { "text": "OK, 6 records retrieved in 0.669ms" }, "totalRowCount": 6, "hasMoreRows": false, "currentPage": 0, "index": 0, "sql": "SELECT * from banksfinders.banklatest bd \nLEFT OUTER JOIN banksfinders.banks bs on bs.bankname=bd.Bank\nWHERE idbanks is NULL", "updatable": false, "fullTableName": "" } ] }, { "state": { "start": 5, "end": 5, "language": "mysql", "result": { "type": "resultIds", "list": [ "0100262e-bd62-4ad6-f3dc-389396d963bd" ] }, "currentHeight": 109, "currentSet": 1, "statements": [ { "delimiter": ";", "span": { "start": 0, "length": 37 }, "contentStart": 0, "state": 3 } ] }, "data": [ { "tabId": "4505a0ea-96db-4ee3-d5de-1b543d5393fa", "resultId": "0100262e-bd62-4ad6-f3dc-389396d963bd", "rows": [ { "0": 1, "1": "FABCB", "2": "Fab Cash Back", "3": "First Abu Dhabi Bank Cash Back Credit Card", "4": 1, "5": 13, "6": "", "7": null, "8": null, "9": null } ], "columns": [ { "title": "idcreditcards", "field": "0", "dataType": { "type": 4, "flags": [ "SIGNED", "ZEROFILL" ], "numericPrecision": 10, "parameterFormatType": "OneOrZero", "synonyms": [ "INTEGER", "INT4" ] }, "inPK": true, "nullable": false, "autoIncrement": true }, { "title": "creditcardscode", "field": "1", "dataType": { "type": 17, "characterMaximumLength": 65535, "flags": [ "BINARY", "ASCII", "UNICODE" ], "needsQuotes": true, "parameterFormatType": "OneOrZero" }, "inPK": false, "nullable": false, "autoIncrement": false }, { "title": "creditcardsname", "field": "2", "dataType": { "type": 17, "characterMaximumLength": 65535, "flags": [ "BINARY", "ASCII", "UNICODE" ], "needsQuotes": true, "parameterFormatType": "OneOrZero" }, "inPK": false, "nullable": false, "autoIncrement": false }, { "title": "creditcardsDetails", "field": "3", "dataType": { "type": 17, "characterMaximumLength": 65535, "flags": [ "BINARY", "ASCII", "UNICODE" ], "needsQuotes": true, "parameterFormatType": "OneOrZero" }, "inPK": false, "nullable": true, "autoIncrement": false, "default": null }, { "title": "idcardtypes", "field": "4", "dataType": { "type": 4, "flags": [ "SIGNED", "ZEROFILL" ], "numericPrecision": 10, "parameterFormatType": "OneOrZero", "synonyms": [ "INTEGER", "INT4" ] }, "inPK": false, "nullable": false, "autoIncrement": false }, { "title": "idbanks", "field": "5", "dataType": { "type": 4, "flags": [ "SIGNED", "ZEROFILL" ], "numericPrecision": 10, "parameterFormatType": "OneOrZero", "synonyms": [ "INTEGER", "INT4" ] }, "inPK": false, "nullable": false, "autoIncrement": false }, { "title": "creditcardsimageid", "field": "6", "dataType": { "type": 17, "characterMaximumLength": 65535, "flags": [ "BINARY", "ASCII", "UNICODE" ], "needsQuotes": true, "parameterFormatType": "OneOrZero" }, "inPK": false, "nullable": true, "autoIncrement": false, "default": null }, { "title": "creditcardsimagelocation", "field": "7", "dataType": { "type": 17, "characterMaximumLength": 65535, "flags": [ "BINARY", "ASCII", "UNICODE" ], "needsQuotes": true, "parameterFormatType": "OneOrZero" }, "inPK": false, "nullable": true, "autoIncrement": false, "default": null }, { "title": "MinimumSalary", "field": "8", "dataType": { "type": 17, "characterMaximumLength": 65535, "flags": [ "BINARY", "ASCII", "UNICODE" ], "needsQuotes": true, "parameterFormatType": "OneOrZero" }, "inPK": false, "nullable": true, "autoIncrement": false, "default": null }, { "title": "AnnualFee", "field": "9", "dataType": { "type": 17, "characterMaximumLength": 65535, "flags": [ "BINARY", "ASCII", "UNICODE" ], "needsQuotes": true, "parameterFormatType": "OneOrZero" }, "inPK": false, "nullable": true, "autoIncrement": false, "default": null } ], "executionInfo": { "text": "OK, 1 record retrieved in 0.38ms" }, "totalRowCount": 1, "hasMoreRows": false, "currentPage": 0, "index": 0, "sql": "SELECT * from banksfinders.creditcards", "updatable": true, "fullTableName": "banksfinders.creditcards" } ] }, { "state": { "start": 6, "end": 11, "language": "mysql", "result": { "type": "text", "text": [ { "type": 0, "index": 0, "content": "MySQL Error (1046): No database selected", "language": "ansi" } ], "executionInfo": { "text": "" } }, "currentHeight": 28, "currentSet": 1, "statements": [ { "delimiter": ";", "span": { "start": 0, "length": 26 }, "contentStart": 0, "state": 0 }, { "delimiter": ";", "span": { "start": 26, "length": 70 }, "contentStart": 27, "state": 0 }, { "delimiter": ";", "span": { "start": 96, "length": 415 }, "contentStart": 97, "state": 0 }, { "delimiter": ";", "span": { "start": 511, "length": 1 }, "contentStart": 510, "state": 3 } ] }, "data": [] }, { "state": { "start": 12, "end": 19, "language": "mysql", "result": { "type": "text", "text": [ { "type": 0, "index": 0, "content": "MySQL Error (1046): No database selected", "language": "ansi" } ], "executionInfo": { "text": "" } }, "currentHeight": 28, "currentSet": 1, "statements": [ { "delimiter": ";", "span": { "start": 0, "length": 500 }, "contentStart": 0, "state": 0 } ] }, "data": [] }, { "state": { "start": 20, "end": 20, "language": "mysql", "currentSet": 1, "statements": [ { "delimiter": ";", "span": { "start": 0, "length": 0 }, "contentStart": 0, "state": 0 } ] }, "data": [] } ] }