Max date in recordset

Hello, i've a table with a lot of field and in particular: InsertDate,Box,Prt Example: InsertDate, Box, PRT 2006-11-01, BXT, 34 2006-11-01, TTS, 33 2006-11-01, RRT, 55 2006-11-02, BXT, 22 2006-11-02, TTS, 99 2006-11-02, SAR, 75 I'd like to find all record inserted in the last day... In this

Re: Mysql Web interface for normal Users

Anthony ha scritto: for root access, i already have phpMyAdmin installed on the server. You can also use phpmyadmin for normal user. In my organization i use it for all users... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Mysql Web interface for normal Users

Vittorio Zuccalà ha scritto: You can also use phpmyadmin for normal user. In my organization i use it for all users... Uff... I didn't remember... If it is not enought you can use Dadabik (www.dadabik.org) It is great: do not be impressed from its simple interface. It is very completed

Last and Last-1

Hi, i've a table in a mysql database. It has a lot of field and three of them are: * A counter: IDTable * A date: DateFaxInsert * A Number: NumberFaxInsert I want to obtain the last and the last - 1 IDTable. If i write: SELECT MAX(IDTable) AS IDMax, DateFaxInsert, NumberFaxInsert FROM

FROM_UNIXTIME(unix_timestamp)

|Hello, i've a mysql table in which a webapplication, written in php, stores a lot of records... One of the table's field is a date and the webapplication uses mktime() to store it as unix timestamp. Now i'd like to use Microsoft Access to access to this table but i'd like to convert unix

Mysql privileges

Hello, ok, you can tell me i'm a crazy boy... I've made a lot of changes to privileges in a mysql server. Then, i saw 2 root account: the first may be able to access from localhost, the second from all hosts. Mysql server is inside our intranet so i decided to drop [EMAIL PROTECTED] Now we

problem on a trigger

Hello, i'm new about triggers... I'm trying to create one trigger: it may insert into a column the user that insert the record... my table- CREATE TABLE `test`.`t2` ( `s1` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `utente` VARCHAR(80) NOT NULL DEFAULT '', PRIMARY KEY(`s1`) ) ENGINE =

manual on stored procedures and triggers

Hello, i'm searching for a manual about stored procedures and triggers. I'm new about this arguments but i want to study them. Unfortunally, mysql online manual is not rich about examples so, can you suggest me some online manuals on stored procedures and triggers? Thank you, Vittorio --

version of mysql

to specify a different version of mysql without install a newer version? I hope i was clear... Thanks in advance for your answers -- vittorio zuccalà Finconsumo Banca SPA [EMAIL PROTECTED] Tel: 011-6319464 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

MysqlCC

Hi, i used MysqlCC for a long time with mysql 4.0 on my remote server... Now i've installed mysql 5.0 on my PC and i'd like to use MysqlCC but it doesn't work. It responds: [localhost] ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL

Access violation in QueryBrowser

Ok, MysqlCC is deprecated. I do not like this decision but... it is the thruth... I'm trying MysqlBrowser. It start connection with my server but it writes in the status bar: Access violation at address 005BC7B4 in module 'MySQLQueryBrowser.exe' Readof address 0 What does it means? It

queue select

- Serp My select has to show: AAA123 BBB111 AAB111 BGF145 Is there a way for it? Thanks!! -- vittorio zuccalà Finconsumo Banca SPA [EMAIL PROTECTED] Tel: 011-6319464 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: remote monitoring of mySQL

...) and i'm very happy about it. -- vittorio zuccalà Finconsumo Banca SPA [EMAIL PROTECTED] Tel: 011-6319464 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Join in two different database

much!! -- vittorio zuccalà Finconsumo Banca SPA [EMAIL PROTECTED] Tel: 011-6319464 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: a tricky join

like. If i've understood your question, you can try this SQL statement: SELECT max( `date` ) AS 'date', sum( `amount` ) AS 'amount' FROM `Prova` WHERE `order` =100 GROUP BY `order` LIMIT 0 , 30 Enjoy and please tell me if it solves your problem... -- vittorio zuccalà Finconsumo Banca SPA [EMAIL