Chcek MySQL version in three ways on Win OS

本文介绍了如何在命令行中登录MySQL并查询其版本、当前连接状态等关键信息,包括服务器版本、连接ID、当前数据库、用户等。

1. Without login into mysql, type it into your cmd

mysql -V

mysql  Ver 14.14 Distrib 5.1.45, for Win32 (ia32)


2. login mysql

mysql> status
--------------
mysql  Ver 14.14 Distrib 5.1.45, for Win32 (ia32)


Connection id:          1517
Current database:
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.1.45-community MySQL Community Server (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:               3306
Uptime:                 58 min 46 sec


Threads: 25  Questions: 19559  Slow queries: 0  Opens: 222  Flush tables: 1  Ope
n tables: 9  Queries per second avg: 5.547
--------------


3. login mysql

mysql> select version();
+------------------+
| version()        |
+------------------+
| 5.1.45-community |
+------------------+
1 row in set (0.07 sec)


PreparedStatementCallback; uncategorized SQLException for SQL [select "waitPutRecord".id, "waitPutRecord".table_info_id as tableInfoId, "taskActiveId".CHCEK_TIP as E0, "taskActiveId.materialId".CODE as E1, "taskActiveId.materialId".NAME as E2, "taskActiveId.materialId".IS_BATCH as E3, "taskActiveId".PLAN_QUANTITY as E4, "taskActiveId".SUM_NUM as E5, "taskActiveId".EXEC_SORT as E6, "taskActiveId".IS_MORE_OTHER as E7, "waitPutRecord".IS_SHOW as E8, "waitPutRecord".IS_FOR_ADJUST as E9, "waitPutRecord".IS_FOR_TEMP as E10, "taskActiveId".ACTIVE_TYPE as E11, "taskId".TABLE_NO as E12, "waitPutRecord".ID as E13, "waitPutRecord".PRODUCE_BATCH_NUM as E14, "productId".CODE as E15, "productId".NAME as E16, "productId".ID as E17, "productId.mainUnit".NAME as E18, "waitPutRecord".LINE_CODE as E19, "waitPutRecord".LINE_NAME as E20, "taskProcessId.equipmentId".ID as E21, "taskProcessId.equipmentId".CODE as E22, "taskProcessId.equipmentId".NAME as E23, "waitPutRecord".PLAN_NUM as E24, "waitPutRecord".EXE_STATE as E25, "waitPutRecord".CHECK_STATE as E26, "waitPutRecord".CHECK_RESULT as E27, "taskId".ID as E28, "waitPutRecord".PLAN_START_TIME as E29, "waitPutRecord".PLAN_END_TIME as E30, "waitPutRecord".ACTUAL_START_TIME as E31, "waitPutRecord".ACTUAL_END_TIME as E32, "waitPutRecord".PROCESS_NAME as E33, "waitPutRecord".ACTIVE_NAME as E34, "procReportId".ID as E35, "waitPutRecord".IS_ALIGE as E36, "waitPutRecord".ACT_STAFF_NAME as E37, "waitPutRecord".EXE_SYSTEM as E38, "formulaId".FORMUAL_CODE as E39, "formulaId".SET_PROCESS as E40, "waitPutRecord".RECORD_TYPE as E41, "procReportId".DETAILS_IS_NULL as E42, "taskId".BATCH_CONTRAL as E43, "taskActiveId".FINAL_INSPECTION as E44, "taskActiveId".IS_RELEASE as E45, "taskActiveId".RELEASE_CONDITIONS as E46, "activeBatchState".DEAL_TYPE as E47, "taskActiveId".CHECK_TIMES as E48, "waitPutRecord".ACTUAL_NUM as E49, "taskActiveId".USE_ITEM as E50, "taskId.productBom".VESSEL_NUM as E51, "taskActiveId".OUT_PUT_TIMES as E52, "waitPutRecord".EXECUTE_NUM as E53, "waitPutRecord".SCAN_VESSEL as E54, "taskActiveId".DISPLAY_NAME as E55 from WOM_WAIT_PUT_RECORDS "waitPutRecord" left join WOM_TASK_ACTIVES "taskActiveId" on "taskActiveId".ID="waitPutRecord".TASK_ACTIVE_ID left join BASESET_MATERIALS "taskActiveId.materialId" on "taskActiveId.materialId".ID="taskActiveId".MATERIAL_ID left join WOM_PRODUCE_TASKS "taskId" on "taskId".ID="waitPutRecord".TASK_ID left join BASESET_MATERIALS "productId" on "productId".ID="waitPutRecord".PRODUCT_ID left join BASESET_UNITS "productId.mainUnit" on "productId.mainUnit".ID="productId".MAIN_UNIT left join WOM_TASK_PROCESSES "taskProcessId" on "taskProcessId".ID="waitPutRecord".TASK_PROCESS_ID left join HM_FACTORY_MODELS "taskProcessId.equipmentId" on "taskProcessId.equipmentId".ID="taskProcessId".EQUIPMENT_ID left join WOM_PROC_REPORTS "procReportId" on "procReportId".ID="waitPutRecord".PROC_REPORT_ID left join RM_FORMULAS "formulaId" on "formulaId".ID="waitPutRecord".FORMULA_ID left join BASESET_ACT_BAT_STA "activeBatchState" on "activeBatchState".ID="waitPutRecord".ACTIVE_BATCH_STATE left join RM_FORMULA_BOM_MAINS "taskId.productBom" on "taskId.productBom".ID="taskId".PRODUCT_BOM WHERE (("waitPutRecord".VALID = ? AND ( "waitPutRecord".IS_FOR_ADJUST = ? and "waitPutRecord".IS_FOR_TEMP = ? and "waitPutRecord".TASK_ACTIVE_ID in(select ID from WOM_TASK_ACTIVES where ( IS_MORE_OTHER = ?))) AND (( "waitPutRecord".RECORD_TYPE = 'WOM_recordType/active' and (( "waitPutRecord".EXE_STATE = 'WOM_runState/runing' or "waitPutRecord".EXE_STATE = 'WOM_runState/waitForRun' or "waitPutRecord".EXE_STATE = 'WOM_runState/paused' or "waitPutRecord".EXE_STATE = 'WOM_runState/finished')) and "waitPutRecord".IS_AUTO = '0')) ) AND "waitPutRecord".CID in (1339481708915088)) ORDER BY "taskActiveId.formulaActiveId".hidden_sort ASC,"waitPutRecord".ID DESC offset 0 rows fetch next 20 rows only]; SQL state [S0001]; error code [4104]; 无法绑定由多个部分组成的标识符 "taskActiveId.formulaActiveId.hidden_sort"。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 无法绑定由多个部分组成的标识符 "taskActiveId.formulaActiveId.hidden_sort"。
最新发布
12-04
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值