[{"createTime":1735734952000,"id":1,"img":"hwy_ms_500_252.jpeg","link":"https://activity.huaweicloud.com/cps.html?fromacct=261f35b6-af54-4511-a2ca-910fa15905d1&utm_source=V1g3MDY4NTY=&utm_medium=cps&utm_campaign=201905","name":"华为云秒杀","status":9,"txt":"华为云38元秒杀","type":1,"updateTime":1735747411000,"userId":3},{"createTime":1736173885000,"id":2,"img":"txy_480_300.png","link":"https://cloud.tencent.com/act/cps/redirect?redirect=1077&cps_key=edb15096bfff75effaaa8c8bb66138bd&from=console","name":"腾讯云秒杀","status":9,"txt":"腾讯云限量秒杀","type":1,"updateTime":1736173885000,"userId":3},{"createTime":1736177492000,"id":3,"img":"aly_251_140.png","link":"https://www.aliyun.com/minisite/goods?userCode=pwp8kmv3","memo":"","name":"阿里云","status":9,"txt":"阿里云2折起","type":1,"updateTime":1736177492000,"userId":3},{"createTime":1735660800000,"id":4,"img":"vultr_560_300.png","link":"https://www.vultr.com/?ref=9603742-8H","name":"Vultr","status":9,"txt":"Vultr送$100","type":1,"updateTime":1735660800000,"userId":3},{"createTime":1735660800000,"id":5,"img":"jdy_663_320.jpg","link":"https://3.cn/2ay1-e5t","name":"京东云","status":9,"txt":"京东云特惠专区","type":1,"updateTime":1735660800000,"userId":3},{"createTime":1735660800000,"id":6,"img":"new_ads.png","link":"https://www.iodraw.com/ads","name":"发布广告","status":9,"txt":"发布广告","type":1,"updateTime":1735660800000,"userId":3},{"createTime":1735660800000,"id":7,"img":"yun_910_50.png","link":"https://activity.huaweicloud.com/discount_area_v5/index.html?fromacct=261f35b6-af54-4511-a2ca-910fa15905d1&utm_source=aXhpYW95YW5nOA===&utm_medium=cps&utm_campaign=201905","name":"底部","status":9,"txt":"高性能云服务器2折起","type":2,"updateTime":1735660800000,"userId":3}]
<>SQL语句创建数据库
SQL语句如下:
create database 数据库名称 on ( name=数据文件逻辑名称, filename='路径+数据文件名', size=数据文件初始大小,
maxsize=数据文件最大容量, filegrowth=数据文件自动增长容量 ) log on ( name=日志文件逻辑名称, filename=
'路径+日志文件名', size=日志文件初始大小, maxsize= 日志文件最大容量, filegrowth=日志文件自动增长容量 )
(1) name: 数据文件名称一般为 (name) _Data ,日志文件名称一般为(name)_Log 。
(2) filename: 数据文件名后缀为 .mdf ,日志文件名后缀为 .ldf 。
(3) maxsize: 设置为 unlimited 时,表示文件最大大小无限制。
(4) filegrowth: 可以设置为具体值(—M)或者百分比(—%),设置为 unlimited 时,表示文件无限制增长。
(5) 某些属性不设置时,创建数据库时会按默认值创建,例如,如果只用 “ create database 数据库名称 ” 创建数据库时,DBMS会按照默认的
“逻辑名称” ”文件组“ ”初始大小“ ”自动增长“ 和 “路径” 等属性创建数据库。
<>例题
创建一个名为“SM”的数据库,初始大小为10MB,最大为50MB,数据库自动增长,增长方式按10%;日志文件初始大小为2MB,最大大小不受限制,按1MB增长。
create database SM on ( name=SM_Data, filename='D:\SM.mdf', size=10, maxsize=50
, filegrowth=10% ) log on ( name=SM_Log, filename='D:\SM.ldf', size=2, maxsize=
unlimited, filegrowth=1MB )