API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 26th, 2017
100
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 10.67 KB | None | 0 0
raw download clone embed print report
  1. C:\xampp\mysql\bin>mysql --user=root --password=Hoornbeeck12 --database=test; LO
  2. AD DATA INFILE 'C:\xampp\htdocs\testScript\text.txt' INTO TABLE testtable FIELDS
  3.  TERMINATED BY ',' ( ID, voornaam, tussenvoegsel, achternaam, geb_datum, straat,
  4.  nummer, postcode, woonplaats );
  5. mysql  Ver 14.14 Distrib 5.1.41, for Win32 (ia32)
  6. Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
  7. This software comes with ABSOLUTELY NO WARRANTY. This is free software,
  8. and you are welcome to modify and redistribute it under the GPL license
  9. Usage: mysql [OPTIONS] [database]
  10.   -?, --help          Display this help and exit.
  11.   -I, --help          Synonym for -?
  12.   --auto-rehash       Enable automatic rehashing. One doesn't need to use
  13.                      'rehash' to get table and field completion, but startup
  14.                      and reconnecting may take a longer time. Disable with
  15.                      --disable-auto-rehash.
  16.  -A, --no-auto-rehash
  17.                      No automatic rehashing. One has to use 'rehash' to get
  18.                      table and field completion. This gives a quicker start of
  19.                      mysql and disables rehashing on reconnect. WARNING:
  20.                      options deprecated; use --disable-auto-rehash instead.
  21.  -B, --batch         Don't use history file. Disable interactive behavior.
  22.                       (Enables --silent)
  23.   --character-sets-dir=name
  24.                       Directory where character sets are.
  25.   --column-type-info  Display column type information.
  26.   -c, --comments      Preserve comments. Send comments to the server. The
  27.                       default is --skip-comments (discard comments), enable
  28.                       with --comments
  29.   -C, --compress      Use compression in server/client protocol.
  30.   -#, --debug[=#]     This is a non-debug version. Catch this and exit
  31.  --debug-check       Check memory and open file usage at exit.
  32.   -T, --debug-info    Print some debug info at exit.
  33.   -D, --database=name Database to use.
  34.   --default-character-set=name
  35.                       Set the default character set.
  36.   --delimiter=name    Delimiter to be used.
  37.   -e, --execute=name  Execute command and quit. (Disables --force and history
  38.                       file)
  39.   -E, --vertical      Print the output of a query (rows) vertically.
  40.   -f, --force         Continue even if we get an sql error.
  41.   -G, --named-commands
  42.                       Enable named commands. Named commands mean this program's
  43.                      internal commands; see mysql> help . When enabled, the
  44.                      named commands can be used from any line of the query,
  45.                      otherwise only from the first line, before an enter.
  46.                      Disable with --disable-named-commands. This option is
  47.                      disabled by default.
  48.  -g, --no-named-commands
  49.                      Named commands are disabled. Use \* form only, or use
  50.                      named commands only in the beginning of a line ending
  51.                      with a semicolon (;) Since version 10.9 the client now
  52.                      starts with this option ENABLED by default! Disable with
  53.                      '-G'. Long format commands still work from the first
  54.                      line. WARNING: option deprecated; use
  55.                      --disable-named-commands instead.
  56.  -i, --ignore-spaces Ignore space after function names.
  57.  --local-infile      Enable/disable LOAD DATA LOCAL INFILE.
  58.  -b, --no-beep       Turn off beep on error.
  59.  -h, --host=name     Connect to host.
  60.  -H, --html          Produce HTML output.
  61.  -X, --xml           Produce XML output
  62.  --line-numbers      Write line numbers for errors.
  63.  -L, --skip-line-numbers
  64.                      Don't write line number for errors. WARNING: -L is
  65.                       deprecated, use long version of this option instead.
  66.   -n, --unbuffered    Flush buffer after each query.
  67.   --column-names      Write column names in results.
  68.   -N, --skip-column-names
  69.                       Don't write column names in results. WARNING: -N is
  70.                      deprecated, use long version of this options instead.
  71.  -O, --set-variable=name
  72.                      Change the value of a variable. Please note that this
  73.                      option is deprecated; you can set variables directly with
  74.                      --variable-name=value.
  75.  --sigint-ignore     Ignore SIGINT (CTRL-C)
  76.  -o, --one-database  Only update the default database. This is useful for
  77.                      skipping updates to other database in the update log.
  78.  -p, --password[=name]
  79.                      Password to use when connecting to server. If password is
  80.                      not given it's asked from the tty.
  81.   -W, --pipe          Use named pipes to connect to server.
  82.   -P, --port=#        Port number to use for connection or 0 for default to, in
  83.                      order of preference, my.cnf, $MYSQL_TCP_PORT,
  84.                       /etc/services, built-in default (3306).
  85.   --prompt=name       Set the mysql prompt to this value.
  86.   --protocol=name     The protocol of connection (tcp,socket,pipe,memory).
  87.   -q, --quick         Don't cache result, print it row by row. This may slow
  88.                      down the server if the output is suspended. Doesn't use
  89.                       history file.
  90.   -r, --raw           Write fields without conversion. Used with --batch.
  91.   --reconnect         Reconnect if the connection is lost. Disable with
  92.                       --disable-reconnect. This option is enabled by default.
  93.   -s, --silent        Be more silent. Print results with a tab as separator,
  94.                       each row on new line.
  95.   --shared-memory-base-name=name
  96.                       Base name of shared memory.
  97.   -S, --socket=name   Socket file to use for connection.
  98.   --ssl               Enable SSL for connection (automatically enabled with
  99.                       other flags). Disable with --skip-ssl.
  100.   --ssl-ca=name       CA file in PEM format (check OpenSSL docs, implies
  101.                       --ssl).
  102.   --ssl-capath=name   CA directory (check OpenSSL docs, implies --ssl).
  103.   --ssl-cert=name     X509 cert in PEM format (implies --ssl).
  104.   --ssl-cipher=name   SSL cipher to use (implies --ssl).
  105.   --ssl-key=name      X509 key in PEM format (implies --ssl).
  106.   --ssl-verify-server-cert
  107.                       Verify server's "Common Name" in its cert against
  108.                      hostname used when connecting. This option is disabled by
  109.                      default.
  110.  -t, --table         Output in table format.
  111.  --tee=name          Append everything into outfile. See interactive help (\h)
  112.                      also. Does not work in batch mode. Disable with
  113.                      --disable-tee. This option is disabled by default.
  114.  --no-tee            Disable outfile. See interactive help (\h) also. WARNING:
  115.                      option deprecated; use --disable-tee instead
  116.  -u, --user=name     User for login if not current user.
  117.  -U, --safe-updates  Only allow UPDATE and DELETE that uses keys.
  118.  -U, --i-am-a-dummy  Synonym for option --safe-updates, -U.
  119.  -v, --verbose       Write more. (-v -v -v gives the table output format).
  120.  -V, --version       Output version information and exit.
  121.  -w, --wait          Wait and retry if connection is down.
  122.  --connect_timeout=# Number of seconds before connection timeout.
  123.  --max_allowed_packet=#
  124.                      Max packet length to send to, or receive from server
  125.  --net_buffer_length=#
  126.                      Buffer for TCP/IP and socket communication
  127.  --select_limit=#    Automatic limit for SELECT when using --safe-updates
  128.  --max_join_size=#   Automatic limit for rows in a join when using
  129.                      --safe-updates
  130.  --secure-auth       Refuse client connecting to server if it uses old
  131.                      (pre-4.1.1) protocol
  132.  --server-arg=name   Send embedded server this as a parameter.
  133.  --show-warnings     Show warnings after every statement.
  134.  
  135. Default options are read from the following files in the given order:
  136. C:\Windows\my.ini C:\Windows\my.cnf C:\my.ini C:\my.cnf C:\xampp\mysql\my.ini C:
  137. \xampp\mysql\my.cnf
  138. The following groups are read: mysql client
  139. The following options may be given as the first argument:
  140. --print-defaults        Print the program argument list and exit
  141. --no-defaults           Don't read default options from any options file
  142. --defaults-file=#       Only read default options from the given file #
  143. --defaults-extra-file=# Read this file after the global files are read
  144.  
  145. Variables (--variable-name=value)
  146. and boolean options {FALSE|TRUE}  Value (after reading options)
  147. --------------------------------- -----------------------------
  148. auto-rehash                       TRUE
  149. character-sets-dir                (No default value)
  150. column-type-info                  FALSE
  151. comments                          FALSE
  152. compress                          FALSE
  153. debug-check                       FALSE
  154. debug-info                        FALSE
  155. database                          test;
  156. default-character-set             latin1
  157. delimiter                         ;
  158. vertical                          FALSE
  159. force                             FALSE
  160. named-commands                    FALSE
  161. ignore-spaces                     FALSE
  162. local-infile                      FALSE
  163. no-beep                           FALSE
  164. host                              (No default value)
  165. html                              FALSE
  166. xml                               FALSE
  167. line-numbers                      TRUE
  168. unbuffered                        FALSE
  169. column-names                      TRUE
  170. sigint-ignore                     FALSE
  171. port                              0
  172. prompt                            mysql>
  173. quick                             FALSE
  174. raw                               FALSE
  175. reconnect                         TRUE
  176. shared-memory-base-name           (No default value)
  177. socket                            (No default value)
  178. ssl                               FALSE
  179. ssl-ca                            (No default value)
  180. ssl-capath                        (No default value)
  181. ssl-cert                          (No default value)
  182. ssl-cipher                        (No default value)
  183. ssl-key                           (No default value)
  184. ssl-verify-server-cert            FALSE
  185. table                             FALSE
  186. user                              root
  187. safe-updates                      FALSE
  188. i-am-a-dummy                      FALSE
  189. connect_timeout                   0
  190. max_allowed_packet                16777216
  191. net_buffer_length                 16384
  192. select_limit                      1000
  193. max_join_size                     1000000
  194. secure-auth                       FALSE
  195. show-warnings                     FALSE
  196.  
  197. C:\xampp\mysql\bin>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!