搜索到
11
篇与
database
的结果
-
-
在Windows10专业版下使用docker安装oracle11g教程 一、安装Docker1、确保你的电脑是win10专业版家庭版的用户需自行升级至专业版才可使用。2、开启Hyper-VWin+R，输入appwiz.cpl，快速打开控制面板中的“程序和功能”在左侧点击“启用或关闭Windows功能”，把Hyper-V勾上3、下载并安装DockerDocker的官方下载地址二、使用Docker安装Oracle1、拉取镜像打开CMD，输入docker pull registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g拉取阿里云上的Oracle镜像2、启动Oracle镜像作为容器docker run -d -p 1521:1521 --name oracle11g registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g3、进入容器docker exec -it oracle11g bash4、配置环境变量使用root账号登录，命令为su root,密码为hellowin输入 vi /etc/profile ，修改配置文件在文件的最后面的 unset -f pathmunge的下一行，按i插入环境变量export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2 export ORACLE_SID=helowin export PATH=$ORACLE_HOME/bin:$PATH按esc，再输入:wq！退出文件编辑。输入exit退出root用户，回到oracle用户。输入 source /etc/profile ，使配置文件生效。5、创建用户依次输入以下命令：sqlplus /nolog conn /as sysdba; alter user system identified by oracle;将system用户的密码设为oracleconn system/oracle; create user aaa identified by aaa;user后面接的是你要新建的用户名，by后面的是你新建的用户密码给新用户授权grant all privileges to aaa;三、使用Navicat连接数据库
-
mysql8导入导出数据库 1.连接数据库mysql -u root -p远程数据库mysql -u root -p -h 192.168.1.100 -P 33072.导出mysqldump -u 用户名 -p 数据库名>/mnt/usb/testdb.sqlmysqldump -u root -p testdb>/mnt/usb/testdb.sql远程数据库mysqldump -h 主机 -P 端口 -u 用户名 -p 数据库名>/mnt/usb/testdb.sqlmysqldump -h 192.168.1.100 -P 3307 -u root -p testdb>/mnt/usb/testdb.sql3.导入mysql -u 用户名 -p 数据库名</mnt/usb/testdb.sqlmysql -u root -p testdb</mnt/usb/testdb.sql4.定制导出脚本USER_NAME=$1 if [ ! -n "$USER_NAME" ]; then echo "User name can't be empty!" exit 0 fi PWD=$2 if [ ! -n "$PWD" ]; then echo "Password name can't be empty!" exit 0 fi echo "Password is $PWD" DB_NAME=$3 if [ ! -n "$DB_NAME" ]; then echo "Database name can't be empty!" exit 0 fi PORT=$4 if [ ! -n "$PORT" ]; then PORT=3306 fi BACK_PATH=$5 if [ ! -n "$BACK_PATH" ]; then BACK_PATH='./db-back' fi HOST=$6 if [ ! -n "$HOST" ]; then HOST='127.0.0.1' fi BACK_FILE_NAME=_"$PORT"_$(date '+%Y%m%d%H%M%S') if [ -a $BACK_PATH ]; then echo "Back path is '$BACK_PATH'." else mkdir $BACK_PATH fi cd $BACK_PATH mysqldump -h $HOST -P $PORT -u$USER_NAME -p$2 $DB_NAME>$DB_NAME$BACK_FILE_NAME.sqldemosh backup.sh root 111111 dbname 3306 /mnt/usb/db-backup
-
在特定数据库中查找字段 在整个MySQL数据库中查找select * from INFORMATION_SCHEMA.columns where COLUMN_NAME Like '%placement%';在特定数据库中查找SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ('ColumnA','ColumnB') AND TABLE_SCHEMA='DatabaseName'; SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%ColumnA%' AND TABLE_SCHEMA='DatabaseName';在特定数据库中查找包含A和B字段的表SELECT DISTINCT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ('A') and TABLE_NAME in (SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ('B') AND TABLE_SCHEMA='DatabaseName')
-
mybatis常用SQL 1.SET<update id="updateStatus"> UPDATE t_user <set> <if test="status != null and status != ''"> status =#{status}, </if> <if test="runStatus != null and runStatus != ''"> run_status =#{runStatus}, </if> </set> WHERE id=#{id} </update>2.DELETE/删除指定条数<delete id="deleteByRobotTeamId"> DELETE from t_user WHERE id = #{id} <if test="num != null"> LIMIT #{num} </if> </delete>3.choose-when结构/IFNULL/MAX/<update id="save" parameterType="Object"> INSERT INTO t_robot_chat_expand (chat_word_id,sort, content ) VALUES( #{chatWordId}, <choose> <when test="sort == null"> (SELECT IFNULL(MAX( RCE.sort ) + 1,0) FROM t_robot_chat_expand RCE WHERE RCE.chat_word_id = #{chatWordId} ), </when> <otherwise> IF((SELECT MAX( RCE.sort ) FROM t_robot_chat_expand RCE WHERE RCE.chat_word_id = 1 ) < #{sort}, (SELECT MAX( RCE.sort ) + 1 FROM t_robot_chat_expand RCE WHERE RCE.chat_word_id = #{chatWordId} ), #{sort}), </otherwise> </choose> #{content}) </update>
您的IP: