01-24-2012
What other rows, precisely, would you want from it?
7 More Discussions You Might Find Interesting
1. UNIX and Linux Applications
How would one go about creating 'day' tables based on the timestamp field.
I have some 'import' tables which contains data from various days and would like to spilt that data up into 'days' based on the timestamp field in new tables.
TABLE_IMPORT1
TABLE_IMPORT2
TABLE_IMPORT3
... (2 Replies)
Discussion started by: hazno
2 Replies
2. Web Development
Hi all,
I have 2 mysql databases running on two different servers (both can be accessed via ssh to each other).
If I have say table ABC on server 1, how can I sync it with table ABC on server 2 if the number of records is different? Both databases are the same structure though server 2 has... (2 Replies)
Discussion started by: muay_tb
2 Replies
3. Programming
Hello everybody,
I'm having troubles creating a relation between two tables in a MySQL database.
Having two tables, being one which contains users information (username, password, user ID, etc) and the other the one which contains transactions information (operation type, user ID of the user who... (2 Replies)
Discussion started by: semash!
2 Replies
4. Programming
Hi,
I have 2 tables.
Table1
name map_code data_code id
aaa 2732C 3333B 10
bbb 1223F 2545v 11
ccc 12
Table2
name map_code data_code id text_description
aaa 2732C 3333B 10 description 1
bbb 1223F 2545v 11 ... (3 Replies)
Discussion started by: vanitham
3 Replies
5. Shell Programming and Scripting
Hello all;
I have been really frustrated with finding the correct perl code (and MySql statements) to accomplish what I thought was straight forward...I have tested I don't know how many different codes\suggestions I found on the net without any success...but anyhow let me explain my plight and... (0 Replies)
Discussion started by: gvolpini
0 Replies
6. Shell Programming and Scripting
my queryis :
select distinct m.name, item_count, item from master m join client p on m.name=p.name where item_count = 1 and item > 1;
But how should I update them?
i used update statetment :
Update from client Set item =1 where m.name=p.name and item_count=1 AND item>1
Is this wrong? (1 Reply)
Discussion started by: siya@
1 Replies
7. Shell Programming and Scripting
What I have:
I have a input.sh (script which basically connect to mysql-db and query's multiple tables to write back the output to output1.out file in a directory)
note: I need to pass an integer (unique_id = anything b/w 1- 1000) next to the script everytime I run the script which generates... (3 Replies)
Discussion started by: kkpand
3 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)