Skip to content

Instantly share code, notes, and snippets.

mysql> select last_insert_id();
+------------------+
| last_insert_id() |
+------------------+
| 0 |
+------------------+
1 row in set (0.00 sec)
ALTER TABLE テーブル名 AUTO_INCREMENT = 1
mysql> select last_insert_id();
+---------------------+
| last_insert_id() |
+---------------------+
| 1234567890123456791 |
+---------------------+
1 row in set (0.00 sec)
ALTER TABLE m_emp MODIFY COLUMN empno bigint(20) NOT NULL;
ALTER TABLE m_emp MODIFY COLUMN empno bigint(20) NOT NULL AUTO_INCREMENT;
@moriya-hm5
moriya-hm5 / oyako
Last active October 28, 2019 14:36
-- 親テーブル(被所有者)
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,
⚓ Running completion hooks...
�📄 Generating README.md...
�🎉 Successfully created project vue-ts.
�👉 Get started with the following commands:
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);
<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({
aws kms generate-data-key --key-id \
arn:aws:kms:ap-southeast-2:xxxxxxxxxxxx:key/xxxxxxxx-6a6b-43f0-8209-xxxxxxxxxxxx \
--key-spec AES_256
C:\Users\takahashi>sam --version
SAM CLI, version 0.6.2