Hi All,
I need to execute the mysql command "source
c:/Test.sql" through Java. how can i do it?
I tried with to use the following methods of the
Statement interface:-
execute(String sql),
executeQuery(String sql)
executeUpdate(String sql)
where String sql = "source c:/Test.sql";
But it generat
Hi Vincent,
two "lazy" solutions :)
1) create symbolic links to all binaries in /usr/local/mysql/bin with a
script.
#!/bin/sh
cd /usr/local/bin
for FILE in `ls /usr/local/mysql/bin`
do
ln -s $FILE `basename $FILE`
done
2) add /usr/local/mysql/bin to your path.
Fraser
___
At 22:45 -0800 12/17/02, Amit Lonkar wrote:
Hi All!
I want to execute the Mysql command "source
c:/Test.sql" through java.
That doesn't make sense. "source" is one of the internal
commands understood by the mysql client program. It's
not a SQL statement that you can execute though the JDBC
in
Hi All!
I want to execute the Mysql command "source
c:/Test.sql" through java.
Which method of the statement interface should I use.
I tried all the three below but they generate an SQL
Exception as :-
"You have an error in your SQL syntax near 'source
c:/netapsv1/tempfiles/Test.sql' at line 1"
If your three php vars are p1, p2, p3 and the three cols are f1, f2, f3,
don't you just need ...
SELECT ...
WHERE f11 IN ( p1, p2, p3 )
OR f2 IN ( p1, p2, p3 )
OR f3 IN ( p1, p2, p3 )
PB
-
> I have an enigma that I just can't seem to resolve.
>
> ==
>
Bill Lovett wrote:
Hello,
You're getting all new boats + all sail boats + all boats of type x
because you're using ORs. If you only want records that match all the
criteria, use ANDs instead.
If I use AND, wouldn't all conditions need to be true to return a
result? In the case of the sear
On Tue, 17 Dec 2002 19:15:08 +0100, Serrand Patrice wrote:
>Does MySQL automatically create index on primary key ?
Yes. See http://www.mysql.com/doc/en/CREATE_TABLE.html
- Steve Yates
- Antonym: The opposite of the word you're searching for.
~ Taglines by Taglinator - www.srtware.com ~
---
On Wed, 18 Dec 2002 22:54:53 -0500, C. Reeve wrote:
>while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
>$num1 = $line['number'];
>}
Loop through the result and return the value from the last row?
Did you want "select sum(number) as SubTotal1 from table1 where
userid=$user1
On Wed, Dec 18, 2002 at 11:55:32AM -0500, Muruganandam wrote:
> Dear Jeremy,
> Can you end me the hardware details of your DB Engine server...
The hardware is about 2 years old now. The master is a dual P3 866
with 2GB RAM and 6 36GB SCSI disks. Some of the slaves are a little
faster (dual P3 1
Success. Thanks. I could have sworn I installed the package before but I was
filing to give the whole path to mysql in the command line. So I deinstalled
it and installed the one off of the Golive CD. I'm glad you were familiar
with mac os x. I'm running this on the dual 1.25 G4.
On 12/18/02 12:4
Dear Jeremy,
Can you end me the hardware details of your DB Engine server...
thanks.
muruganandam g
Jeremy Zawodny wrote:
> rOn Tue, Dec 17, 2002 at 08:43:38PM -0800, Qunfeng Dong wrote:
>
> > I am not sure. Does anyone know any real examples of mysql handling
> > huge database and still perform
At 0:35 -0500 12/18/02, Gary Hostetler wrote:
You're good. It is mac osx, which I was afraid would get me more errors than
straight linux.
I had this problem running a version of MySQL compiled for Mac OS X 10.1.5
after I upgraded to Jaguar (10.2), so perhaps you've simply installed a
distributi
You're good. It is mac osx, which I was afraid would get me more errors than
straight linux.
On 12/18/02 12:33 AM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
> At 0:32 -0500 12/18/02, Gary Hostetler wrote:
>> When I type ./mysql I get the following:
>>
>> dyld: ./mysql Undefined symbols:
>> ./mysq
At 0:32 -0500 12/18/02, Gary Hostetler wrote:
When I type ./mysql I get the following:
dyld: ./mysql Undefined symbols:
./mysql undefined reference to _BC expected to be defined in
/usr/lib/libSystem.B.dylib
./mysql undefined reference to _PC expected to be defined in
/usr/lib/libSystem.B.dylib
.
When I type ./mysql I get the following:
dyld: ./mysql Undefined symbols:
./mysql undefined reference to _BC expected to be defined in
/usr/lib/libSystem.B.dylib
./mysql undefined reference to _PC expected to be defined in
/usr/lib/libSystem.B.dylib
./mysql undefined reference to _UP expected to b
A good question posted to another list..
forwarded message follows
> Several vulnerabilities have been found in the MySQL database system, a
> light database package commonly used in Linux environments but which runs
> also on Microsoft platforms, HP-Unix, Mac OS and more.
> http://zdne
rOn Tue, Dec 17, 2002 at 08:43:38PM -0800, Qunfeng Dong wrote:
> I am not sure. Does anyone know any real examples of mysql handling
> huge database and still perform well?
Our largest table is about 340 million rows now. It grows by roughly
100,000 records per business day. Performance is quit
At 23:33 -0500 12/17/02, Gary Hostetler wrote:
I just installed mysql but I get the command not found when I type mysql. I
am in the bin directory. Anyone know what is going on here?
Does it work in that directory if you type:
./mysql
If it does, then that's your clue. :-)
Thanks
Gary
Hi!
I have an enigma that I just can't seem to resolve.
==
What is Hoped For:
I have 3 variables (called F1, F2 and F3) which will contain either an
integers (a pointer to a "feeback" item in another table, actually) and a
database of questions, each having an F1, F2 and F3, any o
I've read limits are based on the filesize your OS can handle,
the HDD size, memory, how fast your RISC
or CISC processors are...and how the stars are aligned...
i think 4 billion records will need some horses pullin...
8 x 2.4 XEON/2 at least. I've run simple queries on
80 million records and it
I am not sure. Does anyone know any real examples of
mysql handling huge database and still perform well? I
am having problems with the performance with the MySQL
Left join recently. A big table (about 2.5 million
records) left join a small table (about 350K records)
takes generally 2 mins to finis
do this at the prompt...
echo $PATH
whereis mysql
and compare the results.
when in the bin directory type ./mysql as root... without ./ the shell
wont find it...
Jim
-Original Message-
From: Gary Hostetler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 17, 2002 8:33 PM
To: [EMAIL P
Hello,
You're getting all new boats + all sail boats + all boats of type x
because you're using ORs. If you only want records that match all the
criteria, use ANDs instead.
SELECT * FROM boat WHERE condition='$condition' AND type='$type'
Or you might try
SELECT * FROM boat WHERE (condition='n
chown -R mysql:mysql /home/medic/
and make sure there is no outfile.txt already in that
dir.
--- sam <[EMAIL PROTECTED]> wrote:
> I executed the following statement:
>
> SELECT * INTO OUTFILE '/home/medic/outfile.txt' FROM
> fool;
>
> I get the error meassge
>
> " Can't create/write to file
> '
I just installed mysql but I get the command not found when I type mysql. I
am in the bin directory. Anyone know what is going on here?
Thanks
Gary
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
BG --
...and then B.G. Mahesh said...
%
...
%
% Thanks for the quick response. My question may not be very valid..but is
% there a upper limit on the number of records it can handle?
I'll leave this to the experts. I'm almost certain there must be
Hello,
I am attempting to search a table based on information passed from a
submitted form.
The form contains details as follows:
(radio buttons)
Condition: O new O used
Type: O powerO sail
(textbox)
Make: [ ]
etc. etc. etc. ( it's a long list!)
If I write
I've since deleted the code and did it another way. The code however went
something like this. This is just a mock up (there is more being selected
etc and there are some joins, but the syntax is exact).
So what happens is the select statement with $user1 in it gets the proper
values (the first o
At 19:45 -0800 12/17/02, CN YEONG wrote:
Hi,
May I know that if it is posibble to roll back the
sql query automatic if the sql query get error by
using myisam table type and not using innodb type?
No. MyISAM isn't a transaction-safe table type.
CN YEONG wrote:
Hi,
May I know that if it is posibble to roll back the
sql query automatic if the sql query get error by
using myisam table type and not using innodb type?
Thank for help.
No. You need to use a transactional table handler, like InnoDB.
--
Daniel Kasak
IT Developer
* NUS Con
Hi,
May I know that if it is posibble to roll back the
sql query automatic if the sql query get error by
using myisam table type and not using innodb type?
Thank for help.
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http
hello, i have access to mysql db i created, using a client app even on a
remote pc (adding tables, fields, values) but when i try to connect with
dreamweaver i get an unknown error, or unexpected. what do i need to do to
us dreamweaver on my development machine to access an mysql db on my server?
i
+ On Wed, Dec 18, 2002 at 08:10:41AM +, B.G. Mahesh wrote:
+ >
+ > If MYSQL or Postgres can do the job I prefer not to spend the money on
+ > Oracle/MSQL. However, if Oracle/MSQL are required for getting good
+ > reports and scalability, so be it. We will use Oracle/MSQL.
+
+ MySQL will have
yea, me too. but being second just isnt as good...
but did you grant the user permissions on the database
they want to connect too? can you connect to anything listening on
3306? htttp?
when i connect from remote over tcp its
>mysql -h "hostIP" -p -u "someuser" somedatabase
the firewall accepts
On Wed, Dec 18, 2002 at 08:10:41AM +, B.G. Mahesh wrote:
>
> If MYSQL or Postgres can do the job I prefer not to spend the money on
> Oracle/MSQL. However, if Oracle/MSQL are required for getting good
> reports and scalability, so be it. We will use Oracle/MSQL.
MySQL will have no problem wit
hi
We are evaluating few databases for developing an application with
following specs,
1. OS not very important. Leaning towards Linux
2. Currently the database has about 5 million records but it will grow
to 120 million records.
3. The tables will have billing information for a
Did you also check directory permissions? What system are you using?
Chuck
http://68.43.100.7:81/aa8vs
==
"Patriotism is the willingness to kill and
be killed for trivial reasons."
- Bertran Russell
-Original Message-
From: sam [mailto:[EMAIL P
I can...
Hard to know why without more info but a starting point would be to turn on
the query log in MySQL and see what queries it is receiving.
_
Fraser Stuart
Logistics IT
77-85Phone: +61 2 9335 1235
Roberts Rd
I don't think this can be done in a single query, but what about:
SELECT Reference.id1, Reference.id2, sum(Table1.number)
FROM Table1, Reference
WHERE Reference.id1=Table1.id1
GROUP BY Reference.id1
Which gives you:
+--+--++
| id1 | id2 | sum(Table1.number) |
+---
Walt,
you can also test 3.23.54. The following bug fix may be relevant here:
"
MySQL/InnoDB-3.23.54, December 12, 2002
Fixed a bug: the InnoDB range estimator greatly exaggerated the size of a
short index range if the paths to the endpoints of the range in the index
tree happened to branch alrea
Walt,
- Original Message -
From: "walt" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, December 17, 2002 1:58 AM
Subject: innodb/mysql slow returning anything other than primary key
> I've run into an interesting problem. I have a large innodb table (2274962
> rows
Chris,
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, December 17, 2002 7:28 PM
Subject: Assertion failed in buf0buf.ic
> I am receiving an 'Assertion failed' error in my log and I am not really
> sure how to continue. What I was trying
I executed the following statement:
SELECT * INTO OUTFILE '/home/medic/outfile.txt' FROM fool;
I get the error meassge
" Can't create/write to file '/home/medic/outfile.txt' (Errcode:13) "
I followed the solutions from the manual "A.3.3 Problems with File
Permissions"
and still have a problem.
On Wed, 18 Dec 2002 16:05:35 -0500, C. Reeve wrote:
>I can not use two mysql queries in the same PHP file
Please post code snippets, this is possible.
- Steve Yates
- Burger Borg: We do it our way; yours is irrelevant.
~ Taglines by Taglinator - www.srtware.com ~
--
I tried to use mysql-max-3.23.54a but it isn't statically linked against
GBLIB 2.2
Please also note the file size:
mysql-3.23.54a-pc-linux-i686.tar.gz is 9831919
mysql-max-3.23.54a-pc-linux-i686.tar.gz is 6097043
At the startup it prints out:
/lib/libc.so.6: version `GLIBC_2.2' not found
Bye
> Why is it that I can not use two mysql queries in the same PHP file.
You can, I assure you.
> Any info is appreciated.
Perhaps if you could provide your code? W/o it there is no way we can
determine where the problem might be coming from.
Chris
Same message I posted at JGuru and on the JDJ Mailing list, but posting here just
incase it is mysql related and someone can help
On RedHat 7.0 & RedHat 7.3
with Java 1.4.0_03
When page is hit fairly quickly I get the following error:
2002-12-17 14:56:37 StandardWrapperValve[jsp]: Servlet.servi
Hi,
Why is it that I can not use two mysql queries in the same PHP file. I have
tried to do this several times trying to put my site together and have had
nothing but problems.
The recent one is this:
I use a SELECT statement to get some info from a table, then I modify that
info and use an UPDA
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 17 Dec 2002, Aaron Brick wrote:
> i'm encountering some unexpected behavior in replace 3.23. when i pass
> it many replace pairs (only about twenty), its behavior becomes
> unpredictable. many times it does nothing at all, blatantly ignoring
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 17 Dec 2002, John P wrote:
> I want to upgrade my MySQL version (3.23.51) because of the recently
> revealed exploit; the only binary dist on mysql.com for solaris 2.7 is
> 3.23.53; will there be a problem compiling from source on this platfor
I want to upgrade my MySQL version (3.23.51) because of the recently
revealed exploit; the only binary dist on mysql.com for solaris 2.7 is
3.23.53; will there be a problem compiling from source on this platform or
should I wait for the binaries to be updated? There is a .54 release for 2.8
and 2.9
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 17 Dec 2002, Jannie Qu wrote:
> I got the following information. Does any one of you know whether it
> will impact my MySQL db server or not: Version 3.23.53 with InnoDB on
> Mac OS Darwin Kernel Version 6.2. If it does, what's the soluti
Hi,
I have two tables: one holding bids for an auction (table bids) and one
holding user data who placed the bids (users). I would like to get the
highest bid, the user who placed the bid and the number of bids placed,
so I use the following query:
SELECT MAX(bids.amount) AS amount, COUNT(bid
your problem being? perhaps you fail to realize that replace(1) is part of
the mysql distribution.
aaron.
so said [EMAIL PROTECTED] in 1.6K bytes at Tue, Dec 17, 2002:
> Please shove this up your ass
> - Original Message -
> From: "Aaron Brick" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECT
Please shove this up your ass
- Original Message -
From: "Aaron Brick" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 17, 2002 10:05 AM
Subject: replace(1) weirdness
> as rejected by the spam filter: MySQL, query, blah blah.
>
> > hello,
> >
> > i'm encountering some
Thanks to all who replied!
I was just looking at MySQL Front.
Thanks all,
Yves Arsenault
Carrefour Infotech
5, Acadian Dr.
Charlottetown, PEI
C1C 1M2
[EMAIL PROTECTED]
(902)368-1895 ext.242
-Original Message-
From: Grant Cooper [mailto:[EMAIL PROTECTED]]
Sent: December 17, 2002 12:24
Hi, all,
sql, query.
Greetings.
I got the following information. Does any one of you know whether it will
impact my MySQL db server or not: Version 3.23.53 with InnoDB on Mac OS
Darwin Kernel Version 6.2. If it does, what's the solution?
Thank you,
Jannie Qu
==
Hello all,
I have checked the mailing list and the documentation but have been
unable to find any information regarding the level of support for
MySQL on the MacOS 10.2 platform. After moving a production database
from a linux to MacOS 10.2 for development I have noticed that on my
MacOS mach
Hi,
Does MySQL automatically create index on primary key ?
If not how can I create an index on a primary key ?
Thanks for any help.
Patrice Serrand
-
Before posting, please check:
http://www.mysql.com/manual.php (the manu
It sounds like you need to edit your hosts.allow file to allow from the IP
you want to connect from.
add either
mysqld : ###.###.###.### : allow
or
mysqld : all : allow
I'm not a sysadmin though, so you might want to do a search on the proper
way to do this.
-Original Message-
From: Kr
as rejected by the spam filter: MySQL, query, blah blah.
> hello,
>
> i'm encountering some unexpected behavior in replace 3.23. when i pass it
> many replace pairs (only about twenty), its behavior becomes unpredictable.
> many times it does nothing at all, blatantly ignoring matches. other time
i shoved it up my ass and things are now running great. Thanks for your
invaluable assistance.
Now if anyone on this list can be more helpful, I might just have an
orgasm, as well as a fix to my 'problem'.
Where is Paul DuBois when you need him? MY friend Jason says to look for
him on here.
Paul DuBois wrote:
I just tried this script:
[ ... ]
I don't see anything getting flipped.
Wow, I'm impressed :-). I've not actually tried this myself (as it has
been a known bug in at least other db software). Good to know that
MySQL has no such problem.
Now testing:
create table test
At 23:39 -0800 12/16/02, Troy Kruthoff wrote:
>Description:
Invalid reporting of date calc
How-To-Repeat:
note: SESSIONTS is TIMESTAMP type
SELECT (NOW()-SESSIONTS) FROM WEBSESSIONS;
What leads you to expect that this should yield any useful result?
+---+
| (N
Hello,
I am having problems with mysql_install_db. I am running a bleeding-edge
Gentoo system (gcc 3.2.1 and glibc 2.3.1, both with some compatibility
patches. also running unpatched kernel 2.5.52).
MySQL compiles with no errors or problems, but mysql_install_db will not run
correctly.
Sorry, but I don´t understand you... I have no idea, if you don't mind you
could be more expecific...
Thanks a lot for your answer.
- Original Message -
From: Ireneusz Piasecki <[EMAIL PROTECTED]>
To: Egor Egorov <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 17, 2002 2:
I installed binary version (source distribution)... not with rpm
- Original Message -
From: Egor Egorov <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 17, 2002 2:02 PM
Subject: re: Mysql - Upgrading from 3.23.53 to 3.23.54
On Monday 16 December 2002 16:24, Santiago
I am receiving an 'Assertion failed' error in my log and I am not really
sure how to continue. What I was trying to do was start the MySQLd (v
3.23.53) with support for innodb (it is compiled in) on a FreeBSD
4.7-stable server. I used the settings in my-large.cnf as a template. The
server in que
Hello list,
I have been running MySQL 3.23.51 on a 4.6 FreeBSD box for some time
with no problem.
Recently, a client requested the ability to connect from remote. Until
now, I only allow connections from localhost and no TCP port open.
I have been going through the docs trying to figure out h
One trick I have used in the past in other databases is to
create your own descending index. If your field is say fieldA, when
you enter a row into the table take the value of fieldA and subtract
from 0, then put that in fieldB. Index fieldB and you now can order
rows descending.
- Stev
Hi everyone,
this might be a newbie question:
is there a way to switch all rows and columns in the output of an
select statement?
I am using DBIx::XHMTL_Table to display all the contents of a table on
a website.
The problem is that the table has about 50 columns, but every query
result display
Hello list,
I have been running MySQL 3.23.51 on a 4.6 FreeBSD box for some time
with no problem.
Recently, a client requested the ability to connect from remote. Until
now, I only allow connections from localhost and no TCP port open.
I have been going through the docs trying to figure out h
Hello list,
I have been running MySQL 3.23.51 on a 4.6 FreeBSD box for some time
with no problem.
Recently, a client requested the ability to connect from remote. Until
now, I only allow connections from localhost and no TCP port open.
I have been going through the docs trying to figure out h
There are many tools. Use a gui. mysql front (free), premium soft (my pick
but has a 29 day trial). There are also many small window applications to do
this. Do a search at one of the famous downloads. +client +mysql +gui
-Original Message-
From: Charles Mabbott [mailto:[EMAIL PROTECTED]]
Anderson, Alan R wrote:
Isn't the card type a piece of derived data? You should never have to enter it directly; it's computable from (the first digit(s) of) the card number.
Also note, the type of card isn't a SET option at all (it would be an
ENUM) and if its used as a foreign-key relatio
On Tuesday 17 December 2002 09:24, B F wrote:
> I tried your pass-through idea previously and it did not work. Today I even
> typed my query directly into the mysql shell (and bypassing MS-Access
> altogether) and my MySQL server still hung! So we can rule out problems
> with Access of MyODBC...
W
On Tuesday 17 December 2002 03:09, Lopez David E-r9374c wrote:
> Problem is type SMALLINT needs to be MEDIUMINT (MyISAM).
>
> column: id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT
>
> My solution is to use the following ALTER statement:
>
> ALTER TABLE messages CHANGE id
> id MEDIUMINT UNSI
Hello list.
Please help me to refine a JOIN based query which I am not able to correct.
This the scenario (simplified).
Three tables:
Products
-
| id | description |
-
| 01 | bread|
| 02 | milk |
| 0
> From: David T-G [mailto:[EMAIL PROTECTED]]
> ...I still have to figure
> out how to make sure that our credit card types and skill levels don't
> get corrupted (MC, MasterCard, mastercard, ...), but I guess that gets
> enforced in the software interface, right?
Isn't the card type a piece of der
I have some questions on how an index is built and
used.
I have a very simple table like this:
char_col char(10) not null
Index (char_col)
If I have 1000 records in this table, how big will the
index become? The data-size would be 10 000 right?
How does an index look like and how can it speed u
Luc Foisy wrote:
We use enum extensively for 'Y' 'N' values, sort of true false.
That way the values are forced to be one or the other. So any end user has to put one of those values in (if we allow it in that way, though we usually force them to use a checkbox). And its a little more viewable/un
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Daevid --
...and then Daevid Vincent said...
%
% > You mentioned a
% > echo "".$sql."";
% > in your first post; what do you see?
%
% I see exactly what I expected to see. Basically the contents of a db.sql
% file read in that looks like this rough
Have you thought about creating a fulltext index? Then you can search on
any word in a field. MySQL 4 has a lot more options for fulltext search,
but you can still do it in 3.
On Monday, December 16, 2002, at 04:25 PM, Chris Stark wrote:
SELECT my_id FROM my_table WHERE my_value LIKE '%ABCDEFG%
> >What exactly is wrong about using ENUM's?
> Changing them will kill you unless you're _very_ careful.
> Using them is usually unnecessary as you could've used an ID value
> pointing to another table of values. That table can then be added to
> with no risk to your existing queries. As a cont
In some of my tables I see overheard. What does it mean and does it mean I
have to optimize it every time? I seem to see it everyday. SQL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:
Hi,
Seems that mySql sometime write Querys to Log but does
not execute them. I found folling in the MySql Log-File.
Comments made by me are signed with "->".
Maybe some one has a solution for that ?
# at 5636748
#021216 15:27:38 server id 1 Intvar
SET INSERT_ID = 189612;
# at 5636770
#02121
>Description:
When accessing this mysql version from a WinXP client (running in a VMWare
shel) the server crashes reproducable.
>How-To-Repeat:
Access to server with DBTools 1.0.x from WinXP client.
>Fix:
?
>Submitter-Id:
>Originator:Hans-Joerg Wolff
>Organization:
Luc Foisy wrote:
What exactly is wrong about using ENUM's?
Changing them will kill you unless you're _very_ careful.
Using them is usually unnecessary as you could've used an ID value
pointing to another table of values. That table can then be added to
with no risk to your existing queri
Hi,
Here is my configuration :
Linux SME Server 5.6 bêta 7
Mysql 3.23.49
I try to access to Mysql via a client programm nammed MysqlFront. I have
defined an user like this :
Username : "blank"
Host : .domain_name.ch
Password : "blank"
When I try to conn
You might also wish to consider downloading and installing Webmin. It's one of the
easiest installs I have encountered. Simply tar the tarball and proceed into the new
subdirectory (IE webmin-1.030) and perform a /setup.sh . Webmin will allow you easy
access to your server via a web browser. Sim
What exactly is wrong about using ENUM's?
Luc
sql,mysql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-ma
Hi.
You need automake ver. 1.5 don't use 1.5d (i did it and spent couple of
hours to discover, why source rpm 3.23.54a don't rebuild )
autoconf is 2.52
libtool is 1.4.3
Regards.
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December
On Tuesday 17 December 2002 11:08, moka at hol dot gr wrote:
> I am looking at the following situation:
> I am reading some files arriving every minute and parsing them and
> creating a set of files ready to be inserted into tables.
> on the fly. While I am waiting for the next
On Tuesday 17 December 2002 22:04, Muruganandam wrote:
> Dear All,
> Where can i find mysql client and devel .rpm files compatible for
> MySQL-Max-3.23.53a-1.i386.rpm
You can use any recent 3.23.x version of client.
-devel.rpm should be the same as -shared.rpm if it's used.
--
For technical su
On Monday 16 December 2002 16:24, Santiago Alba wrote:
> I have installed MySQL 2.23.53 release and I want to upgrade to MySQL
> 2.23.54... how can
> I do this? Have i got to reinstall? Is there any script?
As usual ;)
Seriously speaking - depends on the way have you installed it.
--
For te
On Tuesday 17 December 2002 13:56, Martin Finnegan wrote:
> I am trying to get a handle on MySQL anticipating a PHP application I want
> to implement on a website next year. I am using WinXP and the website is on
> a Linux server.
> I have created a new database, but am having problems creating t
You cannot execute several SQL statements within a single query.
You are trying to reinvent 'mysql' client batch processing; if you want
to do that, you have to write an SQL parser in PHP that split
your input in independant SQL statements and execute them one by one :(
Daevid Vincent wrote:
>>Yo
> You mentioned a
> echo "".$sql."";
> in your first post; what do you see?
I see exactly what I expected to see. Basically the contents of a db.sql
file read in that looks like this roughly:
CREATE TABLE table1 (
blah int(10),
foo char(5)
);
CREATE TABLE table2 (
blee int(10),
fee
I am not a PHP expert but I think you can run external commands from PHP,
so it should be possible to run mysqladmin, mysqldump and mysql from PHP.
This will work even if you database is on a remote server; just specify
the hostname (ex: "mysqladmin -h mysqlhost create db2")
Daevid Vincent wrote:
Unfortunately, command line is not an option for me. As I said before,
the php scripts are on a web server and the database is on another
server.
> -Original Message-
> From: Joseph Bueno [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 17, 2002 2:47 AM
> To: [EMAIL PROTECTED]
> Subje
1 - 100 of 114 matches
Mail list logo
