执行mysql -e 时能否保持一个长连接? 我有时候在linux shell写些针对于mysql数据库的操作,shell脚本要多次运行mysql -e,但这样的话,每次都要连接数据库,很浪费资源,有没有办法维持一个长连接并以后一直用这个长连接呢? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 想直接用mysql -e来保持长连接不可以考虑别的方式吧 $ mysql test -e "select * from tb;desc user;show tables;"+------+------+| rid | con |+------+------+| 1 | NULL || 2 | NULL || 2 | NULL || 3 | NULL || 4 | NULL || 4 | NULL || 4 | NULL |+------+------++----------+----------------------+------+-----+---------+-----------| Field | Type | Null | Key | Default | Extra+----------+----------------------+------+-----+---------+-----------| userid | smallint(6) unsigned | NO | PRI | NULL | auto_incre| username | varchar(20) | NO | | NULL |+----------+----------------------+------+-----+---------+-----------+---------------------------+| Tables_in_test |+---------------------------+| a || animals || b || cmplcate || columns_priv || contest_skill || db || dd || event || feeder_update || forum || func || general_log || gss_documen_cate || gss_documentation || help_category || help_keyword || help_relation || help_topic || host || human_employee_master || item || ndb_binlog_index || notice || pet || plugin || proc || procs_priv || product || pyk || search || servers || shop || slow_log || stock || student || system_user || t || t1 || t2 || t7974 || t_edition || t_rank || ta || taa || tab || tables_priv || tb || test || text || time_zone || time_zone_leap_second || time_zone_name || time_zone_transition || time_zone_transition_type || treenodes || tt || tt1t || ttt || tttt || type || url || user || viewlog |+---------------------------+你可以向我这样执行多条语句 数据库编码的问题。王大侠都来看看。 高手指点:mysql5的触发器什么情况下会失效,急!! postgresql数据库之间如何连接?如何传递数据? 关于ASP实现mysql库的备份和删除 万分火急,请大家帮帮忙 如何UPDATE。select过的数据 把用select查询出来的结果怎样再数据插入到一张新表中? 请教条mysql语句 谁有mysql 5.5.39驱动jar包 啊 急需 MySQL 全文索引fulltext innodb 匹配不到结果 MySQL多线程 如何用SQL语句得到本季度第一天的日期??
考虑别的方式吧
+------+------+
| rid | con |
+------+------+
| 1 | NULL |
| 2 | NULL |
| 2 | NULL |
| 3 | NULL |
| 4 | NULL |
| 4 | NULL |
| 4 | NULL |
+------+------+
+----------+----------------------+------+-----+---------+-----------
| Field | Type | Null | Key | Default | Extra
+----------+----------------------+------+-----+---------+-----------
| userid | smallint(6) unsigned | NO | PRI | NULL | auto_incre
| username | varchar(20) | NO | | NULL |
+----------+----------------------+------+-----+---------+-----------
+---------------------------+
| Tables_in_test |
+---------------------------+
| a |
| animals |
| b |
| cmplcate |
| columns_priv |
| contest_skill |
| db |
| dd |
| event |
| feeder_update |
| forum |
| func |
| general_log |
| gss_documen_cate |
| gss_documentation |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| human_employee_master |
| item |
| ndb_binlog_index |
| notice |
| pet |
| plugin |
| proc |
| procs_priv |
| product |
| pyk |
| search |
| servers |
| shop |
| slow_log |
| stock |
| student |
| system_user |
| t |
| t1 |
| t2 |
| t7974 |
| t_edition |
| t_rank |
| ta |
| taa |
| tab |
| tables_priv |
| tb |
| test |
| text |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| treenodes |
| tt |
| tt1t |
| ttt |
| tttt |
| type |
| url |
| user |
| viewlog |
+---------------------------+
你可以向我这样执行多条语句