Here's how I do it with tables that have multiple keys:
CREATE TABLE Users
(
Id SMALLINT UNSIGNED UNIQUE NOT NULL AUTO_INCREMENT,
FirstName VARCHAR(25) NOT NULL,
LastName VARCHAR(25) NOT NULL,
PRIMARY KEY(Id),
KEY LastNameIndex (LastName),
Key Firs
On Sat, 2003-09-13 at 02:50, delz wrote:
> I want to know how do I use computations on dates in php or mysql like for
> example, today is September 13, 2003 (2003-09-13) and I want to get the date
> output if I add 5 days from the given date so that my output would be
> September 18, 2003 (2003-0
The way I do it is to call mysqldump.exe from perl, granted it's not the most elegant
way but it's certainly the fastest (to code). Just do:
---
# name or IP address of dbmachine
my $DB_server = localhost.localdomain.tld
# db login authorised to do db dump
my $DB_User = sa
# location and name
Hi,
I've been using MySQL intercompany for a while now with great results. Even
the diehard MSSQL people are amazed at how fast it can be at time. One of the things
I use it for is to store syslog events in it. I wrote a backend that parses a syslog
file as data is being written into
or me :) but MySQL complains. Is it possible to do nested
queries with MySQL ? Does anyone have a better way of displaying the last x amount of
rows inserted into a table ? Thanks in advance...
-Pete
Peter Vertes
Beast Financial Systems
404 Fifth Avenue
New York, NY
I've never connected your way before. I'm using J/Connector from the MySQL site
(http://www.mysql.com/downloads/api-jdbc-stable.html). That way I have no problems
connecting. I do it this way:
// connect to the database
Class.forName("com.mysql.jdbc.Driver");
Connection dbConnection =
Drive
