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.
>
>
-
> Before po
Hi,
Search if somebody has the OLEDB driver for MySQL, and
then you will be able to do it.
Bye and Good Luck!
--- "Darrell A. Sullivan, II"
<[EMAIL PROTECTED]> wrote:
> Can anyone tell me if it is possible to connect to a
> MySQL server running on
> Linux from a Windows Visual Basic application
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.
--- Saravana
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,
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 20
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,
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 Master,
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, ca
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 libz.a(shr.
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 th
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 t
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 w
ny) 1 services the three
service type.
Let me know if this is not what you wanted.
Bye and Good Luck.
> So how do we handle these situations
>
> -Arul
> - Original Message -
> From: "Francisco Reinaldo" <[EMAIL PROTECTED]>
> To: "Arul" <[E
>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 Luc
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,
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,
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!
---
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
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
>
>
-
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 i
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 recomend
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 do
I am not sure if I understand your issue, but if the
tables have been updated in the local computer is
because you did not connect to the server. With
mysqlimport you can specify the host (-h), the user
name and password.
I think that you should use something like:
mysqlimport -hMYSERVER -pMYUSE
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 some
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 he
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
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 JD
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 from
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 H
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 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
ent. Sorry!
>
>
> Gary Every
> Sr. UNIX Administrator
> Ingram Entertainment
> (615) 287-4876
> "Pay It Forward"
> mailto:[EMAIL PROTECTED]
> http://accessingram.com
>
>
> -Original Message-
> From: Francisco Reinaldo [mailto:[EMAIL PROTE
rporate Networking Services
> Tel: +27 21 854 7064
> Cell: +27 72 434 7582
>
> - Original Message -
> From: "Francisco Reinaldo" <[EMAIL PROTECTED]>
> To: "Tonu Samuel"
> <[EMAIL PROTECTED]>
> Cc: "MySQL" <[EMAIL P
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 accep
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 re
Hi,
You don't have to pay the license because you are not
distributing MySQL, BUT whoever installs and user your
application and intends to use MySQL will have to
purchase the license because that person it is using
with a commercial application that it is not open
source.
That GPL thing is very
IX 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,
>
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 y
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 y
40 matches
Mail list logo
