- 使用拼音排序
select * from t order by nlssort(field,'NLS_SORT=SCHINESE_PINYIN_M');
- 使用笔画排序
select * from t order by nlssort(field,'NLS_SORT=SCHINESE_STROKE_M');
- 使用偏旁部首排序
select * from t order by nlssort(field,'NLS_SORT=SCHINESE_RADICAL_M');
select * from t order by nlssort(field,'NLS_SORT=SCHINESE_PINYIN_M');
select * from t order by nlssort(field,'NLS_SORT=SCHINESE_STROKE_M');
select * from t order by nlssort(field,'NLS_SORT=SCHINESE_RADICAL_M');
use Illuminate\Database\Seeder;
use App\Comment;
class CommentsTableSeeder extends Seeder
{
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
// Let's truncate our existing records to start from scratch.
Comment::truncate();
$faker = \Faker\Factory::create();
// And now, let's create a few articles in our database:
for ($i = 0; $i < 100; $i++) {
Comment::create([
'post_id' => random_int(1, 50),
'user_id' => random_int(1, 14),
'status' => random_int(0, 1),
'content' => $faker->sentence,
]);
}
}
}
注册Microsoft密钥和订阅源
在安装.NET之前,您需要注册Microsoft密钥,注册产品存储库并安装所需的依赖项。这只需要每台机器完成一次。
打开命令提示符并运行以下命令:
wget -q https://packages.microsoft.com/config/ubuntu/18.04/packages-microsoft-prod.deb
sudo dpkg -i packages-microsoft-prod.deb
安装.NET SDK
更新可用于安装的产品,然后安装.NET SDK。
在命令提示符中,运行以下命令:
sudo apt-get install apt-transport-https
sudo apt-get update
sudo apt-get install dotnet-sdk-2.1
更多版本:https://www.microsoft.com/net/download/linux-package-manager/rhel/sdk-current
有3种方法:
DB::getConfig('prefix');
DB::connection()->getTablePrefix();
Config::get('database.connections.mysql.prefix');
使用php上传文件出现 nginx: 413 Request Entity Too Large
错误,解决方法如下:
upload_max_filesize
和 post_max_size
修改为 20M
(或更大),然后重启php-fpm。/etc/nginx/nginx.conf
),在 http{}
段中加入 client_max_body_size 20m;
20m为允许最大上传的大小,保存后重启nginx。名称 | 关键字 |
---|---|
AppleScript | applescript |
ActionScript 3.0 | actionscript3, as3 |
Shell | bash, shell |
ColdFusion | coldfusion, cf |
C | cpp, c |
C# | c#, c-sharp, csharp |
CSS | css |
Delphi | delphi, pascal, pas |
diff&patch | diff patch |
Erlang | erl, erlang |
Groovy | groovy |
Java | java |
JavaFX | jfx, javafx |
JavaScript | js, jscript, javascript |
Perl | perl, pl, Perl |
PHP | php |
text | text, plain |
Python | py, python |
Ruby | ruby, rails, ror, rb |
SASS&SCSS | sass, scss |
Scala | scala |
SQL | sql |
Visual Basic | vb, vbnet |
XML | xml, xhtml, xslt, html |
Objective C | objc, obj-c |
F# | f#, f-sharp, fsharp |
R | r, s, splus |
matlab | matlab |
swift | swift |
GO | go, golang |
VS Code中Instant Markdown不支持直接用 C#
,而要用 csharp
才能高亮C#代码。
sudo apt-get install snmpd /*安装snmp服务*/
sudo vi /etc/snmp/snmpd.conf /*编辑snmp配置文件*/
在这里使用默认团体名public,实际环境中建议更改。
agentAddress udp:127.0.0.1:161
改为
agentAddress 192.168.1.9
192.168.1.9为本机IP,即监控服务器要监控的主机IP
vmware-installer -u vmware-workstation
sudo pkill Xorg
[toc]
# 以下任选一种
sudo mfks -t ext4 /dev/sdb1
sudo mkfs.ext4 /dev/sdb1
sudo mkds.ext4 -b 1024 /dev/sdb1
sudo mount /dev/sdb1 /home/mounted
编辑 /etc/fstab
文件,增加一行:
/dev/sdb1 /home/mounted ext4 defaults 0 0