competence-rs.com / localhost / herp / item_master

Navigation panel
Navigation tree
Databases
Tables

Navigation panel

Customize appearance of the 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 tree

Customize the 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

Databases

Databases display options.

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

Tables

Tables display options.

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-

Server: localhost »

Database: herp »

Table: item_master

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:

Do a "query by example" (wildcard: "%")

Column	Type	Collation
id	int(8)

mst_unitid	varchar(200)	latin1_swedish_ci

CategoryID	varchar(20)	latin1_swedish_ci

SubCategoryID	varchar(20)	latin1_swedish_ci

StockID	varchar(20)	latin1_swedish_ci

item_name	varchar(255)	latin1_swedish_ci

item_desc	varchar(255)	latin1_swedish_ci

state	int(5)

height	varchar(10)	latin1_swedish_ci

width	varchar(10)	latin1_swedish_ci

teeth	varchar(10)	latin1_swedish_ci

ups	varchar(10)	latin1_swedish_ci

foil_size	varchar(10)	latin1_swedish_ci

paper_size	varchar(10)	latin1_swedish_ci

paper_name	varchar(10)	latin1_swedish_ci

print_size	varchar(10)	latin1_swedish_ci

frt_br	varchar(10)	latin1_swedish_ci

color_no	varchar(10)	latin1_swedish_ci

image_pdf	varchar(20)	latin1_swedish_ci

embossing	varchar(10)	latin1_swedish_ci

spot	varchar(10)	latin1_swedish_ci

party	varchar(10)	latin1_swedish_ci

varnish	varchar(10)	latin1_swedish_ci

uv	varchar(10)	latin1_swedish_ci

overprint	varchar(10)	latin1_swedish_ci

foil	varchar(10)	latin1_swedish_ci

cut	varchar(10)	latin1_swedish_ci

item_no	varchar(10)	latin1_swedish_ci

flexo_offset	varchar(15)	latin1_swedish_ci

unit	int(5)

size	varchar(5)	latin1_swedish_ci

length	double(10,2)

gsm	varchar(20)	latin1_swedish_ci

od	varchar(20)	latin1_swedish_ci

make	int(5)

grade	int(5)

color	int(5)

serial_no	varchar(30)	latin1_swedish_ci

orig_local	varchar(30)	latin1_swedish_ci

type_name	varchar(30)	latin1_swedish_ci

shade	varchar(30)	latin1_swedish_ci

running_roll	varchar(30)	latin1_swedish_ci

volume	varchar(30)	latin1_swedish_ci

bcm	varchar(30)	latin1_swedish_ci

quality	varchar(30)	latin1_swedish_ci

created_date	date

LPI	varchar(255)	latin1_swedish_ci

THICKNESS	varchar(255)	latin1_swedish_ci

QTY	varchar(255)	latin1_swedish_ci

WEIGHT	varchar(255)	latin1_swedish_ci

conv_unit	varchar(200)	latin1_swedish_ci

conv_factor	varchar(200)	latin1_swedish_ci

min_level	varchar(200)	latin1_swedish_ci

max_level	varchar(200)	latin1_swedish_ci

reorder_level	varchar(200)	latin1_swedish_ci

mrp_rate	varchar(200)	latin1_swedish_ci

item_discount	varchar(200)	latin1_swedish_ci

net_rate	varchar(200)	latin1_swedish_ci

CompanyId	int(11)

shade_name	varchar(200)	latin1_swedish_ci

item_mst_form_rate	varchar(200)	latin1_swedish_ci

product_sheet	varchar(200)	latin1_swedish_ci

net_wt	varchar(200)	latin1_swedish_ci

gross_wt	varchar(200)	latin1_swedish_ci

abc_class	varchar(200)	latin1_swedish_ci

excise_trafficno	varchar(200)	latin1_swedish_ci

warr_period	int(5)

item_mst_form	varchar(200)	latin1_swedish_ci

