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 :
Untitled *
v Show/Hide tables list View in full-screen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
Number of tables: 0
v phpmyadmin bbtracker2
* srno : int(10)
* CKTID : varchar(20)
* IDate : date
* CNAME : varchar(100)
* CADDRESS : varchar(400)
* City : varchar(40)
* pincode : int(10)
* Plan : varchar(11)
* POstatus : varchar(20)
* lcname : varchar(100)
* LCcontact : varchar(20)
* checklist : varchar(10)
* company : varchar(100)
* timestamp : timestamp(6)
v phpmyadmin checklist
* srno : int(5)
* sitename : varchar(100)
* prno : varchar(20)
* pono : varchar(20)
* city : varchar(100)
* caddress : varchar(400)
* spectraid : varchar(20)
* cname : varchar(40)
* cktid : varchar(20)
* company : varchar(40)
* scontactno1 : varchar(30)
* scontactmail1 : varchar(100)
* scontactno2 : varchar(30)
* scontactmail2 : varchar(100)
* linktype : varchar(40)
* cpetype : varchar(40)
* connectivitytype : varchar(40)
* plan : varchar(20)
* fup : varchar(20)
* fuplimit : varchar(20)
* wanip : varchar(40)
* wangateway : varchar(40)
* subnet : varchar(40)
* dns1 : varchar(40)
* dns2 : varchar(40)
* bstartdate : varchar(20)
* bfrequency : varchar(40)
* linkstatus : varchar(40)
* pppoe : varchar(100)
* wifi : varchar(40)
* timestamp : timestamp(6)
v phpmyadmin expanses
* srno : int(5)
* cktid : varchar(17)
* expenses : varchar(15)
* futureexpenses : varchar(15)
* custumername : varchar(100)
* city : varchar(20)
* address : varchar(400)
* timestamp : timestamp(6)
v phpmyadmin fepayment
* srno : int(6)
* vender : varchar(100)
* particular : varchar(400)
* amount : int(10)
* date : date
* timestamp : timestamp
v phpmyadmin fullrecord
* srno : int(5)
* cktid : varchar(20)
* pono : varchar(13)
* podate : varchar(15)
* validity : varchar(15)
* address : varchar(400)
* value : varchar(10)
* gst : varchar(5)
* gstvalue : varchar(11)
* company : varchar(40)
* cname : varchar(40)
* city : varchar(20)
* pincode : int(10)
* plan : varchar(10)
* invoiceno : varchar(100)
* invoicedate : varchar(100)
* invoicevalidity : varchar(100)
* paymentstatus : varchar(100)
* receivingdate : varchar(100)
* idate : varchar(20)
* timestamp : timestamp(6)
v phpmyadmin futureexpense
* srno : int(10)
* cktid : varchar(20)
* futureexpense : int(10)
* timestamp : timestamp(6)
v phpmyadmin investor
* srno : int(11)
* idate : date
* investor : varchar(100)
* particular : varchar(100)
* iamount : int(11)
* profit : int(11)
* returnmonth : varchar(100)
* returndate : date
* timestamp : timestamp
v phpmyadmin invoicerecord1
* srno : int(5)
* cktid : varchar(20)
* invoiceno : varchar(20)
* invmonth : varchar(10)
* invdate : date
* invservicecharge : int(10)
* invotc : int(10)
* invgst : int(10)
* invtotalamount : int(10)
* invoiceperiod : int(5)
* ponumber : varchar(20)
* invvalid : date
* invsubmit : date
* invprocess : varchar(20)
* receive_id : varchar(10)
* timestamp : timestamp(6)
v phpmyadmin linkstatus
* srno : int(5)
* cktid : varchar(20)
* linkstatus : varchar(20)
* date : date
* orderrcvby : varchar(40)
* persondetails : varchar(100)
* timestamp : timestamp(6)
v phpmyadmin operato
* srno : int(10)
* cktid : varchar(20)
* operatorname : varchar(100)
* contact : varchar(40)
* sdeposite : int(10)
* city : varchar(100)
* mrc : int(10)
* otc : int(10)
* plan : varchar(20)
* psdate : varchar(100)
* pedate : date
* ploginid : varchar(40)
* lpassword : varchar(40)
* excilationmatrix : varchar(100)
* paymentstatus : varchar(40)
* npdate : date
* timestamp : timestamp(6)
v phpmyadmin payment1
* srno : int(5)
* cktid : varchar(20)
* pono : varchar(20)
* paymentdate : date
* particular : varchar(400)
* amount : int(10)
* mode : varchar(5)
* image : varchar(400)
* timestamp : timestamp(6)
v phpmyadmin paymentreceive
* srno : int(5)
* cktid : varchar(17)
* invoiceno : varchar(15)
* payment_receive : int(10)
* gst_receive : int(10)
* total_receive : int(10)
* tdsdeduction : int(5)
* balanceamount : int(10)
* receivingdate : date
* pono : varchar(20)
* timestamp : timestamp(6)
v phpmyadmin photo
* srno : int(5)
* cktid : varchar(20)
* image1 : varchar(100)
* image2 : varchar(100)
* image3 : varchar(100)
* image4 : varchar(100)
* timestamp : timestamp(6)
v phpmyadmin pma__bookmark
* id : int(10) unsigned
* dbase : varchar(255)
* user : varchar(255)
* label : varchar(255)
* query : text
v phpmyadmin pma__central_columns
* db_name : varchar(64)
* col_name : varchar(64)
* col_type : varchar(64)
* col_length : text
* col_collation : varchar(64)
* col_isNull : tinyint(1)
* col_extra : varchar(255)
* col_default : text
v phpmyadmin pma__column_info
* id : int(5) unsigned
* db_name : varchar(64)
* table_name : varchar(64)
* column_name : varchar(64)
* comment : varchar(255)
* mimetype : varchar(255)
* transformation : varchar(255)
* transformation_options : varchar(255)
* input_transformation : varchar(255)
* input_transformation_options : varchar(255)
v phpmyadmin pma__designer_settings
* username : varchar(64)
* settings_data : text
v phpmyadmin pma__export_templates
* id : int(5) unsigned
* username : varchar(64)
* export_type : varchar(10)
* template_name : varchar(64)
* template_data : text
v phpmyadmin pma__favorite
* username : varchar(64)
* tables : text
v phpmyadmin pma__history
* id : bigint(20) unsigned
* username : varchar(64)
* db : varchar(64)
* table : varchar(64)
* timevalue : timestamp
* sqlquery : text
v phpmyadmin pma__navigationhiding
* username : varchar(64)
* item_name : varchar(64)
* item_type : varchar(64)
* db_name : varchar(64)
* table_name : varchar(64)
v phpmyadmin pma__pdf_pages
* db_name : varchar(64)
* page_nr : int(10) unsigned
* page_descr : varchar(50)
v phpmyadmin pma__recent
* username : varchar(64)
* tables : text
v phpmyadmin pma__relation
* master_db : varchar(64)
* master_table : varchar(64)
* master_field : varchar(64)
* foreign_db : varchar(64)
* foreign_table : varchar(64)
* foreign_field : varchar(64)
v phpmyadmin pma__savedsearches
* id : int(5) unsigned
* username : varchar(64)
* db_name : varchar(64)
* search_name : varchar(64)
* search_data : text
v phpmyadmin pma__table_coords
* db_name : varchar(64)
* table_name : varchar(64)
* pdf_page_number : int(11)
* x : float unsigned
* y : float unsigned
v phpmyadmin pma__table_info
* db_name : varchar(64)
* table_name : varchar(64)
* display_field : varchar(64)
v phpmyadmin pma__table_uiprefs
* username : varchar(64)
* db_name : varchar(64)
* table_name : varchar(64)
* prefs : text
* last_update : timestamp
v phpmyadmin pma__tracking
* db_name : varchar(64)
* table_name : varchar(64)
* version : int(10) unsigned
* date_created : datetime
* date_updated : datetime
* schema_snapshot : text
* schema_sql : text
* data_sql : longtext
* tracking : set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW')
* tracking_active : int(1) unsigned
v phpmyadmin pma__userconfig
* username : varchar(64)
* timevalue : timestamp
* config_data : text
v phpmyadmin pma__usergroups
* usergroup : varchar(64)
* tab : varchar(64)
* allowed : enum('Y','N')
v phpmyadmin pma__users
* username : varchar(64)
* usergroup : varchar(64)
v phpmyadmin porecord1
* srno : int(6)
* cktid : varchar(20)
* pono : varchar(20)
* podate : date
* validityinmonth : int(10)
* mrcvalue : int(10)
* otcvalue : int(10)
* gst : int(10)
* gstvalue : int(10)
* company : varchar(100)
* po_receive_date : date
* invoiceno : varchar(20)
* poimage : varchar(100)
* timestamp : timestamp(6)
v phpmyadmin porenew
* srno : int(5)
* cktid : varchar(20)
* idate_old : date
* idate_new : date
* pono_old : varchar(20)
* pono_new : varchar(20)
* timestamp : timestamp(6)
v phpmyadmin progretion
* srno : int(10)
* cktid : varchar(100)
* cname : varchar(100)
* caddress : varchar(300)
* city : varchar(20)
* plan : varchar(10)
* status : varchar(300)
* company : varchar(20)
v phpmyadmin shifting
* srno : int(5)
* cktid : varchar(20)
* date : date
* old_address : varchar(400)
* address : varchar(400)
* city : varchar(100)
* pincode : int(10)
* postatus : varchar(20)
* checklist : varchar(10)
* user : varchar(15)
* timestamp : timestamp(6)
v phpmyadmin user
* vishal : varchar(4)
* vishal@gmail.com : varchar(14)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship