I am using mySQL and have the following table:
ID | MIN | MAX | ORDER
1 1 1 1
2 1 3 1
3 2 1 1
4 1 1 2
I want to get ALL the values bu...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20187980.html
Zones:
DatabasesDate Answered: 09/28/2001 Grade: A Views: 0
I am using CF5.0 and MySQL on NT4. I would like to create a database dynamically using sql commands (which works fine) but I can not connect to it afterwards because I can't set up a DSN connection...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_20428107...
Does MYSQL Support Transactional processing such as in oracle or microsoft sql ? i know that it does 't support stored procedures or triggers, but can you run transactions ???
http://www.experts-exchange.com/Database/MySQL/Q_20716849.html
Zones:
MySQL ServerDate Answered: 10/18/2004 Grade: B Views: 0
hi there, i am trying to use a union sql script, but i cant get it right
i am going to explain the situation first.
i am building an sqlthat will check all the articles in my database and will ...
http://www.experts-exchange.com/Database/MySQL/Q_20881967.html
Zones:
MySQL ServerDate Answered: 02/16/2004 Grade: A Views: 0
Hi all,
Is there an easy way to use SQL to duplicate a row, changing only one column, but keeping the others the same as the original?
for example
Duplicate where id=6, set parent="yes";
...
http://www.experts-exchange.com/Database/MySQL/Q_22069341.html
Zones:
MySQL ServerDate Answered: 11/23/2006 Grade: A Views: 0
Hello.
With some changes within our company, our backend interface is being redone, it is currently a PHP / MySQL system for reporting.
Someone who is helping with a revision of the system, t...
http://www.experts-exchange.com/Database/MySQL/Q_23000544.html
Suppose I have a table called Products with the following fields
ProductID (VARCHAR(20))
Cost (DOUBLE)
and a table called ProductComponents with the following fields
ComponentID (VARCHAR(...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23055985.html
Suppose I have a database with details of several investment portfolios. The Portfolio table has rows identified by a PortfolioID field. The Instruments table lists all the instruments which make u...
http://www.experts-exchange.com/Database/MySQL/Q_23065375.html
Hi,
I have this sql query for my mysql database which I use vb asp to display the data.
I have his query hard coded into the asp page but would like to tidy it up into serveral lines so I can...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23083426.html
I have a list of mac addresses in a table. I want to add a column that is the mac adress +1, but it is hex, so just doing a mac +1 will not work. Any ideas how to code a hexidecimal +1 in?
http://www.experts-exchange.com/Database/MySQL/Q_23094072.html