brand_code	varchar(200)	latin1_swedish_ci

material_type	varchar(200)	latin1_swedish_ci

material_item_desc	varchar(200)	latin1_swedish_ci

cust_drwgno	varchar(200)	latin1_swedish_ci

Mfg_drwgcode	varchar(200)	latin1_swedish_ci

Mfg_drwgno	varchar(200)	latin1_swedish_ci

groupid	varchar(200)	latin1_swedish_ci

users	varchar(200)	latin1_swedish_ci

type_of_material	varchar(200)	latin1_swedish_ci

last_po_price	varchar(200)	latin1_swedish_ci

item_profit	varchar(200)	latin1_swedish_ci

mst_ledgerid	varchar(255)	latin1_swedish_ci

mst_ledger_code	varchar(255)	latin1_swedish_ci

tolerance	double(10,2)

item_exciable	varchar(255)	latin1_swedish_ci

price_list_item	int(1)

part_no	varchar(30)	latin1_swedish_ci

curen	int(5)

Convertcuren	int(5)

con_rate	int(5)

box_itm_qty	float(10,2)

assign_vender	varchar(255)	latin1_swedish_ci

depriciation_incometax	int(11)

depriciation_2	int(11)

model	int(10)

waste_per	double(10,2)

front_img	varchar(255)	latin1_swedish_ci

back_img	varchar(255)	latin1_swedish_ci

ref_item_id	int(10)

vat_purchase	int(11)

cst_purchase	int(11)

vat_sales	int(11)

cst_sales	int(11)

inventory_item	varchar(100)	latin1_swedish_ci

batch_item	varchar(1)	latin1_swedish_ci

medicine_item	varchar(1)	latin1_swedish_ci

quality_of_material	varchar(100)	latin1_swedish_ci

back_image	varchar(100)	latin1_swedish_ci

front_image	varchar(100)	latin1_swedish_ci

abtment	double(10,2)

batch_no	varchar(255)	latin1_swedish_ci

hsn_code	varchar(40)	latin1_swedish_ci

hsn_applicable	tinyint(1)

exempted	tinyint(1)

gst_sales	int(11)

gst_purchase	int(11)

gst_percentage	float(6,2)

gst_applicable	varchar(30)	latin1_swedish_ci

Select columns (at least one): DISTINCT

Or Add search conditions (body of the "where" clause):

Number of rows per page

Display order:

Ascending

Descending

id
mst_unitid
CategoryID
SubCategoryID
StockID
item_name
item_desc
state
height
width
teeth
ups
foil_size
paper_size
paper_name
print_size
frt_br
color_no
image_pdf
embossing
spot
party
varnish
uv
overprint
foil
cut
item_no
flexo_offset
unit
size
length
gsm
od
make
grade
color
serial_no
orig_local
type_name
shade
running_roll
volume
bcm
quality
created_date
LPI
THICKNESS
QTY
WEIGHT
conv_unit
conv_factor
min_level
max_level
reorder_level
mrp_rate
item_discount
net_rate
CompanyId
shade_name
item_mst_form_rate
product_sheet
net_wt
gross_wt
abc_class
excise_trafficno
warr_period
item_mst_form
brand_code
material_type
material_item_desc
cust_drwgno
Mfg_drwgcode
Mfg_drwgno
groupid
users
type_of_material
last_po_price
item_profit
mst_ledgerid
mst_ledger_code
tolerance
item_exciable
price_list_item
part_no
curen
Convertcuren
con_rate
box_itm_qty
assign_vender
depriciation_incometax
depriciation_2
model
waste_per
front_img
back_img
ref_item_id
vat_purchase
cst_purchase
vat_sales
cst_sales
inventory_item
batch_item
medicine_item
quality_of_material
back_image
front_image
abtment
batch_no
hsn_code
hsn_applicable
exempted
gst_sales
gst_purchase
gst_percentage
gst_applicable