quick install question about phpMyAdmin
i must be really new! i had no idea and read nothing that said the entire phpMyAdmin directory needed to be in a website folder. (i figured the entire folder need to be in there, is there another way?) how do you folks usually set this up? i mean, do you setup a whole website just to do "admin via the web"? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ISM,FRM Problem plese help if possible
create directory in your mysql data directory, like /var/lib/mysql/mydatabase. copy your .frm, .ISD, ism to that directory. now you have database named mydatabase. --ilham-- On Fri, 16 Feb 2001, Ryan Ahmed wrote: > Q:--have you heard about that guy who finally > discovered what a woman is all about > A:sadly,he died laughing before he could tell > anybody > > (And one for the ladies) > Q:---Why was moses wandering around in the desert for > 40 years? > A:---Coz even then men couldnt take directions!!! > > > Hi Everyone, > Now that I've hopefully got you in a nice mood, > First a bit of history, > I was hosting with a very bad hosting service and so > had to move all my files and so my databases too. > I moved all my files but had no idea on how to move my > DB's so I contacted my hosting service and they sent > me a zip file with the following extentions > .ism > .frm > .isd > Where am I supposed to dump them or what should I do? > Kindly help, > Thank you > -Ryan. > > > > __ > Do You Yahoo!? > Get personalized email addresses from Yahoo! Mail - only $35 > a year! http://personal.mail.yahoo.com/ > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: returning PID
PID is stored in a file in the datadir named .pid [root@georgia data]# cat /usr/local/mysql/data/georgia.pid 19805 Teddy A Jasin wrote: > > Hi, > wat command to type under linux to get the PID of the mysqld that is running? > i tried : 'ps aux | grep mysqld' but this will list the mysqld information but ijust >want it to > show the PID > > thanks > > Teddy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: returning PID
Try this. ps aux | grep mysqld | cut -c 10,11,12,13,14 - Original Message - From: Teddy A Jasin <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 16, 2001 7:32 PM Subject: returning PID Hi, wat command to type under linux to get the PID of the mysqld that is running? i tried : 'ps aux | grep mysqld' but this will list the mysqld information but ijust want it to show the PID thanks Teddy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
returning PID
Hi, wat command to type under linux to get the PID of the mysqld that is running? i tried : 'ps aux | grep mysqld' but this will list the mysqld information but ijust want it to show the PID thanks Teddy
Re: libmysqlclient
copy or link your libmysqlclient.so.10.0 to /usr/lib. Or edit /etc/ld.so.conf. Add path your libmysqlclient.so.10.0, and run ldconfig. You must have root access. --ilham-- On Fri, 16 Feb 2001, Alex Le Fevre wrote: > I just installed MySQL version 3.23.32, and all > appeared to go well. However, after installing PHP 4 > and rebooting my server, when I tried to start Apache > (1.3.14) I got the following message: > > /usr/libexec/ld.so: httpd: libmysqlclient.so.10.0: No > such file or directory > /usr/sbin/apachectl start: httpd could not be started > > I know that libmysqlclient.so.10.0 exists on my drive, > under /home/packages/mysql-3.23.32/libexec/.libs/ > (which is not my install dir; that's > /usr/local/mysql). I tried copying it to /usr/libexec, > and that didn't solve the problem. > > Even more strange, though, is the fact that I don't > have anything in my httpd.conf file that references > MySQL. > > Thank you for any help or direction you could provide. > > Alex Le Fevre > > > __ > Do You Yahoo!? > Get personalized email addresses from Yahoo! Mail - only $35 > a year! http://personal.mail.yahoo.com/ > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
list of databases
Is there any way I can generate a list of the databases in mysql, perhaps with the mysqlshow command and some fancy grep? I'm looking for a list separated by spaces, something that I could use in a bash script. Thanks, Tim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
libmysqlclient
I just installed MySQL version 3.23.32, and all appeared to go well. However, after installing PHP 4 and rebooting my server, when I tried to start Apache (1.3.14) I got the following message: /usr/libexec/ld.so: httpd: libmysqlclient.so.10.0: No such file or directory /usr/sbin/apachectl start: httpd could not be started I know that libmysqlclient.so.10.0 exists on my drive, under /home/packages/mysql-3.23.32/libexec/.libs/ (which is not my install dir; that's /usr/local/mysql). I tried copying it to /usr/libexec, and that didn't solve the problem. Even more strange, though, is the fact that I don't have anything in my httpd.conf file that references MySQL. Thank you for any help or direction you could provide. Alex Le Fevre __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Conversion
bob, first build the tables, to match your ascii database structure, Next use LOAD_DATA INFILE option to load it up, See LOAD_DATA in the manual for a detailed explanation. g'luck bob wrote: > I'm looking for a way to translate a database in ASCII form throw a > MySQL database. > Could you tell me how to do and if there is a special software to do it. > > Tank you > Ragrads > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: newbie
On Fri, 16 Feb 2001, Kelly Zhu wrote: > Try installing mySQL. Please help me out with these questions: > > 1) I am running RedHat 6.0 on a x86 machine. The file I downloaded was > 'Linux (Intel libc6 systems) [pc-linux-gnu-i686]'. Is it the right one? Yes Youare right. beware of 386, 586, or 686 > > 2) 'Linux (Intel libc6 systems) [pc-linux-gnu-i686]' seems to be the binary > distribution because I don't see any make files after untar it. Is that > right? you can copy to the right destination directory. It will be easy, if you download the rpm package such as MySQL-3.23.33-1.386.rpm, MySQL-client-3.23.33-1.386.rpm. you can execute: $ rpm -i > > 3) I treated it as a binary, and followed the instruction for binary > installation. Then this command line puzzles me: > shell> bin/safe_mysqld --user=mysql & double dash is a long option. the short option maybe -u. --ilham-- > > the double dashes may not be right. What is that? > > Have a nice weekend. I come back next Monday hoping to get a good answer > from you. > > Thanks. > > Kelly > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Conversion
I'm looking for a way to translate a database in ASCII form throw a MySQL database. Could you tell me how to do and if there is a special software to do it. Tank you Ragrads - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQl with SSH
On Fri, Feb 16, 2001 at 05:31:54AM -0800, Kuokai Shyu wrote: > > How can I configure MySQL to utilize the SSH package for encrypted > TCP/IP connection between MySQL clients and server? Thanks in > advance. What I do is setup port-forwarding. I forward a local port (say 12345) to port 3306 on the database server via an SSH connection: ssh -f -L 12345:server.foo.com:3306 sleep 9 (or something relatively similar) Then I just tell the client to connect to localhost on port 12345. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: varchar and sql92
db2 is limited to 255. On Fri, 16 Feb 2001, Eric Frazier wrote: > Date: Fri, 16 Feb 2001 14:13:00 -0800 > From: Eric Frazier <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: varchar and sql92 > > Hi, > > I am writing a program to do queries on a lot of different databases. I have > run into something with varchar I didn't expect. > > With mySQL varchar is limited to 255 with postgress it is unlimited it > seems. I only know because it seems to work, not because their stupid > documentation told me, that you can have any length varchar. For instance I > have a varchar 4000 in a postgress database. > > My question is, how standard is mySQL being by limiting varchar to 255 ? I > will have to make some provision for this because I want my queries to work > with postgress as well, but I wondered too if I should look into other > issues like this with lengths of fields? > > Thanks, > > Eric > > > Frazier Consulting > http://www.kwinternet.com/eric > (250) 655 - 9513 > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compile error
Actually the function is called sprintf() rather than snprintf(), to the best of my recollection, and it's probably defined in either stdio.h/stdlib.h or string.h. Change snprintf to sprintf() and see what happens. - Original Message - From: "John Markunas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 16, 2001 1:53 PM Subject: Compile error > Hello > Running gcc 2.95.2 and gnumake 3.39. Attempting to build mysql v3.23.32 or > v3.23.33. > > Getting error, during make > > sql_string.cc: In Method 'bool String::(double,unsigned int=2)': > sql_string.cc:181 Implicit declaration of function 'int snprintf(...)' > > Running on an Alpha Tru64 V4.x > > Any insight would be greatly appreciated. > > > Thank You > > John Markunas > Williams College > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ranking album plays by city, help me beat Oracle
This is the latest approach we're using now. It turns out that the query to get Total
Plays for an Album per City can be taken out of the City for loop & done only once as
a GROUP BY.
The worst case time for MySQL is now 16 seconds compared to Oracle's 8 seconds. On
most cases MySQL is now faster than Oracle but once in a while it's slower.
$query = "SELECT metro, sum(td_num) FROM album_by_metro
WHERE same_album_id = $album
AND rpt_dt >= '$BeginDate' AND rpt_dt <= '$EndDate'
GROUP BY metro";
$start = time();
$result = mysql_query($query) or die ("Can't get $query" . mysql_error());
while ($row = mysql_fetch_array($result))
{
$metro = $row[0];
$metros[] = $metro;
$V_SUMS[$metro] = $row[1];
}
// while
mysql_free_result($result);
//
foreach ($metros as $metro)
{
$V_SUM = $V_SUMS[$metro];
$query = "SELECT same_album_id, SUM(td_num) FROM album_by_metro
WHERE metro = '$metro' AND rpt_dt >= '$BeginDate' AND rpt_dt <= '$EndDate'
GROUP BY same_album_id HAVING SUM(td_num) > $V_SUM";
$result = mysql_query($query, $connection);
if ($result)
$rank = mysql_num_rows($result)+1;
else
$rank = 0;
$ranks[$metro] = $rank;
}
Below is everything you asked for except the Oracle stored procedure which I can't
send.
thanks for your help,
- Sam.
mysql> describe album_by_metro;
+---+--+--+-++---+--
+
| Field | Type | Null | Key | Default| Extra | Privileges
|
+---+--+--+-++---+--
+
| rpt_dt| date | | MUL | -00-00 | | select,insert
,update |
| region| varchar(50) | | || | select,insert
,update |
| metro | varchar(100) | | MUL || | select,insert
,update |
| same_album_id | int(11) | | MUL | 0 | | select,insert
,update |
| td_num| int(11) | | | 0 | | select,insert
,update |
mysql> EXPLAIN SELECT same_album_id, SUM(td_num) FROM album_by_metro
WHERE metro = 'Atlanta' AND rpt_dt >= '2001-01-01' AND
rpt_dt <= '2001-02-14'
GROUP BY same_album_id HAVING SUM(td_num) > 500
mysql> show index from album_by_metro;
+++-+--+
---+---+-+--++-+
| Table | Non_unique | Key_name| Seq_in_index | Column_name
| Collation | Cardinality | Sub_part | Packed | Comment |
+++-+--+
---+---+-+--++-+
| album_by_metro | 1 | rpt_dt |1 | rpt_dt
| A |NULL | NULL | NULL | |
| album_by_metro | 1 | rpt_dt |2 | region
| A |NULL | NULL | NULL | |
| album_by_metro | 1 | rpt_dt |3 | metro
| A |NULL | NULL | NULL | |
| album_by_metro | 1 | rpt_dt |4 | same_album_
id | A |NULL | NULL | NULL | |
| album_by_metro | 1 | rpt_dt |5 | td_num
| A |NULL | NULL | NULL | |
| album_by_metro | 1 | album_by_metro_idx2 |1 | metro
| A |NULL | NULL | NULL | |
| album_by_metro | 1 | album_by_metro_idx2 |2 | rpt_dt
| A |NULL | NULL | NULL | |
| album_by_metro | 1 | album_by_metro_idx1 |1 | same_album_
id | A |NULL | NULL | NULL | |
| album_by_metro | 1 | album_by_metro_idx1 |2 | rpt_dt
| A |NULL | NULL | NULL | |
+++-+--+
---+---+-+--++-+
Benjamin Pflugmann <[EMAIL PROTECTED]> wrote:
Hi.
On Thu, Feb 15, 2001 at 09:25:56PM -0800, [EMAIL PROTECTED] wrote:
>
> > Could you please post the result of "EXPLAIN" for both queries and "SHOW INDEX
>FROM album_by_city".
>
>
> I haven't used EXPLAIN before.
Just put it before the SELECT in your query. I don't know whether this
will work directly in your program (php?), you can do it another way,
too. Let's take your first query:
SELECT SUM(total_plays) FROM album_by_city WHERE album_id = $album_id
AND city = $this_city AND date >= $StartDate AND date <= $EndDate;
You have to replace all variables by some real values. (best if you
simply put an additional echo in your php(?) program).
Assume $album_id=10, $this_city="New York", $StartDate="2001-01-01"
and $EndDate="2001-02-14" would be valid values
Re: Perl DBI
Here is what I would do.
There is always a database on every mysql installation called "mysql"
This database is where your permissions tables and such are stored.
Connect initially to that database. Then, try to create the new database.
If you get an error back, prompt the user, rinse and repeat.
Your connection string should look something like this:
$dbh =
DBI->connect('DBI:mysql:mysql;host=somehost','someuser','somepassword');
Of coarse, you could always connect to the mysql database and get a list of
databases, and not have to expect an error back from mysql on connection...
- Original Message -
From: "John Tsangaris" <[EMAIL PROTECTED]>
To: "Eric Fitzgerald" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 4:46 PM
Subject: RE: Perl DBI
> Hi, Eric.
>
> What I'm trying to do is have my install program check to see if a
database
> of a certain name exists, if it does then the install needs to create
> another one (using a name given by the user), if not then it needs to
create
> it with the original name.
>
> But I cannot figure out how to connect to mysql without already having a
> database setup.
>
> I'll use dbtemp as an example db.
>
> I can try to connect to dbtemp and if it successful, I know it exists. So
I
> prompt the user to enter another db name. I can then check if this exists
> and if it doesn't I can use the dbi to create the new db WHILE I am still
> connected to dbtemp.
>
> If dbtemp does not exist I need to create it. The problem is dbi needs to
> connect to a database even to create another one. So what/how do I
connect
> to initially to create that first database?
>
> I realize, for geeks (myself included), that you could simply create the
db
> manually and then install the program.. but the program is to be usable by
> the layperson.. which means that there is a chance they don't know
anything
> about mysql other than the guy on tech support said it's installed on the
> server.
>
> How do I connect to mysql without connecting to a database?
>
>
> John
>
> -Original Message-
> From: Eric Fitzgerald [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 16, 2001 1:21 PM
> To: John Tsangaris; [EMAIL PROTECTED]
> Subject: Re: Perl DBI
>
>
> Connect to the mysql database if you have access. It always exists.
>
> - Original Message -
> From: "John Tsangaris" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, February 16, 2001 1:58 PM
> Subject: Perl DBI
>
>
> > Is it possible to connect to mysql without connecting directly to a
> > database, check to see if a particular database exists, and if it
doesn't
> > exist create it?
> >
> > I have not been able to find a way of connecting to mysql without having
a
> > database already (I want perl to be able to make the db.. not have it
> > already made before hand.)
> >
> > tia
> >
> > John
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php (the manual)
> >http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
> >
>
>
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
newbie
Try installing mySQL. Please help me out with these questions: 1) I am running RedHat 6.0 on a x86 machine. The file I downloaded was 'Linux (Intel libc6 systems) [pc-linux-gnu-i686]'. Is it the right one? 2) 'Linux (Intel libc6 systems) [pc-linux-gnu-i686]' seems to be the binary distribution because I don't see any make files after untar it. Is that right? 3) I treated it as a binary, and followed the instruction for binary installation. Then this command line puzzles me: shell> bin/safe_mysqld --user=mysql & the double dashes may not be right. What is that? Have a nice weekend. I come back next Monday hoping to get a good answer from you. Thanks. Kelly - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC Prompt on connect
Yes, Pay attention to the large number of problems mentioned regarding MyODBC connections, on this list. Also note that I am not the only one who keeps saying to use PhpMyAdmin. It is simply a better solution. On 15 Feb 2001, at 20:44, Juan Suris wrote: > I've setup MyODBC (Win98) so I can access a MySQL db from Excel. It > works fine, except that everytime I refresh the data, I get the MyODBC > prompt, even when I select the option "Don't Prompt on Connect". This > is kind of anoying, as I need to execute well over 700 queries. > > Anybody have any ideas? > Thanks, > JuanE > > -- > http://FWDer.com -- FWD your way to a fun and SPAM-free mailbox. > Unlimited email addresses at your domain yourname.FWDer.com. > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> To > unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Setting up Access 2000 to work using a mySQL db...
Kentj, I have a setup that differs in just a few ways. My server is Redhat7 Linux, on the Internet. It appears from the IP address that you gave, that yours in on an intranet. Judging by a lot of messages I have seen here, and by my own experience, a similar connection on the Internet is far less reliable, even if correctly configured. Access97 appears to be less of a problem, but I solved my problem by eliminating Access and using PhpMyAdmin. On 15 Feb 2001, at 14:35, kentj wrote: > I have an Access 2000 Db on a Win98 system with tables linked to a > MySql23.32-1 database on Suse Linux 7.0 using the latest MyODBC with a > System DSN specifying anyname.dsn, the IP of 192.168.2.5 for the host, > the database name of "metrics" and port 3306. I had to setup the > privileges very carefully in the MySQL user table and to spell my > database name correctly in order to make it work. > > Rodrigo Antonio Reyes Cabrera wrote: > > > Hi > > I am using Access 2000 and I would like to configure it in order to > > use it as a interface to a mySQL db. Is this possible? I think it > > is, but I haven't been able to get it done so far. I am using the > > myODBC driver, but I get error messages when I try to import or link > > a table from my db into Access. Nevertheless, I can connect from PHP > > using the same ODBC connection. What could be wrong? > > > > Rodrigo > > > > > > - Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" > > before posting. To request this thread, e-mail > > [EMAIL PROTECTED] > > > > To unsubscribe, send a message to the address shown in the > > List-Unsubscribe header of this message. If you cannot see it, > > e-mail [EMAIL PROTECTED] instead. > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> To > unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
varchar and sql92
Hi, I am writing a program to do queries on a lot of different databases. I have run into something with varchar I didn't expect. With mySQL varchar is limited to 255 with postgress it is unlimited it seems. I only know because it seems to work, not because their stupid documentation told me, that you can have any length varchar. For instance I have a varchar 4000 in a postgress database. My question is, how standard is mySQL being by limiting varchar to 255 ? I will have to make some provision for this because I want my queries to work with postgress as well, but I wondered too if I should look into other issues like this with lengths of fields? Thanks, Eric Frazier Consulting http://www.kwinternet.com/eric (250) 655 - 9513 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
CREATE from a mysqldump won't CREATE a table in 3.23?
The following CREATE TABLE came from a mysqldump. When I use the same create
statement to create the table under mysql 3.23 I get an error:
# MySQL dump 8.12
#
# Host: localhostDatabase: installers
#
# Server version3.23.32-log
#
# Table structure for table 'versions'
#
CREATE TABLE versions (
file_id int(9) NOT NULL auto_increment,
languagecode varchar(10) NOT NULL default 'en',
product varchar(100) NOT NULL default '',
platform enum('WIN','MAC','LINUX','PALM') NOT NULL default 'WIN',
version_num varchar(25) NOT NULL default '',
type enum('BETA','RELEASE') NOT NULL default 'BETA',
mode enum('PAY','FREE','AD','ALL') NOT NULL default 'PAY',
date date default NULL,
size int(9) default NULL,
expires date default NULL,
contact_info varchar(255) default NULL,
ARL varchar(255) default NULL,
URL varchar(255) default NULL,
readme varchar(255) default NULL,
relnotes varchar(255) default NULL,
whatsnew varchar(255) default NULL,
note_1 varchar(255) default NULL,
note_2 varchar(255) default NULL,
note_3 varchar(255) default NULL,
note_4 varchar(255) default NULL,
note_5 varchar(255) default NULL,
patchURL varchar(255) default NULL,
patchURLname varchar(255) default NULL,
patchsize int(9) default NULL,
patchnote_1 varchar(255) default NULL,
patchnote_2 varchar(255) default NULL,
manualURL varchar(255) default NULL,
manualURLname varchar(255) default NULL,
manualsize int(9) default NULL,
manualnote_1 varchar(255) default NULL,
manualnote_2 varchar(255) default NULL,
PRIMARY KEY (file_id),
KEY version(product,platform,version_num)
) TYPE=MyISAM;
ERROR 1064 at line 11: You have an error in your SQL syntax near
'version(product,platform,version_num)
) TYPE=MyISAM' at line 34
What gives and is this a bug? How can it REJECT something it gave me as a
mysqldump? Curious, isn't it? I believe this is a bug.
Thanks for any info,
Martin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ISM,FRM Problem plese help if possible
Q:--have you heard about that guy who finally discovered what a woman is all about A:sadly,he died laughing before he could tell anybody (And one for the ladies) Q:---Why was moses wandering around in the desert for 40 years? A:---Coz even then men couldnt take directions!!! Hi Everyone, Now that I've hopefully got you in a nice mood, First a bit of history, I was hosting with a very bad hosting service and so had to move all my files and so my databases too. I moved all my files but had no idea on how to move my DB's so I contacted my hosting service and they sent me a zip file with the following extentions .ism .frm .isd Where am I supposed to dump them or what should I do? Kindly help, Thank you -Ryan. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyODBC and JDBC Bridge Driver
Sorry people, I' ve some bad problems to run mysql with the Java JDBC ODBC Bridge Driver under Win89. Perhaps only a question of syntax, perhaps an internal Error, perhaps... I tried out lots of possibilities, but in the end the error of finding a nonexistant database was the closest thing of success, that is: it accepted the myodbc.dll but refused a connection because not finding the database I described. Is there anyone in the web who got a solution or suffers at the same problem. Please send me a mail. Thanks Thommy Thomas Krause Schellingstr.124 80798 München Tel.: 089/54212278
Re: Index not used for order by when more than 1 field selected, no where clause
Hi. On Fri, Feb 16, 2001 at 09:42:02AM +0100, [EMAIL PROTECTED] wrote: > Benjamin Pflugmann wrote : [...] > > "Second" is never the best way. MySQL uses "First" up to some > > percentage of the amount of records (30% I believe), then uses > > "Third", because reading the data in file order (unsorted) and sorting > > is usually faster than random seeks (due to index usage) over that > > percentage of records. [...] > Sorry to jump in the middle of this thread but your comment make me > think of a case where random seeks may still be better even if more > than 30% of records are involved: You are completely right. That's why I said "usually" above. But it shouldn't make a too big difference generally. In the original problem, the speed difference was so huge, because MySQL could avoid reading the data file at all in one case. > When you set up your database server so that it has enough RAM to > keep the whole database in main memory (buffer cache), random reads > don't need to wait for physical disk seeks and can be very fast. [...] > So my question is: > Is it a way to tune this threshold ? AFAIK, currently the only way is to change it within the source and recompile MySQL. Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compile error
Hello Running gcc 2.95.2 and gnumake 3.39. Attempting to build mysql v3.23.32 or v3.23.33. Getting error, during make sql_string.cc: In Method 'bool String::(double,unsigned int=2)': sql_string.cc:181 Implicit declaration of function 'int snprintf(...)' Running on an Alpha Tru64 V4.x Any insight would be greatly appreciated. Thank You John Markunas Williams College - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: setting key_buffer_size correctly
Hi. On Fri, Feb 16, 2001 at 03:05:35AM -0500, [EMAIL PROTECTED] wrote: > Hello, I have a large database with a lot of queries and was trying to > tune MySQL to get the best performance. I was reading the manuals and it > said to set the key_buffer_size to the best value, you take the first > two of the following values and divide by each other. I believe it said > you should get less then 1%. I was not able to figure out what the best > setting for me to be using was, so I am looking for help. Here are the > values: > > | Key_read_requests| 2983998650 | > | Key_reads| 2139560| This gets you less than 0.1%, i.e. good. > | Key_write_requests | 744067782 | > | Key_writes | 351704288 | > > The machine has 2 gigs of ram and currently the key_buffer_size is set > to 800M. I was wondering if I should increase or decrease the value to > get the best performance gain. Have a look at the status of Key_blocks_used. If it is far below the value of your key_buffer setting (regarding a key block has 1024 bytes), you want to decrease it (to let more memory for OS file system caching). Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Perl DBI
Hi, Eric. What I'm trying to do is have my install program check to see if a database of a certain name exists, if it does then the install needs to create another one (using a name given by the user), if not then it needs to create it with the original name. But I cannot figure out how to connect to mysql without already having a database setup. I'll use dbtemp as an example db. I can try to connect to dbtemp and if it successful, I know it exists. So I prompt the user to enter another db name. I can then check if this exists and if it doesn't I can use the dbi to create the new db WHILE I am still connected to dbtemp. If dbtemp does not exist I need to create it. The problem is dbi needs to connect to a database even to create another one. So what/how do I connect to initially to create that first database? I realize, for geeks (myself included), that you could simply create the db manually and then install the program.. but the program is to be usable by the layperson.. which means that there is a chance they don't know anything about mysql other than the guy on tech support said it's installed on the server. How do I connect to mysql without connecting to a database? John -Original Message- From: Eric Fitzgerald [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 1:21 PM To: John Tsangaris; [EMAIL PROTECTED] Subject: Re: Perl DBI Connect to the mysql database if you have access. It always exists. - Original Message - From: "John Tsangaris" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 16, 2001 1:58 PM Subject: Perl DBI > Is it possible to connect to mysql without connecting directly to a > database, check to see if a particular database exists, and if it doesn't > exist create it? > > I have not been able to find a way of connecting to mysql without having a > database already (I want perl to be able to make the db.. not have it > already made before hand.) > > tia > > John > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql dead but subsys locked
When I mysql status I get message "mysql dead but subsys locked" I recieve socket error when I attempt any access - mysql.sock DOES exist @ /var/lib/ System: Linux localhost.localdomain 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 14 Feb 15 11:25 /lib/libc.so.6 -> libc-2.1.92.so -rwxr-xr-x 1 root root 4776568 Aug 30 17:56 /lib/libc-2.1.92.so -rw-r--r-- 1 root root 22607104 Aug 30 17:15 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Aug 30 17:15 /usr/lib/libc.so Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --without-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --enable-assembler --with-mysqld-user=mysql
MySQl with SSH
Hi, How can I configure MySQL to utilize the SSH package for encrypted TCP/IP connection between MySQL clients and server? Thanks in advance. Kuokai - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQLGUI
Hi, I just started looking at the MySQLGUI tool in depth yesterday. I have one question for now. I'm able to save queries via the "Save Query" button but I don't see any facility to load the query back in from a file. Is this functionality missing or hidden? I've examined all the readme's and didn't see any reference to this functionality. Thanks, Shawn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Perl DBI
Connect to the mysql database if you have access. It always exists. - Original Message - From: "John Tsangaris" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 16, 2001 1:58 PM Subject: Perl DBI > Is it possible to connect to mysql without connecting directly to a > database, check to see if a particular database exists, and if it doesn't > exist create it? > > I have not been able to find a way of connecting to mysql without having a > database already (I want perl to be able to make the db.. not have it > already made before hand.) > > tia > > John > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JDBC question
Don't work with oracle. Sorry. However did have a problem with the version of the jdbc driver on the mysql web site but not with the one on developer's site. It was for mysql not oracle. On Fri, 16 Feb 2001, webmaster wrote: > Date: Fri, 16 Feb 2001 15:44:11 -0500 (EST) > From: webmaster <[EMAIL PROTECTED]> > To: "William R. Mussatto" <[EMAIL PROTECTED]> > Cc: Chen Ka Pong <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Subject: JDBC question > > I am , well I will have to wioork with oracle and jdeveloper, can some of > you please please please telll me where canI find examples of conections > to a database an oracle databse and if I use php again eh the > same question where can I see examples of conections to an oralce data > base using php... information about jdeveloper... and oracle , perhaps a > user group, a mailling list... is jdeveloper hard to use? are jdevelopers > graphical interfaces easy to understand? I am not a java programmer so I > must ask how easy may jdeveloper be I only need to stablish conectivity > to an oracle database, buid the interfaces for consulting the data base > and adding datas to it... well thanks a lot inadvance, cheers > > On Fri, 16 Feb 2001, William R. Mussatto wrote: > > > Date: Fri, 16 Feb 2001 10:48:57 -0800 (PST) > > From: William R. Mussatto <[EMAIL PROTECTED]> > > To: Chen Ka Pong <[EMAIL PROTECTED]> > > Cc: [EMAIL PROTECTED] > > Subject: Re: JDBC question? > > > > > > Had similar problem, get the current version of the driver. > > > > On Fri, 16 Feb 2001, Chen Ka Pong wrote: > > > > > Date: Fri, 16 Feb 2001 20:29:27 +0800 > > > From: Chen Ka Pong <[EMAIL PROTECTED]> > > > To: [EMAIL PROTECTED] > > > Subject: JDBC question? > > > > > > I cannot use the jdbc connection which the driver is download > > > from mysql web site. The error message prompted that > > > "invalid JDBC Driver", what can cause this error? > > > I predict my classpath is wrong, but I would like to know > > > how to set the classpath? > > > (at this status, I am not sure if my classpath is correct or not) > > > > > > Thanks! > > > > > > Pong > > > > > > > Sincerely, > > > > William Mussatto, Senior Systems Engineer > > CyberStrategies, Inc > > ph. 909-920-9154 ext. 27 > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JDBC question
I am , well I will have to wioork with oracle and jdeveloper, can some of you please please please telll me where canI find examples of conections to a database an oracle databse and if I use php again eh the same question where can I see examples of conections to an oralce data base using php... information about jdeveloper... and oracle , perhaps a user group, a mailling list... is jdeveloper hard to use? are jdevelopers graphical interfaces easy to understand? I am not a java programmer so I must ask how easy may jdeveloper be I only need to stablish conectivity to an oracle database, buid the interfaces for consulting the data base and adding datas to it... well thanks a lot inadvance, cheers On Fri, 16 Feb 2001, William R. Mussatto wrote: > Date: Fri, 16 Feb 2001 10:48:57 -0800 (PST) > From: William R. Mussatto <[EMAIL PROTECTED]> > To: Chen Ka Pong <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: JDBC question? > > > Had similar problem, get the current version of the driver. > > On Fri, 16 Feb 2001, Chen Ka Pong wrote: > > > Date: Fri, 16 Feb 2001 20:29:27 +0800 > > From: Chen Ka Pong <[EMAIL PROTECTED]> > > To: [EMAIL PROTECTED] > > Subject: JDBC question? > > > > I cannot use the jdbc connection which the driver is download > > from mysql web site. The error message prompted that > > "invalid JDBC Driver", what can cause this error? > > I predict my classpath is wrong, but I would like to know > > how to set the classpath? > > (at this status, I am not sure if my classpath is correct or not) > > > > Thanks! > > > > Pong > > > > Sincerely, > > William Mussatto, Senior Systems Engineer > CyberStrategies, Inc > ph. 909-920-9154 ext. 27 > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Different behaviour between 3.22.32 and 3.23.32
> >Description: > "SELECT MAX (record_id) FROM record;" iworks in 3.22.32 but > fails in 3.23.32 > Well, that shouldn't really come as a surprise. The manual specifically says (Section "Functions for use in SELECT and WHERE clauses): Note: There must be no whitespace between a function name and the parenthesis following it. This helps the MySQL parser distinguish between function calls and references to tables or columns that happen to have the same name as a function. Spaces around arguments are permitted, though. You may be running your 3.22 version in ANSI mode, this would explain the seemingly strange behaviour. Or it may be, that the behaviour changed between 3.22 and 3.23, to allow for dramatic increase in the number of functions that were added. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Still about libmysqlclient.a?
Hi, There is a mistake and my last question. I am asking about libmysqlclient.a, not libmysql.a. And this is the case: I am using Perl's MySQL module which upon installation always asks me where libmysqlclient.a or libmysqlclient.so is. So, I guess even Windows users need those too. In order to get libmysqlclient.a, I tried to compile MySQL source distribution, but it failed detecting my OS during configure and exited with a message: "Could not find the right ps switches. Which OS is this?" I am using Cygwin gcc. Does anybody know how to work around my problem? Note: config.log attached Thanks. ~Agus~ > Hi! > > On Windows you should use libmysql.lib instead. You find it at > /lib/opt directory. > > Regards, > Miguel > >>I installed MySQL 3.23.32 binary distribution for Windows. >>I can't find libmysql.a in the lib directory. Where is it? Can anybody >>send me one? >> >>--- >>~Agus~ Get your small business started at Lycos Small Business at http://www.lycos.com/business/mail.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: Problem in myODBC(please help me)
> Hi, > My name is sanjeev gupta. I have installed the mysql on nt owrkstation and > also insatlle the myodbc drivers and i am trying to connect with mysql > using the odbc and it gave me error while i am trying too create file dsn. > the Error is followed > > <<...>> > and if i try to create a system DSN and test by using your admin utility > it gave a different error say Access denied for > [EMAIL PROTECTED](password:yes) > and i have given all previleges for admin. > can you please let me know why is it happening. > Thanks > Regards > Sanjeev > > > Sanjeev Gupta > Programmer Analyst > Indus Consultancy Services > [EMAIL PROTECTED] > 201-261-3100 x 264 > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: interesting problem
Yeah, just have your backend script parse the info it needs and just call two queries to make that happen. On Fri, 16 Feb 2001, Chris Toth wrote: > I have a form on a webpage for a simple trouble ticket system. When > requesting a computer be fixed, software be installed, etc...a faculty > member can go to this website and type in the info via an HTML form. > > My problem is, the form needs to be submitted to two different tables. All > of the faculty info(name, email, etc) goes into a faculty table. The actual > description of the request goes into a request table. But I also need to > insert the unique id that is given to the faculty member in the faculty > table INTO the request table. Because this is how I've related the two > tables. In the request table I have a foreign key(called requested_by) that > is the primary key of the faculty table. Is it possible for me to get the > primary key of the faculty table and insert it into the request table > through the same HTML form? > > Thanks, > chriz > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Difference of two datetime fields.
Hello, How could I obtain the difference of two datetime fields giving the result in seconds, like the function datediff in MSsql ? I tried date_sub but I had no success. Ex: 2001-02-16 15:00:00 - 2001-02-16 14:00:00=3600 seconds Thanks, Laercio Brehmer CIASC [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Perl DBI
Is it possible to connect to mysql without connecting directly to a database, check to see if a particular database exists, and if it doesn't exist create it? I have not been able to find a way of connecting to mysql without having a database already (I want perl to be able to make the db.. not have it already made before hand.) tia John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Please Help me ..Apache_1.3.17+php-3.0.16+mysql-3.23.32
I can't to compile this I'm getting the following error on my gmake (most snipped for brevity). gcc -DSOLARIS2=280 -DUSE_HSREGEX -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED -I/usr/local/include -I/usr/local/include/mysql `./apaci` -L/usr/local/lib -R/usr/local/lib \ -o httpd buildmark.o modules.o modules/php3/libphp3.a modules/standard/libstandard.a main/libmain.a ./os/unix/libos.a ap/libap.a regex/libregex.a lib/expat-lite/libexpat.a -R/usr/local/lib/mysql -L/usr/local/lib/mysql -Lmodules/php3 -L../modules/php3 -L../../modules/php3 -lmodphp3-lpam -lm -ldl -lsocket -lnsl -lresolv -lsocket -lnsl Undefined first referenced symbol in file mysql_get_client_info modules/php3/libphp3.a(mysql.o) mysql_drop_db modules/php3/libphp3.a(mysql.o) mysql_close modules/php3/libphp3.a(mysql.o) mysql_fetch_lengths modules/php3/libphp3.a(mysql.o) mysql_free_result modules/php3/libphp3.a(mysql.o) mysql_create_db modules/php3/libphp3.a(mysql.o) mysql_field_seekmodules/php3/libphp3.a(mysql.o) mysql_list_fields modules/php3/libphp3.a(mysql.o) mysql_fetch_row modules/php3/libphp3.a(mysql.o) mysql_real_querymodules/php3/libphp3.a(mysql.o) mysql_real_connect modules/php3/libphp3.a(mysql.o) mysql_stat modules/php3/libphp3.a(mysql.o) mysql_fetch_field modules/php3/libphp3.a(mysql.o) mysql_list_dbs modules/php3/libphp3.a(mysql.o) mysql_select_db modules/php3/libphp3.a(mysql.o) mysql_store_result modules/php3/libphp3.a(mysql.o) mysql_list_tables modules/php3/libphp3.a(mysql.o) mysql_data_seek modules/php3/libphp3.a(mysql.o) mysql_init modules/php3/libphp3.a(mysql.o) ld: fatal: Symbol referencing errors. No output written to httpd collect2: ld returned 1 exit status make[2]: *** [target_static] Error 1 make[2]: Leaving directory `/scratch/webdev/apache_1.3.12/src' make[1]: *** [build-std] Error 2 make[1]: Leaving directory `/scratch/webdev/apache_1.3.12' make: *** [build] Error 2 Thanks. Fabian Gonzalo [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JDBC question?
Had similar problem, get the current version of the driver. On Fri, 16 Feb 2001, Chen Ka Pong wrote: > Date: Fri, 16 Feb 2001 20:29:27 +0800 > From: Chen Ka Pong <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: JDBC question? > > I cannot use the jdbc connection which the driver is download > from mysql web site. The error message prompted that > "invalid JDBC Driver", what can cause this error? > I predict my classpath is wrong, but I would like to know > how to set the classpath? > (at this status, I am not sure if my classpath is correct or not) > > Thanks! > > Pong > Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: There are no DB defined space limits on MySQL Databases ?
--- Brian Reichert <[EMAIL PROTECTED]> wrote: > On Sat, Feb 17, 2001 at 03:23:49PM +0800, yindu wrote: > > There are no DB defined space limits on MySQL Databases ?It's > dangerours .How to control > > the database space on my database user? > > Filesystem quotas. But, to define filesystem quota, I will need to change de Owner of the file to the name of the respecive user right? Example: if the table belong to user max, I'll: chown max.users *.ISM Right?? []'s Fox W. Mulder __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connecting to 2 separate MySql databases
Hi, I know we can connect to 2 separate Mysql database's using Perl and the DBI module but can we connect to 2 different machines? One will be what we are using on our server and one our clients wants to be able to have on their servers. The reason I ask is that we are starting to license our web tools and our clients want their own database records which they are intitled to. Each company that we license to may have a different database and we may have to customize each program based on that database but I want to be able to make this as easy as possible. The database will be used for our website on the backend for members personal information. If users change personal info should we write to both databases? The database also needs to be able to update pages from sql calls for several items on these pages. I can imagine that it will get really slow if we have to do everything 2 times. So is there a better way? Something where we write and query to our database so the website will be at it's peak and then just update their database once or twice a day so they have the updated info. Are there problems with synchronizing things this way? If they delete items how will we know that this has happened. Or should we forget using our database and just connect to theirs for everything. Thus eliminating any problems with synchronization. Or just use ours and let them connect to this database when they need anything. Basically it is our software their information but we need it to be able to make the website work correctly. I need some help. Joe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
EXPLAIN output wierdness?
I have a concern regarding how an index is being used for a query. I've included the query (minus the fields) and the EXPLAIN output below. I'm curious why MySQL would indicate that it's using filesort for table 'd' since it's type is 'const.' The documentation indicates this means that only one row matched (which is true) and that it will use the fields from that table as constants through the rest of the query. Is this normal? The query is fast, but I want to make absolutely certain that it is perfectly optimized. select ...somefields... from thread a, user b, user c, forum d where d.forum_id=1 and a.forum_id=d.forum_id and a.forum_id = 1 and a.owner_id = b.user_id and a.reply_id = c.user_id order by modified desc limit 140,140 Here's the output of EXPLAIN: +---++-+-+-++--- ---++ | table | type | possible_keys | key | key_len | ref| rows | Extra | +---++-+-+-++--- ---++ | d | const | PRIMARY | PRIMARY | 4 | const | 1 | Using filesort | | a | range | forumupdate | forumupdate | 4 | NULL | 849 | where used | | b | eq_ref | PRIMARY,user_id | PRIMARY | 4 | a.owner_id | 1 | where used | | c | eq_ref | PRIMARY,user_id | PRIMARY | 4 | a.reply_id | 1 | where used | +---++-+-+-++--- ---++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Insert statement always makes value as 0
Can anyone see why maybe this set of select/insert statements always inserts a value
of 0 instead of the selected site id in the first select statement? The variable
$getid should hold the site id to be entered into the table ssx but its always entered
at 0 and I get no php or mysql errors. Any help would be appreciated, thanks.
$selectid="SELECT site_id FROM sites WHERE domain = \"$domain\"";
$getid = mysql_query($selectid);
echo mysql_error();
$hostsql2="INSERT INTO hostnames ( sid, hostname, ethernet_ip ) VALUES ( 'NULL',
'$hostname', INET_NTOA('$ethernet_ip'))";
$hostresult2=mysql_query($hostsql2);
echo mysql_error();
$details2="INSERT INTO details ( sid, os, home_dir, date, processor, memory, installs
) VALUES ( LAST_INSERT_ID(), '$os', '$home_dir', '$date', '$processor', '$memory',
'$installs')";
$detailsresult2 = mysql_query($details2);
$ssx2="INSERT INTO ssx ( id, sid, site_id ) VALUES ( 'NULL', LAST_INSERT_ID(),
'$getid')";
$ssxresult2 = mysql_query($ssx2);
Degerli dostumuz,Sizin goruslerinize ihtiyacýmýz var.
Degerli dostumuz,Liberal Demokrat Parti olarak her pazartesi saat 19.00'de , genel baskanýmýz sayýn Besim TIBUK'un da katilimlariyla düzenledigimiz "Halk Toplantilarýnda" sizi de aramizda gormekten onur duyariz... Yer : Balmumcu Liberal Demokrat Parti Genel Merkezi Saat : 19.00 Telefon: 0 212 27248 73 - 0 212 266 34 60 Url: www.ldp.org.tr E-mail : [EMAIL PROTECTED] ICQ : 105677326 Bizden mesaj almak istemiyorsaniz bu maili reply ediniz. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Check tables, BUG or JUST OPTION?
I'm running mysql 3.23.32, I did the test: With a running server I forced a kind of problem, I delete the MYI file. #mv contaComum.MYI contaComum.MYI.bck Then I run CHECK TABLE contaComum; It returns OK. If I restard server or execute a flush tables it'll show the problem. Should CHECK TABLE execute an automatic FLUSH TABLES? --- Tenha uma conta de email Grátis no ACBusca! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL-Excel data correlation
We have a ton of data in MS Excel that I need to put into a Solaris based MySQL dB. The data needs input such that it correlates across several different tables (i.e. I can't just do table dumps). What is the most efficient way to do this? Thanks, Valerie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GROUP BY gives inconsistent .. (more info)
By the way, if I rewrite the SQL without calculated fields, e.g.
instead of defining @MyYear, @StartMonth, and @EndMonth as variables
but rather duplicating the SQL to create a MyYear (and the others) column
and then inside the larger formula for Period, it works.
-- Jamie
The following statement:
SELECT Date, @MyYear := year(Date) AS MyYear, @StartMonth :=
floor((month(date)-1)/3)*3+1 AS StartMonth,
@EndMonth := floor((month(date)-1)/3)*3+3 AS EndMonth,
@Period :=
concat(left(monthname(concat('1-',@StartMonth,'-2000')),3),'-',left(monthname(concat('1-',@EndMonth,'-2000')),3),'
',year(date)) AS Period,
@Pgroup := CONCAT(@MyYear,@StartMonth,@EndMonth),
Avg(Operator_Courtesy) AS Courtesy,
avg(Operator_Knowledge) AS Knowledge,
avg(Operator_Etiquette) AS Etiquette,
avg(Overall_Impression) AS Overall FROM tbl_PhoneTester GROUP BY Period
gives incorrent and inconsistent results. Server 3.23.31.
...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GROUP BY gives inconsistent and wrong results using a calculated field
The following statement:
SELECT Date, @MyYear := year(Date) AS MyYear, @StartMonth :=
floor((month(date)-1)/3)*3+1 AS StartMonth,
@EndMonth := floor((month(date)-1)/3)*3+3 AS EndMonth,
@Period :=
concat(left(monthname(concat('1-',@StartMonth,'-2000')),3),'-',left(monthname(concat('1-',@EndMonth,'-2000')),3),'
',year(date)) AS Period,
@Pgroup := CONCAT(@MyYear,@StartMonth,@EndMonth),
Avg(Operator_Courtesy) AS Courtesy,
avg(Operator_Knowledge) AS Knowledge,
avg(Operator_Etiquette) AS Etiquette,
avg(Overall_Impression) AS Overall FROM tbl_PhoneTester GROUP BY Period
gives incorrent and inconsistent results. Server 3.23.31.
The resulting sql should give one row for every 3-month period as
defined by the Date field. I don't get all the groups.
If I group by Date instead of my calculated period, I see one row for
every unique date as expected.
Then, I switch the GROUP BY back to Period. The first try results in
three resultant rows, a null one (for null dates) Jan-Mar 1999 and
Jan-Mar 2000.
I run it again - no change - and get a fourth row the second and
subsequent times, Oct-Dec 1999.
Any idea what's going on?
Jamie
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: taxes
Ran into an interesting twist on "presence" in a state. One client went to a trade show in Nevada. She was informed that for the next quarter she would have to consider herself "in" Nevada, even though she did not sell anyting at the show. I don't think she is going back. On Thu, 15 Feb 2001, Mike Wexler wrote: > Date: Thu, 15 Feb 2001 14:03:33 -0800 > From: Mike Wexler <[EMAIL PROTECTED]> > To: Mikel King <[EMAIL PROTECTED]> > Cc: Brady Orand <[EMAIL PROTECTED]>, [EMAIL PROTECTED], > [EMAIL PROTECTED] > Subject: Re: taxes > > > > Mikel King wrote: > > > > guys I think you are making this a way bigger problem than it really > > is...e-merce crap is generally taxed based on the location of the > > vendor; much the same way in which mail order businesses are taxed. > > You really only have to worry about the state/locality in which you > > are incorperated/operate from, and in many cases this only applies to > > transactions that occur within those bounds. Meaning that both the > > vendor and the customer are in the same state. Really this is a > > matter for the bean counters, but thus far I've yet to buy anything > > even from Amazon that I have to pay tax on unless they are in my > > state. > > Actually it gets complicated for two reasons. On the web site I run > http://www.tias.com/ we have vendors in all 50 states. Second, if you > have a business presence in the state the customer is located in, then > you need to calculate the tax for *their* locality. So in the normal > case where you are calculating the taxes for just 1 vendors. Who has > only one location, then things can be simplified by dealing with only > the rules of the state (and the localities within the state). > > > > > cheers, > > mikel > > > > Mike Wexler wrote: > > > > > Actually its even more complicated than this. There are city taxes > > > and > > > other taxes on other boundaries. In addition the rules as far as > > > what > > > things are taxable vary by locality. For example, some localities > > > charge > > > taxes on shipping and others don't. > > > > > > Brady Orand wrote: > > > > > > > > This is not as easy (conceptually) as it sounds. You have to know > > > the > > > > current state tax plus any county taxes applicable. If you set up > > > a table > > > > with this information, you can cross reference the location of the > > > buyer > > > > with the table, calculate the appropriate taxes, and charge them > > > > accordingly. > > > > > > > > You must also make sure to record the taxes that were paid so they > > > can be > > > > paid to the appropriate tax agency. Not an easy task. > > > > > > > > There are sources out there for all of this information and you > > > can get tax > > > > tables on a CD that can be imported. > > > > > > > > Brady... > > > > > > > > Original Message Follows > > > > From: Mikel King <[EMAIL PROTECTED]> > > > > To: LDL Enterprise <[EMAIL PROTECTED]> > > > > CC: *MySQL mail list <[EMAIL PROTECTED]> > > > > Subject: Re: taxes > > > > Date: Wed, 14 Feb 2001 16:57:35 -0500 > > > > > > > > Wound't you just set a table with an id, state_abrev, & tax > > > columns. Then > > > > the id column will match the selection...et cettera...capisce > > > > > > > > LDL Enterprise wrote: > > > > > > > > > does anyone know how to calculateg taxes for a shop cart that > > > would set > > > > the > > > > > tax depending on the state that they select when filling out > > > their > > > > contact > > > > > information? Thanks. > > > > > > > > > > _ ___ > > > > > | | | \ | | > > > > > | |__ | |> || |__ > > > > > |||___/ || > > > > > > > > > > Larry L. > > > > > [EMAIL PROTECTED] > > > > > www.ldlenterprise.com > > > > > > > > > > > > > - > > > > > > > > Before posting, please check: > > > > >http://www.mysql.com/manual.php (the manual) > > > > >http://lists.mysql.com/ (the list archive) > > > > > > > > > > To request this thread, e-mail > > > <[EMAIL PROTECTED]> > > > > > To unsubscribe, e-mail > > > > <[EMAIL PROTECTED]> > > > > > Trouble unsubscribing? Try: > > > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > - > > > > > > > Before posting, please check: > > > > http://www.mysql.com/manual.php (the manual) > > > > http://lists.mysql.com/ (the list archive) > > > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > > > > > To unsubscribe, e-mail > > > > <[EMAIL PROTECTED]> > > > > Trouble unsubscribing? Try: > > > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > _ > > > > Get your FREE download of MSN Explorer at http://explorer.msn.com > > > > > > > > > > > - > > > > > > > Before posting, please check:
Re: MySQL CRM
On Fri, 16 Feb 2001, Steve Ruby wrote: > Does anybody know of any commercial or opensource CRM systems that > run with MySQL on Linux (and/or FreeBSD)? > > Mainly I need canned responses and ticket management and some other > standard features. Have a look at http://freshmeat.net/, where most of the OSC software is announced anyway. Regards, Jan-Aage -- Mr. Jan-Aage Bruvoll Managing Director Bruvoll Brains in Bits, 7a Neal's Yard, London WC2H 9DP, UK Office: +442072408283 Cell: +4792492482 Fax: +4792571158 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: transactions -- whole table locked from reads too?
My guess is that this is what was happening. I'm not sure of any way to confirm it though, how do I ensure that my select() is happening from a different database page then the insert? -Scott -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 10:38 AM To: [EMAIL PROTECTED] Subject: Re: transactions -- whole table locked from reads too? Scott, did you try to do the insert and select on the same database page? In BDB there is page level locking used, and the behavior you describe sounds like that the insert has placed a page level lock on the page where you try to do the select. Then it is correct behavior of the database that your select has to wait until the commit which releases the locks placed by the insert. A possible solution would be to use 'dirty read', i.e., non-locking read in select, but I do not know if BDB provides such. My own Innobase table handler allows you to read and insert data concurrently with no interference from locks, because Innobase does in a select a consistent non-locking read, in the style of Oracle. But MySQL/Innobase is not available yet, it will come out in MySQL 3.23.3x in a few days (see my posting a couple of hours ago). Regards, Heikki Tuuri Innobase Oy Helsinki, Finland - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Display information
Hello all again. I think I need to be a little more specific in describing my problem. So, let me try again. I have a database of scrap records. There are currently over 2000 records in this database. I have a web page that queries this database and displays the records in reverse order, newest to oldest. I use this query to do that... SELECT id,lot_id,lot_type FROM scrap_table ORDER BY id DESC LIMIT 0,10 which displays the last 10 records. If I want the next 10 records, I change the limit statement to look like this... LIMIT 10,10 which starts at the 10th record recovered and displays another 10, again from newest to oldest. I have a button on my web page that increments the number of records (LIMIT <##>,10) with each click on the "Pg Up" or "Pg Dn" button. Now, I don't want to page through eight or nine pages to get down to the record I'm looking for. I want to generate a query to display a range of 10 records starting with my entry. Now, the following query will work... SELECT id,lot FROM scrap_table WHERE id >=1880 and id <= 1890 ORDER BY id desc; but I don't always have the starting record number to work with. Now, the following suggestion seemed promising... SELECT id,lot_id,lot_type FROM scrap_table ORDER BY id limit 1932,10; seemed promising but it put them in oldest-to-newest order (ascending), not newest-to-oldest order (desc). When the "desc" qualifier was added, I got records 122 thru 113. Again, not exactly what I was looking for. What I was actually hoping for was something I could add to my original SELECT statement to perform the task if someone entered the ID but would show all (limit 10) if there was no entry. And, I wanted to do it without rewriting my code. Unfortunately, it looks like I may have to do a code rewrite for that section, which means documenting, testing, acceptance... Anyway, thanks for all the suggestions Ron suggestions vie email * > select id,lot_id,lot_type from scrap_table where id >= 1932 order by id > limit 10; > select id,lot_id,lot_type from scrap_table order by id limit 1932,10; > > either should work, i think the first would be faster but I'm not positive > how MySQL would handle the second in terms of optimization. > > -jm ** > If you simply needed the exact result here's the query > > SELECT id,lot_id,lot_type FROM scrap_table WHERE > id BETWEEN 1932 AND 1942 > ORDER BY id DESC ** > isn't it as simple as... > > select id,lot_id,lot_type from scrap_table > where id >= 1932 and id <= 1942 > order by id limit 10; > > ? > > cheers, > > P *** > Have a look in the manual, it says LIMIT [offset], rows, so you should say: > > order by id limit 1932, 10; > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
interesting problem
I have a form on a webpage for a simple trouble ticket system. When requesting a computer be fixed, software be installed, etc...a faculty member can go to this website and type in the info via an HTML form. My problem is, the form needs to be submitted to two different tables. All of the faculty info(name, email, etc) goes into a faculty table. The actual description of the request goes into a request table. But I also need to insert the unique id that is given to the faculty member in the faculty table INTO the request table. Because this is how I've related the two tables. In the request table I have a foreign key(called requested_by) that is the primary key of the faculty table. Is it possible for me to get the primary key of the faculty table and insert it into the request table through the same HTML form? Thanks, chriz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Switching from 3.22.32 to 3.23.33. What about the database files?
Tobias - You can continue to use the ISAM format or convert to the new MYISAM format (and other formats such as HEAP, I believe). See the 'mysql_convert_table_format' script in the bin directory. -karl Tobias Wolff wrote: > > Hello, > can anyone tell me whether or not I have to convert the database files when > switching from MySQL Version 3.22.32 to Version 3.23.33. I am working on > SuSe Linux 6.4. Is it sufficient just to copy the database files? > Thanks, > Tobias. > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Possible SHOW DATABASE || TABLE bug in 3.23.33
Sinisa Milivojevic wrote: > > Greg Cope writes: > > >Description: > > SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e > > a nice list of blanks - no of blank lines > > equals number of databases / tables) > > > > >How-To-Repeat: > > Do a mysqlshow or SHOW DATABASES under mysql in version 3.23.33 > > > > >Fix: > > > > >Submitter-Id: > > >Originator:Greg Cope > > >Organization: > > > > >MySQL support: none > > >Synopsis: SHOW command possiblxky broken in 3.23.33 > > >Severity: non-critical > > >Priority: low > > >Category: mysql > > >Class: sw-bug > > >Release: mysql-3.23.33 (Source distribution) > > > > >Environment: > > > > System: Linux server1.totallyradio.com 2.2.17-14 #1 Mon Feb 5 18:48:50 > > EST 2001 i686 unknown > > Architecture: i686 > > > > Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc > > /usr/bin/cc > > GCC: Reading specs from > > /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs > > gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) > > Compilation info: CC='gcc' CFLAGS='-O3 -malign-double -ffast-math > > -funroll-all-loops -fno-rtti -fno-exceptions -march=pentiumpro > > -fomit-frame-pointer' CXX='c++' CXXFLAGS='-O3 -malign-double > > -ffast-math -funroll-all-loops -fno-rtti -fno-exceptions > > -march=pentiumpro -fomit-frame-pointer' LDFLAGS='' > > LIBC: > > lrwxrwxrwx1 root root 13 Feb 13 10:46 /lib/libc.so.6 > > -> libc-2.1.3.so > > -rwxr-xr-x1 root root 4101836 Jan 15 15:49 > > /lib/libc-2.1.3.so > > -rw-r--r--1 root root 20273324 Jan 15 15:49 /usr/lib/libc.a > > -rw-r--r--1 root root 178 Jan 15 15:49 /usr/lib/libc.so > > Configure command: ./configure --prefix=/usr/local/mysql-3.23.33 > > --enable-assembler --with-mysqld-ldflags=-all-static > > --with-mysqld-user=mysql --localstatedir=/var/lib/mysql > > --sysconfdir=/etc --with-extra-charsets=complex --datadir=/var/lib/mysql > > --localstatedir=/var/lib/mysql --infodir=/usr/info --mandir=/usr/man > > --without-debug --without-bench > > Perl: This is perl, version 5.005_03 built for i386-linux > > > > Hi! > > As there are so many reports, we shall investigate a problem. > > Regards, > > Sinisa Thanks for the reply. I've narrowed this down to a possible issue with the mysqld binary - as I've two versions of mysql on my machine - 3.23.32 and .33. If I fire up .32 everything is fine. If I fire up .33 everthing appears fine until you do a "SHOW" command. Both binaries are setup with the same configure line and hence share the same data dirs (althought not at the same time ;-) Thanks again. Greg > > __ _ _ ___ == MySQL AB > /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic > /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] >/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus > /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| > /*/^^^\*\^^^ > /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: show database does not work ;-(
Rick Roberts wrote: > > mysql> select version(); > +---+ > | version() | > +---+ > | 3.23.33 | > +---+ > 1 row in set (0.01 sec) > > mysql> SHOW DATABASES; > +--+ > | Database | > +--+ > | mysql| > | test | > +--+ > 2 rows in set (0.02 sec) > > I'm using Mandrake 7.2. > I installed using the RPM > MySQL-3.23.33-1.i386.rpm Thanks Not much help to me mind ... Thanks again ;-( Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: show database does not work ;-(
mysql> select version(); +---+ | version() | +---+ | 3.23.33 | +---+ 1 row in set (0.01 sec) mysql> SHOW DATABASES; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.02 sec) I'm using Mandrake 7.2. I installed using the RPM MySQL-3.23.33-1.i386.rpm - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: There are no DB defined space limits on MySQL Databases ?
On Sat, Feb 17, 2001 at 03:23:49PM +0800, yindu wrote: > There are no DB defined space limits on MySQL Databases ?It's dangerours .How to >control > the database space on my database user? Filesystem quotas. -- Brian 'you Bastard' Reichert<[EMAIL PROTECTED]> 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: Display information
Have a look in the manual, it says LIMIT [offset], rows, so you should say:
order by id limit 1932, 10;
SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [HIGH_PRIORITY]
[DISTINCT | DISTINCTROW | ALL]select_expression,...
[INTO OUTFILE 'file_name' export_options][FROM table_references
[WHERE where_definition][GROUP BY col_name,...]
[HAVING where_definition]
[ORDER BY {unsigned_integer | col_name | formula} [ASC | DESC] ,...]
[LIMIT [offset,] rows]
Tobias.
-Ursprüngliche Nachricht-
Von: Ron Beck [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 16. Februar 2001 17:23
An: [EMAIL PROTECTED]
Betreff: Display information
Hello all,
I have a database with a little over 2000 records. I want to be able to
construct a query that says something like this...
select id,lot_id,lot_type from scrap_table
(part I need help with)
order by id limit 10;
which should give me records 1932 - 1942 like this...
+--+--+--+
| id | lot_id | lot_type |
+--+--+--+
| 1942 | 0034906 | F|
| 1941 | 0100308 | F|
| 1940 | 0036309 | S|
| 1939 | 0033503 | F|
| 1938 | 0034108E | D|
| 1937 | 0034712 | F|
| 1936 | 0029404 | F|
| 1935 | 0032706 | F|
| 1934 | 0029404 | F|
| 1933 | 0100307 | F|
| 1932 | 0100404 | F|
+--+--+--+
any suggestions?
Ron
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Display information
isn't it as simple as... select id,lot_id,lot_type from scrap_table where id >= 1932 and id <= 1942 order by id limit 10; ? cheers, P > > which should give me records 1932 - 1942 like this... > > +--+--+--+ > | id | lot_id | lot_type | > +--+--+--+ > | 1942 | 0034906 | F| > | 1941 | 0100308 | F| > | 1940 | 0036309 | S| > | 1939 | 0033503 | F| > | 1938 | 0034108E | D| > | 1937 | 0034712 | F| > | 1936 | 0029404 | F| > | 1935 | 0032706 | F| > | 1934 | 0029404 | F| > | 1933 | 0100307 | F| > | 1932 | 0100404 | F| > +--+--+--+ > > > any suggestions? > > Ron > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Display information
> select id,lot_id,lot_type from scrap_table > (part I need help with) >order by id limit 10; > > which should give me records 1932 - 1942 like this... > > +--+--+--+ > | id | lot_id | lot_type | > +--+--+--+ > | 1942 | 0034906 | F| > | 1941 | 0100308 | F| > | 1940 | 0036309 | S| > | 1939 | 0033503 | F| > | 1938 | 0034108E | D| > | 1937 | 0034712 | F| > | 1936 | 0029404 | F| > | 1935 | 0032706 | F| > | 1934 | 0029404 | F| > | 1933 | 0100307 | F| > | 1932 | 0100404 | F| > +--+--+--+ If you simply needed the exact result here's the query SELECT id,lot_id,lot_type FROM scrap_table WHERE id BETWEEN 1932 AND 1942 ORDER BY id DESC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL CRM
Does anybody know of any commercial or opensource CRM systems that run with MySQL on Linux (and/or FreeBSD)? Mainly I need canned responses and ticket management and some other standard features. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Display information
select id,lot_id,lot_type from scrap_table where id >= 1932 order by id limit 10; select id,lot_id,lot_type from scrap_table order by id limit 1932,10; either should work, i think the first would be faster but I'm not positive how MySQL would handle the second in terms of optimization. -jm -Original Message- From: Ron Beck [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 8:23 AM To: [EMAIL PROTECTED] Subject: Display information Hello all, I have a database with a little over 2000 records. I want to be able to construct a query that says something like this... select id,lot_id,lot_type from scrap_table (part I need help with) order by id limit 10; which should give me records 1932 - 1942 like this... +--+--+--+ | id | lot_id | lot_type | +--+--+--+ | 1942 | 0034906 | F| | 1941 | 0100308 | F| | 1940 | 0036309 | S| | 1939 | 0033503 | F| | 1938 | 0034108E | D| | 1937 | 0034712 | F| | 1936 | 0029404 | F| | 1935 | 0032706 | F| | 1934 | 0029404 | F| | 1933 | 0100307 | F| | 1932 | 0100404 | F| +--+--+--+ any suggestions? Ron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Possible SHOW DATABASE || TABLE bug in 3.23.33
Greg Cope writes:
> >Description:
> SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e
> a nice list of blanks - no of blank lines
> equals number of databases / tables)
>
> >How-To-Repeat:
> Do a mysqlshow or SHOW DATABASES under mysql in version 3.23.33
>
> >Fix:
>
> >Submitter-Id:
> >Originator:Greg Cope
> >Organization:
>
> >MySQL support: none
> >Synopsis: SHOW command possiblxky broken in 3.23.33
> >Severity: non-critical
> >Priority: low
> >Category: mysql
> >Class: sw-bug
> >Release: mysql-3.23.33 (Source distribution)
>
> >Environment:
>
> System: Linux server1.totallyradio.com 2.2.17-14 #1 Mon Feb 5 18:48:50
> EST 2001 i686 unknown
> Architecture: i686
>
> Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
> /usr/bin/cc
> GCC: Reading specs from
> /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
> gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
> Compilation info: CC='gcc' CFLAGS='-O3 -malign-double -ffast-math
> -funroll-all-loops -fno-rtti -fno-exceptions -march=pentiumpro
> -fomit-frame-pointer' CXX='c++' CXXFLAGS='-O3 -malign-double
> -ffast-math -funroll-all-loops -fno-rtti -fno-exceptions
> -march=pentiumpro -fomit-frame-pointer' LDFLAGS=''
> LIBC:
> lrwxrwxrwx1 root root 13 Feb 13 10:46 /lib/libc.so.6
> -> libc-2.1.3.so
> -rwxr-xr-x1 root root 4101836 Jan 15 15:49
> /lib/libc-2.1.3.so
> -rw-r--r--1 root root 20273324 Jan 15 15:49 /usr/lib/libc.a
> -rw-r--r--1 root root 178 Jan 15 15:49 /usr/lib/libc.so
> Configure command: ./configure --prefix=/usr/local/mysql-3.23.33
> --enable-assembler --with-mysqld-ldflags=-all-static
> --with-mysqld-user=mysql --localstatedir=/var/lib/mysql
> --sysconfdir=/etc --with-extra-charsets=complex --datadir=/var/lib/mysql
> --localstatedir=/var/lib/mysql --infodir=/usr/info --mandir=/usr/man
> --without-debug --without-bench
> Perl: This is perl, version 5.005_03 built for i386-linux
>
Hi!
As there are so many reports, we shall investigate a problem.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL errors during high activity
I know this has come up before, but I couldn't find a satisfactory solution. I'm running MySQL 3.23.23 on mandrake linux. It's used by a web site that has very high activity. During times of high activity, I find my perl scripts generating two kinds of errors: DBD::mysql::db selectrow_array failed: Lost connection to MySQL server during query at ... DBI->connect(games) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at The MySQL log does not errors. This happens both with Apache::DBI and plain DBI run at the command line. Does anyone have advice on getting rid of these errors? Thanks. -- -- smalltime industries brings you the latest in games, information, art, and interplanetary transport. Visit us at www.smalltime.com -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Different behaviour between 3.22.32 and 3.23.32
>Description: "SELECT MAX (record_id) FROM record;" iworks in 3.22.32 but fails in 3.23.32 In v3.22.32, both the following SQL commands work: mysql> SELECT MAX (record_id) FROM record; +-+ | MAX (record_id) | +-+ | 3010001 | +-+ 1 row in set (0.03 sec) mysql> SELECT MAX(record_id) FROM record; ++ | MAX(record_id) | ++ |3010001 | ++ 1 row in set (0.02 sec) But in v3.23.32 only one works: mysql> SELECT MAX (record_id) FROM record; ERROR 1064: You have an error in your SQL syntax near '(record_id) FROM record' at line 1 mysql> SELECT MAX(record_id) FROM record; ++ | MAX(record_id) | ++ |5040003 | ++ 1 row in set (0.00 sec) >How-To-Repeat: As above >Fix: Check all scripts and modify where required :-( >Submitter-Id: adsb >Originator:Andrew Benham >Organization: Nortel Networks Plc -- Andrew Benham [EMAIL PROTECTED] Nortel Networks Plc, London Road, Harlow, Essex CM17 9NA, United Kingdom Tel: +44 1279 402372Fax: +44 1279 405746 I speak for myself, my views are not necessarily the views of Nortel Networks or any other corporation. > >MySQL support: none >Synopsis: Change in SQL syntax happened >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-3.23.32 (Official MySQL binary) >Environment: System: HP-UX wharh05g B.10.20 A 9000/785 2016207775 two-user license Some paths: /usr/bin/perl /usr/bin/make /opt/corp/unsupported/bin/gmake /opt/corp/unsupported/gcc-2.8.1/bin/gcc /usr/bin/cc GCC: Reading specs from /opt/corp/unsupported/gcc-2.8.1/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.8.1/specs gcc version 2.8.1 Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include -fomit-frame-pointer -O6 -fpic' CXX='gcc' CXXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti -O6 ' LDFLAGS='' LIBC: -r-xr-xr-x 1 binbin1863680 Oct 8 1999 /lib/libc.1 -r--r--r-- 1 binbin2456372 Oct 8 1999 /lib/libc.a lrwxr-xr-x 1 root sys 15 Mar 21 2000 /lib/libc.sl -> /usr/lib/libc.1 -r-xr-xr-x 1 binbin1863680 Oct 8 1999 /usr/lib/libc.1 -r--r--r-- 1 binbin2456372 Oct 8 1999 /usr/lib/libc.a lrwxr-xr-x 1 root sys 15 Mar 21 2000 /usr/lib/libc.sl -> /usr/lib/libc.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-pthread --with-named-thread-libs=-ldce --disable-shared Perl: This is perl, version 5.004 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: COUNT(DISTINCT )
You can use: SELECT , count() FROM GROUP BY > -Original Message- > From: Franz, Fa. PostDirekt MA [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 16, 2001 3:02 AM > To: [EMAIL PROTECTED] > Subject: COUNT(DISTINCT ) > > > > Hi Everybody , > > I am using MySql 3.22.32 on LINUX. > My problem is , that 'SELECT COUNT(DISTINCT ) FROM > > doesn't work > like described in the HTML-manual (7.4.13) . > It even doesn't work at all. > Is tthat a bug , am I stupid , or is there any workaround. > > Greetings > Klaus > > Besuchen Sie uns auch im Internet: http://www.postdirekt.de > > Diese Mail ist von: > Deutsche Post Direkt GmbH > Beleglese Center Mannheim > > Klaus Franz > Manager Abgleichsysteme > > Willy-Brandt-Platz 13 Tel. 06 21.129 56 436 > 68161 Mannheim > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Switching from 3.22.32 to 3.23.33. What about the database files?
Hello, can anyone tell me whether or not I have to convert the database files when switching from MySQL Version 3.22.32 to Version 3.23.33. I am working on SuSe Linux 6.4. Is it sufficient just to copy the database files? Thanks, Tobias. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: show database does not work ;-(
Fred van Engen wrote: > > On Fri, Feb 16, 2001 at 02:18:11PM +, Greg Cope wrote: > > Dear All > > > > I've just installed mysql on a new host (3.23.33) and show databases > > does not work ;-(. > > > > Maybe it would help to read (or search) the list before posting. I have already searched the list, and it has not helped. > > There are several mails regarding this problem, among them a mail with > subject 'Some problems encountered when linked to glibc-2.2.1'. It > suggests a fix I believe. If the fix isn't clear, please repost your > (new) question. I'm not running MySQL on Linux, but someone else will > probably be able to help implement the fix then. I'm on glibc-2.1.3 I've narrowed this down to a difference between the mysqld binary. I just tried it on two near identical machines and there appears to be a bug bug. 3.23.32 works as expected - 3.23.33 does not - here at least. Greg > > Regards, > > Fred. > > -- > Fred van Engen XO Communications B.V. > email: [EMAIL PROTECTED] Televisieweg 2 > tel: +31 36 5462400 1322 AC Almere > fax: +31 36 5462424 The Netherlands > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Display information
Hello all, I have a database with a little over 2000 records. I want to be able to construct a query that says something like this... select id,lot_id,lot_type from scrap_table (part I need help with) order by id limit 10; which should give me records 1932 - 1942 like this... +--+--+--+ | id | lot_id | lot_type | +--+--+--+ | 1942 | 0034906 | F| | 1941 | 0100308 | F| | 1940 | 0036309 | S| | 1939 | 0033503 | F| | 1938 | 0034108E | D| | 1937 | 0034712 | F| | 1936 | 0029404 | F| | 1935 | 0032706 | F| | 1934 | 0029404 | F| | 1933 | 0100307 | F| | 1932 | 0100404 | F| +--+--+--+ any suggestions? Ron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Possible SHOW DATABASE || TABLE bug in 3.23.33
>Description: SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e a nice list of blanks - no of blank lines equals number of databases / tables) >How-To-Repeat: Do a mysqlshow or SHOW DATABASES under mysql in version 3.23.33 >Fix: >Submitter-Id: >Originator:Greg Cope >Organization: >MySQL support: none >Synopsis: SHOW command possiblxky broken in 3.23.33 >Severity: non-critical >Priority: low >Category: mysql >Class: sw-bug >Release: mysql-3.23.33 (Source distribution) >Environment: System: Linux server1.totallyradio.com 2.2.17-14 #1 Mon Feb 5 18:48:50 EST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O3 -malign-double -ffast-math -funroll-all-loops -fno-rtti -fno-exceptions -march=pentiumpro -fomit-frame-pointer' CXX='c++' CXXFLAGS='-O3 -malign-double -ffast-math -funroll-all-loops -fno-rtti -fno-exceptions -march=pentiumpro -fomit-frame-pointer' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Feb 13 10:46 /lib/libc.so.6 -> libc-2.1.3.so -rwxr-xr-x1 root root 4101836 Jan 15 15:49 /lib/libc-2.1.3.so -rw-r--r--1 root root 20273324 Jan 15 15:49 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 15 15:49 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql-3.23.33 --enable-assembler --with-mysqld-ldflags=-all-static --with-mysqld-user=mysql --localstatedir=/var/lib/mysql --sysconfdir=/etc --with-extra-charsets=complex --datadir=/var/lib/mysql --localstatedir=/var/lib/mysql --infodir=/usr/info --mandir=/usr/man --without-debug --without-bench Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: DROP COLUMN
Werner, Your syntax is correct and valid for MySQL. The problem could lie with your ODBC driver. What version are you on? Try downloading a utility for administering MySQL. UrbSQL is good from www.urbanresearch.com and see if that can drop the column. Good luck. Andy Woolley www.databasewatch.com - Original Message - From: "Wernher Korff" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 16, 2001 2:40 PM Subject: DROP COLUMN > hello list;) > > i have a SQL command to DROP a COLUMN from a mySQL database, the problem > is that the syntax i am using doesnt seem to be the right syntax for > mySQL, my statement currently read:"ALTER TABLE WorkGroups DROP COLUMN > Personnel" and i get the error message: > Error Type: > Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) > [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax > near 'Personnel'. > please help me, tis urgent that it works soon > > thanx regards wernher > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: transactions -- whole table locked from reads too?
Scott, did you try to do the insert and select on the same database page? In BDB there is page level locking used, and the behavior you describe sounds like that the insert has placed a page level lock on the page where you try to do the select. Then it is correct behavior of the database that your select has to wait until the commit which releases the locks placed by the insert. A possible solution would be to use 'dirty read', i.e., non-locking read in select, but I do not know if BDB provides such. My own Innobase table handler allows you to read and insert data concurrently with no interference from locks, because Innobase does in a select a consistent non-locking read, in the style of Oracle. But MySQL/Innobase is not available yet, it will come out in MySQL 3.23.3x in a few days (see my posting a couple of hours ago). Regards, Heikki Tuuri Innobase Oy Helsinki, Finland - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: show database does not work ;-(
Rick Roberts wrote: > > SHOW DATABASES; Sorry my subject line had the last S missing: mysql> 010216 15:29:14 1 Query SHOW DATABASES SHOW DATABASES; +--+ | Database | +--+ | | | | | | | | | test | +--+ 5 rows in set (0.01 sec) Are you using 3.23.33 ? Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
test
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def_password NULL
#define def_db_name NULL
MYSQL *conn;
int main(int argc,char *argv[])
{
conn=mysql_init(NULL);
mysql_real_connect(
conn,
def_host_name,
def_user_name,
def_password,
def_db_name,
0, /*port defaut*/
NULL, /*socket default*/
0);/*flag*/
mysql_close(conn);
exit(0);
}
I compile as follows:
gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \
-L/home/MySQL/MySQL/lib \
-lmysqlclient
then I get :
/home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
my_open.o(.text+0x14):undefined reference to 'open64'
/home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format':
mf_format.o(.text+0x201):undefined reference to '__lxstat64'
/home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
my_open.o(.text+0x21):undefined reference to 'fopen64'
nothing left to do with the situation, I beg your help. anyway I'm a
newcomer. thank you very much.
please send message to [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: show database does not work ;-(
On Fri, Feb 16, 2001 at 02:18:11PM +, Greg Cope wrote: > Dear All > > I've just installed mysql on a new host (3.23.33) and show databases > does not work ;-(. > Maybe it would help to read (or search) the list before posting. There are several mails regarding this problem, among them a mail with subject 'Some problems encountered when linked to glibc-2.2.1'. It suggests a fix I believe. If the fix isn't clear, please repost your (new) question. I'm not running MySQL on Linux, but someone else will probably be able to help implement the fix then. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Antwort: difference of two datetime values
On 16.02.2001 13:27:58 Vyacheslav Chukin wrote: > Please, tell me, > how could I determine, > which one of two datetime values is greater? Date1 < Date2 > In other words, > how could I determine, > is stored on db datetime value in future or past? Past: DbDateTime < NOW() Present: DbDateTime = NOW() Future: DbDateTime > NOW() > Before posting, please check: >http://www.mysql.com/manual.php (the manual) ^^ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can't connect in Windows 2000
Sorry, thought you were just having trouble teleneting to W2K server to run mysql or other exe's at command prompt. We ran into this because appartently W2K supports a different telnet that has to be started as a service before you can connect. Once it was running we had no problem coming into MySQL server. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Merge table problem.
Hello monty,
I'm trying to use merge table for logging - to have a possibility to
Rotate log files and to quickly delete old data - for this I'm goint
to setup a number of merge tables where each contains data for one
day, and the inserts are done to the last table using real table
name, therefore the select runs on merged table to cover all data.
Currently I found the followning problem which may lead to the
problems:
mysql> create table t1 (val char(10));
Query OK, 0 rows affected (0.00 sec)
mysql> create table t2 (val char(10));
Query OK, 0 rows affected (0.00 sec)
mysql> create table test (val char(10)) type=merge union=(t1,t2);
Query OK, 0 rows affected (0.00 sec)
mysql> insert into t1 values("a");
Query OK, 1 row affected (0.01 sec)
mysql> insert into t2 values("b");
Query OK, 1 row affected (0.00 sec)
mysql> select * from test;
+--+
| val |
+--+
| a|
| b|
+--+
2 rows in set (0.00 sec)
mysql>
as you see the result is correct and merge table reflects all changes:
mysql> insert into t2 values("b");
Query OK, 1 row affected (0.00 sec)
mysql> select * from test;
+--+
| val |
+--+
| a|
| b|
| b|
+--+
3 rows in set (0.00 sec)
Dublicates are also wellcome.
Let's add the key:
mysql> alter table t2 add key(val);
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> insert into t2 values("b");
Query OK, 1 row affected (0.00 sec)
mysql> select * from test;
+--+
| val |
+--+
| a|
| b|
| b|
+--+
3 rows in set (0.00 sec)
As you see the're starting to get incorrect result. The same thing
will be if I'll insert other different rows.
The only thing to fix this is to flush table test;
Other thing which also seems to be strange:
mysql> delete from t1;
Query OK, 0 rows affected (0.00 sec)
mysql> delete from t2;
Query OK, 0 rows affected (0.00 sec)
mysql> select count(*) from test;
+--+
| count(*) |
+--+
|2 |
+--+
1 row in set (0.00 sec)
mysql> select * from test;
+--+
| val |
+--+
| zzz |
| zzz |
+--+
2 rows in set (0.00 sec)
The last thing is unrepeatable. But I got this once during the tests.
Other tests show even more strange ting (this seems not to be key
related):
mysql> alter table t2 drop key val;
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> insert into t1 values("zzz");
Query OK, 1 row affected (0.00 sec)
mysql> insert into t2 values("zzz");
Query OK, 1 row affected (0.00 sec)
mysql> select * from test;
+--+
| val |
+--+
| zzz |
+--+
1 row in set (0.00 sec)
mysql>
--
Best regards,
Peter mailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
transactions -- whole table locked from reads too?
If I start a transaction (set autocommit=0 in the command line utility), then do an "insert" in one session, then open a second session and try to do a select on that table, before the first session has committed, the select just hangs. Once I commit in the first session, my select proceeds fine. Is there some reason the whole table seems to be locked from reads just because someone has an uncommitted transaction? The table type is BDB, it's running on Solaris 7/SPARC. Thanks for any help you can offer! -Scott - Scott McCool [EMAIL PROTECTED] (703)847-3303x2051 -
Re: SQL statement in PHP
Matt Davis wrote: Check the manual. The manual shows where following from. > > Can anybody help with this > > If I put the following statement in PHP my browser tells me that there is an > error on the line. > > //create sql statement > $sql = "select Business_Name,Trading_Details where Business_Type = > "Consultancy" and Bassingbourn != "0" from Main"; > > If I remove > > where Business_Type = "Consultancy" and Bassingbourn != "0" > > It work fine, but no variation of the above line works. Am I missing > something really obvious. Please help as I am very quickly becoming bald. > > Matt. > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DROP COLUMN
hello list;) i have a SQL command to DROP a COLUMN from a mySQL database, the problem is that the syntax i am using doesnt seem to be the right syntax for mySQL, my statement currently read:"ALTER TABLE WorkGroups DROP COLUMN Personnel" and i get the error message: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'Personnel'. please help me, tis urgent that it works soon thanx regards wernher - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
show database does not work ;-(
Dear All I've just installed mysql on a new host (3.23.33) and show databases does not work ;-(. The data directory is thus: drwxrwsr-x5 mysqlmysql4096 Feb 16 14:06 mysql Inside it has: [root@server1 lib]# ls -l mysql/ total 28 drwx--S---2 mysqlmysql4096 Feb 16 13:43 foo drwxrwxr-x 24 mysqlmysql4096 Feb 16 13:23 mysql -rw-rw1 mysqlmysql5769 Feb 16 14:09 server1.log -rw-rw-r--1 mysqlmysql 780 Feb 16 14:06 server1.totallyradio.com.err -rw-rw1 mysqlmysql 4 Feb 16 14:06 server1.totallyradio.com.pid drwx--2 mysqlmysql4096 Feb 16 13:23 test Which all looks normal. I can connect etc but show does not work - if I do : SELECT * on mysql.users; I get results. Is this a bug (in which case I do a full bug report) -- I have a feeling I am doing something very wrong that must be obvious ? A rather dazed and confused, Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't connect to MySQL when using PHP
I'm start MySQL with 'mysqld-opt --default-character-set=gbk'. I can use mysql connect to MySQL,and query. But I use PHP,it display: Warning: MySQL Connection Failed: Can't initialize character set 28 (path: default) in Why??? WinMe+Apache 1.3.17(Win32)+PHP 4.04pl1+MySQL 3.23.33 [EMAIL PROTECTED]
Re: taxes
Unless you have a physical location in that state! If you are in a state where Dell has a location you must pay that state's sales tax. Hey Vivek do you ever sleep! :) Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Vivek Khera" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 15, 2001 10:26 PM Subject: Re: taxes > > "MK" == Mikel King <[EMAIL PROTECTED]> writes: > > MK> guys I think you are making this a way bigger problem than it > MK> really is...e-merce crap is generally taxed based on the location > MK> of the vendor; much the same way in which mail order businesses > MK> are taxed. You really only have to worry about the state/locality > > What world (or country) do you live in? When was the last time you > ordered something from Dell or Apple on line? What tax rate did you > pay? You pay your local rate; not the rate of the location of the > store. > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Indefinite Timeouts
Mario Oschwald writes:
> Hi,
> Didn´t find this anywhere in the documentation...
>
> does -1 work if I want to set a Mysql timeout variable to indefinite??
>
> e.g. wait_timeout=-1
>
> Thanks
>
> Mario Oschwald
No, you will have to set a very large value.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
installation on hpux10.20 ends with ./mysql_install_db[284]: 13980 Memory fault(coredump)
Description: After having installed binaries, or compiled source code, mysql_install_db ends in a coredump How-To-Repeat: Fix: Submitter-Id: [EMAIL PROTECTED] Originator: Organization: MySQL support: [none ] Synopsis: install ends in coredump Severity: [ critical ] Priority: [ high ] Category: mysql Class: [ sw-bug ] Release:mysql-3.23.33 (Source distribution) Environment: HP9000/D270, OS HPUX10.20, gcc System: HP-UX server B.10.20 A 9000/861 Some paths: /usr/local/bin/perl /usr/local/bin/make /opt/gcc/bin/gcc /opt/gcc/bin/cc GCC: Reading specs from /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include' CXX='gcc' CXXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -r-xr-xr-x 1 binbin1863680 Nov. 10 1999 /lib/libc.1 -r--r--r-- 1 binbin2456532 Nov. 10 1999 /lib/libc.a lrwxr-xr-x 1 root sys 15 Juni 10 1996 /lib/libc.sl -> /usr/lib/libc.1 -r-xr-xr-x 1 binbin1863680 Nov. 10 1999 /usr/lib/libc.1 -r--r--r-- 1 binbin2456532 Nov. 10 1999 /usr/lib/libc.a lrwxr-xr-x 1 root sys 15 Juni 10 1996 /usr/lib/libc.sl -> /usr/lib/libc.1 Configure command: ./configure --with-pthread --with-named-thread-libs=-ldce --prefix=/usr/local/mysql --disable-shared --with-named-curses-libs=/usr/local/lib/libncurses.a --with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock --with-mysqld-user=mysql --with-libwrap Perl: This is perl, version 5.003 with EMBED - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1114: The table 'SQLb07dc_0' is full
> set SQL_BIG_TABLES = 1; You also will have to keep in mind that now that a filesystem is being used for the MySQL work you'll need the room to do it. In some cases the default MySQL install uses '/var/tmp' for it's chalkboard which in some OS installations, referring to UNIX of course, this is typically set too small for some larger SELECT requirements. Setting this tmp work to be done in a separate partition on a separate drive is the best (IMHO) but may be impossible in most situations. I personally avoid /tmp, unless it's mounted on a separate filesystem, due to the filling up of your / partition. You can find your tmpdir setting by typing in a MySQL client connected to a running server: show variables <-- Look for the tmpdir variable. You can then change the tmpdir setting in a number of ways all found in the manual. Here are a few considerations from a local filesystem installation of the MySQL-3.23.32 Docs: manual.html#Temporary_files manual.html#Command-line_options <-- Look for -t, --tmpdir=path manual.html#Programs <-- Discusses using environment variable TMPDIR You can also create an entry in your my.cnf (Version get's important here.) to point to a new tmpdir: tmpdir = /NEW_PATH/ On a different note, you might want to check your SELECT to see how well it's actually working by using the EXPLAIN command. In a MySQL client connected to a running MySQL server type: EXPLAIN SELECT [Rest of your statement.] This should give you a good idea as to why your SELECT is requiring more than what is `normal'. Finally, yes long winded, I'm assuming your not using 3.23.x since it has now changed to automatically creating disk-based temporary tables if it needs to. (Still a filesystem size requirement though.) You might want to upgrade depending on your situation. On Fri, 16 Feb 2001, Fred van Engen wrote: > On Fri, Feb 16, 2001 at 09:55:32AM +0100, Chappuis J.-Vincent wrote: > > Hi, > > I have this error when I execute a query : ERROR 1114: The table 'SQLb07dc_0' is >full > > I can execute other queries without problems but when I want to execute the query : > > > > there is always the same error message. > > How can I do to reset the table 'SQLb07dc_0' or to reset the sql buffer ? > > > > I've seen this when MySQL uses an internal table for temporary data. > There is a limit on the size of these tables. You can force MySQL to > use a file in its temporary directory to store the results: > > set SQL_BIG_TABLES = 1; > > An alternative is to do a SELECT SQL_BIG_RESULT ... instead of > SELECT ... . Note that SELECT SQL_BIG_RESULT doesn't work in 3.22.x, > though it is accepted by the parser. You don't mention which version > you use. 'set SQL_BIG_TABLES' works fine in 3.22.x. > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table timestamps? More specific control of "SHOW TABLE STATUS" command
Why don't you : select timestampfield from mytable order timestampfield decs limit 1 Jay Lawrence wrote: > > Atle, your suggestion is for the last time a record was updated. I am > interested in the entire table. > > The closest that I have seen thus far is: > SHOW TABLE STATUS > The Update_time field is most likely what I am after. > > However I was hoping to do something more like > > select Update_time from table(x) status > > Giving me one value back - the Update_time for table "x" of current > database. > > Perhaps this is a candidate for function extension? > > Jay > > > You might be able to use this, depending on your needs: > > > > from http://www.mysql.com/doc/D/A/DATETIME.html > > > > [snip] > > Automatic updating of the first TIMESTAMP column occurs under any of the > > following conditions: > > The column is not specified explicitly in an INSERT or LOAD DATA INFILE > > statement. > > The column is not specified explicitly in an UPDATE statement and some > > other column changes value. (Note that an UPDATE that sets a column to the > > value it already has will not cause the TIMESTAMP column to be updated, > > because if you set a column to its current value, MySQL ignores the update > > for efficiency.) > > You explicitly set the TIMESTAMP column to NULL. > > [/snip] > > > > > > .. Atle > > > > On Wed, 14 Feb 2001, Jay Lawrence wrote: > > > > > Hey all, > > > > > > Is there a way to quickly obtain the last time a table was > updated/touched? > > > > > > In my app I am caching queries so long as the table data has not > changed. I'd like a quick check to see if a table has changed since the > query was first executed. My perusal of documentation plus a few searches on > mailing lists has not uncovered this matter - but I could have missed it. > > > > > > TIA, > > > Jay > > > > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL statement in PHP
On Fri, Feb 16, 2001 at 12:43:15PM -, Matt Davis wrote: > Can anybody help with this > > If I put the following statement in PHP my browser tells me that there is an > error on the line. > > //create sql statement > $sql = "select Business_Name,Trading_Details where Business_Type = > "Consultancy" and Bassingbourn != "0" from Main"; > You need to escape the double-quotes in the double-quoted string. I don't know PHP, but usually something like below should work: //create sql statement $sql = "select Business_Name,Trading_Details where Business_Type = \"Consultancy\" and Bassingbourn != \"0\" from Main"; Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SQL statement in PHP
PHP sees the first " of "Consultancy" as being the end of the variable $sql. To get round this, change the " to ' inside the statement (e.g. ...where Business_Type = 'Consultancy' and...) HTH Jon -Original Message- From: Matt Davis [mailto:[EMAIL PROTECTED]] Sent: 16 February 2001 12:43 To: mysql Subject: SQL statement in PHP Can anybody help with this If I put the following statement in PHP my browser tells me that there is an error on the line. //create sql statement $sql = "select Business_Name,Trading_Details where Business_Type = "Consultancy" and Bassingbourn != "0" from Main"; If I remove where Business_Type = "Consultancy" and Bassingbourn != "0" It work fine, but no variation of the above line works. Am I missing something really obvious. Please help as I am very quickly becoming bald. Matt. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL statement in PHP
Take a look at your query once again: "select/../"Consultancy"/.../" You can have "" inside "". The ways to do it, so that it would work: -> use '$somethinghere' instead of "$something" or -> use \"$somethinghere\" instead of second "$something" or -> use '".$somthinghere."' instead of ... Cheers Siim Einfeldt > Can anybody help with this > > If I put the following statement in PHP my browser tells me that there is an > error on the line. > > //create sql statement > $sql = "select Business_Name,Trading_Details where Business_Type = > "Consultancy" and Bassingbourn != "0" from Main"; > > If I remove > > where Business_Type = "Consultancy" and Bassingbourn != "0" > > It work fine, but no variation of the above line works. Am I missing > something really obvious. Please help as I am very quickly becoming bald. > > > Matt. > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Indefinite Timeouts
Hi, Didn´t find this anywhere in the documentation... does -1 work if I want to set a Mysql timeout variable to indefinite?? e.g. wait_timeout=-1 Thanks Mario Oschwald - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Innobase + transactions & row level locks will be released in a few days in MySQL 3.23.3x
Hi, readers of the mailing list! Monty will roll a new distribution of MySQL 3.23.3x this weekend. Innobase will be included there and it will provide transactions, rollback, recovery, row level locking, and Oracle-like consistent read. Monty will leave for a vacation in Rio on Wednesday, so the new distribution should be ready at the latest on that day. Currently, Intel NT and Intel Linux versions have been tested. We will compile and test Solaris 32-bit and Linux Alpha 64-bit versions this weekend. Regards, Heikki Tuuri Innobase Oy Helsinki, Finland - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JDBC question?
If U R using some IDE, then there shd be a place to add on Ur classpaths. If not, from the prompt For Windows > java -classpath "c:\JDBCdriver;c:\JDBCdriver\driver.jar;." file.java For Unix> java -classpath "/tmp/JDBCdriver:/tmp/JDBCdriver/driver.jar:." file.java note: when including jar or zip U have to include the fileName. Cheers! Thiru PS: U find extensiv dos on setting classpath. go to www.javasoft.com On Fri, 16 Feb 2001 20:29:27 +0800 Chen Ka Pong <[EMAIL PROTECTED]> wrote: -> I cannot use the jdbc connection which the driver is download -> from mysql web site. The error message prompted that -> "invalid JDBC Driver", what can cause this error? -> I predict my classpath is wrong, but I would like to know -> how to set the classpath? -> (at this status, I am not sure if my classpath is correct or not) -> -> Thanks! -> -> Pong -> -o0o "There is no finish line, you can always learn" "You have to keep pressure on yourself, you have to work on your weaknesses". Thiru S/W Engineer, Service Dvlpment Group Infoseek,Japan Voice - (81)-3-5453-2056 http://www.infoseek.co.jp <- Click Here http://www.rakuten.co.jp <- Click Here http://house.infoseek.co.jp <- Click Here http://profile.infoseek.co.jp <- Click Here http://chat.infoseek.co.jp <- Click Here - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
deleting old records VS. index on datetime field (question about optimization)
Hi,
I have a table
DAY : DATETIME
CAT_ID : INT
DATA : TEXT
ID : INT
and I have to extract all records not older than 2 weeks with given
CAT_ID (sorted by DAY).
query for that is very simple, but what if this table has 1 000 000
records? Do you think that deleting records older than eg. 2 weeks would
accelerate all operation? And is it worth the price (no archive) ?
btw. of course query is performed on table with all needed indexes.
--
[EMAIL PROTECTED]
{ http://postmoderna.com ^ design studio }
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: difference of two datetime values
select if(columnname > now(), "future", "past") from tblname On Fri, 16 Feb 2001, Vyacheslav Chukin wrote: > Please, tell me, > how could I determine, > which one of two datetime values is greater? > > In other words, > how could I determine, > is stored on db datetime value in future or past? > > Best regards, mailto:[EMAIL PROTECTED] > Vyacheslav Chukin > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
"DELETE FROM mergetable" clears merge definition
>Description:
"DELETE FROM mergetable" clears merge definition
>How-To-Repeat:
mysql> use test;
Database changed
mysql> CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, message CHAR(20));
Query OK, 0 rows affected (0.04 sec)
mysql> CREATE TABLE t2 (a INT AUTO_INCREMENT PRIMARY KEY, message CHAR(20));
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO t1 (message) VALUES ("Testing"),("table"),("t1");
Query OK, 3 rows affected (0.11 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> INSERT INTO t2 (message) VALUES ("Testing"),("table"),("t2");
Query OK, 3 rows affected (0.01 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> CREATE TABLE total (a INT NOT NULL, message CHAR(20), KEY(a)) TYPE=MERGE
UNION=(t1,t2);
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> select * from total;
+---+-+
| a | message |
+---+-+
| 1 | Testing |
| 2 | table |
| 3 | t1 |
| 1 | Testing |
| 2 | table |
| 3 | t2 |
+---+-+
6 rows in set (0.03 sec)
mysql> delete from total;
Query OK, 0 rows affected (0.01 sec)
mysql> select * from total;
Empty set (0.00 sec)
!!! you can now also check that totals.MRG is empty !!!
mysql> select * from t1;
+---+-+
| a | message |
+---+-+
| 1 | Testing |
| 2 | table |
| 3 | t1 |
+---+-+
3 rows in set (0.00 sec)
mysql> select * from t2;
+---+-+
| a | message |
+---+-+
| 1 | Testing |
| 2 | table |
| 3 | t2 |
+---+-+
3 rows in set (0.01 sec)
mysql> alter TABLE total UNION=(t1,t2);
Query OK, 0 rows affected (1.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> select * from total;
+---+-+
| a | message |
+---+-+
| 1 | Testing |
| 2 | table |
| 3 | t1 |
| 1 | Testing |
| 2 | table |
| 3 | t2 |
+---+-+
6 rows in set (0.01 sec)
mysql>
>Fix:
Use a WHERE clause to specify which rows to delete.
>Submitter-Id: [EMAIL PROTECTED]
>Originator:Fred van Engen
>Organization:
XO Communications B.V.
>MySQL support: none
>Synopsis: "DELETE FROM mergetable" clears merge definition
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.33 (Source distribution)
>Environment:
System: SunOS lei 5.7 Generic_106541-07 sun4u sparc SUNW,Ultra-250
Architecture: sun4
Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc
GCC: Reading specs from /opt/gcc/lib/gcc-lib/sparc-sun-solaris2.7/2.8.1/specs
gcc version 2.8.1
Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS=''
LIBC:
-rw-r--r-- 1 bin bin 1693556 Sep 22 1999 /lib/libc.a
lrwxrwxrwx 1 root root 11 Oct 7 1999 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 bin bin 1115304 Sep 22 1999 /lib/libc.so.1
-rw-r--r-- 1 bin bin 1693556 Sep 22 1999 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Oct 7 1999 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 bin bin 1115304 Sep 22 1999 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/opt/mysql-3.23
Perl: This is perl, version 5.005_03 built for sun4-solaris
!!! The above is generated by mysqlbug on the system that MySQL runs on. The
!!! MySQL source was compiled on an identical system with gcc 2.95.2.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
