Make your auto_increment primary key something bigger than a TINYINT
> ive run into some trouble with a table not taking more then 128
> rows. I just use MySQL from my webpage, with PHP, and its all
> done by my host, so im a novice here. Anything i can do to get
> the table to accept more the
>Description:
The following line inputs the current UNIX time into a field -
date_start - with the date_stop filed defaulting to '0':
insert into contract_work (sess_id,email,date_start)
values('bde32bfde3ac89c7d510df573bb6bb88','Joe Bloggs',unix_timestamp())
The result is as follows:
ive run into some trouble with a table not taking more then 128 rows. I just use MySQL
from my webpage, with PHP, and its all done by my host, so im a novice here. Anything
i can do to get the table to accept more the 128 rows?
thanks folks.
DarthZeth
"Men never do evil so completely and cheerf
Check out Netsaint (www.netsaint.org) The current beta can be complied with
MySQL support.
David Price
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Van
Sent: Thursday, May 17, 2001 10:20 PM
To: MySQL
Subject: MySQL-Based System Monitoring Tool
Gre
I have 3 variations of a fairly simple aggregate query done on a medium sized table of
2 million rows.
Doing an ORDER BY makes the query go from less than a second to often taking 30
seconds.
Is this a bug ?
We're running on Free BSD 4.2 with Dual PIII 700mhz & 1GB RAM.
- Sam.
A. The o
any binary version for cobalt qube2 (mips processor) ??
have mysql ever tested install at cobalt qube/raq ??
how is it done?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.my
Does anybody know a good PERL list
Does anybody have a simple example of a PERL code connecting to a MYSQL
database??
I just want the syntax
Thanks
Siomara
_
Get Your Private, Free E-mail from MSN Hotmail at http://ww
> > In order to save space in our database, we designed our tables to use
> > enumerated datatypes. For one column, we have about 2,800
> > different values,
> > each of which is about 30-40 text characters long. Now, all the MySQL
> > documentation I have read states that the limit for the num
yes I did. ps shows the following
root 9066 0.0 2.1 2108 988 ?S10:23 0:00 /bin/sh
/usr/local/mysql/bin/safe_mysqld
root 9079 0.0 3.8 12084 1796 ?S10:23 0:00
/usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=
root 9081 0.0 3.8
> You can start the MySQL daemon with:
> cd /usr/local/mysql ; /usr/local/mysql/bin/safe_mysqld &
...
> [root@stupidsiteforjerks mysql-3.23.38]# /usr/local/mysql/bin/mysqladmin
> -u
> root -p password 'new-password'
> Enter password:
> /usr/local/mysql/bin/mysqladmin: connect to server at 'localho
Hello, all.
Having a small problem with MySQL and need some expert help. Trying to do a left
outer join on one table out of seven. As shown below the only table which may have
no row would be the pnotes table. Also shown below is the results I am getting (*use
a fixed font for proper vi
Recently, I've been trying to install MySQL on a redhat 7.2 system. I am
trying to do so from source. Everything seems to go well untill I have
to change the root password. Basicly the following happens:
Installing all prepared tables
010518 10:22:02 /usr/local/mysql/libexec/mysqld: Shutdown
Only way I can think of is to use a temp table:
CREATE TEMPORARY TABLE test (fruits varchar(100) not null) TYPE=HEAP;
INSERT INTO test SELECT DISTINCT fruits1 FROM table;
INSERT INTO test SELECT DISTINCT fruits2 FROM table;
SELECT DISTINCT fruits FROM test;
DROP TABLE test;
However this can be s
I think you're using it incorrectly. It should be:
grant insert on test.* to testuser@localhost identified by 'testpassword';
> I have successfully installed MySQL 3.23.38. I can start the server
> and log in as root. When I try to grant new users using:
>
> grant insert to test.* for testu
Perhaps in your case it would be better to use another table and do a join?
> Hi!
>
> In order to save space in our database, we designed our tables to use
> enumerated datatypes. For one column, we have about 2,800
> different values,
> each of which is about 30-40 text characters long. Now,
Does the table have an auto_increment column? If so:
select * from table where autoinccolumn = LAST_INSERT_ID();
> I wrote a program to keep inserting rows to the databases. But I
> want to check the LAST row I inserted. Is there any good way to do it??
--
Hi, everyone,
I wrote a program to keep inserting rows to the databases. But I want to check the
LAST row I inserted. Is there any good way to do it??
thanks,
Joe
Sinisa Milivojevic wrote:
>[EMAIL PROTECTED] writes:
>> >Description:
>> date_format is setting times to 12:00 AM; time_format works fine
>> >How-To-Repeat:
>> mysql> select start,TIME_FORMAT(start, '%l:%i %p') AS start2 FROM time;
>> +--+--+
>> | start| start2 |
>> +--
Hi!
In order to save space in our database, we designed our tables to use
enumerated datatypes. For one column, we have about 2,800 different values,
each of which is about 30-40 text characters long. Now, all the MySQL
documentation I have read states that the limit for the number of ENUM keys
If you look at the 'text' file you created with the 'dump', you'll see that
it contains all of the 'SQL commands' to recreate the tables and 'insert' the
data you've extracted.
So you simply type:
mysql mydbf_db < /mydir/mydbf.backup
(you might have to insert/add the -u and a username and
Don Pro writes:
>Hi,
>
>I back up my entire database with the following command:
>
>mysqldump --opt -p"password" mydbf_db > /mydir/mydbf.backup
I've got:
mysqldump -h mysql.io.com -u "user" -p --opt "database" >! backup-file.sql
mysql -h mysql.io.com -u "user" -p "database" < backup-f
cool, thanks! I don't know why I was using LEFT JOINS :)
What would I do if I wanted to go the other way... ie see everyone who
reports to Bob?
Also, won't this query return blank if you can't go "up" 2 levels to S3?
Thanks!
Graeme
- Original Message -
From: "Dibo Chen" <[EMAIL PROTEC
Hi,
I back up my entire database with the following command:
mysqldump --opt -p"password" mydbf_db > /mydir/mydbf.backup
Does anyone know the counterpart command to restore from the backup
file?
Thanks,
Don
-
Before posting,
Hello
I am trying to install DBD-mysql, i have installed all the requisites
that its needs :
1. Perl ==> ActivePerl-5.6.1.626
2. MySQL ==> Ver 9.38 Distrib 3.22.32
3. DBI ==> DBI-1.15
4. C compiler and Gzip libraries are included in the installation of Linux
, but when i run the make tol
try:
select s3.name from staff s1, staff s2, staff s3
where s1.id = 1 and s1.reportsto = s2.id and s2.reportsto = s3.id
"Graeme B. Davis" wrote:
>
> I have a staff database which contains a column that has a "reports to"
> field.
>
> If I have a table like this:
>
> IDNameReports To
>
I have a staff database which contains a column that has a "reports to"
field.
If I have a table like this:
IDNameReports To
1 Graeme 5
3 Bob 6
5 Sue 3
How can I (in one query) find the next 2 levels of people that Graeme
reports to?
Ie, I
Hi!
A bug fix patch:
If you do a lot of inserts into a table and a column in a secondary
index contains NULL values, then the insert buffer may overflow,
causing an assertion failure in ibuf0ibuf.c, line 2264. A fixed
mysql/innobase/ibuf/ibuf0ibuf.c can be downloaded from
http://www.innobase.fi
Hi
I am attempting to run the compiled version of mysqlgui on RedHat 7.0
The mysql.sock socket is located in /var/lib/mysql/mysql.sock on RedHat 7.0
Whereis is mysqlgui trying to locate the socket.
Thanks
Stan
--
Stan Gruszka
System Administrator
IP Applications (Canada) Corp
Suite 154, 555 S
Dibo Chen wrote:
> probably there are spaces?
D'oh! Yes, a leading space.
This query...
select length(streetnum),streetnum from main where streetnum=3411;
produced a length of five, not four.
I'll use the trim() function & compare apples to apples. :) Thanks!
--
Tired of Earthlink? Get Jus
I have successfully installed MySQL 3.23.38. I can start the server
and log in as root. When I try to grant new users using:
grant insert to test.* for testuser identified by 'testpassword';
It comes back saying 0 rows affected. I can go the the MySQL db
and look at the grant table and it
>Description:
Using MATCH in select-clauses returns:
ERROR 1030: Got error -1 from table handler
>How-To-Repeat:
Table:
CREATE TABLE files
(id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
filename BLOB,
commen
I'm trying to add php support into apache and the 'make' command fails.
mysql-3.23.38 installed fine and I ran some tests and everything is working.
php-4.0.5 also installed fine (but don't know how to test it from the
command line). The apache configure also went fine:
[root@dns2 apache_1.3.14]
Dibo Chen wrote:
> try SELECT * WHERE x like '3411'.
Like doesn't work either. I tried it.
mysql> select ppn from main where streetnum=3411;
+---+
| ppn |
+---+
| 01A003290 |
| 01A016440 |
+---+
2 rows in set (3.04 sec)
mysql> select pp
At 11:36 18/05/2001 -0400, Michael Britton wrote:
Hi,
That error message should means: the server wasn't started or the
client wasn't able to connect for privileges issues.
The server you should use is: mysqld-nt.exe
The recommended way on NT is as service so install it by:
\mysql\bin\mysqld-n
try SELECT * WHERE x like '3411'.
Steve Sobol wrote:
>
> I have a varchar field that contains the street number (part of a
> mailing address). It's a varchar because the field may occasionally
> contain non-numeric characters, but normally it doesn't.
>
> Let's call the field "x".
>
> I have a
I am intersted in your MySQL GUI. Any specs available ?
Will the software be at a cost ?
Are you looking for distributors ?
I am an independant consultant in France and enthused by free software field.
Yours truly,
Michel Demonfaucon
Ahimsa
I have a varchar field that contains the street number (part of a
mailing address). It's a varchar because the field may occasionally
contain non-numeric characters, but normally it doesn't.
Let's call the field "x".
I have a record where x='3411'.
In spite of the fact that x is a varchar, the
I have two columns in a table I need to get distinct values out of. I
know I can get distinct combinations of the values of the two columns with
"SELECT DISTINCT fruits1, fruits2" but what I need is unique values among
the two. So that if in fruits1 I have values "apples" and "oranges", an
System: NT 4.0
mysql Ver. 8.2 Distrib 3.22.34, for Win95/Win98 on i586
I'm unable to access mysql server on port 3306. Error reads: Can't connect
to MySQL server on 'localhost' (10061). Does this mean it's not on 3306?
How do I get it there? Do I have the wrong version and do I need to
down
Hi Van,
I use a program called netsaint. (netsaint.sourceforge.net) It
uses mysql or postgresql for almost everything. The history file is
still flat ASCII, but its on the todo list to move it to the mysql
database. (it's the only file that has NOT been put into a
database!). The mysql p
According to Chili's website they do support 3.23
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
-Original Message-
From: Putri Alam [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 18, 2001 10:46 AM
To: '[EMAIL PROTECTED]'
Subject: my
I don't know why it would HAVE to have that exact version, the newer
versions should be backwards compatible. I do believe that you should be
able to get a Win32 version, it just may be hard to track down an old version.
At 10:46 AM 5/18/2001 -0400, Putri Alam wrote:
>Hi,
>
>Does mySQL 3.22.32
On Fri, 18 May 2001, Kip Turk wrote:
>
> Is it possible to make this type of logical command in MySQL?
>
> if ((x == y) or (x == z)) { response1 }
> else { response2 }
>
I'll go ahead and follow up my own post, as I found a solution, using
regexp. Here's a test case I ran if anyone else is
Our solution to this was installing myODBC on the NT Server and connecting
in this fashion:
Dim Conn_STRING
Conn_STRING =
"driver={mysql};database=dbname;uid=uname;pwd=password;option=16386;"
set rsRecordSet = Server.CreateObject("ADODB.Recordset")
rsRecordSet.ActiveConnection = Conn_STRING
This
Hi,
Does mySQL 3.22.32-1 work on Windows 98? My ISP is using Chili!Soft ASP
which only talks to mySQL 3.22.32-1, therefor mySQL 3.23 is out of the
question.
Any reply is greatly appreciated.
Putri Alam
US-ASEAN Business Council
Washington, DC
that is because you are calling a script using cgi from the command prompt.
that's really a question for a perl/cgi group.
cgi's are intended to be run from the web.
i think you can just press Ctrl+D (or Ctrl+Z - can't remember which) when you get that
prompt to continue.
- Original Mess
Is it possible to make this type of logical command in MySQL?
if ((x == y) or (x == z)) { response1 }
else{ response2 }
>From what I can see the sql if statement will only handle one argument on
the LHS. Can this be done, or do I need to look at multiple queries and
then combine the
You don't use telnet or ftp to connect to the MySQL server.
You use the client "mysql".
Rodolfo Baselli wrote:
> Hi
> I've got a MySQL box running on a PIII/700 with SuSE Linux 6.4 and
> cannot connect to it via telnet and ftp.
> I have my telnet prompt back as I stop the MySQL server daemon (f
Hi Ashutosh,
You can try a tool like MySQLX which was specifically developed for MySQL
and ASP, see: http://www.scibit.com/MySQLX
or any of the other ASP API interfaces in the mysql Contrib section.
Regards
Jacques
http://www.scibit.com/mysql
> -Original Message-
> From: ASHUTOSH SHARMA
I am moving all my web-hosting stuff for my company in-house (finally)!
Thanks to Dell's price cuts and Mpower DSL connection (at an unbeatable
price) I am able to bring in-house most of the stuff (including fabulous
MySQL database) BUT the Real
Audio/Video server. I need a plan that gives me Rea
try connect with a minimal script, like this (I didn't try it) :
#!/usr/bin/perl -w
use strict;
use CGI;
use DBI;
my $dbh;
print "something before connect";
$dbh = DBI->connect("DBI:mysql:$database", "$username", "$password") or die
"Couldn't connect to database: " . $dbh->errstr;
print "somet
Hi
I've got a MySQL box running on a PIII/700 with SuSE Linux 6.4 and
cannot connect to it via telnet and ftp.
I have my telnet prompt back as I stop the MySQL server daemon (from the
console ;-)).
The MySQL client login is always straight, it never fails and I get the
mysql> prompt immeditely.
Ha
Hi,
I tried to connect to the database, when I compiled it, it replied with
"(offline mode: enter name=value pairs on standard input)" - What is
this meant?
Below is my code:
#!/usr/bin/perl -w
use strict;
use CGI;
use DBI;
my $dbh;
my $sth;
my @row;
my $form = new CGI;
print $form->header;
Can some one let me know about the URL to go through
the mysql Admin issues.
Regards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
---
In message <001301c0ddf3$49e1cc60$12ffa8c0@notodo>, Martin Cabrera
Diaubalick <[EMAIL PROTECTED]> writes
>Hi there!
>
>I installed MyODBC and tried to import a Database from my Web Hosting
>account but didn't let me. Was it me that didn't know how to do it or is it
>possible that access is only a
Amy Wan wrote:
>
>> Hi all,
>> I have a regular table like this
>>
>> CREATE TABLE MediaChannel
>> (
>> MediaChannelID INT NOT NULL,
>> Medium VARCHAR(5) NOT NULL,
>> CallLettersVARCHAR(12) NOT NULL,
>> StationNickNameVARCHAR(
Hi,
We run mysql V3.22.32 (solaris 2.5.1 version ) on a Solaris 2.6 box. The
top command shows the mysqld running at 98.3% of cpu time when the
system is idling. On a Solaris 7 box runnning Solaris 7 running
mysql-3.22.32 (solaris 7 version) but also idle, the top command shows
0.5% for the mysql
Fariba Noorbakhsh writes:
> Hi,
>
> I want to install mysql for unix machine (digital/compaq)
> alphav56-dec-osf4.0d.
> Is there any version of mySQL for this version of digital unix?!!!
> I tried to ftp a version called
> "mysql-3-23-25-beta-dec-os4_0f-alphaev6_tar" and I have a problem with
> i
Hi,
I want to install mysql for unix machine (digital/compaq)
alphav56-dec-osf4.0d.
Is there any version of mySQL for this version of digital unix?!!!
I tried to ftp a version called
"mysql-3-23-25-beta-dec-os4_0f-alphaev6_tar" and I have a problem with
instalation manual:
I can't find the Make
Nothing is running.
I tried removing the socket mysql.sock and trying reconnect, but it creates
a new socket mysql.sock and mysql is not running.
I know this kind of problem is known, but I never found a solution.
> -Original Message-
> From: Rolf Hopkins [SMTP:[EMAIL PROTECTED]]
> Sent:
You're MySQL server is not running. Start the MySQL server.
Linux: /etc/rc.d/init.d/mysql start (as root)
If you're trying to access MySQL on another host then you need to specify that host on
the
command line:
mysqladmin -h
Radu Adam schrieb:
> so ... this is another story:
>
> mysqladmin:
respected sir,
i have a problem regarding connectivity between ASP and mysql.
will it possible to connect asp with mysql if yes then how we can do it
will it need any driver if yes then from where we get that driver ..
will i get some tutoril in this matter...
thanking you
ashutosh
[EMAIL PROTECTED] writes:
> >Description:
> date_format is setting times to 12:00 AM; time_format works fine
> >How-To-Repeat:
> mysql> select start,TIME_FORMAT(start, '%l:%i %p') AS start2 FROM time;
> +--+--+
> | start| start2 |
> +--+--+
> | 12:00:00
How can I use transactions in mySQL ver. 3.23.38-nt?
Tel.: 0422-678874
mailto:[EMAIL PROTECTED]
Carlo Scalet
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
so ... this is another story:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
(111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
Indeed there is no mysql.sock at
Hi,
Well, I also had the same problem and finally traced the bug down
to a file called db_readdump.php3 in phpmyadmin directory.
If you'r still having the problem, may be this is helpful to you too.
edit db_readdump.php3 and add in the beginning of the file
$db = trim($db);
Then at the
- Original Message -
From: Fayed Design
To: [EMAIL PROTECTED]
Sent: Friday, May 18, 2001 1:14 PM
Hello to all of you,
does anybody know how to connect an Java Applet with mySql.I am trying already since
weeks,no success.
It always response no suitable Driver although I uploaded the
has it already started? ps -ef | grep mysql
- Original Message -
From: "DEVOS BASTIEN" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 18, 2001 19:11
Subject: mysql start failed.
> Here's a problem I have when trying starting mysql.
> Config : RH7.0, MySQL 3.23.32, kerne
-p is for when you have a password set, but you don't have one set yet.
password is used to set or change the password but it needs a parameter
following it, the new password.
You did install mysql from the mysql web site, not RH's mysql, didn't you?
- Original Message -
From: "Radu Ada
Hello,
we're using mysql 3.23.33 on a separate Linux server, but about 50% of all
connections go wrong and get an error like this: "Aborted connection 84620
to db: 'xxx' user: 'yyy' host: `aaa.bbb.cc.ddd.' (Got timeout reading
communication packets)". There are 3 frontends (Sun) webservers. We'r
Here's a problem I have when trying starting mysql.
Config : RH7.0, MySQL 3.23.32, kernel2.4.3.
I read that there's a problem with RH7.0 and that a ´chown -R mysql
/var/lib/mysql´ should resolve that, but it doesn't change anything.
always this message :
010518 13:00:22 mysqld started
010518 13
I posted a question yesterday ... I installed RedHat Linux 7.1 with MySQL on it but it
doesn't let me do anything. This is what happens:
[root@lambda /root]# mysqladmin -u root password
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using pa
Fengxian Guo writes:
> how do i start mysql gui interface in sun solaris 2.7 sparc ?
>
>
>thanks very much
Hi!
There is a README that comes with a source and binary distros.
If you do not have one, please let me know.
If you find problems, then again let me know.
Re
> Use ints and bigints?
INT much use I's afraid.
I want external data processing to get back a format that
it can use, but still want to be able to use the MYSQL
date functions, which are excellent.
A better idea would be TIMESTAMPS(14) but these suffer from
the 32bit int 2037 problem (aka the Y
add this:
$sth -> finish;
$dbh -> disconnect;
to the end
- Original Message -
From: "Simon Chan" <[EMAIL PROTECTED]>
To: "mysql Mail List" <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 11:44 PM
Subject: DBI:mysql error message
> Hey everybody,
>
>
> This is my perl DBI script:
Hi,
I heard something about a master election feature or something that will decide if a
server
would act as master or slave in a mysql replication "cluster"..
But that was for version 4.0 ?
I'm currently trying to set up a solution where all mysql machines starts up with no
slave or
mast
Andrew Wafula wrote:
>
> Hello,
>
> I have installed the mysql-max version 3.23.38 and I
> now have a problem with mysql. Whenever I try to
> access mysql I get an error when loading mysql.so that
> mysql_init is an undefined symbol.
>
> Where could the problem be?
>
> Andrew
>
>
Hi
No not all versions. You have to have either BDB, InnDB or GEMINI to use
transactions. The new mysqld-max has either BDB or InnoDB and some have
Both.
Regards
~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell
Does MySQL for Windows support transaction ?
If YES, all version ?
Thanks a lot.
--
K Free E-mail http://www.k.ro/
by KappaNet http://www.kappa.ro/
-
Before posting, please check:
http://ww
Hello,
I have installed the mysql-max version 3.23.38 and I
now have a problem with mysql. Whenever I try to
access mysql I get an error when loading mysql.so that
mysql_init is an undefined symbol.
Where could the problem be?
Andrew
80 matches
Mail list logo
