Hi,MySQL,
Does MySQL support for IPv6?
Upscene Productions has a Secret Super Sale on
Database Workbench Pro, the database developer IDE.
This is a 75% discount on the normal price, check
for details:
http://www.upscene.com/dbw_secretsupersale.php
Valid for one week only, March the 23rd to 28th.
With regards,
Martijn Tonies
Until recently I have been using 4.0.25 and have just upgraded to 5.1
and just wondered if MySQL now enabled me to store queries in the
database rather than have to put them all on my pages. Basically, I
want to be able to write some select statements and save them in the
database.
Mat,
On Tue, Mar 17, 2009 at 2:04 PM, Matthew Stuart m...@btinternet.com wrote:
Until recently I have been using 4.0.25 and have just upgraded to 5.1 and
just wondered if MySQL now enabled me to store queries in the database
rather than have to put them all on my pages. Basically, I want to be
Until recently I have been using 4.0.25 and have just upgraded to 5.1
and just wondered if MySQL now enabled me to store queries in the
database rather than have to put them all on my pages. Basically, I
want to be able to write some select statements and save them in the
database.
Hi list,
THE IDEA IS TO HAVE A COMMON LOGIN
I have two mysql servers with different databases on each of them.
I want to search each databases(few tables) on both the server using a
single login(mysql connection)
Procedure is working fine.but then i have to use two logins(mysql
connection)
Kishhna,
On Tue, Mar 17, 2009 at 4:13 PM, Krishna Chandra Prajapati
prajapat...@gmail.com wrote:
Hi list,
THE IDEA IS TO HAVE A COMMON LOGIN
I have two mysql servers with different databases on each of them.
I want to search each databases(few tables) on both the server using a
single
Matthew,
wondered if MySQL now enabled me to store queries in the database
In three ways---stored procedures; views; and prepared statements built
from query strings that come from anywhere including your own tables.
PB
http://www.artfulsoftware.com
-
Matthew Stuart wrote:
Until
On Tue, 2009-03-17 at 17:10 +0100, Jon Stephens wrote:
Please don't post off-topic mails to the MySQL Cluster list.
Jon hi, I couldn't see anything that read such posts were not permitted.
That said, I have tried to present the post as clearly and informative
as possible. Hope people agree.
I am writing a tracking procedure that will be inserted into every procedure
(regardless of who writes the procedure) that will insert a record into an
audit table. This means the procedure, regardless of who writes it, must
have the permission to insert into the table. I am going to modify the
3 tables are related by one-many links.
Employees Assets Maintenance
Employees can be assigned = 0 Assets
Assets can have = 0 occurances of Maintenance.
Assets table contains EmployeeIDs and MaintenanceIDs,
but no Foreign Key contraints.
Queries ...
1) which Employees
James,
I'm guessing this is the same position you sent me direct, sorry for not
getting back to you, it slipped my mind. Sadly the location is not
suitable for me.
Can I suggest you post this on the MySQL website in the Jobs Forum? You
should get a good response from there as its a good
On Tue, Mar 17, 2009 at 12:25 PM, j...@camalyn.org j...@camalyn.org wrote:
On Tue, 2009-03-17 at 17:10 +0100, Jon Stephens wrote:
Please don't post off-topic mails to the MySQL Cluster list.
Jon hi, I couldn't see anything that read such posts were not permitted.
That said, I have tried to
On Tue, Mar 17, 2009 at 12:42 PM, BobSharp bobsh...@ntlworld.com wrote:
These have been written successfully with Sub-Queries,
I would like to know how they can be done with only JOINs ?
http://dev.mysql.com/doc/refman/5.0/en/rewriting-subqueries.html
- Perrin
--
MySQL General Mailing List
On Tue, 2009-03-17 at 12:56 -0400, Jujitsu Lizard wrote:
On Tue, Mar 17, 2009 at 12:25 PM, j...@camalyn.org j...@camalyn.org wrote:
On Tue, 2009-03-17 at 17:10 +0100, Jon Stephens wrote:
Please don't post off-topic mails to the MySQL Cluster list.
Jon hi, I couldn't see anything
Massimo,
First, I don't see this is spam, every reply I have seen on the list,
with the exception of those from yourself and another Sun employee,
agree that James post was of benefit to list the members, particularly
in the current economic climate. Surely if list members think the
message is
SELECT Employees.*
FROM Employees LEFT JOIN Assets ON Employess.EmployeeID =
Assets.EmployeeID
WHERE Assets.EmployeeID IS NULL
The one for assets with no maintenance is similar. The point is the left
join above produces in its output all rows from the Employees table
regardless of whether
Thanks for that,worked through and found that this gives the correct
result ...
--- Employee No Assets ---
SELECT DISTINCT e.employeeID AS eID,
concat(e.firstname, , e.lastname) AS eName
FROM employees e LEFT JOIN assets a ON e.employeeID = a.employeeID
WHERE
I'm writing a report tool wherein we have many customers who subscribe
to this SaaS. There are millions of rows of data per customer. All
customers are islands from each other (of course).
Are there any major issues or benefits between storing each customer in
their own database (with their own
Are these databases identical or merely similar? If they are structurally
identical, I'd go for one database per customer. Then you have isolation,
easy structure updates and above all, consistent front-end code, in
whatever language that occurs. Just obtain the customer ID and then use the
20 matches
Mail list logo