dev.surenasolutions.in / 127.0.0.1 / sgm_crm / items

There are no favourite tables.

New
information_schema
mysql
payitsea_jnablr
performance_schema
phpmyadmin
rajkamal_crm
sgm_crm
surena
- surena_code_editor
- surena_crm
- edbroad
  - surena_edbroad_1
  - surena_edbroad_old
test

Customise 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.
Favourite tables Maximum number of favourite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customise 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

Customise 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 - 24 (665 total, Query took 0.0031 seconds.) [item_code: YSGMP8VTP2... - SINGLEBEARINGBUSH...]

SELECT * FROM `items` ORDER BY `item_code` DESC

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

Filter rows:

Sort by key:

			id	item_name	alias_name	item_code 1	packing	hsn_sac_id	ledger_id	item_cat_id	godown_id	uom_id	brand_id	company_id	item_type	valuation_method	standard_cost	price_basis	mrp	profit_logic	price_type	profit_value	price sale_price	average_price	last_purchase_price	purchase_price	sale_price_delete	tax_rate	stock_quantity_del	opening_value_del	max_qty	min_qty	reorder_days	low_stock_alert	is_subsidy_item	is_edit_mrp	branch_id	item_name_key	name_norm	aliases_norm	delete_status	created_at	updated_at
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 519	519	1.5SS Y-VIB SLOT P8 SS 1.5MM	1.5SS Y-VIB SLOT P8 SS 1.5MM	YSGMP8VTP2		14808	0	7	1	1	1	1	GOODS	WAC	0.00	MRP	4872.90			0.00	4872.90	0.00	0.00	0.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	15SSYVIBSLOTP8SS15MM	15ssyvibslotp8ss15mm		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 516	516	1.5MM MS Y-VIB HOLE P6	1.5MM MS Y-VIB HOLE P6	YSGMP6VTP1		0	0	7	1	1	1	1	GOODS	WAC	0.00	MRP	5830.00			0.00	5830.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	15MMMSYVIBHOLEP6	15mmmsyvibholep6		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 515	515	1.5MM MS Y-VIB HOLE P2 1.5 SS	1.5MM MS Y-VIB HOLE P2 1.5 SS	YSGMP2VTP1		0	0	7	1	1	1	1	GOODS	WAC	0.00	MRP	100.00			0.00	100.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	15MMMSYVIBHOLEP215SS	15mmmsyvibholep215ss		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 514	514	1.5SS Y-VIB SLOT P10 SS 1.5	1.5SS Y-VIB SLOT P10 SS 1.5	YSGMP10VTP2		0	0	7	1	1	1	1	GOODS	WAC	0.00	MRP	100.00			0.00	100.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	15SSYVIBSLOTP10SS15	15ssyvibslotp10ss15		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 512	512	DOUBLE PUTTY STONE BASE 4MM MS	DOUBLE PPUTTY STONE BASE 4MM MS	YSGM2IN1WBP2_4_1		0	0	7	1	1	1	1	GOODS	WAC	0.00	MRP	8050.00			0.00	8050.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	DOUBLEPUTTYSTONEBASE4MMMS	doubleputtystonebase4mmms		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 508	508	2IN1 MOUTH 1.5MM SS	2IN1 MOUTH 1.5MM SS	YSGM2IN1DCP1_2_1		14808	0	7	1	1	1	1	GOODS	WAC	0.00	MRP	100.00			0.00	100.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	2IN1MOUTH15MMSS	2in1mouth15mmss		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 507	507	1.5MM MS Y-VIB HOLE P10 SS 1.5	1.5MM MS Y-VIB HOLE P10 SS 1.5	YSGM10VTP1		14808	0	7	1	1	1	1	GOODS	WAC	0.00	MRP	6572.00			0.00	6572.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	15MMMSYVIBHOLEP10SS15	15mmmsyvibholep10ss15		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 533	533	SOGGO SPRAY MEDIUM YELLOW-400ML	SOGGO SPRAY MEDIUM YELLOW-400ML	YELPAINT400		6991	0	13	1	1	1	1	GOODS	WAC	0.00	MRP	135.00			0.00	135.00	0.00	0.00	135.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	SOGGOSPRAYMEDIUMYELLOW400ML	soggospraymediumyellow400ml		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 151	151	YELLOW CUP	YELLOW FIBER CUP	YCUP		17602	0	9	1	1	1	1	GOODS	WAC	0.00	MRP	21.18			0.00	21.18	0.00	0.00	8.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	YELLOWCUP	yellowcup		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 532	532	TUB PIECE 3MM MS	TUB PIECE 3MM MS	Y-Tub Piece 3MM MS		14810	0	7	1	1	1	1	GOODS	WAC	0.00	MRP	72.55			0.00	72.55	0.00	0.00	0.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	TUBPIECE3MMMS	tubpiece3mmms		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 538	538	WELDING MACHINE ARC 250 ST 250AMPS	WELDING MACHINE ARC 250 ST 250AMPS	WELDMC250		18820	0	18	1	1	1	1	GOODS	WAC	0.00	MRP	9200.00			0.00	9200.00	0.00	0.00	9200.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	WELDINGMACHINEARC250ST250AMPS	weldingmachinearc250st250amps		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 537	537	WELDING ELECTRODE 3.15X350 STD	WELDING ELECTRODE 3.15X350 STD	WELD315X350		18820	0	18	1	1	1	1	GOODS	WAC	0.00	MRP	1981.53			0.00	1981.53	0.00	0.00	1981.53	0.00	0.00	0	0	0	0	0	10	N	Y	1	WELDINGELECTRODE315X350STD	weldingelectrode315x350std		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 410	410	VSP-01	VIBRATOR SIDE PATTI-01	VSP-01		14808	0	7	1	1	1	1	GOODS	WAC	0.00	MRP	100.00			0.00	100.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	VSP01	vsp01		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 225	225	UCP 205 BEARING	205 P BEARING	UCP205P		18508	0	2	1	1	1	1	GOODS	WAC	0.00	MRP	250.00			0.00	250.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	UCP205BEARING	ucp205bearing		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 235	235	UCHB 208	UCHB-208 BEARING	UCHB_208		18508	0	2	1	1	1	1	GOODS	WAC	0.00	MRP	745.76			0.00	745.76	0.00	0.00	550.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	UCHB208	uchb208		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 234	234	UCHA-208	UCHA-208 ACENTRIC BEARING	UCHA_208		18508	0	2	1	1	1	1	GOODS	WAC	0.00	MRP	745.76			0.00	745.76	0.00	0.00	550.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	UCHA208	ucha208		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 228	228	UCFL 207/20	207 FL BEARING	UCFL207FL		18508	0	2	1	1	1	1	GOODS	WAC	0.00	MRP	325.00			0.00	325.00	0.00	0.00	325.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	UCFL20720	ucfl20720		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 226	226	UCFL 204/12	204 FL BEARING	UCFL204_12		18508	0	2	1	1	1	1	GOODS	WAC	0.00	MRP	233.05			0.00	233.05	0.00	0.00	152.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	UCFL20412	ucfl20412		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 409	409	TUB-01 (PLAIN)	TUB-01 (PLAIN)	TUB01		14808	0	7	1	1	1	1	GOODS	WAC	0.00	MRP	305.08			0.00	305.08	0.00	0.00	0.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	TUB01PLAIN	tub01plain		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 293	293	TAG BIG & SMALL	TAG BIG & SMALL	TAG		19450	0	8	1	1	1	1	GOODS	WAC	0.00	MRP	139.00			0.00	139.00	0.00	0.00	139.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	TAGBIGSMALL	tagbigsmall		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 665	665	S.S. Conveyor (C.S.G)	S.S. Conveyor (C.S.G)	SSCSG		14808	0	16	1	0	1	1	GOODS	WAC	0.00	MRP	3531.07			0.00	3531.07	0.00	0.00	0.00	0.00	18.00	0	0	0	0	0	10	N	Y	1	SSCONVEYORCSG	ssconveyorcsg		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 283	283	SPROCKET WITH GEAR PIN	SPROCKET WITH GEAR PIN	SPRWGPIN		17212	0	14	1	1	1	1	GOODS	WAC	0.00	MRP	100.00			0.00	100.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	SPROCKETWITHGEARPIN	sprocketwithgearpin		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 243	243	SPROCKET WITH GEAR PIN	SPROCKET WITH GEAR PIN	SPKWGEARPIN		20237	0	14	1	1	1	1	GOODS	WAC	0.00	MRP	100.00			0.00	100.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	SPROCKETWITHGEARPIN	sprocketwithgearpin		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 408	408	SP-01 U CLAMP	SP-01 U CLAMP	SP01UC		14808	0	7	1	1	1	1	GOODS	WAC	0.00	MRP	100.00			0.00	100.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	0	10	N	Y	1	SP01UCLAMP	sp01uclamp		0	0000-00-00 00:00:00	0000-00-00 00:00:00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 4	4	SINGLE BEARING BUSH	SINGLE BEARING BUSH	SINGLEBEARINGBUSH		18519	0	5	1	1	1	1	GOODS	WAC	0.00	MRP	52.60			0.00	52.60	0.00	0.00	52.60	0.00	18.00	0	0	0	0	0	10	N	Y	1	SINGLEBEARINGBUSH	singlebearingbush		0	0000-00-00 00:00:00	0000-00-00 00:00:00

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view