site > Select Domain > Options > Custom php.ini settings
upload_max_filesize = 30M
post_max_size = 30M
My Notebook
site > Select Domain > Options > Custom php.ini settings
upload_max_filesize = 30M
post_max_size = 30M
source: (user9385340)(2022), https://stackoverflow.com/questions/8557172/mysql-order-by-sorting-alphanumeric-correctly
example:
SELECT `alphanumericCol` FROM `tableName` ORDER BY
SUBSTR(`alphanumericCol` FROM 1 FOR 1),
LPAD(lower(`alphanumericCol`), 10,0) ASC
output:
1
2
11
21
100
101
102
104
S-104A
S-105
S-107
S-111
<input type="text" oninput="this.value=this.value.replace(/[^A-Z0-9]/gi,'').toUpperCase()">
Create a folder
Rename folder to:
.{ED7BA470-8E54-465E-825C-99712043E01C}
自己寫一個js array prototype unique function
Array.prototype.unique = function()
{
var n = [];
for(var i = 0; i < this.length; i++)
{
if (n.indexOf(this[i]) == -1) n.push(this[i]);
}
return n;
}
var arr = ["a","b","c","b","d","a","c","c"];
console.log(arr.unique());
//輸出["a", "b", "c", "d"]
Editor.js https://editorjs.io/
CKEditor https://ckeditor.com/
Quilljs https://quilljs.com/
Prosemirror https://prosemirror.net/
Tiptap https://tiptap.dev/
Source: https://stackoverflow.com/questions/2366018/how-to-re-sync-the-mysql-db-if-master-and-slave-have-different-database-incase-o, David Espart 2010
This is the full step-by-step procedure to resync a master-slave replication from scratch:
At the master:
RESET MASTER;
FLUSH TABLES WITH READ LOCK;
SHOW MASTER STATUS;
And copy the values of the result of the last command somewhere.
Without closing the connection to the client (because it would release the read lock) issue the command to get a dump of the master:
mysqldump -u root -p --all-databases > /a/path/mysqldump.sql
Now you can release the lock, even if the dump hasn’t ended yet. To do it, perform the following command in the MySQL client:
UNLOCK TABLES;
Now copy the dump file to the slave using scp or your preferred tool.
At the slave:
Open a connection to mysql and type:
STOP SLAVE;
Load master’s data dump with this console command:
mysql -uroot -p < mysqldump.sql
Sync slave and master logs:
RESET SLAVE;
CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=98;
Where the values of the above fields are the ones you copied before.
Finally, type:
START SLAVE;
To check that everything is working again, after typing:
SHOW SLAVE STATUS;
you should see:
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
That’s it!
show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000177 | 31692464 | | |
+------------------+----------+--------------+------------------+
1 row in set (0.000 sec)
File = mysql-bin.000177, Position = 31692464
stop slave;
CHANGE MASTER TO master_log_file = 'mysql-bin.000177', master_log_pos =31692464;
start slave;
show slave status \G;
master
show master status;
slave
show slave status \G;
<div id="maintable">
<table>
<thead>
<tr>
<th scope="col">#</th>
<th scope="col">連結</th>
<th scope="col">名稱</th>
</tr>
</thead>
<tbody>
<template v-for="(item, index) in menulist">
<tr>
<th>{{ index + 1 }}</th>
<td><a :href="item.dm_link">{{ item.dm_key }}</a></td>
<td>{{ item.dm_name }}</td>
</tr>
</template>
</tbody>
</table>
</div>
let maintable = new Vue({
el: '#maintable',
data: {
menulist: [
{dm_key: 'TW1', dm_link: 'menu/TW1', dm_name: 'Innonext 1'},
{dm_key: 'TW2', dm_link: 'menu/TW2', dm_name: 'Innonext 2'},
{dm_key: 'TP1', dm_link: 'menu/TP1', dm_name: 'Innonext 3'},
{dm_key: 'TP2', dm_link: 'menu/TP2', dm_name: 'Innonext 4'},
]
},
methods: { }
});