Hi, I was wondering if any of you clever people out there can help me. I
have a client with a problem I'm sure some of you have fixed in the past ...
Client has 3 geographically separate sites, running same application (mine,
of course) and generating data on MySQL database.
Periodically
Mark,
Sorry to not clarify the connection between the word join and the SQL. Please refer
to the manual (it's easy
to use) for explanations, as mentioned earlier.
Further to Roger's comment: there is another terminology where you can write the words
INNER JOIN or LEFT JOIN
(and several
Hi.
I would do a simple read file,search database,input record script in
perl
and transfer the files using scp (ofcourse i asume this is in
linux/unix)
put it all under cronjob and it should work fine.
On the other hand i am sure others have better ideas:)
/PM\
David Shields wrote:
Hi, I
Hi.
Not only that you also sent it to the wrong person:)
It was david that asked the question anyway i cc it to the list and him.
sometime i will experiment with that also but time is to short:)
Regards
/PM\
Ed Lazor wrote:
doh... I should go to bed... I just reread what I wrote and it
Tracy,
Saturday, January 26, 2002, 10:45:32 PM, you wrote:
TY I apologize for this too basic question.
TY I installed MySQL using rpm. But I can't fine
TY mysql.h and mysql_config on my server. Where are they
TY from?
TY More Details:
TY Environment: MySQL server 3.23.46 and client
colorparam0100,0100,0100/paramHello Jeremy, list,
I asked:
After a select .. insert .. the mysql client returns something like:
Query OK, 11393 rows affected (0.47 sec)
Records: 11393 Duplicates: 0 Warnings: 0
Is it possible in perl/DBI to fetch the count of duplicates and
Is there a function for URL encoding a value ?
Here's what I mean :
select x from y
returns 'word1 word2 %word3'
If I were to put this into a URL, some browsers will not handle the URL
correctly, especially at the space character, also the same happens
with some proxy servers (like squid at
I would like to select from table with date field all records from some
date, for example today ( i think this is function NOW(). How do i do
this? I try : select * from seminar where Datum NOW()
Lp
jure
-
Before posting,
Hi list,
Assume I have various tables which all have these three fields:
userid, title, date_created
Now I want to create a list containing entries
of all tables ordered by date_created with a single select.
Is this possible or do I have to make either various
selects or create an extra table
Hello,
is possible on the fly change size of innodb tables ??
i create table 1G large but is small and i need enlarge it. Can i
change number in my.cnf or something else ?
S pozdravem
Michal Dvoracek [EMAIL PROTECTED]
Capitol Internet Publisher, Korunovacni 6, 170 00
Hi, Is there a way to lock a table so that only one user can change it and
then unlockit?
I need to do this coz I want visitors to retrieve some values from a
database but each value must be retrieved only by one user and then marked
up to be expired, so I don't want two users to retrieve the
Hi Hayan,
have a look at:
http://www.mysql.com/doc/L/O/LOCK_TABLES.html
for information on (un)locking tables.
At 11:48 28.01.02 +0300, you wrote:
Hi, Is there a way to lock a table so that only one user can change it and
then unlockit?
I need to do this coz I want visitors to retrieve some
Yes, i need this too but for a whole database. i just thought, if there is a
power loss, and the database is get stuck, the users won't able to connect
again ...
Vaso
-Original Message-
From: Hayan Al Mamoun [mailto:[EMAIL PROTECTED]]
Sent: 2002. janu?r 28. 9:48
To: MYSQL MAILING LIST
Dear sir,
I used mysql-4.0.1 running on Solaris-2.5.1 and
compile with Gcc-2.95.3. (package from www.sunfreeware.com)
I used command below.
CC=gcc CFLAGS=-O3 \
CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \
./configure --prefix=/usr/local/mysql --with-low-memory
At 01:11 2002-01-28, Alex wrote:
Enfin, disons surtout quen visitant le site dont je vais vous donner le
lien, vous allez avoir accès à des photos et à des vidéos qui sont de
véritables bombes
. A ne pas mettre entre toutes les mains
[snip]
Aurez-vous le courage de cliquer ici ?
I've installed mysql 3.23.47 (Binaries) on a Linux RedHat 7.0 box.
Everything seems to be OK (the server runs) but I cannot connect to it using
mysql client:
When I enter mysql -u etc...
I've got a bash: mysql: command not found
Any idea ?
Thanks
--
Stéphane
On Mon, 28 Jan 2002, Stephane Pinel wrote:
When I enter mysql -u etc...
I've got a bash: mysql: command not found
which mysql
Probably isn't in your path.
Either call with full path, or put its dir in your path.
-
Before
Hi.
Seems the paths are missing so try running locate mysql or find -name
mysql
from basedirectory.
/PM\
Stephane Pinel wrote:
I've installed mysql 3.23.47 (Binaries) on a Linux RedHat 7.0 box.
Everything seems to be OK (the server runs) but I cannot connect to it using
mysql client:
Hi
I amnot sure whether this is the appropriate list for my question.
If not i would be thankful for a pointer to the correct list.
I am using the Version 3.22.32 of the mysql client C API on a Solaris Sparc
Machine.
When i compile and link my application, it apparently needs
a shared object
Of course, the SAME spam we saw before appears again. No surprise.
Does anyone still believe this will go away by itself? It won't - it will only get
worse - unless the list administrators actually *do* something about it! The filters
DO NOT WORK.
At 17:05 2002-01-28, you wrote:
TF
Jure,
I would like to select from table with date field all records from some
date, for example today ( i think this is function NOW(). How do i do
this? I try : select * from seminar where Datum NOW()
The manual has a section on date/time functions and another on date/time data types.
Hi Tobias,
Assume I have various tables which all have these three fields:
userid, title, date_created
Now I want to create a list containing entries
of all tables ordered by date_created with a single select.
Is this possible or do I have to make either various
selects or create an extra
Hi all.
Eric here from South Africa.
I'm fairly new at using mysql and need to access images via a php website. What is the
best way to store images or reference to images like jpg and gifs in a mysql db? Also
what would the sql
querie look like to call the and view the image. Is there any
Hi,
Thanx dn. I know how to build joined selects but the problem is that those
two tables are not joinable. I don't have an entry in table 1 which
references to a field in table 2. I just want to create a list of
both tables ordered by date and limited to say 20 entries.
At 12:22 28.01.02
Of course, the SAME spam we saw before appears again. No surprise.
Does anyone still believe this will go away by itself? It won't -
it will only get worse - unless the list administrators actually
*do* something about it! The filters DO NOT WORK.
Is there any reason why the list can't just
Can anyone help me -
I am trying to extract data on the availability of a holiday villa using the
statement
'SELECT PossDate from JuneDates where not exists(SELECT PossDate FROM
Reservation WHERE PossDate Between ArrDate And DeptDate AND
Reservation.VillaID=\'Adonis\')'.
(This was originally
I have a table like this :
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-++
| id| int(11) | | PRI | 0 | auto_increment |
| isim | char(26) |
Hi, Is there a way to lock a table so that only one user can change it and
then unlockit?
I need to do this coz I want visitors to retrieve some values from a
database but each value must be retrieved only by one user and then marked
up to be expired, so I don't want two users to retrieve the
You might try something like this.(unless I am missing something:-)
$result = mysql_query (select * from email2 where email = $email);
if (mysql_num_rows($result))
{ record already exists}
else
{insert a new record}
Cary
At 07:28 AM 1/28/02, [EMAIL PROTECTED] wrote:
I have a table like
* Sinisa Milivojevic
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
Hi,
can someone from the mysql developers tell me what i did
wrong, if this
is a bug? I converted back to 3.23.42 to be on the safe side. ;) TIA
--
Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
Thanx, Roger.
Harald was right: What I want to do is a UNION which is not implemented
in mysql prior 4.0.0 :((
Your suggestion might work but I'm not sure if it's fast enough to be
done on-the-fly (i.e. during a http user request) due to the fact that
the tables are quite large and I have to
Hi,
You can also create an UNIQUE INDEX on 'email' field.
You can then directly insert, it will fail if a record
with the same email already exist.
Hope this helps
--
Joseph Bueno
NetClub/Trader.com
Cary wrote :
You might try something like this.(unless I am missing something:-)
$result
Hi Tobias,
Would the UNION command help?
(otherwise we'd need to see the table definitions to comment)
Regards,
=dn
- Original Message -
From: Tobias Kremer :: IT [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 28 January 2002 12:34
Subject: Re: selecting over various tables
Hi,
Hi
I have a two servers:
1. MSATER
mySQL 3.23.47 under Windows 2000
character_set: koi8_ru
character_sets: latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis
dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7
cp1251 danish hebrew win1251 estonia
Eric,
Generally you would store references to the images in the database as a full
or partial
pathname.
You can store binary data in the db itself using the BLOB type but this is
not necessarily
the most efficient approach to take
John Lodge
-Original Message-
From: Eric Torr Klopper
On Mon, 28 Jan 2002, Sinisa Milivojevic wrote:
Hi,
This is not OK according to syntax as PRIMARY is a reserved word.
UNIQUE KEY PRIMARY (id)
Why don't you just say PRIMARY KEY (id) ??
Hmm, well because that's just a mysqldump of a database which already
exists in mysql and it turned out
On Mon, 28 Jan 2002 14:49:18 +0100
Harald Fuchs [EMAIL PROTECTED] wrote:
In article [EMAIL PROTECTED],
Tobias Kremer :: IT [EMAIL PROTECTED] writes:
Hi,
Thanx dn. I know how to build joined selects but the problem is that those
two tables are not joinable. I don't have an entry in
On Mon, 28 Jan 2002, Sinisa Milivojevic wrote:
Are you sure that the above is the output from mysqldump ??
What server version ??
Look into the original posting on Jan 9 2002 for complete description. ;-)
--
Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS /
On Fri, Jan 25, 2002 at 01:25:10PM -0600, Philip Molter wrote:
: I have a table with two fields that reference the same field in
: another table. Is this allowed (I'm not sure if it is). mysql
: 3.23.46 allows this, but apparently, mysql 3.23.47 does not. Create
: it with just one key and it's
Adolfo,
Saturday, January 26, 2002, 6:52:20 PM, you wrote:
AEZ I have instaled MYSQL on Solaris 2.8 on Intel plataform, and did this
AEZ as says the manual, but when try to run it sends a message :
AEZ Segmentation fault - core dumped
AEZ # bin/safe_mysqld --user=mysql
AEZ # Starting mysqld
Mark,
Saturday, January 26, 2002, 11:58:47 PM, you wrote:
MS What about converting MySQL data to Oracle ?
In general, mysqldump will help.
MS Mark
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___
Jure,
Monday, January 28, 2002, 11:58:30 AM, you wrote:
JG I would like to select from table with date field all records from some
JG date, for example today ( i think this is function NOW(). How do i do
JG this? I try : select * from seminar where Datum NOW()
You can find description of
webmaster,
Friday, January 25, 2002, 8:45:10 PM, you wrote:
w I have a question which just may very well be ridiculous. In one table,
w we have a column of type timestamp. In normal cases, we want any changes
w to this row to update this timestamp (hence the nature of this datatype).
w
Michal,
Monday, January 28, 2002, 12:12:28 PM, you wrote:
MD Hello,
MD is possible on the fly change size of innodb tables ??
MD i create table 1G large but is small and i need enlarge it. Can i
MD change number in my.cnf or something else ?
Take a look at:
Mitsuru,
Friday, January 25, 2002, 8:12:02 AM, you wrote:
MH What would be the most effective way to compare 2 databases to see if
MH they are identical? This is for the replication. We would like to check
MH if a slave DB is identical to the primary DB.
For example, you can compare
Thomas,
Monday, January 28, 2002, 7:56:52 AM, you wrote:
TK Hi I am new to MySQL
TK I have installed MySQL on windows 200 swerver and installed MyODBC.
TK I created a db and added a user with the grant command and added
TK select,insert,delete,update privileges for the user.
mysql show
Check out mysqldump.
Michael Collins wrote:
Can describe be used to show columns from all tables in a database?
All at once that is. I want to document all fields in all tables and
find I need to display one table at a time.
Hello,
I've been using mysql 3.23.47 with Coldfusion 4.52 for several months, and I
want to switch to a new server with mysql max 3.23.47 and Coldfusion 5.0.
I was able to get the new versions of each running on the new server without
any problem, but I can't get the Coldfusion 5.0 serverto
Richard,
I use this with all kinds of situations.
I am using this function and others like it on tables with 100k to 3m
records.
They always work best when the field your looking for info on is indexed.
Order By only causes a second process that seems unnecessary but I have not
tested it
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
On Mon, 28 Jan 2002, Sinisa Milivojevic wrote:
Hi,
Hmm, well because that's just a mysqldump of a database which already
exists in mysql and it turned out that I cannot reimport it into mysql
back. It looks to me as a bug in mysqldump (look for
Vasoczki,
Monday, January 28, 2002, 12:20:21 PM, you wrote:
VF Yes, i need this too but for a whole database. i just thought, if there is a
VF power loss, and the database is get stuck, the users won't able to connect
VF again ...
It should be a very fanciful power failure and hardware failure
Andrei,
Monday, January 28, 2002, 11:50:56 AM, you wrote:
AB Is there a function for URL encoding a value ?
AB Here's what I mean :
AB select x from y
AB returns 'word1 word2 %word3'
AB If I were to put this into a URL, some browsers will not handle the URL
AB correctly, especially at the
Paul,
Monday, January 28, 2002, 3:01:20 AM, you wrote:
PD Kill the server (kill -9), bring it back up with -S (skip grant tables)
-Sg actually. :-)
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___
Keith,
Sunday, January 27, 2002, 6:22:31 AM, you wrote:
K The MySQL documentation (2.6.1 Linux Notes) states that is essential to
K run the 'mysqld' process with the highest possible priority on the Linux
K 2.4 kernel and this can be achieved by adding 'renice -20 $$' to
K 'safe_mysqld'. Where
Just add another file entry to my.cnf seperated by commas... You can add as
many seperate files as you like... (within reason of course, eventually if
the line length gets longer than 1024 or so you cant add anymore). Once you
edit the file, restart mysql and innobase will detect the new file
At 15:52 28.01.02 +0100, you wrote:
Your suggestion might work but I'm not sure if it's fast enough to be
done on-the-fly (i.e. during a http user request) due to the fact that
the tables are quite large and I have to manually join 10 tables :(
I'd say that a UNION over 10 tables is a sure
Description:
I try to get the last 5 different times and the first 5
different times. There is a difference of aproximately
1 minute and 40 seconds between this to queries. I do not see
reason for the difference in the execution times.
I am the only one who works on the database. Nobody else
And YOU are part of the problem - every spam is backed up by one of your
complaints, doubling the traffic.
If it really bothers you that much then set up a filter rule (killfile) for
the persistent spammers, or risk being killfiled yourself - you have become
a spammer.
Can't you take your
Hello!
I have a table with one field that is a varchar
primary key. Can the ? be added/updated/deleted to
this varchar primary key?
Thank you for your help.
Sincerely,
Tiffany
__
Do You Yahoo!?
Great stuff seeking new owners in Yahoo!
A friend of mine is having a problem with the 3 norwegian characters æ Æ, ø
Ø and å Å. (html: aelig; oslash; and aring;)
When a string is inserted with either of these characters, and later
selected and returned, they do not appear as they are supposed to. I.e: Ø
becomes O.
Also: Alphabetically
At 10:06 -0500 1/28/02, Butch Bean wrote:
Richard,
I use this with all kinds of situations.
I am using this function and others like it on tables with 100k to 3m
records.
They always work best when the field your looking for info on is indexed.
Order By only causes a second process that seems
At 7:37 -0800 1/28/02, Tiffany C. wrote:
Hello!
I have a table with one field that is a varchar
primary key. Can the ? be added/updated/deleted to
this varchar primary key?
What does this mean? You want to add a literal ? character to the
end of the column value?
Thank you for your help.
Philip.
you must have an index on the referenced key in the parent table. Now
test_base has no indexes at all.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB
Hi,
I'm just starting my first MySQL db, and I'm going to want to
print out reports from it and produce a camera-ready document.
Has anyone done this before, using, say, Star Office or AbiWord
or something?
TIA.
--
David S. Jackson[EMAIL PROTECTED]
On Tue, 2002-01-22 at 22:40, DL Neil wrote:
Hi Jonas,
I wonder if its possbile to make a toplist from the folowing table:
+--+--+
| name | status |
+--+--+
| Bob | working |
| Jane | sleeping |
| Joe | sleeping |
| Bob
Hello,
It seems that the following preparedStatement is
changing the character ? to null.
PreparedStatement selectLocation =
conn.prepareStatement(select location, addressLine1,
addressLine2, addressLine3, addressLine4,
addressLine5, addressLine6, addressLine7,
addressLine8, addressLine9,
You are correct... my apologies, I was thinking in VB where I built a
handler to let me sent multiple sql statements in one chunk and where the
'@' doesn't matter.
BB
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 28, 2002 11:28 AM
To: [EMAIL
Hi,
I have one concern about multithread.
I am building online exam system. many students can
get access to one table in one time. Should i use
table lock every time when one student get access to
the table. As i know, mysql is multithread,that means
it already incorporate the table lock
At 8:52 -0800 1/28/02, Tiffany C. wrote:
Hello,
It seems that the following preparedStatement is
changing the character ? to null.
PreparedStatement selectLocation =
conn.prepareStatement(select location, addressLine1,
addressLine2, addressLine3, addressLine4,
addressLine5, addressLine6,
On Mon, 28 Jan 2002, Sinisa Milivojevic wrote:
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
On Mon, 28 Jan 2002, Sinisa Milivojevic wrote:
Hi,
Hmm, well because that's just a mysqldump of a database which already
exists in mysql and it turned out that I cannot reimport it into mysql
On Mon, Jan 28, 2002 at 06:48:30PM +0200, Heikki Tuuri wrote:
: Philip.
:
: you must have an index on the referenced key in the parent table. Now
: test_base has no indexes at all.
Apparently, you also need indexes on the child table:
mysql create table test_bk ( fld int not null, primary key
You are correct... my apologies, I was thinking in VB where I built a
handler to let me sent multiple sql statements in one chunk and where the
'@' doesn't matter.
BB
This Works as a test...
my $getbigage = $dbh-prepare(
SELECT \@maxage:=max(age) from contacts);
my $getbigage1
Hey there!
Hoping someone can help me out when it comes to granting privileges for a
user in MySQL.
Basically, I have granted privileges to a user who I do not want to have
root access and I want to minimize his access to only his databases.
Using the MySQL manual, I granted him basic
Andrew Gould writes:
Please forgive my ignorance; but what is a
camera-ready document?
Andrew
That is easy :
A document that looks so nice that you can spare one shot on it.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
Camera ready means the a commercial printer cn go direct from the
provided document(s) to negatives/plates or direct to plate without
having to modify the originals in any way.
Save a lot of money in make up and AA charges.
Jack
Andrew Gould wrote:
Please forgive my ignorance; but what is a
I have 2 tables, detail and product. The detail table could have millions
of rows. The product table could have a few hundred. I need to know which
products are in the detail table. (It would also be nice to know which
products aren't in the detail table). The problem is it has to be fast,
Hi folks,
Hope some of you could help me here.
I have done
./configure --prefix=/ussr/loca/mysql
--localstatedir=/usr/loca/mysql/data
--withunix-socket-path=/tmp/mysql.sock
make
make install
1/ There is no /usr/local/mysql/data directory
2/ There is no
A camera-ready document is what is sent to a printing service. The
print-out may have crop marks or color information.
bb
-Original Message-
From: Andrew Gould [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 28, 2002 12:35 PM
To: David S. Jackson; [EMAIL PROTECTED];
[EMAIL PROTECTED];
How do you start mysql autamaticaly on boot up ?
Am running suse 7.2 linux with mysql installed to
/usr/loca/mysql
Thanks
Samy
__
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
At 12:12 -0600 1/28/02, BD wrote:
I have 2 tables, detail and product. The detail table could have
millions of rows. The product table could have a few hundred. I need
to know which products are in the detail table. (It would also be
nice to know which products aren't in the detail table). The
Would LIMIT work?
select distinct prod_id from products, detail where somedetailwhere
and product.prod_id = detail.prod_id LIMIT 1;
Original Message:
-
From: BD [EMAIL PROTECTED]
Date: Mon, 28 Jan 2002 12:12:48 -0600
To: [EMAIL PROTECTED]
Subject: How to emulate subselect on
At 1:50 -0800 1/28/02, Andrei B. wrote:
Is there a function for URL encoding a value ?
Here's what I mean :
select x from y
returns 'word1 word2 %word3'
If I were to put this into a URL, some browsers will not handle the URL
correctly, especially at the space character, also the same happens
I would like to use a single sign on for samba, mysql, and login...is
this possible?
our other alternative ms sql server 2000 which has the ability to
authenticate off samba.is external authentication on the todo list?
many thanks
don smith
Does anyone know how to set up a connection pool to the MySQL database in
weblogic.properties?
I tried to set it up as follows:
weblogic.jdbc.connectionPool.mysqlConnPool=\
url=jdbc:mysql:localhost:3306,\
driver=org.gjt.mm.mysql.Driver,\
loginDelaySecs=1,\
Oops, I didn't realize that you were looking for more than one product id.
Original Message:
-
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Mon, 28 Jan 2002 13:31:37 -0500
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: How to emulate subselect on larger table? ###
On Mon, Jan 28, 2002 at 12:00:43PM -0500, bin cai wrote:
Hi,
I have one concern about multithread. I am building online exam
system. many students can get access to one table in one
time. Should i use table lock every time when one student get access
to the table. As i know, mysql is
From: Don Smith [EMAIL PROTECTED]
our other alternative ms sql server 2000 which has the ability to
authenticate off samba
Uh, oh! Another of our brethren is being tempted by the Dark Side.
I doubt that MySQL could be easily coerced into external authentication, since the
existing
From: Michael Collins [mailto:[EMAIL PROTECTED]]
Can describe be used to show columns from all tables in a database?
At 9:56 AM -0800 1/28/02, Bruce Sandell wrote:
try mysqldump with the -d option.
That was my first thought, but this does not give a result in the
nice tables wish describe
Crack the Perl book. A script to do this using SHOW DATABASES and
SHOW TABLES to get the lists would be fairly trivial to write.
james montebello
On Mon, 28 Jan 2002, Michael Collins wrote:
From: Michael Collins [mailto:[EMAIL PROTECTED]]
Can describe be used to show columns from all
At 11:33 -0800 1/28/02, Michael Collins wrote:
From: Michael Collins [mailto:[EMAIL PROTECTED]]
Can describe be used to show columns from all tables in a database?
At 9:56 AM -0800 1/28/02, Bruce Sandell wrote:
try mysqldump with the -d option.
That was my first thought, but this does not give
A fellow in our shop wrote a perl script to do just that.
Enjoy!
Andy
Andy Ingham
Systems Librarian
Academic Affairs Library
UNC-Chapel Hill
919-962-1288
[EMAIL PROTECTED]
*
You can write a shell script that does:
mysqlshow database, and then loops throught the tables returned doing:
mysqlshow database table
Michael Collins wrote:
From: Michael Collins [mailto:[EMAIL PROTECTED]]
Can describe be used to show columns from all tables in a database?
At 9:56 AM
bash-2.04$ for i in `mysql mysql -e 'show tables;'`; do mysql mysql -e describe
$i;; done
Assuming bash as the shell, and os as UNIX, of course...
Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com/
At 1:46 PM -0600 1/28/02, Paul DuBois wrote:
I'd write a script that issued SHOW TABLES, then a DESCRIBE for each
table.
Thanks for the suggestion, I know some of the workarounds, I am
looking for the shortcut. Consider this as a feature request: allow
for describe to take a wildcard for the
Does anyone have a good example of accessing and displaying data in a MySQL
database using ASP and displaying it on a web page? I'm a VB programmer and
I'm new to accessing databases from the web and just need one good example
to tie everything together.
Thanks
--On Monday, January 28, 2002 11:52:08 AM -0600 Ed Carp [EMAIL PROTECTED]
wrote:
Hi, Bill! Did you ever get this issue resolved? I've got the same
problem - MySQL starts, but no clients can connect, not even mysqladmin.
TIA :)
I have not completely figured out what the problem is and I
Does anyone have a good example of accessing and displaying data in a MySQL
database using ASP and displaying it on a web page? I'm a VB programmer and
I'm new to accessing databases from the web and just need one good example
to tie everything together.
Thanks
Does anyone have a good example of accessing and displaying data in a MySQL
database using ASP and displaying it on a web page? I'm a VB programmer and
I'm new to accessing databases from the web and just need one good example
to tie everything together.
Thanks
This config worked for me:
weblogic.jdbc.connectionPool.PoolName=\
url=jdbc:mysql://localhost:3306/test,\
driver=org.gjt.mm.mysql.Driver,\
initialCapacity=1,\
maxCapacity=10,\
capacityIncrement=1,\
props=user=DBUser;password=DBPassword
Does anyone have a good example of accessing and displaying data in a MySQL
database using ASP and displaying it on a web page? I'm a VB programmer and
I'm new to accessing databases from the web and just need one good example
to tie everything together.
Thanks
1 - 100 of 139 matches
Mail list logo