Hi,
Maccess helps to analyse data in databases; it is a Web interface to
MySQL server. License is GPL.
Main features:
--
* user friendly query creation for MySQL server
* selective, grouped, and crosstab queries
* various outputs (XML, HTML, TXT, graphs)
* data ungrouping in grouped
Hi!
My problem is when I use group by concat(col1,col2) when col1 and col2
is primary keys and col1 is varchar(255):
SELECT col1,col2 FROM Table1 GROUP BY concat(col1,col2);
- return only one row - it is bad
SELECT col1,col2 FROM Table1 GROUP BY concat(col1,col1,col2);
- return 48 rows - it
Good morning!
Where is mistake?
my $dbh=DBI-connect("DBI:$driver:$database:$hostname",$user,$pass,{AutoCommit=0});
my $sth=$dbh-prepare(q{
insert into
test.Pokus
(a,b)
values
(?,?)
});
foreach my $a ("a","b","c","d") {
$sth-execute($a,$a);
}
$dbh-commit;