| Lines 17-42
          
      
      
        Link Here | 
        
          | 17 |  | 17 |  | 
        
          | 18 |   <refnamediv> | 18 |   <refnamediv> | 
        
          | 19 |     <refname>koha-mysql</refname> | 19 |     <refname>koha-mysql</refname> | 
          
            
              | 20 |     <refpurpose>Provide an interactive mysql shell set up for the specified Koha instance.</refpurpose> | 20 |     <refpurpose>Provide a mysql shell set up for the specified Koha instance.</refpurpose> | 
        
          | 21 |     <refclass>UNIX/Linux</refclass> | 21 |     <refclass>UNIX/Linux</refclass> | 
        
          | 22 |   </refnamediv> | 22 |   </refnamediv> | 
        
          | 23 |  | 23 |  | 
        
          | 24 |   <refsynopsisdiv> | 24 |   <refsynopsisdiv> | 
        
          | 25 |     <cmdsynopsis> | 25 |     <cmdsynopsis> | 
          
            
              | 26 |       <command>koha-mysql</command> <arg choice="req" rep="norepeat"><replaceable>instancename</replaceable></arg> | 26 |       <command>koha-mysql</command> <arg choice="req" rep="norepeat"><replaceable>instancename</replaceable></arg> <arg choice="opt" rep="repeat">mysql option</arg> | 
        
          | 27 |     </cmdsynopsis> | 27 |     </cmdsynopsis> | 
        
          | 28 |   </refsynopsisdiv> | 28 |   </refsynopsisdiv> | 
        
          | 29 |  | 29 |  | 
        
          | 30 |   <refsect1><title>Description</title> | 30 |   <refsect1><title>Description</title> | 
          
            
              | 31 |   <para>Provide an interactive mysql shell set up for the specified Koha instance.</para> | 31 |   <para>Provide a mysql shell set up for the specified Koha instance.</para> | 
        
          | 32 |   </refsect1> | 32 |   </refsect1> | 
        
          | 33 |  | 33 |  | 
        
          | 34 |   <refsect1><title>Example usage</title> | 34 |   <refsect1><title>Example usage</title> | 
        
          | 35 |     <variablelist> | 35 |     <variablelist> | 
        
          | 36 |       <varlistentry> | 36 |       <varlistentry> | 
          
            
              | 37 |         <term>Send an SQL query to MySQL</term> | 37 |         <term>Run interactive mysql shell for speicified Koha instance</term> | 
        
          | 38 |         <listitem> | 38 |         <listitem> | 
          
            
              | 39 |           <para>"Some SQL query" | <command>koha-mysql</command> <arg choice="req" rep="norepeat"><replaceable>instancename</replaceable></arg></para> | 39 |           <para><command>koha-mysql</command> <arg choice="req" rep="norepeat"><replaceable>instancename</replaceable></arg></para> | 
            
              |  |  | 40 |         </listitem> | 
            
              | 41 |       </varlistentry> | 
            
              | 42 |       <varlistentry> | 
            
              | 43 |         <term>Run a query given as an argument without launching mysql shell</term> | 
            
              | 44 |         <listitem> | 
            
              | 45 |           <para><command>koha-mysql</command> <arg choice="req" rep="norepeat"><replaceable>instancename</replaceable></arg> -e "SOME SQL QUERY"</para> | 
            
              | 46 |         </listitem> | 
            
              | 47 |       </varlistentry> | 
            
              | 48 |       <varlistentry> | 
            
              | 49 |         <term>Run a query, skip column names on output</term> | 
            
              | 50 |         <listitem> | 
            
              | 51 |           <para><command>koha-mysql</command> <arg choice="req" rep="norepeat"><replaceable>instancename</replaceable></arg> -e "SOME SQL QUERY" --skip-column-names</para> | 
        
          | 40 |         </listitem> | 52 |         </listitem> | 
        
          | 41 |       </varlistentry> | 53 |       </varlistentry> | 
        
          | 42 |       <varlistentry> | 54 |       <varlistentry> | 
  
    | Lines 50-55
          
      
      
        Link Here | 
        
          | 50 |    | 62 |    | 
        
          | 51 |   <refsect1><title>See also</title> | 63 |   <refsect1><title>See also</title> | 
        
          | 52 |   <simplelist type="inline"> | 64 |   <simplelist type="inline"> | 
            
              |  |  | 65 |     <member><command>mysql (1)</command></member> | 
        
          | 53 |     <member><command>koha-dump-defaults(8)</command></member> | 66 |     <member><command>koha-dump-defaults(8)</command></member> | 
        
          | 54 |     <member><command>koha-reset-passwd(8)</command></member> | 67 |     <member><command>koha-reset-passwd(8)</command></member> | 
        
          | 55 |     <member><command>koha-upgrade-schema(8)</command></member> | 68 |     <member><command>koha-upgrade-schema(8)</command></member> | 
            
              | 56 | -  |  |  |