質問編集履歴
2
追記
test
CHANGED
File without changes
|
test
CHANGED
@@ -279,3 +279,141 @@
|
|
279
279
|
|
280
280
|
|
281
281
|
何卒、宜しくお願い致します。
|
282
|
+
|
283
|
+
|
284
|
+
|
285
|
+
(追記)
|
286
|
+
|
287
|
+
```pyj.sql
|
288
|
+
|
289
|
+
-- phpMyAdmin SQL Dump
|
290
|
+
|
291
|
+
-- version 4.8.3
|
292
|
+
|
293
|
+
-- https://www.phpmyadmin.net/
|
294
|
+
|
295
|
+
--
|
296
|
+
|
297
|
+
-- Host: 127.0.0.1
|
298
|
+
|
299
|
+
-- Generation Time:
|
300
|
+
|
301
|
+
-- サーバのバージョン: 10.1.35-MariaDB
|
302
|
+
|
303
|
+
-- PHP Version: 7.2.9
|
304
|
+
|
305
|
+
|
306
|
+
|
307
|
+
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
308
|
+
|
309
|
+
SET AUTOCOMMIT = 0;
|
310
|
+
|
311
|
+
START TRANSACTION;
|
312
|
+
|
313
|
+
SET time_zone = "+00:00";
|
314
|
+
|
315
|
+
|
316
|
+
|
317
|
+
|
318
|
+
|
319
|
+
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
320
|
+
|
321
|
+
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
322
|
+
|
323
|
+
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
324
|
+
|
325
|
+
/*!40101 SET NAMES utf8mb4 */;
|
326
|
+
|
327
|
+
|
328
|
+
|
329
|
+
--
|
330
|
+
|
331
|
+
-- Database: `part_time_job`
|
332
|
+
|
333
|
+
--
|
334
|
+
|
335
|
+
|
336
|
+
|
337
|
+
-- --------------------------------------------------------
|
338
|
+
|
339
|
+
|
340
|
+
|
341
|
+
--
|
342
|
+
|
343
|
+
-- テーブルの構造 `ptj`
|
344
|
+
|
345
|
+
--
|
346
|
+
|
347
|
+
|
348
|
+
|
349
|
+
CREATE TABLE `ptj` (
|
350
|
+
|
351
|
+
`num` int(11) NOT NULL,
|
352
|
+
|
353
|
+
`No` int(4) NOT NULL,
|
354
|
+
|
355
|
+
`office` varchar(10) NOT NULL,
|
356
|
+
|
357
|
+
`ymd` varchar(10) NOT NULL,
|
358
|
+
|
359
|
+
`time` varchar(10) NOT NULL,
|
360
|
+
|
361
|
+
`week` varchar(10) NOT NULL
|
362
|
+
|
363
|
+
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
364
|
+
|
365
|
+
|
366
|
+
|
367
|
+
--
|
368
|
+
|
369
|
+
-- テーブルのデータのダンプ `ptj`
|
370
|
+
|
371
|
+
--
|
372
|
+
|
373
|
+
|
374
|
+
|
375
|
+
INSERT INTO `ptj` (`num`, `No`, `office`, `ymd`, `time`, `week`) VALUES
|
376
|
+
|
377
|
+
(20, 9998, '出勤', '2018-12-26', '12:48', '水'),
|
378
|
+
|
379
|
+
(21, 9999, '出勤', '2018-12-26', '12:48', '水'),
|
380
|
+
|
381
|
+
(23, 9998, '退勤', '2018-12-26', '16:04', '水'),
|
382
|
+
|
383
|
+
(28, 9999, '退勤', '2018-12-26', '18:21', '水'),
|
384
|
+
|
385
|
+
(36, 1, '出勤', '2018-12-28', '11:42', '金'),
|
386
|
+
|
387
|
+
(37, 1, '退勤', '2018-12-28', '16:24', '金');
|
388
|
+
|
389
|
+
|
390
|
+
|
391
|
+
--
|
392
|
+
|
393
|
+
-- Indexes for dumped tables
|
394
|
+
|
395
|
+
--
|
396
|
+
|
397
|
+
|
398
|
+
|
399
|
+
--
|
400
|
+
|
401
|
+
-- Indexes for table `ptj`
|
402
|
+
|
403
|
+
--
|
404
|
+
|
405
|
+
ALTER TABLE `ptj`
|
406
|
+
|
407
|
+
ADD PRIMARY KEY (`num`);
|
408
|
+
|
409
|
+
|
410
|
+
|
411
|
+
--
|
412
|
+
|
413
|
+
-- AUTO_INCREMENT for dumped tables
|
414
|
+
|
415
|
+
--
|
416
|
+
|
417
|
+
|
418
|
+
|
419
|
+
```
|
1
追記
test
CHANGED
File without changes
|
test
CHANGED
@@ -256,6 +256,10 @@
|
|
256
256
|
|
257
257
|
![イメージ説明](4f2584d8e87f6bfbdf25f2565ea6b5fb.jpeg)
|
258
258
|
|
259
|
+
(追記)
|
260
|
+
|
261
|
+
![イメージ説明](42db10071ac8a2c2dacd6693f7450066.jpeg)
|
262
|
+
|
259
263
|
|
260
264
|
|
261
265
|
データベースは上記のような感じになるのですが、例えば「No9998の出勤時間と退勤時間を
|