__NUXT_JSONP__("/posts/snippets/mysql", (function(a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,_,$,aa,ab,ac,ad,ae,af,ag,ah,ai,aj,ak,al,am,an,ao,ap,aq,ar,as,at,au,av,aw,ax){return {data:[{category:"snippets",posts:{slug:"mysql",title:"Mysql",toc:[{id:G,depth:H,text:I},{id:J,depth:t,text:K},{id:L,depth:t,text:M},{id:N,depth:t,text:O},{id:P,depth:t,text:Q},{id:R,depth:t,text:S},{id:T,depth:t,text:U},{id:V,depth:t,text:W},{id:X,depth:t,text:Y},{id:Z,depth:H,text:_},{id:C,depth:t,text:C}],body:{type:"root",children:[{type:b,tag:$,props:{id:G},children:[{type:b,tag:h,props:{href:"#quick-commands",ariaHidden:p,tabIndex:q},children:[{type:b,tag:c,props:{className:[r,s]},children:[]}]},{type:a,value:I}]},{type:a,value:e},{type:b,tag:u,props:{id:J},children:[{type:b,tag:h,props:{href:"#dump-database-into-file",ariaHidden:p,tabIndex:q},children:[{type:b,tag:c,props:{className:[r,s]},children:[]}]},{type:a,value:K}]},{type:a,value:e},{type:b,tag:j,props:{className:[k]},children:[{type:b,tag:l,props:{className:[m,x]},children:[{type:b,tag:n,props:{},children:[{type:a,value:"mysqldump -u root -p backend "},{type:b,tag:c,props:{className:[d,o]},children:[{type:a,value:"\u003E"}]},{type:a,value:aa}]}]}]},{type:a,value:e},{type:b,tag:D,props:{},children:[]},{type:a,value:e},{type:b,tag:u,props:{id:L},children:[{type:b,tag:h,props:{href:"#insert-dump-into-database",ariaHidden:p,tabIndex:q},children:[{type:b,tag:c,props:{className:[r,s]},children:[]}]},{type:a,value:M}]},{type:a,value:e},{type:b,tag:j,props:{className:[k]},children:[{type:b,tag:l,props:{className:[m,x]},children:[{type:b,tag:n,props:{},children:[{type:a,value:" mysql -u root -p inopack "},{type:b,tag:c,props:{className:[d,o]},children:[{type:a,value:"\u003C"}]},{type:a,value:aa}]}]}]},{type:a,value:e},{type:b,tag:D,props:{},children:[]},{type:a,value:e},{type:b,tag:u,props:{id:N},children:[{type:b,tag:h,props:{href:"#create-database",ariaHidden:p,tabIndex:q},children:[{type:b,tag:c,props:{className:[r,s]},children:[]}]},{type:a,value:O}]},{type:a,value:e},{type:b,tag:j,props:{className:[k]},children:[{type:b,tag:l,props:{className:[m,y]},children:[{type:b,tag:n,props:{},children:[{type:a,value:i},{type:b,tag:c,props:{className:[d,g]},children:[{type:a,value:"create"}]},{type:a,value:i},{type:b,tag:c,props:{className:[d,g]},children:[{type:a,value:ab}]},{type:a,value:ac},{type:b,tag:c,props:{className:[d,f]},children:[{type:a,value:z}]},{type:a,value:e}]}]}]},{type:a,value:e},{type:b,tag:D,props:{},children:[]},{type:a,value:e},{type:b,tag:u,props:{id:P},children:[{type:b,tag:h,props:{href:"#drop-database",ariaHidden:p,tabIndex:q},children:[{type:b,tag:c,props:{className:[r,s]},children:[]}]},{type:a,value:Q}]},{type:a,value:e},{type:b,tag:j,props:{className:[k]},children:[{type:b,tag:l,props:{className:[m,y]},children:[{type:b,tag:n,props:{},children:[{type:b,tag:c,props:{className:[d,g]},children:[{type:a,value:"drop"}]},{type:a,value:i},{type:b,tag:c,props:{className:[d,g]},children:[{type:a,value:ab}]},{type:a,value:ac},{type:b,tag:c,props:{className:[d,f]},children:[{type:a,value:z}]},{type:a,value:e}]}]}]},{type:a,value:e},{type:b,tag:u,props:{id:R},children:[{type:b,tag:h,props:{href:"#list-all-foreign-keys-for-a-table",ariaHidden:p,tabIndex:q},children:[{type:b,tag:c,props:{className:[r,s]},children:[]}]},{type:a,value:S}]},{type:a,value:e},{type:b,tag:j,props:{className:[k]},children:[{type:b,tag:l,props:{className:[m,y]},children:[{type:b,tag:n,props:{},children:[{type:b,tag:c,props:{className:[d,g]},children:[{type:a,value:ad}]},{type:a,value:"\n  TABLE_NAME"},{type:b,tag:c,props:{className:[d,f]},children:[{type:a,value:v}]},{type:a,value:ae},{type:b,tag:c,props:{className:[d,f]},children:[{type:a,value:v}]},{type:a,value:af},{type:b,tag:c,props:{className:[d,f]},children:[{type:a,value:v}]},{type:a,value:ag},{type:b,tag:c,props:{className:[d,f]},children:[{type:a,value:v}]},{type:a,value:ah},{type:b,tag:c,props:{className:[d,g]},children:[{type:a,value:ai}]},{type:a,value:aj},{type:b,tag:c,props:{className:[d,f]},children:[{type:a,value:E}]},{type:a,value:ak},{type:b,tag:c,props:{className:[d,g]},children:[{type:a,value:al}]},{type:a,value:am},{type:b,tag:c,props:{className:[d,o]},children:[{type:a,value:A}]},{type:a,value:i},{type:b,tag:c,props:{className:[d,B]},children:[{type:a,value:an}]},{type:a,value:i},{type:b,tag:c,props:{className:[d,o]},children:[{type:a,value:F}]},{type:a,value:ao},{type:b,tag:c,props:{className:[d,o]},children:[{type:a,value:A}]},{type:a,value:i},{type:b,tag:c,props:{className:[d,B]},children:[{type:a,value:ap}]},{type:b,tag:c,props:{className:[d,f]},children:[{type:a,value:z}]},{type:a,value:e}]}]}]},{type:a,value:e},{type:b,tag:u,props:{id:T},children:[{type:b,tag:h,props:{href:"#list-all-foreign-keys-for-a-column",ariaHidden:p,tabIndex:q},children:[{type:b,tag:c,props:{className:[r,s]},children:[]}]},{type:a,value:U}]},{type:a,value:e},{type:b,tag:j,props:{className:[k]},children:[{type:b,tag:l,props:{className:[m,y]},children:[{type:b,tag:n,props:{},children:[{type:b,tag:c,props:{className:[d,g]},children:[{type:a,value:ad}]},{type:a,value:" \n  TABLE_NAME"},{type:b,tag:c,props:{className:[d,f]},children:[{type:a,value:v}]},{type:a,value:ae},{type:b,tag:c,props:{className:[d,f]},children:[{type:a,value:v}]},{type:a,value:af},{type:b,tag:c,props:{className:[d,f]},children:[{type:a,value:v}]},{type:a,value:ag},{type:b,tag:c,props:{className:[d,f]},children:[{type:a,value:v}]},{type:a,value:ah},{type:b,tag:c,props:{className:[d,g]},children:[{type:a,value:ai}]},{type:a,value:aj},{type:b,tag:c,props:{className:[d,f]},children:[{type:a,value:E}]},{type:a,value:ak},{type:b,tag:c,props:{className:[d,g]},children:[{type:a,value:al}]},{type:a,value:am},{type:b,tag:c,props:{className:[d,o]},children:[{type:a,value:A}]},{type:a,value:i},{type:b,tag:c,props:{className:[d,B]},children:[{type:a,value:an}]},{type:a,value:i},{type:b,tag:c,props:{className:[d,o]},children:[{type:a,value:F}]},{type:a,value:ao},{type:b,tag:c,props:{className:[d,o]},children:[{type:a,value:A}]},{type:a,value:i},{type:b,tag:c,props:{className:[d,B]},children:[{type:a,value:ap}]},{type:a,value:i},{type:b,tag:c,props:{className:[d,o]},children:[{type:a,value:F}]},{type:a,value:"\n  REFERENCED_COLUMN_NAME "},{type:b,tag:c,props:{className:[d,o]},children:[{type:a,value:A}]},{type:a,value:i},{type:b,tag:c,props:{className:[d,B]},children:[{type:a,value:"'\u003Ccolumn\u003E'"}]},{type:b,tag:c,props:{className:[d,f]},children:[{type:a,value:z}]},{type:a,value:e}]}]}]},{type:a,value:e},{type:b,tag:u,props:{id:V},children:[{type:b,tag:h,props:{href:"#drop-column-in-table",ariaHidden:p,tabIndex:q},children:[{type:b,tag:c,props:{className:[r,s]},children:[]}]},{type:a,value:W}]},{type:a,value:e},{type:b,tag:j,props:{className:[k]},children:[{type:b,tag:l,props:{className:[m,y]},children:[{type:b,tag:n,props:{},children:[{type:b,tag:c,props:{className:[d,g]},children:[{type:a,value:"ALTER"}]},{type:a,value:i},{type:b,tag:c,props:{className:[d,g]},children:[{type:a,value:"TABLE"}]},{type:a,value:" table_name\n  "},{type:b,tag:c,props:{className:[d,g]},children:[{type:a,value:"DROP"}]},{type:a,value:i},{type:b,tag:c,props:{className:[d,g]},children:[{type:a,value:"COLUMN"}]},{type:a,value:" column_name"},{type:b,tag:c,props:{className:[d,f]},children:[{type:a,value:z}]},{type:a,value:e}]}]}]},{type:a,value:e},{type:b,tag:u,props:{id:X},children:[{type:b,tag:h,props:{href:"#run-script",ariaHidden:p,tabIndex:q},children:[{type:b,tag:c,props:{className:[r,s]},children:[]}]},{type:a,value:Y}]},{type:a,value:e},{type:b,tag:j,props:{className:[k]},children:[{type:b,tag:l,props:{className:[m,y]},children:[{type:b,tag:n,props:{},children:[{type:a,value:"source D:"},{type:b,tag:c,props:{className:[d,o]},children:[{type:a,value:aq}]},{type:a,value:"Projects"},{type:b,tag:c,props:{className:[d,o]},children:[{type:a,value:aq}]},{type:a,value:"backend"},{type:b,tag:c,props:{className:[d,f]},children:[{type:a,value:E}]},{type:b,tag:c,props:{className:[d,g]},children:[{type:a,value:"sql"}]},{type:b,tag:c,props:{className:[d,f]},children:[{type:a,value:z}]},{type:a,value:e}]}]}]},{type:a,value:e},{type:b,tag:D,props:{},children:[]},{type:a,value:e},{type:b,tag:$,props:{id:Z},children:[{type:b,tag:h,props:{href:"#mac-osx",ariaHidden:p,tabIndex:q},children:[{type:b,tag:c,props:{className:[r,s]},children:[]}]},{type:a,value:_}]},{type:a,value:e},{type:b,tag:u,props:{id:C},children:[{type:b,tag:h,props:{href:"#installment",ariaHidden:p,tabIndex:q},children:[{type:b,tag:c,props:{className:[r,s]},children:[]}]},{type:a,value:C}]},{type:a,value:e},{type:b,tag:w,props:{},children:[{type:a,value:"Uninstall Mysql or any other mysql isntallations"}]},{type:a,value:e},{type:b,tag:w,props:{},children:[{type:b,tag:h,props:{href:"https:\u002F\u002Fgist.github.com\u002Fvitorbritto\u002F0555879fe4414d18569d",rel:[ar,as,at],target:au},children:[{type:a,value:"Uninstall mysql"}]}]},{type:a,value:e},{type:b,tag:w,props:{},children:[{type:a,value:"Brew update"}]},{type:a,value:e},{type:b,tag:j,props:{className:[k]},children:[{type:b,tag:l,props:{className:[m,x]},children:[{type:b,tag:n,props:{},children:[{type:a,value:"brew update\n"}]}]}]},{type:a,value:e},{type:b,tag:w,props:{},children:[{type:a,value:"Brew install"}]},{type:a,value:e},{type:b,tag:j,props:{className:[k]},children:[{type:b,tag:l,props:{className:[m,x]},children:[{type:b,tag:n,props:{},children:[{type:a,value:"brew "},{type:b,tag:c,props:{className:[d,"function"]},children:[{type:a,value:"install"}]},{type:a,value:" mysql\n"}]}]}]},{type:a,value:e},{type:b,tag:w,props:{},children:[{type:a,value:"Start mysql service"}]},{type:a,value:e},{type:b,tag:j,props:{className:[k]},children:[{type:b,tag:l,props:{className:[m,x]},children:[{type:b,tag:n,props:{},children:[{type:a,value:"brew services start mysql\n"}]}]}]},{type:a,value:e},{type:b,tag:w,props:{},children:[{type:a,value:"mysql secure installation"}]},{type:a,value:e},{type:b,tag:j,props:{className:[k]},children:[{type:b,tag:l,props:{className:[m,x]},children:[{type:b,tag:n,props:{},children:[{type:a,value:"mysql_secure_installation\n"}]}]}]},{type:a,value:e},{type:b,tag:w,props:{},children:[{type:a,value:av}]},{type:a,value:e},{type:b,tag:w,props:{},children:[{type:b,tag:h,props:{href:"https:\u002F\u002Fstackoverflow.com\u002Fquestions\u002F9695362\u002Fmacosx-homebrew-mysql-root-password",rel:[ar,as,at],target:au},children:[{type:a,value:av}]}]}]},dir:"\u002Fsnippets",path:"\u002Fsnippets\u002Fmysql",extension:".md",createdAt:aw,updatedAt:aw},prev:ax,next:ax}],fetch:{},mutations:void 0}}("text","element","span","token","\n","punctuation","keyword","a"," ","div","nuxt-content-highlight","pre","line-numbers","code","operator","true",-1,"icon","icon-link",3,"h3",",","p","language-shell","language-sql",";","=","string","installment","br",".","AND","quick-commands",2,"Quick commands","dump-database-into-file","dump database into file","insert-dump-into-database","insert dump into database","create-database","create database","drop-database","drop database","list-all-foreign-keys-for-a-table","list all foreign keys for a table","list-all-foreign-keys-for-a-column","List all foreign keys for a column","drop-column-in-table","Drop column in table","run-script","run script","mac-osx","MAC (OSx)","h2"," backend.sql\n","database"," inopack","SELECT","COLUMN_NAME","CONSTRAINT_NAME"," REFERENCED_TABLE_NAME","REFERENCED_COLUMN_NAME\n","FROM","\n  INFORMATION_SCHEMA","KEY_COLUMN_USAGE\n","WHERE","\n  REFERENCED_TABLE_SCHEMA ","'\u003Cdatabase\u003E'","\n  REFERENCED_TABLE_NAME ","'\u003Ctable\u003E'","\u002F","nofollow","noopener","noreferrer","_blank","Brew fix","2022-04-06T00:56:14.970Z",null)));