This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
aws kms generate-data-key --key-id \ | |
arn:aws:kms:ap-southeast-2:xxxxxxxxxxxx:key/xxxxxxxx-6a6b-43f0-8209-xxxxxxxxxxxx \ | |
--key-spec AES_256 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<body> | |
<div id="swagger-ui"></div> | |
<script src="./swagger-ui-bundle.js"> </script> | |
<script src="./swagger-ui-standalone-preset.js"> </script> | |
<script src="./sample-dev-oas30-apigateway.js"> </script> <!-- jsonファイルをjsに変えて追加 --> | |
<script> | |
window.onload = function() { | |
// Build a system | |
const ui = SwaggerUIBundle({ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
receivedEvent: function(id) { | |
var parentElement = document.getElementById(id); | |
var listeningElement = parentElement.querySelector('.listening'); | |
var receivedElement = parentElement.querySelector('.received'); | |
listeningElement.setAttribute('style', 'display:none;'); | |
receivedElement.setAttribute('style', 'display:block;'); | |
console.log('Received Event: ' + id); | |
console.log('test:' + cordova.platformId); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
⚓ Running completion hooks... | |
�📄 Generating README.md... | |
�🎉 Successfully created project vue-ts. | |
�👉 Get started with the following commands: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 親テーブル(被所有者) | |
CREATE TABLE `m_department` ( | |
`departmentid` varchar(10) NOT NULL, | |
`departmentname` varchar(255) DEFAULT NULL, | |
PRIMARY KEY (`departmentid`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 | |
-- 子テーブル(所有者) | |
CREATE TABLE `m_emp` ( | |
`empno` bigint(20) NOT NULL AUTO_INCREMENT, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ALTER TABLE m_emp MODIFY COLUMN empno bigint(20) NOT NULL; | |
ALTER TABLE m_emp MODIFY COLUMN empno bigint(20) NOT NULL AUTO_INCREMENT; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
mysql> select last_insert_id(); | |
+---------------------+ | |
| last_insert_id() | | |
+---------------------+ | |
| 1234567890123456791 | | |
+---------------------+ | |
1 row in set (0.00 sec) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ALTER TABLE テーブル名 AUTO_INCREMENT = 1 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
mysql> select last_insert_id(); | |
+------------------+ | |
| last_insert_id() | | |
+------------------+ | |
| 0 | | |
+------------------+ | |
1 row in set (0.00 sec) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
mysql> insert into m_emp (empno,empname,departmentid) values (3,'takahashi','101010'); ← empnoを3で指定する | |
Query OK, 1 row affected (0.29 sec) | |
mysql> select * from m_emp; | |
+---------------------+------------+--------------+ | |
| empno | empname | departmentid | | |
+---------------------+------------+--------------+ | |
| 3 | takahashi | 101010 | ← レコードが追加されている | |
| 5 | 従業員A | 10101001 | | |
| 6 | 従業員B | 10101001 | |