http://php-mysql.devsitehosting.com PHP and MySQL Web Development Fri, 01 Jun 2007 14:46:24 +0000 http://backend.userland.com/rss092 en Postprocess mysql's output. 1.23.3 Discussion In non-interactive mode, mysql separates output columns with tabs and there is no option for specifying the output delimiter. Under some circumstances, it may be desirable to produce output that uses a different delimiter. Suppose you want to create an ... http://php-mysql.devsitehosting.com/2007/06/01/postprocess-mysqls-output-1233-discussion-in-non-interactive-mode/ % mysql cookbook > outputfile However, if you try to run mysql interactively with the output redirected, you won't be able to see what you're typing, so generally in this case you'll also take query input from a file (or another program): % ... http://php-mysql.devsitehosting.com/2007/05/31/mysql-cookbook-outputfile-however-if-you/ Redirect mysql's output or use a pipe. 1.21.3 Discussion mysql chooses its default output format according to whether you run it interactively or non- interactively. Under interactive use, mysql normally sends its output to the terminal and writes query results using tabular format: ... http://php-mysql.devsitehosting.com/2007/05/31/redirect-mysqls-output-or-use-a-pipe-1213/ [6] The --pager option is not available under Windows. % mysql --pager=/usr/bin/less --pager by itself tells mysql to use your default pager, as specified in your PAGER environment variable: % mysql --pager If your PAGER variable isn't set, you must ... http://php-mysql.devsitehosting.com/2007/05/30/6-the-pager-option-is-not-available-under/ +----------+ +---------------------+ | NOW( ) | +---------------------+ | 2001-07-04 10:42:22 | +---------------------+ 1.18.4 See Also By default, results generated by queries that are specified with -e are displayed in tabular format if output goes to the terminal, and in tab-delimited ... http://php-mysql.devsitehosting.com/2007/05/30/now/ produces output consisting of semicolon-terminated SQL statements can be used as an input source for mysql. This can be useful in many ways. For example, the mysqldump utility is used to generate database backups. It writes a backup as a set of SQL statements that recreate the ... http://php-mysql.devsitehosting.com/2007/05/30/produces-output-consisting-of-semicolon-terminated-sql-statements-can/ Then create a script file loop.sql that contains the following lines (be sure each line ends with a semicolon): UPDATE counter SET depth = depth + 1; SELECT depth FROM counter; SOURCE loop.sql; Finally, invoke mysql and issue a SOURCE command to ... http://php-mysql.devsitehosting.com/2007/05/29/then-create-a-script-file-loopsql-that-contains/ INSERT INTO limbs (thing,legs,arms) VALUES('tripod',3,0); INSERT INTO limbs (thing,legs,arms) VALUES('Peg Leg Pete',1,2); INSERT INTO limbs (thing,legs,arms) VALUES('space alien',NULL,NULL); To execute the statements in this SQL script file in batch mode, change directory into the tables directory of the recipes distribution where the table-creation ... http://php-mysql.devsitehosting.com/2007/05/29/insert-into-limbs-thinglegsarms-valuestripod30-insert-into-limbs/ By default, the mysql program reads input interactively from the terminal, but you can feed it queries in batch mode using other input sources such as a file, another program, or the command arguments. You can also use copy and paste as a source of query input. This ... http://php-mysql.devsitehosting.com/2007/05/28/by-default-the-mysql-program-reads-input-interactively/ +--------+ To set a variable explicitly to a particular value, use a SET statement. SET syntax uses = rather than := to assign the value: mysql> SET @sum = 4 + 7; mysql> SELECT @sum; +------+ | @sum | ... http://php-mysql.devsitehosting.com/2007/05/28/to-set-a-variable-explicitly-to-a/