I need a help here. My administrator made some changes and we couldn't access some files any more.
I am trying to replace a list of files from one format to another. Can anyone help me please?
Here is an example of
aaa_bbbb_cccccc.03172002_02:30:08
How can I replace the ':' with... (3 Replies)
Hi,
I need to pass a space bar or an enter key in a script for it to return control to my script. How do I do this.
For example the spacebar ascii value is 127, how do I tell the script to run this command. (4 Replies)
I have two files.
Each file has one line with 2500 charaters in it and both lines should be the same, but thay are not.
I need to compare the two lines and find where the differences are. So what I need to do is compare each character one at a time to find out whats different. (4 Replies)
Hi,
I'm trying to insert double quotes right after the third delimiter in a file. Delimiter is ^Z.
For example:
Input:
Oct ^Z 1234 ^Z John ^Z Hello!"
Desired Output:
Oct ^Z 1234 ^Z John ^Z "Hello!"
Any ideas? (1 Reply)
Hi,
I have a No Delimiter variable length text file with following schema -
Column Name Data length
Firstname 5
Lastname 5
age 3
phoneno1 10
phoneno2 10
phoneno3 10
sample data - ... (16 Replies)
Hi,
Extremely new to Perl scripting, but need a quick fix without using TEXT::CSV
I need to read in a file, pass any delimiter as an argument, and convert it to bar delimited on the output. In addition, enclose fields within double quotes in case of any embedded delimiters.
Any help would... (2 Replies)
Hello guys,
I have a problem where I need to add a delimiter, that can be | for example, after each 28000 chars.
The problem is that sometimes 1 row, which should contain 28000 chars is split in 2, so I want to put the delimiter after each 28000 so I will know the end of each row.
Please... (2 Replies)
I would like to hear your directions on how to Insert theses tag </TITLE> and <TEXT> at a given position in 1000 of text files.
My Files look like as
samplefile1.txt
<DOC>
<DOCNO>3_September_2012</DOCNO>
<TITLE>
... ... ... .... ... .. .. .. ... .. .. ....
</TITLE>
<TEXT>
.... (1 Reply)
Hi All,
I wanted a sed/awk command to add a value/character on a particular position without disturbing the position of other characters.
I have file a.txt
OL 10031 Day Black Midi Good Value P01 P07
OL 10031 Day Black Short Good Value P01 P07
I want to get the output as... (2 Replies)
Hi All,
We have a requirement of picking nth position value by using cut command. value would be delimited by any symbols. We have to pass delimited value and postition to get the value in a string.
ex.
echo "A,B,C,D,E" |cut -d "," -f3
echo "A|B|C|D|E"|cut -d "|" -f2
Kindly frame the... (5 Replies)
Discussion started by: KK230689
5 Replies
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)