Quick question about the license issue that I thought of while reading
through the Interbase Vs. MySQL threads.
If I develop a program that uses MySQL for my company and it is only used
for internal use, never repacked and sold/distributed outside the company
what type of license aggrement is that
Ok I'm stumped on what I think should be a somewhat simple query. What I
have so far is a list of names that is in a list of projects AND in a the
main contact list by doing the following query:
SELECT p.name, p.company FROM contacts c, projects p WHERE
CONCAT(c.firstName, " ", c.lastName) = p.name
The biggest problem is if you want to do this from a remote pc, that pc
will need access to the server itself and the mysql client tools. It
sounds as if this pc is not on your LAN and I doubt the hosting service
will be willing to expose there database to the internet so you can do a
backup. If yo
>
> I'm probably going to have to do the alternate technique regardless. =\
>
> On Tuesday, September 10, 2002, at 05:23 PM, Nicholas Stuart wrote:
>
>>> From my experince this is not possible.
>> Is there any reason why you can not simply do two inserts foll
>From my experince this is not possible.
Is there any reason why you can not simply do two inserts following each
other?
INSERT INTO table1(column1) SELECT column1a FROM table2 WHERE [something]
INSERT INTO table1(column2) VALUES(valueFromMemory)
(as if you didnt know that already) =D
There shoul
DB independent? As in an entire list of tables in your MySQL server? Or as
in independent from MySQL to say MS SQL Server? If the later then I'm sure
each db as some form of query to get a list of tables, just look it up. I
don't think there would be a unified way simple because each db is
complet
You would have to do something like:
SELECT * FROM users WHERE CONCAT(firstname, " ", lastname) = "John Smith"
That should get you what you want.
If your taking your DB from MS SQL to MySQL only a few queries will port
directly over. You have to be careful that you follow the MySQL syntax and
func
Hello Richard,
I just went through something similar with upgrading from 3.23.49 to 4.03.
The reason you can't connect to MySQL is
>020908 15:53:33 mysqld ended
This should obviously not be here.
Check the error logs to see if they say anything important and/or helpful
there. Most likely found un
I had this problem to but was never able to find what was causing it. The
way I got around it was by doing execute statements like:
connection.execute("INSERT INTO .")
That way I avoided VB handling the updates and it worked. But since Josh
pointed this little problems "solution" out I might g
simply
be
> high praise for MyODBC, but my Access app has no difficulty at all
talking
> to the database.
>
> Arthur
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "Arthur Fuller" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 28, 2002 1:57
True you could, but then that way you will loose portability if Jon (for
whatever reason) decides to move to another type of DB. Never used
libmySQL so I dont know how the speed is, but assume its as fast if not
faster then ODBC.
ODBC has the plus of being user friendly and of being an M$ Universa
I would strongly urg you not to use Access as the front end. The biggest
problem is that the Jet Engine/Access backend is pretty much completly
different then MySQL and you will run into problems with table structure
and the like. Also, using access as the front end has been extremly slow
when eve
S-SQL = indexs will be used on tables mentioned in the JOIN clause
and they will not in MYSQL
-Original Message-
From: Nicholas Stuart [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:40 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: MS Access and mySQL
I have been there
I have been there done that with old access data, but no forms. Your
plans should be focused around what you know and what your systems are
tied to. Since its an NT box you could go with pretty much any language
ie java/vb/c++. VB would be the obvious choice for ease of transfering
the Access VBA
Heh...ya I knew I fogot to do something. You would think that would be an
install step.
Next task is recompilling the apache httpd as it doesnt like not having
the libmysqlcleint.so.10 file which is now libmysqlcleint.so.11
thx for the tip. =D
-Nick
louie miranda said:
> Add the mysql lib path
First thing I would do is update your mysql. That version is very old and
probably does not support a lot of stuff you are looking for. After that I
would go and download the newest JDBC drivers from:
http://www.mysql.com/downloads/api-jdbc.html
-Nick
marco said:
> Hello everybody
> I'm just
Check out http://www.dbtools.com.br/EN/ I use it to import from access to
mysql. By the sounds of it though you have some dirty data which may or
may not need to be cleaned before going through there program. The only
real problem I had was that working with old dirty data is a pain since a
lot of
Aye, I forgot to mention to lock the db before backing up...my bad. But
again the idea is the same just schedule win2k to do it.
-Nick
Ed Carp said:
>> >> On windows you could simply copy the entire data directory with a
>> Scheduled job. Copying the files should be all you need to do for
>> win
On windows you could simply copy the entire data directory with a
Scheduled job. Copying the files should be all you need to do for windows.
For a cleaner, and what most people would say is a better way you could
schedule a batch file to run mysqldump that would dump the data and
structure to a fi
Thanks, that was simple enough...guess I just couldnt think of that.
Thanks again!
-Nick
Gordon said:
> Try round(value*4,0)/4
> Worked on the samples I tried
>
>> -Original Message-
>> From: Nicholas Stuart [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday,
Ok here's the problem. Trying to write a select statement to be able to
round a set of numbers to the nearest quarter of an inch. Here is what I
have so far:
*-*
SELECT
CONCAT(ROUND(inside_length + (wall_thickness * 2), 0),'\'
Had a wierd problem with my first slave.
Slave 1 has MySQL 4.02 on win 2000
Slave 2 has MySQL 3.23.49(?) or some where arond there on win nt 4
Master has MySQL 3.23.51 on Linux RH 7.2
Slave 2 and master appear to be running with out problems. How ever after
making several table drops to the maste
Hello all. I have been trying to add a second slave to my server but have
come up to a hopefully easy problem. The first slave is up and running
fine, but after copying down the master info to the second slave when I go
to start it it is trying to read the original logs which were/are being
used f
Hello and good morning all! I'm running into a problem when trying to test
mysql on Red Hat Linux. I have the server up and running just fine with no
problems, but when I go to run ./mysql-test-run it spits back the
following.
TEST USER SYSTEM ELAPSEDRESULT
--
There has been some work done on this by the folks at
http://www.icarz.com/mysql/They have a dll that can be used to replace ADO for mysql.
Haven't
personally used it, but they say its faster.-Nick
Efren Pedroza said:
> Maybe I'm goin to ask something stupid, but I've to do it, MySQL++ API
> can
Never got any replies from the list with suggestions from my last post so
I thought I would give another cry for help.To recap:
Master Server - Win NT 4.0 mysql 3.23.49-nt-log dual pII 600
Slave Server - Win 2k mysql 4.0.1-alpha-max-nt p4 2.0
Procedure: Followed the manual to set up the slave mas
26 matches
Mail list logo
