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 "admi
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 a
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 info
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?
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
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,
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
-
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:
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 tel
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
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.c
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 t
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 i
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
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 f
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 rep
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
distributio
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 a
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
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, th
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
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 Ever
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 s
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 (unsor
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 Alp
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
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 conne
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/
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 m
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
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
>
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
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 u
> >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 funct
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
> 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
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
> memb
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]
---
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 h
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.
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 downl
--- 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 quot
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 we
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 on
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
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 :
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
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
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 statemen
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
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 200
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
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,
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
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
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 d
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
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 se
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
M
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. #303
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][FRO
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 |
> +--+
> 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|
>
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
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
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:
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 fa
>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) |
+-+
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
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.
--
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
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...
+-
>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
>
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
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 y
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.0
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
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 ma
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:
DbDateT
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 M
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
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
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
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 Pr
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
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
[E
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]
- Origina
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
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:
> 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
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
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
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:
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 '".$somthingh
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/m
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
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
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
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 pas
>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, mes
1 - 100 of 125 matches
Mail list logo
