mysql_query (connection, qbuf); seems to hang if the disk is
full. Surely this isn't right. The command line utility
reports "disk full" but my poor C program hangs never
to return from this call. What's up with that?
(FreeBSD/Whatever version of MySQL was current this summer)
--
With fo
Dear Members,
I installed RedHat 7.1, Apache, PHP4 and MySQL in a Intel Pentium processor
system.
Everything works fine (i.e. MySQL, PHP, etc). But when I want to connect
MySQL through PHP. It is giving an error 'call to unknown function
"mysql_connect" in line in __' .
Can any one provide a solut
I'd like to know if mysql.sock comes with a linux installation as I have
follwed the instructions to install linux but it always says
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2) . but mysql.sock does not seem to be
anywhere
on my linux machine
t
HELP!!
Can someone PLEASE help me with this issue?
-Original Message-
From: Gill, Vern [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 12:47 AM
To: '[EMAIL PROTECTED]'
Subject: FW: compile errors
Anyone able to help with this? O
Version 3.23.46-max on a dual Xeon RedHat 7.2 machine with all RedHat
patches and their latest -smp kernel.
I turned on binary logging on a particular database with binlog-do-db= and
later try this:
mysqlbinlog -uroot -pxxxyyy binlogfilename-bin.001
It shows me the inserts and deletes that were
Hi,
I think indexing the column(s) can help you. But there are certain
criteria before you use indexs (like number of duplicate values in the
column ..blah blah..)
u can find more on this page
http://www.linux-mag.com/cgi-bin/printer.pl?issue=2001-06&article=mysql
i hope this will help you.
Neer
Hi,
Thanks for your clue. Please provide me with additional details as to how
should I go about doing this (making Mysql use MacRoman encoding).
1)About compiling a particular character set with mysql, the manual says:
MYSQL MANUAL: shell> ./configure --with-charset=CHARSET
CHARSET may be one o
I downloaded and installed the new patch from Borland that allows Kylix to
use versions of MySQL 3.23 and newer. Most of the errors on connection
stopped and it seems to connect. What I am getting now is a
"username/password invalid" error. I have connected with Webmin, MySQL at a
prompt and kmys
Hi,All:
I need your help, When I compile the Msql-Mysql-Modules, I got errors, I am
running Redhat7.1 with perl5.6.1, the whole process is just as follows:
[root@wappy local]# cd Msql-Mysql-modules-1.2218
[root@wappy Msql-Mysql-modul
Hi again Florin,
- Original Message -
From: "Florin Andrei" <[EMAIL PROTECTED]>
> SELECT event.cid, iphdr.ip_src, iphdr.ip_dst, tcphdr.tcp_dport FROM
> event, iphdr, tcphdr WHERE event.cid = iphdr.cid AND event.cid =
> tcphdr.cid AND tcphdr.tcp_flags = '2';
Your only search condition i
Hi all,
I have written to this mailing lists twice before, but nobody seems
responds. Please help, this charset problem is very disturbing.
In my case I need to import text files with "MacRoman encoding" into mysql.
I am working on Mac OS X. How do we get support for this encoding?
Regards,
K
Hi,
If I have a SELECT that returns a large number of results, say > 1000, then
returns the results for the SELECT takes much over an order of magnitude longer
than if the results set had been, say, 100.
Now, is there any way I can quickly return the length of the result set withotu
actually ret
Hello,
I created the entries by adding them manually to the table (not using
GRANT). And yes, I did run FLUSH PRIVILEGES. Anything else I should try
doing? The MySQL manual didn't really provide much help.
Thanks!
Tyler
- Original Message -
From: "Carsten H. Pedersen" <[EMAIL PROTECT
I can't speak for other table formats but in MyIsam tables you can take your
database down, rename the table's files (.frm .MYI .MYD), and restart the
server. I'd make a backup if you are going to try it, though.
Jon Gardiner.
> -Original Message-
> From: Alex Pukinskis [mailto:[EMAIL P
Ah, I finally found mention of this in the manual.
Sorry to bother everyone.
Thanks.
---
Hello,
To use InnoDB you have to put how large of a file MySQL is allowed to make by putting
an entry in /etc/my.cnf such as the one I used:
innodb_data_home_dir =
Hi Florian,
- Original Message -
From: "Florin Andrei" <[EMAIL PROTECTED]>
> I have this SQL query:
> SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2 WHERE \
> tbl1.col3 = tbl2.col4 AND tbl1.col5 = '123';
> (well, maybe there are more than two columns selected, and maybe a
> little more t
Alex Pukinskis writes:
> mysql> ALTER TABLE 'group' RENAME groups;
> ERROR 1064: You have an error in your SQL syntax near ''group' RENAME
> groups' at line 1
It should be ` (backtick) rather than ' (apostrophe/single quote). This
is explained i the manual section on table/column names if I'm
Chip,
> > I have a database with 12 tables. I am running a query to select certain
> > fields
> > from 3 of the tables, like this -
> >
> > select Title, Details, StartDate, City, State
> > from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations
> > where phpCalendar_Details.Event
Florin Andrei writes:
> SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2 WHERE \
> tbl1.col3 = tbl2.col4 AND tbl1.col5 = '123';
>
> The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let
> it run over night, in the morning i still didn't got any results, so i
> killed the query).
Hello,
To use InnoDB you have to put how large of a file MySQL is allowed to make by putting
an entry in /etc/my.cnf such as the one I used:
innodb_data_home_dir = /var/lib/mysql/innodb
innodb_data_file_path = indb1:200M;indb2:200M
that of course gives us 400M total.
I have not yet found in t
On Wed, 2001-12-05 at 15:01, Robert Alexander wrote:
> At 14:45 -0800 2001/12/05, Florin Andrei wrote:
> >The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let
> >it run over night, in the morning i still didn't got any results, so i
> >killed the query).
>
> the hardware and
> I don't think it's a version problem because the R
PM was mysql-3.23.33-4 and the tarball is mysql-max
-3.23.46-pc-linux-gnu-i686.tar.gz.
33 != 46
I'd be surprised if that's not the reason for the problems
you're having, especially considering how much has changed
since 3.22.
//C - points to
Well, I got around the problem by replacing the old mysql/english directory with a new
one from the tarball. I hope that was an o.k. thing to do.
At 04:35 PM 12/5/2001 -0600, you wrote:
>Using mysql-3.23.33-4 on SuSE Linux 7.1:
>root@fluorite:/usr/sbin > uname -a
>Linux fluorite 2.4.0-64GB-SMP
On Wednesday, December 5, 2001, at 04:08 PM, Robert Alexander wrote:
> At 15:55 -0700 2001/12/05, Alex Pukinskis wrote:
>>> group is a reserved word, use groups as table name
>>
>> That being the case, how do I drop or rename a table called "group"?
>
> Try:
>
> ALTER TABLE 'group' RENAME new_ta
Hi!
On Dec 05, JW wrote:
> Using mysql-3.23.33-4 on SuSE Linux 7.1:
> root@fluorite:/usr/sbin > uname -a
> Linux fluorite 2.4.0-64GB-SMP #1 SMP Wed Jan 24 15:52:30 GMT 2001 i686 unknown
>
> We've been using MySQL for a while and we're trying to test InnoDB.
> According the InnoDB page all we ne
Hi everyone,
I'm using InnoDB tables, and I would like to turn the auto commit off.
I do SET AUTOCOMMIT=0 in my.ini file.
And when I restart the server, it won't start.
Does anyone know why?
Regards,
Oganes Demirchyan
Motorola Life Science
757 S.Raymond
Pasadena, CA 91105
Tel: 626-584-5900
At 15:55 -0700 2001/12/05, Alex Pukinskis wrote:
>> group is a reserved word, use groups as table name
>
>That being the case, how do I drop or rename a table called "group"?
Try:
ALTER TABLE 'group' RENAME new_table_name
HTH,
/Rob
~
Robert Alexander, A
At 14:45 -0800 2001/12/05, Florin Andrei wrote:
>The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let
>it run over night, in the morning i still didn't got any results, so i
>killed the query).
Hi Florin,
It would help if you could also provide:
the hardware and OS
the a
"DL Neil" <[EMAIL PROTECTED]> on 12/05/2001 11:35:46 PM
Internet mail from:
Please respond to "DL Neil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
cc:
Subject: Re: select statement group by unusual results
Chip,
> I have a database with 12 tables. I am running a q
On Wednesday, December 5, 2001, at 03:44 PM, Philippe Parmentier wrote:
> group is a reserved word, use groups as table name
That being the case, how do I drop or rename a table called "group"?
-Alex
--
Alex Pukinskis
Internet Consultant
aboutChange
http://aboutchange.com
http://aboutcreati
Yes, group is a reserved word (think GROUP BY). See
http://www.mysql.com/doc/R/e/Reserved_words.html
I believe you can make this work by putting the table name in quotes, e.g.
Select * FROM 'group';
but you will probably find it easioer to rename your table.
Michael
On Wed, 5 Dec 2001, A
group is a reserved word, use groups as table name
-Original Message-
From: Alex Pukinskis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 11:39 PM
To: [EMAIL PROTECTED]
Subject: queries on particular table produce errors
Whenever I try to do anything with a specific table
I have this SQL query:
SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2 WHERE \
tbl1.col3 = tbl2.col4 AND tbl1.col5 = '123';
(well, maybe there are more than two columns selected, and maybe a
little more than two tables, but you got the idea...)
The tables have 5...10 columns, every column is an in
Chip,
> I have a database with 12 tables. I am running a query to select certain
> fields
> from 3 of the tables, like this -
>
> select Title, Details, StartDate, City, State
> from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations
> where phpCalendar_Details.EventLocationID =
Hello everyone,
I've rewrote our existing our existing software to be compatible both for Oracle 8i
and MySQL databases.
I wanted to know, does MySQL support auto-extending of it's tablespace?
I know how to manually do it, by adding data files, and restarting the server.
Also, how could I chec
Whenever I try to do anything with a specific table in my db, I get an
error. Here's the list of tables:
mysql> show tables;
++
| Tables_in_acv2 |
++
| company|
| group |
| internet |
| knowing|
| person |
| personality|
René,
> I want to select about 25 rows from a table, and sort them by two
> criteria. First, by each row's Series field ("Baby", "Genesis", "Super",
> "Predator", "Millennium" are the various Series, and the order I'd like
> the rows in the array). Within each Series, I'd like the rows sorted by
Using mysql-3.23.33-4 on SuSE Linux 7.1:
root@fluorite:/usr/sbin > uname -a
Linux fluorite 2.4.0-64GB-SMP #1 SMP Wed Jan 24 15:52:30 GMT 2001 i686 unknown
We've been using MySQL for a while and we're trying to test InnoDB. According the
InnoDB page all we need to do is untar the package and ove
Hello,
I'm having trouble determining what's going wrong with a MySQL query that
I'm doing from PHP.
I have a table with the following columns:
id (int)
name (varchar 20)
starttime (int)
duration (int)
now, i have a row that has a starttime of 60, when i attempt to do the
following update with
Hi,
- Original Message -
From: "Michael Tam" <[EMAIL PROTECTED]>
> I am using MySQL 3.23.41 under Win2000. I wonder what is the easiest
> way to upgrade the MySQL to 3.23.46 with my existing data and grant table?
>
>From what I see is that I need to dump the data tables as file
I'm looking for a new commerce package, something run of a MySQL database.
it's gotta have bulletproof (well, as close as you can get) session
management. I wonder what others on the list are using and like? input is
appreciated!
thanks!
-
On Wed, Dec 05, 2001 at 04:28:58PM -0500, David Hudgins wrote:
: For some reason the binary install install of mysql on redhat linux is
: putting the database files in /var/lib/mysql instead of
: /usr/local/mysql/data. The data dir is present and holds mysql and test
: databases, but when we popu
I have a database with 12 tables. I am running a query to select certain
fields
from 3 of the tables, like this -
select Title, Details, StartDate, City, State
from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations
where phpCalendar_Details.EventLocationID = phpCalendar_EventLoca
For some reason the binary install install of mysql on redhat linux is
putting the database files in /var/lib/mysql instead of
/usr/local/mysql/data. The data dir is present and holds mysql and test
databases, but when we populated the data base the new databases where put
into /var/lib/mysql. W
> Hello,
>
> I keep on getting "1045 - Access denied for user: [EMAIL PROTECTED]
> (using password: YES)"
> errors. I'm connecting to this MySQL server from a remote site.
>
> I don't see any reason for this. I KNOW that my password is correct. In
> the user table, the "Host" is set to % for th
go to http://www.mysql.com
Get documentation, such as MYSQL Manual. Read it.
No, you do not need MYSQL on your local system, but helps when testing, and
learning. MYSQL is available for Unix/Linux and Windows systems.
There ae many good books. The "bible" is Paul DuBois book, MYSQL. He ofte
I didn't know where else to turn, but I'm wondering the simple (and
stupid) question of how do I get started using and learning MySQL.
I recently switched to a hosting company that supports MySQL, but what
do I need to get started using it and learning it?
Does the MySQL only exist on a web ho
Hello,
I keep on getting "1045 - Access denied for user: [EMAIL PROTECTED]
(using password: YES)"
errors. I'm connecting to this MySQL server from a remote site.
I don't see any reason for this. I KNOW that my password is correct. In
the user table, the "Host" is set to % for the "mysql" user
You know, I tried that, it it STILL didn't work. Then, after remembering
to reboot my brain, I took a look at the smarts.sql that my ISP kindly
dumped for me, to see what code/statements it might be missing--and lo
and behold!--it didn't have a USE database; statement! Adding this one
wee line
it should read: INSERT INTO recensioni VALUES( NULL,...
In order fot auto_increment to work, you must use NULL. When you tried
NULL, what SPECIFIC error did you get when it complained?
FYI: it complains about the "duplicate key" because you already inserted a
record with 300 in the PRIMARY KEY
George Horvath wrote:
>
> > > Ok, I followed your advice and removed the soaris built gcc from
> > > sunfreeware and downloaded the source instead. How ever now I am
> > > getting this message when I try to compile gcc:
> > >
> > > # /usr/local/gcc-2.95.3/configure --prefix=/usr/local/gnu
> > >
BLOCKED DELIVERY OF EMAIL FROM [EMAIL PROTECTED]
Our email scanner has detected a file type (or content) which we are not
permitting through our systems.
These namely include movies, executables and large pictures.
Your email has been stopped. The intended sender will receive
Hello,
Always struggling on my php-odbc-MS access project, I managed to successfully
add a record to a table.
Now, no matter what I write in the first field (random numbers, AUTO,
AUTO_INCREMENT...)
I get this:
Insert Into recensioni VALUES (300, 'riee', 'reworew', 'wer', 2001,'IT', 2.5,
'd
In 3.23 or later: Just specify an ID of 1000 when you insert your first
record. If every record thereafter is INSERTed with ID = NULL (or just
not specified), then AUTO_INCREMENT will automatically bump up each ID
field by one after the first one. If you are loading data from
mysqlimport or
quoted from: http://www.bitbybit.dk/mysqlfaq/faq.html#auto_increment
In latter versions of MySQL, you can specify AUTO_INCREMENT=n as a table
option. This will tell MySQL to use n for the initial value. Any new rows
added will increment the counter by 1, as usual. This value is lost if you
delet
Sun 450
Solaris 7
3 CPU
MySQL binary install
50 million record table. Initially tested on dual
CPU Intel Linux, now trying on Sun.
During index create (via alter), it copies the base
file (as documented). It spins the CPU at about 31%,
with 7 threads active. There is almost NO iowait (fast
f
Although Samba is not needed for what you need, I suggest that you install
it. I use it to easily share files (without FTP) on my home systems:
RH Linux 7.0, Win98
be prepared to tinker around with the samba configuration files, though.
-Original Message-
From: Faizal Mangera [mailto:[E
Hi I get the following errors on start-up;
011205 12:53:25 mysqld started
/usr/local/libexec/mysqld: File './melges-bin.1' not found (Errcode: 13)
011205 12:53:25 Could not use melges-bin for logging (error 13)
011205 12:53:25 /usr/local/libexec/mysqld: Can't create/write to file
'/usr/local/v
In General Terms:
Most default linux installs do not allow root user to telnet in to the
machine, this is good as a default.
You need to add the user that you do logon as to the MySQL permissions. This
can be found in the manual.
To access your MySQL db from Access, all you need to do is install
Hi,
How do I start an autoincrement field at a certain value, say 1000?
I have a field as:
ID INT NOT NULL AUTO_INCREMENT,PRIMARY KEY (ID)
How do I modify it to start at 1000?
These all generate errors:
modify mytable ID AUTO_INCREMENT = 1000;
modify mytable ID = 1000;
modify mytable ID AUTO_INCR
Hey people,
I've just set-up mysql on a redhat version6.1 of linux. I am new to both.
If i log into the machine as root I can run mysql.
If I log into the machine as a normal user I can't run mysql.
Is it a case of permissions in linux?
I need to be able to run mysql through a telnet window on
At 10:08 -0700 2001/12/05, Weaver, Walt wrote:
>When I start up mysqld, the datafiles and logfiles are created just fine.
>But, when everything is done the following error appears:
>
>/usr/local/mysql/mysql-3.23.44-innodb/libexec/mysqld: Table 'mysql.host'
>doesn't exist
This may be an obvious on
Yup, somehow I must've missed that. Thanks...
--Walt
-Original Message-
From: Mike(mickalo)Blezien [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 10:22 AM
To: Weaver, Walt
Cc: [EMAIL PROTECTED]
Subject: Re: Error trying to create InnoDB database. HELP
Did you run the 'my
Did you run the 'mysql_install_db' script after installing MySQL??
the database 'mysql' should be located within the datadir, along with the other
databases that are created.
>>On Wed, 5 Dec 2001 10:08:38 -0700 , "Weaver, Walt" <[EMAIL PROTECTED]> wrote:
>>Okay, I've finally gotten around to
Dammit, never mind. I figured it out.
Maybe someday I'll be able to ask an intelligent question here...
--Walt
-Original Message-
From: Weaver, Walt
Sent: Wednesday, December 05, 2001 10:09 AM
To: [EMAIL PROTECTED]
Subject: Error trying to create InnoDB database. HELP
Okay, I've fina
REGISTE O SEU DOMÍNIO GRÁTIS
Se tem um daqueles endereços complicados do tipo,
http://www.endereço.pt/paginas_pessoais/~minha_pagina/index.html, aproveite esta
oportunidade para criar um endereço mais simples e fácil de comunicar, do tipo,
www.minha_pagina.web.pt, SEM PAGAR NADA.
O WEB.PT Fre
Andrew Kharchuk writes:
> I'm using ukrainian language filling the database. The next problem
> occured: when i'm using "LIKE '$text' " at the 'SELECT" SQL statement
> with some 2 letters in ukrainian letters in $text, mysql server regard them
> as another letter (it make no distinction be
Okay, I've finally gotten around to trying to create an InnoDB database.
I've configured MySQL on Linux Red Hat 6.2, mysql 3.23.44 with the
--with-innodb parm. Everything installed wonderfully.
When I start up mysqld, the datafiles and logfiles are created just fine.
But, when everything is done
> Anyways, if any PHP people here are--god forbid--actually using MySQL as
> their database, I would GREATLY appreciate any help in this matter. I've
> thoroughly read the mysqldump chapter in the docs, and gone through
> several tutorials, but have found nothing on actually restoring a
> data
Raffaella,
try to compile the latest version 3.23.46 on your system with the gcc -g
flag. MySQL AB does not have a ready binary on Tru64, so you have to compile
yourself. If it still crashes, run the slave inside gdb and do bt full, so
that we see where it crashes.
Regards,
Heikki
http://www.in
That's why I cross-posted there as well. But I've found that posting to
the mysql list doesn't help, more often than not--perhaps fewer
subscribers.
Anyways, if any PHP people here are--god forbid--actually using MySQL as
their database, I would GREATLY appreciate any help in this matter. I've
> > Ok, I followed your advice and removed the soaris built gcc from
> > sunfreeware and downloaded the source instead. How ever now I am
> > getting this message when I try to compile gcc:
> >
> > # /usr/local/gcc-2.95.3/configure --prefix=/usr/local/gnu
> > Configuring for a sparc-sun-solaris2
Hello !
With M$ Query it's achieved just by executing any modification query
(insert,update,create etc).
Check the permissions for user from who the ODBC connections is performing.
Goodbye.
Dannis.
On Wed, Dec 05, 2001 at 04:46:22PM +0100, TOMASSONI Dominique wrote:
> Hello the list,
>
> Is it
Hmmm,
Good thinking. However, the files needed (autoconf) is in /usr/local/bin -
which is in my $PATH. a which shows autoconf so I know it can be seen
without any problems. There is no ld.conf.so under solaris 2.6.
Any more suggestions as I am having big problems with this.
Thanks,
Matt.
---
If you need a timestamp that is automatically updated when a record is
inserted, replaced, or updated, declare one field in the record as
TIMESTAMP:
create table mytable (
myvalue int default 0,
mytime TIMESTAMP
}
INSERT INTO mytable VALUES( 123, NULL );
-Original Message-
From: *Himer
Little problem with MySQL 3.23.46 under Windows ME. I'm trying to create
a database from an .sql file (the dumped remains of a functioning
database--also MySQL). The dumping was easy, but I'm having a problem
putting it back. I have a dumped file called smarts.sql that starts this
way:
---
>mysql ... which would prevent index usage. If your kind of query is
> frequent and slow, you could split your DATETIME column into two
> separate columns for DATE and TIME and put an index onto TIME.
Ok, thanks for the help!
Regards Emil
--
Emil Rasmussen
http://noget.net
-
Hello the list,
Is it possible to import ODBC data into a mysql database ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request thi
Hello !
I often use that common scheme to parametrize my queries.
#!/bin/bash
#check parameters most commonly (only number of parameters)
if [ $# !=NUMBER_OF_PARAMETERS_NEEDED ];
then echo "Too few parameters";exit 1;
fi
# these are queries in my "transactional" procedure
# $1...$N ar
On Wed, Dec 05, 2001 at 05:05:54PM +0200, Michael Widenius wrote:
>
> Hi!
>
>
> Yes; Our Solaris binaries are currently 32 bit.
>
> The main reason for this is that I haven't seen any reports that gcc
> should be able to produce production quality code on 64 bit sparc.
>
the sun compiler d
Oh, okay, you want to know how to use NetInfo.
Do "man niutil" and read the man pages on niutil. Also very useful, in
the following link is a brief description of how to use NetInfo Manager
to do the same thing if you prefer GUI:
http://developer.apple.com/internet/macosx/osdb.html
It tells
Hello list!
I have installed MySQL 3.23.39 on Compaq Tru64 UNIX V5.1. I need to run two
servers on the same machine, one as master and another as slave. The
database used is InnoDB, I need to replicate only one database.
I start successfully the master. When I start the slave it go up and down.
On Wednesday, December 5, 2001, at 12:24 AM, René Fournier wrote:
>
> I have to create a MySQL for my PHP scripts. How do I do this in Mac
> OSX? There are a bunch of command line tools, but I'm not sure which
> one[s] to use.
Well, if you already have MySQL installed, then just use them as
mweb,
I suggest you use the ODBC Metadata functions in PHP to describe your
database, e.g. odbc_tables, odbc_columns, odbc_primarykeys,
odbc_foreignkeys, etc.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Int
> First: please reply to the list, not directly to me.
> Then:
>
> I need a repeatable test case. That is
>
> CREATE TABLE ...
> INSERT INTO ... VALUSE (...),(...)...
> SELECT * FROM ... WHERE ... <= it works
> SELECT * FROM ... WHERE ... ORDER BY ... <= it does not
THIS QUERY WO
> -Original Message-
> From: Michael Widenius
> Yes; Our Solaris binaries are currently 32 bit.
>
Hi,
> The main reason for this is that I haven't seen any reports that gcc
> should be able to produce production quality code on 64 bit sparc.
>
I've been involved with 64bity stuff h
>> I have to create a MySQL for my PHP scripts. How do I do this in Mac
>> OSX? There are a bunch of command line tools, but I'm not sure which
>> one[s] to use.
>
> Not sure I understand this question. What do you mean by "create a
> MySQL for my PHP?"
oops, I meant to write "create a MySQL
Hello everyone..
I know that you can write the sql scripts into a text file and redirect it
to the mysql from command line.. Is there any way to add shell/system
commands to automate process? PArticularly, I am looking for a way to echo
files and put them in a blob column.
I am also wondering
Hi Konstantin,
You don't mention what version of MySQL you are using so I will
assume that you are using the most recent. There were many problems
with the threads libraries and even some compiler bugs on 4.1 and 4.2.
The are resolved by 4.3 and 4.4 (and soon to be 4.5) Is there any
chance tha
>
> It sounds to me as if you need to change your table design. You want to
> search by hours only,
> so you should have an hours column in your database. Either you should
> break the date up into
> DATE and TIME fields
I have been thinking on doing that, but there was something about it, that i
Ken Menzel writes:
> Hi Sinisa and Colin,
> Sinisa the PR database (Problem/Resolution Database) for freebsd is
> a more formal version of
> http://www.mysql.com/doc/B/u/Bugs.html .
>
> In FreeBSD eash problem is assigned a number in a database tracking
> who submitted the bug, the date, the p
On Wednesday 05 December 2001 05:51 am, Ian Moss wrote:
> System: Linux proserver 2.2.14 #1 Sat Mar 25 00:45:35 GMT 2000 i686 unknown
> Architecture: i686
>
> Basically its all a lie that linux is more stable than windoze.
> I've run mysql on pc's over the last year with no problems at all.
> The
Hi Husri,
you are low on memory (as the error says). try this, first remove the
file config.cache from the mysql source directory then rerun config
and add --with-low-memory to the list of commands: I use a shell
scripte with this:
rm config.cache
CC=gcc CFLAGS=-O3 CXX=gcc \
CXXFLAGS="-O3 -fe
Hi Sinisa and Colin,
Sinisa the PR database (Problem/Resolution Database) for freebsd is
a more formal version of
http://www.mysql.com/doc/B/u/Bugs.html .
In FreeBSD eash problem is assigned a number in a database tracking
who submitted the bug, the date, the priority, and details about the
bu
Emil,
You might try to split the time stamp into separate date and time columns. That would
allow you to cretae and use an index on time alone.
At 14:24 2001-12-05 +0100, Emil Rasmussen wrote:
>>
>> WHERE myfield LIKE 'HH'
>>
>> However this query will probably not use your index
Ian writes:
> Here is the 2.8 package I just downloaded from one of your mirror sites.
>
> [reckon]/vol0/homes/ian/tmp/mysql-3.23.46-sun-solaris2.8-sparc/bin> ls mysqld
> mysqld*
> [reckon]/vol0/homes/ian/tmp/mysql-3.23.46-sun-solaris2.8-sparc/bin> file mysqld
> mysqld: ELF 32-bit MSB exe
> WHERE myfield LIKE 'HH'
>
> However this query will probably not use your index either :)
Yeah, it works, but still, it does not use my index as long as it is
working
with strings. But neat trick anyway.
It sounds to me as if you need to change your table design. You want to
sea
MySQL - spam bypasser
> myisamchk --keys-used=3D0 -rq
> You can enable/disable keys from command line in 3.23.
While that would disable the key before the load,
how do I re-enable them afterwards?
-
Before posting, please
mysql> use protodel;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in table 'access'
Didn't find any fields in table 'document'
Didn't find any fields in table 'document_access_log'
Didn't
Hi, I am looking to export a PHP/MySQL application I have written. As far as
the MySQL side goes I am unsure if I should simply send a MySQL folder (copied
from the MySQL/Data directory) or a php file that would create all the
neccessary MySQL tables the first (and only) time it ran. I can ap
1 - 100 of 122 matches
Mail list logo
