1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132
| --------------
SET AUTOCOMMIT = 0
--------------
--------------
START TRANSACTION
--------------
--------------
DROP DATABASE IF EXISTS `base`
--------------
--------------
CREATE DATABASE `base`
DEFAULT CHARACTER SET `latin1`
DEFAULT COLLATE `latin1_general_ci`
--------------
--------------
COMMIT
--------------
--------------
DROP TABLE IF EXISTS `test`
--------------
--------------
CREATE TABLE `test`
(
`clef` int unsigned NOT NULL,
`val` char(25) NOT NULL DEFAULT ' ',
PRIMARY KEY (`clef`)
) ENGINE=InnoDB
DEFAULT CHARSET=`latin1` COLLATE=`latin1_general_ci`
ROW_FORMAT=COMPRESSED
--------------
--------------
INSERT INTO `test` (`clef`, `val`) VALUES
(0, 'description générale'),
(15, 'description client 15'),
(71, 'description client 71')
--------------
--------------
select *
from test
--------------
+------+-----------------------+
| clef | val |
+------+-----------------------+
| 0 | description générale |
| 15 | description client 15 |
| 71 | description client 71 |
+------+-----------------------+
--------------
select val
from test
where clef in (0, 15)
order by clef desc
limit 1
--------------
+-----------------------+
| val |
+-----------------------+
| description client 15 |
+-----------------------+
--------------
select val
from test
where clef in (0, 91)
order by clef desc
limit 1
--------------
+----------------------+
| val |
+----------------------+
| description générale |
+----------------------+
--------------
DROP TABLE IF EXISTS `client`
--------------
--------------
CREATE TABLE `client`
(
`id` int unsigned NOT NULL,
`val` char(25) NOT NULL DEFAULT ' ',
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=`latin1` COLLATE=`latin1_general_ci`
ROW_FORMAT=COMPRESSED
--------------
--------------
INSERT INTO `client` (`id`, `val`) value (3, 'description client 3')
--------------
--------------
REPLACE INTO `client` (`id`, `val`)
select 3 as 'id', val from test where clef in (0, 3) order by clef desc limit 1
--------------
--------------
REPLACE INTO `client` (`id`, `val`)
select 7 as 'id', val from test where clef in (0, 7) order by clef desc limit 1
--------------
--------------
select *
from client
--------------
+----+----------------------+
| id | val |
+----+----------------------+
| 3 | description générale |
| 7 | description générale |
+----+----------------------+
--------------
COMMIT
--------------
--------------
SET AUTOCOMMIT = 1
--------------
Appuyez sur une touche pour continuer... |
Partager