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)
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)
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)
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)
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)
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
mysql::diff::database
MySQL::Diff::Database(3pm) User Contributed Perl Documentation MySQL::Diff::Database(3pm)NAME
MySQL::Diff::Database - Database Definition Class
SYNOPSIS
use MySQL::Diff::Database;
my $db = MySQL::Diff::Database->new(%options);
my $source = $db->source_type();
my $summary = $db->summary();
my $name = $db->name();
my @tables = $db->tables();
my $table_def = $db->table_by_name($table);
my @dbs = MySQL::Diff::Database::available_dbs();
DESCRIPTION
Parses a database definition into component parts.
METHODS
Constructor
new( %options )
Instantiate the objects, providing the command line options for database access and process requirements.
Public Methods
o source_type()
Returns 'file' if the data source is a text file, and 'db' if connected directly to a database.
o summary()
Provides a summary of the database.
o name()
Returns the name of the database.
o tables()
Returns a list of tables for the current database.
o table_by_name( $name )
Returns the table definition (see MySQL::Diff::Table) for the given table.
FUNCTIONS
Public Functions
o available_dbs()
Returns a list of the available databases.
Note that is used as a function call, not a method call.
COPYRIGHT AND LICENSE
Copyright (c) 2000-2011 Adam Spiers. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
same terms as Perl itself.
SEE ALSO
mysqldiff, MySQL::Diff, MySQL::Diff::Table, MySQL::Diff::Utils
AUTHOR
Adam Spiers <mysqldiff@adamspiers.org>
perl v5.14.2 2012-04-06 MySQL::Diff::Database(3pm)