Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `proj_detl`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts part_id oa_no proj_no product_category sa_name assy_drg_no sa_drg_no sa_per_assy part_name part_drg_no batch_no parts_per_assy vendor_order_qty actual_qty reqd_total_qty mat_req_qty mat_recd_qty mat_issue_qty part_rcpt_qty accepted_qty rejected_qty rework_qty rework_issue_qty part_issue_qty trgt_date class_of_parts status os_planner date_drg_issue raw_mat_spec raw_mat_dimension rev_del_dt remarks proj_remarks_by_date_time bom_qty part_acpt_date part_issue_assly_date part_issue_assly_qty return_accept_qty no_of_stages status_flag start_dt end_dt pending_assly_issue_qty bom_upload_date design_eng part_drg_remarks part_drg_aprov_by drg_release_dt type final_insp_dt no_of_insp mr_na part_drg_release_by hsn_code sac_code revision uom model make website alternate_allow week_lead_time part_drg_file part_drg_file_flag sa_drg_file sa_drg_file_flag qc_require inventory_id drawing_updated_by drawing_updated_date drg_update_status
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 5443
5443 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 SPINDLE 0433-2-00-010 1 1.000 1.000 0.000 1.000 1.000 0.000 1.000 0.000 1.000 0.000 0.000 0.000 0.000 2012-04-05 A 100.00 VINEESH 2012-04-05 1900-01-01 NULL 1.000 1900-01-01 1900-01-01 0.000 0.000 1 A 2012-04-05 1900-01-01 0.000 2012-04-05 approved 2012-04-05 MFG NULL 1 1 0 NULL 0 No 0433-2-00-010.pdf 0 002-0-00-010.pdf 0 1 122 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 5446
5446 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 SPINDLE HUB 0434-3-00-010 WE 1 1.000 1.000 0.000 1.000 0.000 0.000 1.000 0.000 1.000 0.000 0.000 0.000 0.000 1900-01-23 A 100.00 N.G RANJITH 1900-01-23 NA 1900-01-01 NULL 1.000 1900-01-01 1900-01-01 0.000 0.000 1 A 1900-01-23 1900-01-01 0.000 1900-01-23 approved 1900-01-23 MFG NULL 0 1 0 NULL 0 No 0434-3-00-010 WE.pdf 0 002-0-00-010.pdf 0 1 123 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 5447
5447 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 TEST PIESE 20MNCR5 1 30.000 30.000 0.000 30.000 30.000 30.000 30.000 0.000 30.000 0.000 0.000 0.000 0.000 1900-01-10 C 100.00 RAJESH 1900-01-30 20 MNCR5 DIA 30X30 1900-01-01 NULL 30.000 1900-01-01 1900-01-01 0.000 0.000 1 A 1900-01-30 1900-01-01 0.000 1900-01-30 approved 1900-01-30 MFG NULL 1 1 0 NULL 0 No 20MNCR5.pdf 0 002-0-00-010.pdf 0 1 124 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 5448
5448 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 TEST PIECE EN353 1 30.000 30.000 0.000 30.000 30.000 30.000 30.000 0.000 30.000 0.000 0.000 0.000 0.000 1900-01-10 C 100.00 RAJESH 1900-01-30 EN353 DIA 30X35 1900-01-01 NULL 30.000 1900-01-01 1900-01-01 0.000 0.000 1 A 1900-01-30 1900-01-01 0.000 1900-01-30 approved 1900-01-30 MFG NULL 1 1 0 NULL 0 No EN353.pdf 0 002-0-00-010.pdf 0 1 125 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 5449
5449 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 36 A/F NUT PART-1 1 50.000 50.000 0.000 50.000 0.000 0.000 50.000 0.000 50.000 0.000 0.000 0.000 0.000 1900-01-23 C 100.00 RAJESH 1900-01-23 NA 1900-01-01 NULL 50.000 1900-01-01 1900-01-01 0.000 0.000 1 A 1900-01-23 1900-01-01 0.000 1900-01-23 approved 1900-01-23 MFG NULL 0 1 0 NULL 0 No PART-1.pdf 0 002-0-00-010.pdf 0 1 126 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 5450
5450 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 32 A/F NUT PART-2 1 50.000 50.000 0.000 50.000 0.000 0.000 50.000 0.000 50.000 0.000 0.000 0.000 0.000 1900-01-23 C 100.00 RAJESH 1900-01-23 NA 1900-01-01 NULL 50.000 1900-01-01 1900-01-01 0.000 0.000 1 A 1900-01-23 1900-01-01 0.000 1900-01-23 approved 1900-01-23 MFG NULL 0 1 0 NULL 0 No PART-2.pdf 0 002-0-00-010.pdf 0 1 127 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 5451
5451 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 A2-11 RING GAUGE T202001-260 1 1.000 1.000 0.000 1.000 1.000 1.000 1.000 1.000 1.000 0.000 0.000 0.000 0.000 1900-01-30 A 100.00 GIRIDHARANM L 1900-01-19 OHNS OD-286, ID-184, THICKNESS-32 1900-01-01 NULL 1.000 2014-09-08 1900-01-01 0.000 0.000 1 A 1900-01-19 1900-01-01 0.000 1900-01-19 approved 1900-01-19 MFG NULL 0 1 0 NULL 0 No T202001-260.pdf 0 002-0-00-010.pdf 0 1 128 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 5452
5452 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 A2-8 RING GAUGE T202002-260 1 1.000 1.000 0.000 1.000 1.000 1.000 1.000 1.000 1.000 0.000 0.000 0.000 0.000 1900-01-30 A 100.00 GIRIDHARANM L 1900-01-23 OHNS & BRASS BUSH DIA  206 X 30 & DIA 16 X 70 1900-01-01 NULL 1.000 2014-09-08 1900-01-01 0.000 0.000 1 A 1900-01-23 1900-01-01 0.000 1900-01-23 approved 1900-01-23 MFG NULL 0 1 0 NULL 0 No T202002-260.pdf 0 002-0-00-010.pdf 0 1 129 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 6283
6283 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 GRINDING ATTACHMENT BRACKET 0499-2-00-198 F 1 1.000 1.000 0.000 1.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1900-01-30 A 100.00 Levinpurchase 2000-01-19 NA 1900-01-01 NULL 1.000 1900-01-01 1900-01-01 0.000 0.000 1 A 2000-01-19 1900-01-01 0.000 2000-01-19 approved 2000-01-19 MFG NULL 0 1 0 NULL 0 No 0499-2-00-198 F.pdf 0 002-0-00-010.pdf 0 1 130 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 6330
6330 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 INNER BALANCING WEIGHT 0172-4-01-062 1 3.000 3.000 0.000 3.000 3.000 3.000 3.000 0.000 3.000 0.000 0.000 0.000 0.000 2001-01-30 C 100.00 N.G RANJITH 1900-11-03 MS DIA 65 X 12 1900-01-01 NULL 3.000 1900-01-30 1900-01-01 0.000 0.000 1 A 1900-11-03 1900-01-30 0.000 1900-11-03 approved 1900-11-03 MFG NULL 2 1 0 NULL 0 No 0172-4-01-062.pdf 0 002-0-00-010.pdf 0 1 131 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 6331
6331 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 WASHER 0171-4-01-062 1 1.000 1.000 0.000 1.000 1.000 1.000 0.000 0.000 1.000 0.000 0.000 0.000 0.000 2001-01-30 C 100.00 N.G RANJITH 1900-11-03 MS DIA 30 X 18 1900-01-01 NULL 1.000 1900-01-01 1900-01-01 0.000 0.000 1 A 1900-11-03 1900-01-01 0.000 1900-11-03 approved 1900-11-03 MFG NULL 1 1 0 NULL 0 No 0171-4-01-062.pdf 0 002-0-00-010.pdf 0 1 132 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 6332
6332 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 OUTER BALANCING WEIGHT 0173-4-01-062 1 3.000 3.000 0.000 3.000 3.000 3.000 3.000 0.000 3.000 0.000 0.000 0.000 0.000 2001-01-30 C 100.00 N.G RANJITH 1900-11-03 MS DIA 76 X 12 1900-01-01 NULL 3.000 1900-01-30 1900-01-01 0.000 0.000 1 A 1900-11-03 1900-01-30 0.000 1900-11-03 approved 1900-11-03 MFG NULL 2 1 0 NULL 0 No 0173-4-01-062.pdf 0 002-0-00-010.pdf 0 1 133 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 6402
6402 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 FLANGE 0170-4-01-062 1 1.000 1.000 0.000 1.000 1.000 1.000 1.000 0.000 1.000 0.000 0.000 0.000 0.000 2002-01-15 B 100.00 GIRIDHARANM L 1900-11-07 15Ni2Cr1Mo15 DIA 95 X 48 1900-01-01 NULL 1.000 1900-01-01 1900-01-01 0.000 0.000 1 A 1900-11-07 1900-01-01 0.000 1900-11-07 approved 1900-11-07 MFG NULL 0 1 0 NULL 0 No 0170-4-01-062.pdf 0 002-0-00-010.pdf 0 1 134 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 6403
6403 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 FLANGE 0174-4-00-062 1 1.000 1.000 0.000 1.000 1.000 1.000 1.000 0.000 1.000 0.000 0.000 0.000 0.000 2002-01-15 C 100.00 N.G RANJITH 1900-11-07 EN-19 DIA 95 X 25 1900-01-01 NULL 1.000 1900-01-01 1900-01-01 0.000 0.000 1 A 1900-11-07 1900-01-27 0.000 1900-11-07 approved 1900-11-07 MFG NULL 2 1 0 NULL 0 No 0174-4-00-062.pdf 0 002-0-00-010.pdf 0 1 135 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 6404
6404 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 8*17"50" MALE GAUGE 0010-4-01-240 1 1.000 1.000 0.000 1.000 1.000 1.000 1.000 0.000 1.000 0.000 0.000 0.000 0.000 2002-01-15 B 100.00 GIRIDHARANM L 1900-11-07 EN-31 DIA 30 X 70 1900-01-01 NULL 1.000 1900-01-01 1900-01-01 0.000 0.000 1 A 1900-11-07 1900-01-01 0.000 1900-11-07 approved 1900-11-07 MFG NULL 0 1 0 NULL 0 No 0010-4-01-240.pdf 0 002-0-00-010.pdf 0 1 136 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 6441
6441 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 QIILL NA 1 1.000 1.000 0.000 1.000 0.000 0.000 0.000 0.000 1.000 0.000 0.000 0.000 0.000 2001-01-30 A 100.00 N.G RANJITH 2001-01-19 NA 1900-01-01 NULL 1.000 1900-01-01 1900-01-01 0.000 0.000 1 A 2001-01-19 1900-01-01 0.000 2001-01-19 approved 2001-01-19 MFG NULL 0 1 0 NULL 0 No NA.pdf 0 002-0-00-010.pdf 0 1 137 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 6455
6455 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 WHEEL GUARD 0177-3-00-062 1 1.000 1.000 0.000 1.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1900-01-30 C 100.00 Levinpurchase 2001-01-19 1900-01-01 NULL 1.000 1900-01-01 1900-01-01 0.000 0.000 1 A 2001-01-19 1900-01-01 0.000 2001-01-19 approved 2001-01-19 MFG NULL 0 1 0 NULL 0 No 0177-3-00-062.pdf 0 002-0-00-010.pdf 0 1 138 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 6456
6456 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 TOP COVER 0176-2-00-062 1 1.000 1.000 0.000 1.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1900-01-30 C 100.00 Levinpurchase 2001-01-19 1900-01-01 NULL 1.000 1900-01-01 1900-01-01 0.000 0.000 1 A 2001-01-19 1900-01-01 0.000 2001-01-19 approved 2001-01-19 MFG NULL 0 1 0 NULL 0 No 0176-2-00-062.pdf 0 002-0-00-010.pdf 0 1 139 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 6457
6457 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 GUARD COVER 0178-4-00-062 1 1.000 1.000 0.000 1.000 1.000 1.000 0.000 0.000 1.000 0.000 0.000 0.000 0.000 2002-01-31 C 100.00 N.G RANJITH 2001-01-19 MS DIA 245 X 10 1900-01-01 NULL 1.000 1900-01-01 1900-01-01 0.000 0.000 1 A 2001-01-19 1900-01-01 0.000 2001-01-19 approved 2001-01-19 MFG NULL 1 1 0 NULL 0 No 0178-4-00-062.pdf 0 002-0-00-010.pdf 0 1 140 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 6458
6458 IN HOUSE 010 SPINDLE ASSLY 01-0-00 002-0-00-010 1 FLANGE PULLER 0175-4-00-062 1 1.000 1.000 0.000 1.000 1.000 1.000 1.000 0.000 1.000 0.000 0.000 0.000 0.000 2002-01-31 C 100.00 N.G RANJITH 2001-01-21 C-45 DIA 25 X 50 1900-01-01 NULL 1.000 1900-01-01 1900-01-01 0.000 0.000 1 A 2001-01-21 2013-08-08 0.000 2001-01-21 approved 2001-01-21 MFG NULL 2 1 0 NULL 0 No 0175-4-00-062.pdf 0 002-0-00-010.pdf 0 1 141 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 8595
8595 IN HOUSE 010 OVER ALL ASSLY 01-0-00 01-0-00 1 NUT FOR SCREW ROD NA 1 1.000 1.000 0.000 1.000 0.000 0.000 0.000 0.000 1.000 0.000 0.000 0.000 0.000 1900-01-31 B 100.00 RAJESH 1900-01-27 1900-01-01 NULL 1.000 1900-01-01 1900-01-01 0.000 0.000 1 A 1900-01-27 1900-01-01 0.000 1900-01-27 approved 1900-01-27 MFG NULL 0 1 0 NULL 0 No NA.pdf 0 01-0-00.pdf 0 1 142 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 8596
8596 IN HOUSE 010 OVER ALL ASSLY 01-0-00 01-0-00 1 DRAW BAR 0077-4-00-204 1 1.000 1.000 0.000 1.000 0.000 0.000 0.000 0.000 1.000 0.000 0.000 0.000 0.000 1900-01-31 B 100.00 RAJESH 1900-01-27 NA 1900-01-01 NULL 1.000 1900-01-01 1900-01-01 0.000 0.000 1 A 1900-01-27 1900-01-01 0.000 1900-01-27 approved 1900-01-27 MFG NULL 0 1 0 NULL 0 No 0077-4-00-204.pdf 0 01-0-00.pdf 0 1 143 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 10363
10363 STOCK STOCK SPINDLE GEAR BOX ASSLY 05-0-00 010-1-00-187 1 SPLINE SHAFT-II 0017-3-187 1 2.000 2.000 0.000 2.000 0.000 0.000 0.000 0.000 2.000 0.000 0.000 0.000 0.000 1900-01-01 A 100.00 GIRIDHARANM L 1900-01-18 20MNCR5 DIA75X340 1900-01-01 NULL 2.000 1900-01-18 1900-01-01 2.000 0.000 1 A 1900-01-18 1900-01-18 0.000 1900-01-18 approved 1900-01-18 MFG NULL 0 1 0 NULL 0 No 0017-3-187.pdf 0 010-1-00-187.pdf 0 1 144 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 10404
10404 STOCK STOCK SPINDLE GEAR BOX ASSLY 05-0-00 010-1-00-187 1 SPLINE SHAFT-I 0016-3-187 1 2.000 2.000 0.000 2.000 0.000 0.000 0.000 0.000 2.000 0.000 0.000 0.000 0.000 1900-01-01 A 100.00 GIRIDHARANM L 1900-01-18 20MNCR5 DIA 90X340 1900-01-01 NULL 2.000 1900-01-18 1900-01-01 2.000 0.000 1 A 1900-01-18 1900-01-18 0.000 1900-01-18 approved 1900-01-18 MFG NULL 0 1 0 NULL 0 No 0016-3-187.pdf 0 010-1-00-187.pdf 0 1 145 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM proj_detl WHERE `proj_detl`.`part_id` = 10405
10405 STOCK STOCK SPINDLE GEAR BOX ASSLY 05-0-00 010-1-00-187 1 SPLINE SHAFT-III 0027-3-187 1 2.000 2.000 0.000 2.000 0.000 0.000 0.000 0.000 2.000 0.000 0.000 0.000 0.000 1900-01-01 A 100.00 GIRIDHARANM L 1900-01-18 20MN CR5 DIA 65X350 1900-01-01 NULL 2.000 1900-01-18 1900-01-01 2.000 0.000 1 A 1900-01-18 1900-01-18 0.000 1900-01-18 approved 1900-01-18 MFG NULL 0 1 0 NULL 0 No 0027-3-187.pdf 0 010-1-00-187.pdf 0 1 146 NULL
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query