win-2u7lqi3pblr.tail51e984.ts.net / 127.0.0.1 / nldsignc_2025 / vehicles

There are no favorite tables.

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 11 (12 total, Query took 0.0168 seconds.) [color: ขาว... - แดง...]

SELECT * FROM `vehicles` ORDER BY `color` ASC

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

			id	car_plate	car_type	res_car_type	vehicle_kind	brand	model	car_year	color 1	fuel_type	cargo_size	cargo_capacity_kg	engine_cc	engine_cylinders	horsepower_hp	cargo_width_m	cargo_length_m	cargo_height_m	timing_system	timing_note	chassis_no	engine_no	reg_date ???????????????	reg_date_text	vehicle_age_years	reg_expire ?????????????????	insurance_co	insurance_no	insurance_expire	inspect_expire ??????????????????	last_service_km	last_service_date	next_service_km	next_service_date	current_km	gross_weight_kg	curb_weight_kg	payload_weight_kg	department	assigned_driver FK drivers.id	remark	status	created_at
Edit	Copy	Delete DELETE FROM vehicles WHERE `vehicles`.`id` = 1	1	82-0161	truck_large	6ล้อธรรมดา_ISUZU_มีลิฟท์	รถบรรทุกส่วนบุคคล	ISUZU	FRR90NNXXQ	0000	ขาว	diesel	2.22 × 6.45 × 2.20 ม.	NULL	NULL	4	190	2.22	3.10	2.20	chain	ส่วนใหญ่เป็นโซ่เดี่ยว	MP1FRR90NDT001385	4HK1154922	2015-01-29	29 มกราคม 2558	11	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	600464	9700	5700	4000	NULL	NULL	นำเข้าจากไฟล์แนบ	active	2026-05-09 11:39:38
Edit	Copy	Delete DELETE FROM vehicles WHERE `vehicles`.`id` = 2	2	82-1213	truck_large	6ล้อธรรมดา_ISUZU_มีลิฟท์	รถบรรทุกส่วนบุคคล	ISUZU	FRR90NNXXS	0000	ขาว	diesel	2.22 × 6.45 × 2.20 ม.	NULL	NULL	4	190	2.22	3.10	2.20	chain	ส่วนใหญ่เป็นโซ่เดี่ยว	MP1FRR90NFT001871	4HK1PG9470	NULL	2559	10	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	10400	5600	4800	NULL	NULL	นำเข้าจากไฟล์แนบ	active	2026-05-09 11:39:38
Edit	Copy	Delete DELETE FROM vehicles WHERE `vehicles`.`id` = 3	3	82-2157	truck_large	6ล้อจัมโบ้_HINO_มีลิฟท์	รถบรรทุกส่วนบุคคล	HINO	FG8JT1A-JGT	0000	ขาว	diesel	2.40 × 8.50 × 2.40 ม.	NULL	NULL	6	240	2.40	8.50	2.40	gear	Timing Gear / Gear Train	MNKFG8JT1XHX10299	J08EWJH53861	2018-02-09	9 กุมภาพันธ์ 2561	8	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	15000	9300	5700	NULL	NULL	นำเข้าจากไฟล์แนบ	active	2026-05-09 11:39:38
Edit	Copy	Delete DELETE FROM vehicles WHERE `vehicles`.`id` = 4	4	3ฒฮ6665	pickup	4ล้อพื้นเรียบ	รถกระบะบรรทุก	TOYOTA	HILUX CHAMP 2024	0000	ขาว	diesel	1.80 × 2.75 × 1.00 ม.	NULL	2393	4	150	1.70	2.70	1.00	chain	Timing Chain	MR3AA9CA106300822	2GD5571758	2024-08-05	5 สิงหาคม 2567	2	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2790	1500	1290	NULL	NULL	นำเข้าจากไฟล์แนบ	active	2026-05-09 11:39:38
Edit	Copy	Delete DELETE FROM vehicles WHERE `vehicles`.`id` = 5	5	2ฒจ6940	pickup	4ล้อพื้นเรียบ	รถกระบะบรรทุก	ISUZU	D-MAX 2017	0000	ขาว	diesel	1.70 × 2.47 × 1.00 ม.	NULL	1898	4	150	1.70	2.47	1.00	chain	Single Chain	MP1TFR87JHT039653	RZ4ERN3133	2017-10-18	18 ตุลาคม 2560	9	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2700	1900	800	NULL	NULL	นำเข้าจากไฟล์แนบ	active	2026-05-09 11:39:38
Edit	Copy	Delete DELETE FROM vehicles WHERE `vehicles`.`id` = 6	6	1ฒษ4308	pickup	4ล้อพื้นเรียบ	รถกระบะบรรทุก	ISUZU	D-MAX 2016	0000	ขาว	diesel	1.70 × 2.47 × 1.00 ม.	NULL	1898	4	150	1.70	2.47	1.00	chain	Single Chain	MP1TFR87JGT029284	RZ4EPG6809	2016-08-22	22 สิงหาคม 2559	10	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2700	1800	900	NULL	NULL	นำเข้าจากไฟล์แนบ	active	2026-05-09 11:39:38
Edit	Copy	Delete DELETE FROM vehicles WHERE `vehicles`.`id` = 7	7	2ฒฒ3281	pickup	4ล้อพื้นเรียบ	รถกระบะบรรทุก	ISUZU	D-MAX 2018	0000	ขาว	diesel	1.70 × 2.47 × 1.00 ม.	NULL	1890	4	150	1.70	2.47	1.00	chain	Single Chain	MP1TFR87JKT011728	RZ4ETII6247	2019-02-22	22 กุมภาพันธ์ 2562	7	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2700	1800	900	NULL	NULL	นำเข้าจากไฟล์แนบ	active	2026-05-09 11:39:38
Edit	Copy	Delete DELETE FROM vehicles WHERE `vehicles`.`id` = 9	9	2ฒต3012	truck_small	4ล้อกลาง_HINO_มีลิฟท์	รถบรรทุกส่วนบุคคล	HINO	XZU600R-HKMLKT3 2018	0000	ขาว	diesel	1.58 × 3.10 × 1.75 ม.	NULL	4009	4	136	1.58	3.10	1.75	gear	Timing Gear	MNKACK4H002004364	NO4CVH12093	2018-07-24	24 กรกฎาคม 2561	8	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	4500	2200	2300	NULL	NULL	นำเข้าจากไฟล์แนบ	active	2026-05-09 11:39:38
Edit	Copy	Delete DELETE FROM vehicles WHERE `vehicles`.`id` = 10	10	1กฌ2340	pickup	4ล้อSupport_TOYOTA	รถกระบะ 4 ประตู	TOYOTA	KUN36R-PRASYT AV 2012	0000	ขาว	diesel	NULL	NULL	2982	4	171	NULL	NULL	NULL	belt	สายพานราวลิ้น	MR0EZ39G908561667	1KD-U159765	2012-11-22	22 พฤศจิกายน 2555	14	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1800	1800	NULL	NULL	NULL	นำเข้าจากไฟล์แนบ	active	2026-05-09 11:39:38
Edit	Copy	Delete DELETE FROM vehicles WHERE `vehicles`.`id` = 11	11	ฒห72	truck_small	4ล้อกลาง_HINO_ไม่มีลิฟท์	รถบรรทุกส่วนบุคคล	HINO	XZU600R-HKMLKT3 2017	0000	ขาว	diesel	1.58 × 3.10 × 1.75 m.	NULL	4009	4	136	1.58	3.10	1.75	gear	Timing Gear	MNKACK4H002003831	NO4CVAH11752	2017-11-16	16 พฤศจิกายน 2560	9	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	4500	2200	2300	NULL	NULL	นำเข้าจากไฟล์แนบ	active	2026-05-09 11:39:38
Edit	Copy	Delete DELETE FROM vehicles WHERE `vehicles`.`id` = 8	8	ฒฉ1332	pickup	4ล้อSupport_NISSAN_CAP	รถกระบะบรรทุก	NISSAN	NAVARA 2011	0000	เทา	diesel	1.83 × 1.50 × 0.45 ม.	NULL	2188	4	111	NULL	NULL	NULL	chain	มี 2 เส้น (โซ่ + โซ่เดี่ยว)	MNTNCGD10Z0016776	YD25332183T	2008-07-25	25 กรกฎาคม 2551	18	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2570	1550	1020	NULL	NULL	นำเข้าจากไฟล์แนบ	active	2026-05-09 11:39:38
Edit	Copy	Delete DELETE FROM vehicles WHERE `vehicles`.`id` = 12	12	5กภ2840	pickup	4ล้อSupport_FORD	รถกระบะ 4 ประตู	FORD	FORD RANGER 2016	0000	แดง	diesel	1.56 × 1.54 × 0.50 ม.	NULL	2198	4	160	NULL	NULL	NULL	chain	Ranger 2016 ใช้โซ่ราวลิ้น	MNBLMF080GW619688	P4AT2255314	2016-10-04	4 ตุลาคม 2559	10	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1750	1750	NULL	NULL	NULL	นำเข้าจากไฟล์แนบ	active	2026-05-09 11:39:38

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view