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)
How do I write a perl script to get the cron jobs? I could do a
perl -e ' system "crontab -l > jobs.txt " ';
Is there a better way?
Then I can use perl to make changes to jobs.txt. How can I submit the changes.
I suppose I could use system "crontab jobs.txt", is there a better way?
... (0 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)
Hi pls help me out to short out this problem
rm PAB113_011.out
rm: PAB113_011.out: override protection 644 (yes/no)? n
If i give y it remove the file.
But i added the rm command as a part of ksh file and i tried to remove the file. Its not removing and the the file prompting as... (7 Replies)
how can i automatically create a file on Linux? like a process that searches for the file and if the file does not exist, it automatically makes the file (3 Replies)
I need to extract the data from oracle table and written the below code.
But it is not working.There is some problem with the query and output is shown is No rows selected" . If I run the same query from sql developer there is my required output.
And if I run the shell script with simple sql... (7 Replies)
I feel stupid for asking this because it seems that MYSQL code isn't working the way that I think it should work.
Basically I wrote code like this:
select * from `Test_DC_Trailer` HAVING max(DR_RefKey);
Where the DR_RefKey is a unique numeric field that is auto iterated (like a primary key)... (7 Replies)
Hi ,
I need to filter input file according to following
All rows with the following conditions should be removed
1) If in a row, the number of 'N's starting col 2 exceeds 2 (3 or more)
OR
2) If a row is duplicated with the same value, starting col 2,
A value 'N' is considered missing... (1 Reply)
Dear All,
I am trying to write a Unix Script which fires a sql query. The output of the sql query gives multiple rows. Each row should be saved in a separate Unix File.
The number of rows of sql output can be variable. I am able save all the rows in one file but in separate files.
Any... (14 Replies)
Hello
I've four fields . They are First Name, Last Name, Age, Country. So when I run a Unix command, I get below output with these fields comes every time in different order as you can see. Some times first name is the first row and other time last name is first row in the output and etc etc..... (9 Replies)
Discussion started by: rprpr
9 Replies
LEARN ABOUT DEBIAN
poe::component::irc::plugin::isupport
POE::Component::IRC::Plugin::ISupport(3pm) User Contributed Perl Documentation POE::Component::IRC::Plugin::ISupport(3pm)NAME
POE::Component::IRC::Plugin::ISupport - A PoCo-IRC plugin that handles server capabilities
DESCRIPTION
This handles the "irc_005" messages that come from the server. They define the capabilities support by the server.
METHODS
"new"
Takes no arguments.
Returns a plugin object suitable for feeding to POE::Component::IRC's "plugin_add" method.
"isupport"
Takes one argument. the server capability to query. Returns a false value on failure or a value representing the applicable capability. A
full list of capabilities is available at <http://www.irc.org/tech_docs/005.html>.
"isupport_dump_keys"
Takes no arguments, returns a list of the available server capabilities, which can be used with "isupport".
INPUT
This module handles the following PoCo-IRC signals:
"irc_005" (RPL_ISUPPORT or RPL_PROTOCTL)
Denotes the capabilities of the server.
"all"
Once the next signal is received that is greater than "irc_005", it emits an "irc_isupport" signal.
OUTPUT EVENTS
"irc_isupport"
Emitted by: the first signal received after "irc_005"
"ARG0" will be the plugin object itself for ease of use.
This is emitted when the support report has finished.
AUTHOR
Jeff "japhy" Pinyan, japhy@perlmonk.org
SEE ALSO
POE::Component::IRC
POE::Component::IRC::Plugin
perl v5.14.2 2011-12-07 POE::Component::IRC::Plugin::ISupport(3pm)