Hi,
I recomend you to use the pre-compiles binary
distribution. You won't have to build it and it worked
for me.
This is the link for the Intel platform:
http://www.mysql.com/downloads/download.php?file=Downloads/MySQL-3.23/mysql-3.23.51-pc-linux-gnu-i686.tar.gz
Bye and Good Luck.
---
mysqlsms.sql
Also if you are inside the application
mysqlsource sms.sql
Bye and Good Luck!
--- Scott Pippin [EMAIL PROTECTED] wrote:
I need to run a file called sms.sql from the command
line. Is this
possible and what is the syntax?
Thanks in advance.
Hi,
I wanted to summarize my problem again so if somebody
had the same issue can help me.
O.S. IBM AIX 4.3.3
MySQL Binary Distribution: 3.23.46
When I run ./scripts/mysql_install_db, I got this
error:
exec(): 0509-036 Cannot load program ./bin/mysqld
because of the following errors:
0509-150
Hi,
Are you sure that is trying to access the internet. It
may be trying to open the port, remember that MySQL
needs 3306 (by default) to communicate with the
server.
I think if you just open that port, everything will be
ok.
Bye and Good Luck.
--- Matthew K. Gold [EMAIL PROTECTED] wrote:
Hi,
Hi,
Change the alias to date_format(date,'%D %M %Y') AS
mydate, so you are sure that you sort by the date
field not my the formatted date. Be aware that if you
sort my the formatted string, MySql is going to treat
it as a string and therefore sort it as a string.
11th July 2002 2st July 2002
Hello Nitesh,
You can find that and more at...
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
Good Luck,
--- Nitesh Divecha [EMAIL PROTECTED] wrote:
Hello All,
I need help with tables. I have created my table
with some attributes in
it.
I need to modify my table attributes, can any
Hi,
Use LEFT JOIN instead of =. In a 1:m relationship,
only records that match in both tables are selected.
With L.J., the master is always selected even if the
record is not present in the child.
Master
Id
1
2
3
4
5
Children
FK_id Value
1 V1
1 V2
2 V3
Select id, value from
Victoria,
I am using mysql-3.23.49-ibm-aix4.3.3.0-rs6000.tar.gz,
which is the latest version posted on your site.
Also, when I try to compile mysql-3.23.51.tar.gz, I
get the following error executing the make command:
my_gethostbyname.c, line 81.5: 1506-068 (S)
Operation between types struct
Hi,
When I try to execute scripts/mysql_install_db, I get
some errors about some libraries missing:
exec(): 0509-036 Cannot load program
./bin/my_print_defaults because of the following
errors:
0509-150 Dependent module libz.a(shr.o) could not be
loaded.
0509-022 Cannot load module
Hi,
Use LEFT JOIN instead =
Bye and Good Luck!
--- Mark Colvin [EMAIL PROTECTED] wrote:
I want to select from three tables where there may
or may not be a record in
the third table. Table 1 and 2 have a one to one
relationship and table 1
and 2 both have a one to many relationship with
Hi,
If you mean how to connect to a MySQL server from a
remote machine in a local network, you only need to
include the computer (or ip address) of the server in
the HOSTNAME. You also have to make sure that the user
in the connection string, has permission to access the
database, you should go
Hi,
Mailing list: http://lists.mysql.com/
Joining three tables could be something like this.
Select * from t1 INNER JOIN t2 ON t1.id = t2.id INNER
JOIN t3 ON t2.id = t3.id
I highly recomend you to read some basic SQL books
before you carry on with your project. Trial and error
is not always
From MySQL manual:
http://www.mysql.com/doc/M/o/Moving.html
http://www.mysql.com/doc/U/p/Upgrading-to-arch.html
I have tried and it works in HP-Solaris and LINUX, but
I tend to agree with Cal, my recomendation is to use
an alternative procedure such as dumping and
importing.
Bye and Good
these situations
-Arul
- Original Message -
From: Francisco Reinaldo [EMAIL PROTECTED]
To: Arul [EMAIL PROTECTED]; MySQL
[EMAIL PROTECTED]
Cc: Arul [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 3:27 AM
Subject: Re: help me with this query
Hi,
Select companyid, count
Hi,
This is not related with your issue but if you want to
do serious development, don't use Windows 98 in any of
its versions. It is going to give a lot of problems.
Bye and Good Luck.
--- Matthew Scarrow [EMAIL PROTECTED] wrote:
I've built a whole program with vb6 and mysql
database back
Hi,
Select companyid, count(*) from CompanyServices where
serviceid = 1 or serviceid = 2 or serviceid = 3
group by companyid
having count(*) = 3
Bye and Good Luck.
--- Arul [EMAIL PROTECTED] wrote:
Hi All
The Table design goes like this
Company Table
companyid
Hi,
Sorry but MySQL does not support subqueries yet.
Bye and Good Luck!
--- Narcis GRATIANU [EMAIL PROTECTED]
wrote:
When I try this:
SELECT article, dealer, price
FROM shop s1
WHERE price=(SELECT MAX(s2.price)
FROM shop s2
WHERE s1.article =
Hi,
Since subqueries are not allowed in MySQL, this is
what I would do:
Create a temporary table with the id's containing
multiple dates.
Inner join your table with the temporary table.
Even if MySQL allowed subqueries, this is what will
probably happen behind the scene.
Bye and Good Luck!
No1.
Sounds like a permission problem. Make sure that you
have that domain in the list of computer allowed to
connect to MySQL. Refer to MySQL manual to get more
information about this.
No2.
PC based application won't run on Linux unless you run
them under an PC-emulator which I don't even know
Dough! They started behaving like big corporations
already; certification, consulting, etc, etc.
:-)
--- Defryn, Guy [EMAIL PROTECTED] wrote:
I was wondering if anybody heard about a possible
release of books that help you prepare for the Mysql
certification?
Cheers
Hi,
These tools are not open source:
http://www.thekompany.com/products/dataarchitect/
You can download the evaluation. It supports MySQL
directly:
http://www.datanamic.com/download/download_dezign.html
If you are not familiar with database methodology and
relation entity diagrams, I
Hi Miles,
Could you explain the same thing with a some sample
data? I does not need to be your data. I think that
what you want to do is this but I am not sure.
Field1 Field2
A 1
A 1
A 2
A 3
B 1
B 1
B 2
C 2
C 2
C 4
C 4
When you say last
Some database providers implementation always return
-1 no matter the amount of records is returned. That
happens to ADO too for certain cursors. The best way
to go to count records is Count(*), prepare a query
like Select count(MyField) from MyTable Where ... and
then get the value.
I hope it
If I remember correctly from the manual, you can dump
your data generating the SQL statements (this is what
you are doing) and your file will have a bunch of
INSERTS. Your problem is that those inserts will have
something like SET YourBinaryField =
'a-bunch-of-characters'. The problem is that
Which driver are you using? I use
mm.mysql-2.0.4-bin.jar
Which IDE are you using? If you are using JBuilder 5,
you have to go to required library and add one
pointing to that file. If you are building a jar file
from your classes, you have to make sure that you tell
the library to include this
Hola Javier,
It is difficult to tell because you did not include
the table structures, relationships, indices, etc.
But... at a first glance we is killing you query
anyways is this:
FROM
Bill b, Hour h
The poor db engine is probably creating a huge
temporary table with all
Why don't you try to download MySQL from
www.mysql.com? Maybe your CD-copy is corrupted.
Good luck!
--- Dean Harding [EMAIL PROTECTED] wrote:
It sure does work on XP. I'm using it right now...
What error does it give, or if no errors, what
happens when you try to
run it?
Dean Harding.
How are you connecting to MySQL?, through MySQL ODBC I
am assuming. I might happen that the ODBC driver for
MySQL does not implement ADOX functionality.
Have you tried to take a look to the MySQL++ API? You
might have to create your own dll (or COM component)
to modify the database structure
Hi,
I would not rely on the insertion order if I were
you. Honestly, I don't know how MySQL deals with it
but servers such as Microsoft SQL Server or even
Access won't provide a deterministic order unless you
sort using sort by.
I recomend you to use sort by anyways if you need the
result sets
Well, that would depend if the SQL script generated by
your designer is compatible with MySQL, some type
names may be different.
Good Luck!
--- [EMAIL PROTECTED] wrote:
I generated an SQL script of my datamodel in
PowerDesigner which I'd like
to import into mySql to create my tables, keys,
Hi,
I've been able to connect from an Windows XP to a HP
Solaris and LINUX. Make sure that you can ping the
UNIX computer from yours. Then replace the computer
name in the connection string (most of the time is
localhost) for the UNIX computer's ip address (you can
use the name if you have DNS
Hi Chris,
I am Tom, you know your manager, did you say that I am
wrong!!!
Just kidding :-).
Well I cannot find any good reason for having two
databases in two different instance. Do you have two
Oracles or Microsoft SQL Server instances in the
computer? Nope.
The only reason when that is
434 7582
- Original Message -
From: Francisco Reinaldo [EMAIL PROTECTED]
To: Tonu Samuel
[EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 12:14 AM
Subject: Re: table is read only when DB copied from
Win to UNIX
Thanks for the tip but I have added
Hi,
I have an installation of MySQL in Windows and another
one in UNIX Solaris 2.7. I need to move the databases
across system and I have manually ftped a database
directory from the Windows MySQL to the UNIX MySQL.
Fine, I can see the database, show tables works,
selects works. The whole nine
Hi,
I have an installation of MySQL in Windows and another
one in UNIX Solaris 2.7. I need to move the databases
across system and I have manually ftped a database
directory from the Windows MySQL to the UNIX MySQL.
Fine, I can see the database, show tables works,
selects works. The whole nine
to Windows.
I'll keep trying though but if somebody already knows
the solution, please let me know.
Thanks.
--- Tonu Samuel
[EMAIL PROTECTED] wrote:
On Wed, 12 Jun 2002, Francisco Reinaldo wrote:
Fine, I can see the database, show tables works,
selects works. The whole nine yards? Nope! I
36 matches
Mail list logo