What would be useful is, if you could provide a "working example" of the data you have, the files they are in, what data and columns you expect to "grep", and manipulate, what the headings should be, and where that information might come from, and how the result should be presented.
Otherwise, it might take hours, and we'd have to license the answer to you!
Hi, iam learning MySql. Iam trieing to create a table in the database "guestbook"
at the command line in mysql heres what i type but i get a error
mysql>create table guestbook
->(
-> name varchar(40) null.
-> url varchar(40) null.
-> comments ... (3 Replies)
Dear Folks,
If I have 2 files, say A and B in format:
A:
$1 $2
01032 12856
01041 13351
01042 11071
01042 12854
01042 12862
01042 12866
.
.
.
and
B: (2 Replies)
There is table 'DEPT' in the database with the following desciption:
Name Null? Type
------- -------- ------------------------
DEPTNO NOT NULL NUMBER(2)
DNAME NULL VARCHAR2(14)
LOC NULL VARCHAR2(13)
Using shell script, I need to create a structure for the... (2 Replies)
Hi,
I have four input files and would like to create an output file as a table. Please check the example below.
File 1.
111111
222222
333333
444444
File 2.
555555
666666
777777
888888
File 3.
aaaaa
bbbbb
ccccc
ddddd (2 Replies)
Hi
I want create table based on csv file .I have come up with some informations getting columns names and then no idea from that
.Please any help
file.txt
col1|col2|col3|col4|col5
1234|zxxxx|xcvvv|300|null
file.sh
file=$1
c1=`head -1 $file|tr "|" "\n" |cat -n`
echo "$c1"... (31 Replies)
hi there, I am trying to create a stored procedure that i can pass the table name to and it will create a table with that name. but for some reason it creates with what i have defined as the variable name . In the case of the example below it creates a table called 'tname'
for example
... (6 Replies)
I would like to use awk to parse a file with three columns in, like:
Chennai,01,1
Chennai,07,1
Chennai,08,3
Chennai,09,6
Chennai,10,12
Chennai,11,19
Chennai,12,10
Chennai,13,12
Kerala,09,2
AP,10,1
AP,11,1
Delhi,13,1
Kerala,13,3
Chennai,00,3
Chennai,01,1
Chennai,02,1
Chennai,07,5 (3 Replies)
I have a table ABC with 4 columns and below data
Col1,Col2,Col3,Col4
prod,10,12,joba
prod,10,11,jobb
qa,10,12,jobc
I want to create an output file like this
Server:prod
StartTime:10
EndTime:12
JobName:joba
Server:prod
StartTime:10
EndTime:11
JobName:jobb (3 Replies)
Hi,
I required the output like attached:
I tried using the below command and i'm getting error:
file with data:
.TS
box;
cB s s
c|c|c
PO Download statistics - Host to SOM
Time;Receive Time;Processing Time;PO count
4.30 AM OMHPO File;Tue Feb 21 04:39:55 EST 2012;Tue Feb... (3 Replies)
Hi I am trying to create a table within an awk if statement
awk -F, '{ if ($8 ~ /Match/)
BEGIN{print "<table>"} {print "<tr>";for(i=1;i<=NF;i++)print "<td>" $i"</td>";print "</tr>"} END{print "</table>"}' SN1.csv | mailx -s "Your details" abc@123.com
But this doesnt work..
Please suggest (8 Replies)
Discussion started by: sidnow
8 Replies
LEARN ABOUT DEBIAN
alzabo::create::foreignkey
Alzabo::Create::ForeignKey(3pm) User Contributed Perl Documentation Alzabo::Create::ForeignKey(3pm)NAME
Alzabo::Create::ForeignKey - Foreign key objects for schema creation.
SYNOPSIS
use Alzabo::Create::ForeignKey;
DESCRIPTION
A foreign key is an object defined by several properties. It represents a relationship from a column or columns in one table to a column
or columns in another table.
This relationship is defined by its cardinality (one to one, one to many, or many to one) and its dependencies (whether or not table X is
dependent on table Y, and vice versa).
Many to many relationships are not allowed. However, you may indicate such a relationship when using the Alzabo::Create::Schema->add_rela-
tion method method, and it will create the necessary intermediate linking table for you.
INHERITS FROM
"Alzabo::ForeignKey"
Note: all relevant documentation from the superclass has been merged into this document.
METHODS
new
The constructor takes the following parameters:
* columns_from => "Alzabo::Create::Column" object(s)
* columns_to => "Alzabo::Create::Column" object(s)
These two parameters may be either a single column or a reference to an array columns. The number of columns in the two parameters
must match.
* cardinality => [1, 1], [1, 'n'], or ['n', 1]
* from_is_dependent => $boolean
* to_is_dependent => $boolean
* comment => $comment
An optional comment.
It returns a new "Alzabo::Create::ForeignKey" object.
Throws: "Alzabo::Exception::Params"
table_from
table_to
Returns the relevant "Alzabo::Create::Table" object.
columns_from
columns_to
Returns the relevant "Alzabo::Create::Column" object(s) for the property as an array.
column_pairs
Returns an array of array references. The references are to two column array of "Alzabo::Create::Column" objects. These two columns cor-
respond in the tables being linked together.
set_columns_from ("Alzabo::Create::Column" object(s))
Sets the column(s) that the relation is from. This can be either a single column object or a reference to an array of column objects.
Throws: "Alzabo::Exception::Params"
set_columns_to ("Alzabo::Create::Column" object(s))
Sets the column(s) that the relation is to. This can be either a single column object or a reference to an array of column objects.
Throws: "Alzabo::Exception::Params"
cardinality
Returns a two element array containing the two portions of the cardinality of the relationship. Each portion will be either '1' or 'n'.
from_is_dependent
to_is_dependent
Returns a boolean value indicating whether there is a dependency from one table to the other.
is_one_to_one
is_one_to_many
is_many_to_one
Returns a boolean value indicating what kind of relationship the object represents.
set_cardinality (@cardinality) see above for details
Sets the cardinality of the foreign key.
Throws: "Alzabo::Exception::Params"
set_from_is_dependent ($boolean)
Indicates whether or not the first table in the foreign key is dependent on the other (i.e. whether the 'from' table is dependent on the
'to' table).
set_to_is_dependent ($boolean)
Indicates whether or not the second table in the foreign key is dependent on the other (i.e. whether the 'to' table is dependent on the
'from' table).
id
Returns a string uniquely identifying the foreign key.
is_same_relationship_as ($fk)
Given a foreign key object, this returns true if the two objects represent the same relationship. However, the two objects may represent
the same relationship from different table's points of view.
comment
Returns the comment associated with the foreign key object, if any.
set_comment ($comment)
Sets the comment for the foreign key object.
AUTHOR
Dave Rolsky, <autarch@urth.org>
perl v5.8.8 2007-12-23 Alzabo::Create::ForeignKey(3pm)