Home » Open Source » MySQL » getting output as per the column content (Mysql , Windows)
|
|
Re: getting output as per the column content [message #653695 is a reply to message #653676] |
Thu, 14 July 2016 18:33  |
 |
Barbara Boehmer
Messages: 9105 Registered: November 2002 Location: California, USA
|
Senior Member |
|
|
mysql> create table mysql.xyz
-> (code char(6));
Query OK, 0 rows affected (0.28 sec)
mysql>
mysql> insert into mysql.xyz (code) values ('abc');
Query OK, 1 row affected (0.13 sec)
mysql> insert into mysql.xyz (code) values ('.abc');
Query OK, 1 row affected (0.09 sec)
mysql> insert into mysql.xyz (code) values ('.abc');
Query OK, 1 row affected (0.12 sec)
mysql> insert into mysql.xyz (code) values ('..abc');
Query OK, 1 row affected (0.07 sec)
mysql> insert into mysql.xyz (code) values ('...abc');
Query OK, 1 row affected (0.06 sec)
mysql> insert into mysql.xyz (code) values ('.abc');
Query OK, 1 row affected (0.04 sec)
mysql>
mysql> select * from mysql.xyz;
+--------+
| code |
+--------+
| abc |
| .abc |
| .abc |
| ..abc |
| ...abc |
| .abc |
+--------+
6 rows in set (0.00 sec)
mysql>
mysql> alter table mysql.xyz add level integer;
Query OK, 0 rows affected (0.57 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql>
mysql> update mysql.xyz
-> set level = length(code)-length(replace(code,'.','')),
-> code = replace(code,'.','');
Query OK, 6 rows affected (0.04 sec)
Rows matched: 6 Changed: 6 Warnings: 0
mysql>
mysql> select * from mysql.xyz;
+------+-------+
| code | level |
+------+-------+
| abc | 0 |
| abc | 1 |
| abc | 1 |
| abc | 2 |
| abc | 3 |
| abc | 1 |
+------+-------+
6 rows in set (0.00 sec)
mysql>
|
|
|
Goto Forum:
Current Time: Mon May 05 00:26:59 CDT 2025
|