atelier-pierre-garage.tail8a30dc.ts.net / 127.0.0.1 / garage_db_clean / vehicules

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 - 20 (21 total, Query took 0.0618 seconds.)

SELECT * FROM `vehicules`

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

Filter rows:

			id	proprietaire_type	proprietaire_nom	proprietaire_prenom	proprietaire_societe	proprietaire_adresse	proprietaire_commune	proprietaire_profession	marque	modele	categorie	numero_serie_type	carrosserie	numero_moteur	cylindree	puissance_admin	carburant	places_assises	ptac	poids_vide	charge_utile	immatriculation	immat_precedente	date_immat_precedente	annee	date_premiere_circulation	date_visite_technique	date_assurance	vin	kilometrage	etat	photo	notes	date_ajout	photo_original_name	photo_mime	photo_blob	photo_uploaded_at
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 1	1	usine	NULL	NULL	MINIMAD SARLU	c/o MINIMMO CONSTRUCTION - Lot AFZ - 02 , Antsaham...	Ankadikely Ilafy	NULL	LADA	NIVA	Véhicule particulier	212140	SUV/4*4	9357894	1690	10	Essence	4	1610	1210	400	2301 AH	1416 TAU	2017-01-31	1977	2012-01-31	2026-10-15	2026-11-03	XTA212140A1974404	29870	operationnel	vehicule_20251122_090755_3283.jpeg	NULL	2025-11-22 11:07:55	vehicule_20251122_090755_3283.jpeg	image/jpeg	[BLOB - 74.4 KiB]	2026-02-19 06:50:32
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 2	2	usine	NULL	NULL	MINIMMO CONSTRUCTION SARL	II R 30 AMBOANJOBE	BONGATSARA ANTANANARIVO	NULL	PEUGEOT	505		551D58	Break	ZA009952	2498	10	Diesel	9	1650	1210	440	2035 TBB	2035 TBB	2017-01-24	NULL	1985-09-17	2025-09-23	2026-04-16	3189871	205337	hs	vehicule_20251209_133830_4544.jpg	NULL	2025-12-09 15:38:30	vehicule_20251209_133830_4544.jpg	image/jpeg	[BLOB - 45.9 KiB]	2026-02-19 06:50:32
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 3	3	usine	NULL	NULL	MINIMAD SARLU	c/o MINIMMO CONSTRUCTION - Lot AFZ - 02 , Antsaham...	Ankadikely Ilafy	NULL	CITROEN	TYPE U23		NULL		NULL	1911	42	Essence	2	4500	2500	2000	9482 T	9482 T	NULL	NULL	NULL	NULL	NULL	NULL	0	hs	vehicule_20251209_140734_2627.jpg	NULL	2025-12-09 16:07:34	vehicule_20251209_140734_2627.jpg	image/jpeg	[BLOB - 55.8 KiB]	2026-02-19 06:50:32
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 4	4	usine	NULL	NULL	MINIMAD SARLU	c/o MINIMMO CONSTRUCTION - Lot AFZ - 02 , Antsaham...	Ankadikely Ilafy	NULL	SUZUKI SAMURAI	SJ-413		NULL		NULL	4	60	Essence	5	NULL	NULL	NULL	5068 TP	5068 TP	NULL	NULL	NULL	NULL	NULL	NULL	47904	hs	vehicule_20251209_142642_2868.jpg	NULL	2025-12-09 16:26:42	vehicule_20251209_142642_2868.jpg	image/jpeg	[BLOB - 405.2 KiB]	2026-02-19 06:50:32
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 5	5	usine	NULL	NULL	PISTE ROUGES	LOT II i 50 BIS ALAROBIA	MAHAJANGA	USAGE PERSONNEL	FORD	RANGER		MNCBSFE408W712854		WLAT888938	4	10	Diesel	5	NULL	NULL	1094	8870 TAL	8870 TAL	NULL	NULL	NULL	NULL	NULL	UA8VLAH	16694	en_reparation	vehicule_20251210_090714_5978.jpg	NULL	2025-12-10 11:07:14	vehicule_20251210_090714_5978.jpg	image/jpeg	[BLOB - 378.1 KiB]	2026-02-19 06:50:32
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 14	14	usine	NULL	NULL	MINIMAD SARLU	NULL	Ankadikely Ilafy	NULL	Yamaha	Axis Glide	Camionnette	NULL		NULL	100	NULL	Essence	2	NULL	NULL	NULL	-	NULL	NULL	NULL	NULL	NULL	NULL	NULL	44621	hs	vehicule_20251216_083450_4695.png	NULL	2025-12-16 10:34:50	vehicule_20251216_083450_4695.png	image/png	[BLOB - 1.0 MiB]	2026-02-19 06:50:32
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 15	15	usine	NULL	NULL	PISTES ROUGES SARLU	c/o MINIMO CONSTRUCTION - Lot AFZ - 02 , Antsahama...	Ankadikely Ilafy	NULL	Chevrolet	Special Deluxe (Série AH) BOOMBA	Véhicule particulier	306581	Berline	Illisible	3850	17	Essence	2	1500	1383	117	0071 tce	BM9 73J	2026-02-23	1941	1941-01-01	2027-03-25	NULL	3065818	13896	operationnel	vehicule_20251216_102129_1114.jpg	NULL	2025-12-16 12:21:29	vehicule_20251216_102129_1114.jpg	image/jpeg	[BLOB - 54.5 KiB]	2026-02-19 06:50:32
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 17	17	usine	NULL	NULL	MINIMAD SARLU	NULL	Ankadikely Ilafy	NULL	Citroën	Traction Avant 11 B		NULL	Berline	NULL	1911	11	Essence	5	1550	1120	430	--	NULL	NULL	1957	NULL	NULL	NULL	NULL	0	en_reparation	vehicule_20251216_142911_7992.jpg	NULL	2025-12-16 16:29:11	vehicule_20251216_142911_7992.jpg	image/jpeg	[BLOB - 10.1 KiB]	2026-02-19 06:50:32
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 18	18	usine	NULL	NULL	MINIMAD SARLU	c/o MINIMO CONSTRUCTION - Lot AFZ - 02 , Antsahama...	Ankadikely Ilafy	NULL	Steyr-Puch	Pinzgauer 710M	Camionnette	NULL		NULL	2499	11	Essence	10	2950	1950	1000	5934 TAJ	NULL	NULL	1971	NULL	NULL	NULL	NULL	87215	operationnel	vehicule_20251218_074535_2106.png	NULL	2025-12-18 09:45:35	vehicule_20251218_074535_2106.png	image/png	[BLOB - 1.9 MiB]	2026-02-19 06:53:29
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 19	19	usine	NULL	NULL	MINIMAD SARLU	NULL	Ankadikely Ilafy	NULL	Austin	Mini Moke		NULL	Berline	NULL	998	6	Essence	4	900	578	320	---	NULL	NULL	1993	NULL	NULL	NULL	NULL	0	hs	vehicule_20251218_144248_3354.png	NULL	2025-12-18 16:42:48	vehicule_20251218_144248_3354.png	image/png	[BLOB - 580.9 KiB]	2026-02-19 06:51:34
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 20	20	client_externe	HUGUES	RIPERT MAURICE MAX	MINIMAD SARLU	LOT Maison N°01 Village Imerina Ankorondrano	Antananarivo	Gérant Société	Porsche	356 B 1500	Véhicule particulier	NULL	Coupé	NULL	1488	9	Essence	4	1300	950	350	0388 TD	NULL	NULL	1969	NULL	2027-02-07	NULL	NULL	0	operationnel	vehicule_20260326_081155_4737.jpeg	NULL	2025-12-19 07:53:43	WhatsApp Image 2026-03-26 at 09.57.31.jpeg	image/jpeg	[BLOB - 113.8 KiB]	2026-03-26 10:11:55
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 21	21	usine	NULL	NULL	MINIMAD SARLU	c/o MINIMO CONSTRUCTION - Lot AFZ - 02 , Antsahama...	Ankadikely Ilafy	NULL	Ford	Figo	Véhicule particulier	NULL	Berline	YFAC9350002	1196	5	Essence	5	1540	1040	500	9823 TAV	NULL	NULL	2011	NULL	NULL	NULL	MAJ1XXMRJ1CG66443	77324	operationnel	vehicule_20251229_173128_8496.jpeg	NULL	2025-12-29 19:31:28	vehicule_20251229_173128_8496.jpeg	image/jpeg	[BLOB - 154.1 KiB]	2026-02-19 06:51:34
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 22	22	usine	NULL	NULL	MINIMAD SARLU	c/o MINIMO CONSTRUCTION - Lot AFZ - 02 , Antsahama...	Ankadikely Ilafy	NULL	Suzuki	Jimny		NULL		NULL	1328	7	Essence	4	1420	1060	360	8161 TBL	NULL	NULL	2018	NULL	2026-11-05	2026-09-02	JSAFJB43V00716602	70281	operationnel	vehicule_20251229_202258_8835.png	NULL	2025-12-29 22:22:58	vehicule_20251229_202258_8835.png	image/png	[BLOB - 268.9 KiB]	2026-02-19 06:51:34
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 23	23	client_externe	HAROUET	Mathias	NULL	Ambatobe Ilafy	NULL	Directerur de développement	Yamaha	Crux	Moto	NULL	Utilitaire	NULL	106	1	Essence	2	245	113	130	3930 TBJ	NULL	NULL	2001	NULL	NULL	NULL	NULL	0	operationnel	vehicule_20251230_053124_2202.png	NULL	2025-12-30 07:31:24	vehicule_20251230_053124_2202.png	image/png	[BLOB - 971.4 KiB]	2026-02-19 06:51:34
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 24	24	usine	NULL	NULL	MINIMAD SARLU	c/o MINIMO CONSTRUCTION - Lot AFZ - 02 , Antsahama...	Ankadikely Ilafy	NULL	Honda	TN Acty	Camionnette	NULL		NULL	547	2	Essence	2	1020	670	350	N°1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0	hs	vehicule_20260105_121249_2903.png	NULL	2026-01-05 14:12:49	vehicule_20260105_121249_2903.png	image/png	[BLOB - 223.8 KiB]	2026-02-19 06:51:34
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 25	25	usine	NULL	NULL	MINIMAD SARLU	NULL	Ankadikely Ilafy	NULL	Honda	TN Acty	Camionnette	NULL	Pickup	NULL	547	2	Essence	5	1020	670	350	N°2	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0	hs	vehicule_20260105_121306_5476.png	NULL	2026-01-05 14:13:06	vehicule_20260105_121306_5476.png	image/png	[BLOB - 223.8 KiB]	2026-02-19 06:51:34
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 26	26	usine	NULL	NULL	MINIMAD SARLU	c/o MINIMO CONSTRUCTION - Lot AFZ - 02 , Antsahama...	Ankadikely Ilafy	NULL	Willys-Overland	CJ-3B (Universal Jeep)	Véhicule particulier	NULL	Berline	NULL	2199	12	Essence	4	1588	1017	571	7091 TAH	NULL	NULL	1953	NULL	NULL	NULL	NULL	0	operationnel	vehicule_20260219_135944_4468.jpeg	NULL	2026-02-07 09:28:09	WhatsApp Image 2026-02-07 at 9.20.45 AM.jpeg	image/jpeg	[BLOB - 140.6 KiB]	2026-02-19 15:59:44
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 27	27	usine	NULL	NULL	MINIMMO	c/o MINIMO CONSTRUCTION - Lot AFZ - 02 , Antsahama...	Ankadikely	NULL	MERCEDES-BENZ	Classe GL 500 4MATIC	Camionnette	166873	Break	27892830313417	4663	33	Essence	7	3260	2270	990	9003 TBG	NULL	NULL	2015	NULL	2026-05-21	NULL	WDC1668731A759457	0	operationnel	vehicule_20260326_044703_4643.jpeg	NULL	2026-03-26 06:47:03	WhatsApp Image 2026-03-09 at 7.51.38 AM.jpeg	image/jpeg	[BLOB - 163.9 KiB]	NULL
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 28	28	usine	NULL	NULL	Atelier	NULL	NULL	NULL	Atelier		Véhicule particulier	NULL	NULL	NULL	NULL	NULL	Autre	5	NULL	NULL	NULL	ATELIER	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0	operationnel	NULL	NULL	2026-05-13 15:10:01	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 29	29	client_externe	RIPERT	Hugues	NULL	Antsahamarofoza Ilafy	Ilafy	P.D.G.	BMW	C1 125	Moto	NULL	Scooter	NULL	125	NULL	Essence	1	NULL	185	NULL	BMW-C1	NULL	NULL	2000	NULL	NULL	NULL	NULL	0	operationnel	bmw_c1_commons.jpg	BMW C1 125 - scooter urbain avec toit et cellule d...	2026-05-15 14:18:32	bmw_c1_commons.jpg	image/jpeg	[BLOB - 126.6 KiB]	2026-05-15 14:18:32
Edit	Copy	Delete DELETE FROM vehicules WHERE `vehicules`.`id` = 30	30	usine	NULL	NULL	PISTES ROUGES SARLU	c/o MINIMO CONSTRUCTION - Lot AFZ - 02 , Antsahama...	Antananarivo	NULL	Ford	Taunus 17M Turnier	Véhicule particulier	56 335	Break	NULL	1698	10	Essence	6	1410	1060	350	5991-TC	V1E-NEUF	1961-10-02	1961	1961-10-02	NULL	NULL	NULL	0	hs	vehicule_1961_ford_taunus_17m_turnier_5991_tc.jpg	FORD TAUNUS 17M TURNIER BREAK - 1961 - ESSENCE - 1...	2026-06-15 10:30:45	Ford_Taunus_17_M_dutch_licence_registration_EL-45-...	image/jpeg	[BLOB - 892.4 KiB]	2026-06-15 10:30:45

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view