how this works?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How mailx -r works?

I'm using Sun Solaris. I used mailx -r "MyEmailId" -s "sub" "toEmailID" from my unix id and it worked. But when i run the same script from other's unix id it works as well. mean any one in my environment can mail to other's email without my knowledge. My questions are How it works and why it...

2. UNIX for Dummies Questions & Answers

How zcat works?

Hi, just i would like to know, how will be the response if you try to read a 40GB compressed file using zcat. a)Uncompress the 40GB file and have it in the disk. use cat to view the steps. b)Use zcat directly to view the compressed file? What are the steps being occurred in step (b)? Where...

3. Shell Programming and Scripting

How does a if works in shell

Hi, I need to compare and get an output for values greater than "X10" (values contain both characters and numbers) using if loop... FOR EG: I want to export values greater than X10, i.e., in-case if the value is X11 and greater than the "if" part to be executed if the value is X9 and...

4. Shell Programming and Scripting

[ask]how does sed -e 's/<[^>]*>//g' works?

I found this command, sed -e 's/<*>//g', will return the content of a line with pattern something like this, <tag1>content</tag1>.. How does this works? What does sed -e 's/<*>//g' actually do? What if I wanted to get content of a line with pattern something like this, content? thanks..

5. UNIX for Advanced & Expert Users

How this works?

I have a program............ #include<stdio.h> #include<unistd.h> main() { if(fork == 0) { printf("Hi every body:p!!!!!!!!!!"); } } This program works with out any error. here fork is not a system call. It just act as a variable.But how it works without declaring it? What data type it...

6. UNIX for Dummies Questions & Answers

>./a.pl works, >a.pl - does not

When I try to execute script, I get message: >aa.pl zsh: command not found: aa.pl but >./aa.pl works OK. What to change in environment to force the former way to work? Thank you, Alex Z

7. Shell Programming and Scripting

Still trying to get a grep -c that works

I am trying to get a count of each line sub runit2 { my ($file1a, $file2a) = @_; my $file1_vala = $file1a->get; my $file2_vala = $file2a->get; open (FILE1a, "$file1_vala") or die; open (FILE2a, "$file2_vala") or die; chomp(my @strings = <FILE2a>); while (1) { foreach $pattern...

8. UNIX for Dummies Questions & Answers

How ls | wc -l works?

ls displays files in tabbed output. Say a directory contains 3 files. ls will list all 3 in one line. So, I expect ls | wc -l to give 1, but it counts the nr of files and gives 3. Can someone explain how this works?

9. Shell Programming and Scripting

Help it works but its to SLOW

I am a novice at shell scripting. I have managed to cobble together a script that does exactly what I need it to do. However I am gathering information from 700+ devices. This script takes hours to complete the task. Is there a better way of doing it than what I have listed here? This script...

10. Linux

How does NORET_TYPE works ?

Hi, I was looking at the panic() code in linux kernel which is defined as: 51 /** 52 * panic - halt the system 53 * @fmt: The text string to print 54 * 55 * Display a message, then perform cleanups. 56 * 57 * This function never returns. 58 */ 59 60 NORET_TYPE void panic(const char *...

LEARN ABOUT DEBIAN

sql::translator::producer::mysql

SQL::Translator::Producer::MySQL(3pm)			User Contributed Perl Documentation		     SQL::Translator::Producer::MySQL(3pm)

NAME

       SQL::Translator::Producer::MySQL - MySQL-specific producer for SQL::Translator

SYNOPSIS

       Use via SQL::Translator:

	 use SQL::Translator;

	 my $t = SQL::Translator->new( parser => '...', producer => 'MySQL', '...' );
	 $t->translate;

DESCRIPTION

       This module will produce text output of the schema suitable for MySQL.  There are still some issues to be worked out with syntax
       differences between MySQL versions 3 and 4 ("SET foreign_key_checks," character sets for fields, etc.).

ARGUMENTS

       This producer takes a single optional producer_arg "mysql_version", which provides the desired version for the target database. By default
       MySQL v3 is assumed, and statements pertaining to any features introduced in later versions (e.g. CREATE VIEW) are not produced.

       Valid version specifiers for "mysql_version" are listed here

   Table Types
       Normally the tables will be created without any explicit table type given and so will use the MySQL default.

       Any tables involved in foreign key constraints automatically get a table type of InnoDB, unless this is overridden by setting the
       "mysql_table_type" extra attribute explicitly on the table.

   Extra attributes.
       The producer recognises the following extra attributes on the Schema objects.

       field.list
	   Set the list of allowed values for Enum fields.

       field.binary, field.unsigned, field.zerofill
	   Set the MySQL field options of the same name.

       field.renamed_from, table.renamed_from
	   Use when producing diffs to indicate that the current table/field has been renamed from the old name as given in the attribute value.

       table.mysql_table_type
	   Set the type of the table e.g. 'InnoDB', 'MyISAM'. This will be automatically set for tables involved in foreign key constraints if it
	   is not already set explicitly. See "Table Types".

	   Please note that the "ENGINE" option is the preferred method of specifying the MySQL storage engine to use, but this method still works
	   for backwards compatibility.

       table.mysql_charset, table.mysql_collate
	   Set the tables default charater set and collation order.

       field.mysql_charset, field.mysql_collate
	   Set the fields charater set and collation order.

SEE ALSO

       SQL::Translator, http://www.mysql.com/.

AUTHORS

       darren chamberlain <darren@cpan.org>, Ken Youens-Clark <kclark@cpan.org>.

perl v5.14.2							    2012-01-18				     SQL::Translator::Producer::MySQL(3pm)

Programming