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 (proba
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 other
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,
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 da
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
0100,0100,0100Hello 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 warnings,
> or even
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 le
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, pl
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 same
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 so
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 (E
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 --e
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 ?
>http://w
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éphan
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.
-
Be
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 li
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:
>T&F Informati
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 tabl
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 do
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 ju
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 do
=?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
> MIPS / Institute for
I have a table like this :
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-++
| id| int(11) | | PRI | 0 | auto_increment |
| isim | char(26) | Y
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 same
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))
{ }
else
{}
Cary
At 07:28 AM 1/28/02, [EMAIL PROTECTED] wrote:
>I have a table like this :
>
>+---+--+--+
* 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.
* Tobias Kremer :: IT
> 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.
Try this:
If you are using a table handler in MySQL that doesn't support transactions,
you must use LOCK TABLES if you want to ensure that no other thread comes
between a SELECT and an UPDATE. The example shown below requires LOCK TABLES
in order to execute safely:
mysql> LOCK TABLES trans READ,
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:-)
>
> $resu
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 hungar
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
Roger Baklund writes:
> * 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 -
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
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
* Sinisa Milivojevic
> Roger Baklund writes:
> > I believe the problem was that this is the ouput of a
> > mysqldump... why does mysqldump create invalid CREATE
> > statements...?
>
> Are you sure that the above is the output from mysqldump ??
>
> What server version ??
Of course I can not be 100
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 / In
>Description:
If i call get_lock('kornexl',10) in the master (Version 3.23.47), and
release_lock('kornexl') later, there are no errors in the master.
The slave (Version 3.23.44) stops with the following error:
ERROR: 1064 You have an error in your SQL syntax near 'DO RELEA
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 m
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: http://www.mysql.com/doc/A/d/
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 mysqldu
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 conn
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 directly
=?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
Anton kornexl writes:
> >Description:
> If i call get_lock('kornexl',10) in the master (Version 3.23.47), and
> release_lock('kornexl') later, there are no errors in the master.
> The slave (Version 3.23.44) stops with the following error:
> ERROR: 1064 You have an error in your
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 failu
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 th
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'. Wh
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 entr
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 table
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 has
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 petiti
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! Aucti
A friend of mine is having a problem with the 3 norwegian characters æ Æ, ø
Ø and å Å. (html: æ ø and å)
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 sorting strings
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 se
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 y
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 | sleep
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, add
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 PROTEC
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 feature?
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, addressLin
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
* [EMAIL PROTECTED]
> 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.
There is a problem in some case
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
Please forgive my ignorance; but what is a
"camera-ready document"?
Andrew
--- "David S. Jackson" <[EMAIL PROTECTED]> wrote:
> 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
>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 $getbiga
Several times I have selected too many rows from a table while playing with
the database in MySQL.exe (Win2k). So rather than wait for several thousand
rows to scroll by, I press Ctrl-C. Of course this terminates the MySQL.Exe
program entirely and puts me back at the DOS prompt. This is rather
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 privileg
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 PROT
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
David,
Monday, January 28, 2002, 10:39:12 AM, you wrote:
DS> Hi, I was wondering if any of you clever people out there can help me. I
DS> have a client with a problem I'm sure some of you have fixed in the past ...
DS> Client has 3 geographically separate sites, running same application (mine,
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,
ver
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 /tmp/myq
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
---
Sounds like a job for a LEFT JOIN. However, before we can help, we need to
know the table structure andhow the two tables are related.
Of course, if sub-selects are out of the question.
-Original Message-
From: BD [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 28, 2002 12:13 PM
To: [EM
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).
Would LIMIT work?
select distinct prod_id from products, detail where
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 larger table? ###
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 hap
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,\
initialCapa
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? ###
Woul
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 authe
>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
1 - 100 of 160 matches
Mail list logo
