Bennett Haselton wrote:
> Is it possible to set a column to have no possible default value, so if you
> try to create a record that doesn't specify a value for that column, you'll
> get an error?
Set it to NOT NULL
> For example, if I have a table where the "date" field should always be
>
Is it possible to set a column to have no possible default value, so if you
try to create a record that doesn't specify a value for that column, you'll
get an error?
For example, if I have a table where the "date" field should always be
set. I took out the default "NULL" value, but that just
At 22:00 01/12/01 +, Chris Withers wrote:
Hi,
I have a Win2000 machine and I would like to do a test with
your problem. Please can you send me more specify details
(definition table and SQL statements) so as I can build a
C/C++ client program for try to repeat the issue ?.
Regards,
Miguel
>H
On 1-Dec-2001 16:49 Sinisa Milivojevic wrote:
|
| Thank you for the repeatable test case.
I've just tested this with 3.23.46 and it still fails.
regards.
--
-Dale
-
Before posting, please check:
http://www.mysql.com/ma
Not sure that total users is a good metric; queries per second may be
better.
We host web sites and use MySQL with MyISAM tables for small and
medium-sized sites, Oracle for the big ones. Oracle's row-level locking
abilities make a big, deciding difference for the bigger, more active sites.
Oracl
Yup, --quick did the trick. Actually I wound up using --opt. Thanks.
Quidditch is sort of an airborne soccer game. It requires special equipment
not normally available in stores.
-- Walt Weaver
Bozeman, Montana, USA
-Original Message-
From: Sinisa Milivojevic
To: Weaver, Walt
Cc: [EM
Maurice,
If I do $sort = "id+DESC" I get this error:
Warning: Supplied argument is not a valid MySQL result resource
(not sure what you mean by "URI escape $sort"). Tell me more...
Thanks!
Paul.
Maurice Aubrey wrote:
> On Sat, Dec 01, 2001 at 06:52:13PM -0700, Rosyna wrote:
> > htmle
htmlentities($sort);
http://www.php.net/manual/en/function.htmlentities.php
Ack, at 12/1/01, Paul Markov said:
>Hi,
>some users of my web are having problems with sorting a MySQL table
>because older
>versions of Netscape do not recognize a blank space and do not convert
>it into a %20.
>
>Here
Hi,
some users of my web are having problems with sorting a MySQL table
because older
versions of Netscape do not recognize a blank space and do not convert
it into a %20.
Here's my situation:
$sort = "id DESC"
if ($page_num != $total_num_page){print " Next
Page
Netscape drops "DESC" because it
Sorry I confused read lock with locks that prevent other threads to read.
This is what I meant :
I have web sites where there are periodic inserts (& deletes ) of many
new records generated by crawlers.
In order to reduce the # of queries I do compound operations like
INSERT VALUES(a),(b),(c
I have web sites where there are periodic inserts (& deletes ) of many
new records generated by crawlers.
In order to reduce the # of queries I do compound operations like
INSERT VALUES(a),(b),(c), and DELETE FROM table WHERE record_id IN
($LONG_ID_LIST).
At the same as these operations are
Stephen P Toothman writes:
> I was wondering is there anyway to change the socket location from
> /tmp/mysql.sock to something else, other than recompiling :-)? If there is
> not I would like to highly recommend it as an option.
Change it in the config file (my.cnf). It's right there. Just b
Barbara Ferrell writes:
> i am setting up a musql database on linux. if you had a choice which
> processor would you use. does it really matter. i keep reading that linux
> runs better with an intel processor.
Who is claiming that? While it's true that the first and main platform
for Linux
You can specify the location when you start up the server
--socket=/path/to/mysql.sock
or enter it in your my.cnf file:
socket = /path/to/mysql.sock
in the [mysqld] group
>On Sat, 17 Nov 2001 21:34:24 -0600, Stephen P Toothman <[EMAIL PROTECTED]> wrote:
>>
>>I was wondering is there any
Hi Folks,
I'm having a problem when I try to populate a MySQL database using DTS in
SQL2000. The data types on the SQL2k table are varchar, as well as the types
in MySQL. I am receiving a 'Data Overflow' error for each column that it
tries to update. I've tried numerous ways of population, each f
I was wondering is there anyway to change the socket location from
/tmp/mysql.sock to something else, other than recompiling :-)? If there is
not I would like to highly recommend it as an option.
TIA
stevet
_
Do You Yahoo!?
Get your
Hi.
I tested this with 3.23.38 and was not able to reproduce the
problem. The UPDATE works as supposed for me.
Did you compile the server yourself? If so, try an official binary. If
not, please post more information, like where you got your binary
from, which version it is and so on. Use "mysqlb
i am setting up a musql database on linux. if you had a choice which
processor would you use. does it really matter. i keep reading that linux
runs better with an intel processor.
-
Before posting, please check:
http://ww
On Saturday 01 Dec 2001 21:29, Ady Wicaksono wrote:
> How to get an advantage from Dual ProcessorMachine when i'm using MySQL,
> should i recompile MySQL what option should be activated ?
You need to run more than one query at a time, for a start.
I am not sure about how good SMP support for va
Hi.
MySQL doesn't (yet) suport sub-queries. For further information have a
look at http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html.
Bye,
Benjamin.
On Thu, Nov 29, 2001 at 12:07:01AM -0500, [EMAIL PROTECTED] wrote:
>
> Hi all,
>
> I wanna try the following query,
>
> ===
Greetings,
I am having some trouble getting a 64bit mysql (built with gcc)
to work correctly. I am able to build and start mysql, but it crashes
anytime I try to manipulate a table with some data in it. This is
using mysql-3.23.42.
Here is what I see in the error log.
011130 18:53:35 mysqld r
Hi again, Sinisa...
Chris Withers wrote:
>
> Okay, table_cache increased from 64 to 256...
>
> > * check free disk space on all drives
Well, it got up to indexing 10,000 documents this time but then hung again. Now,
I don't know if this is because increasing the table_cache made a difference o
How to get an advantage from Dual ProcessorMachine when i'm using MySQL,
should i recompile MySQL what option should be activated ?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
In message <[EMAIL PROTECTED]>, Mark Worsdall
<[EMAIL PROTECTED]> writes
>Hi,
>
>Want I need is to find out when a table was last updated, not a records
>timestamp.
>
>Is there a way?
>
>or for SW people:
>
>way is there a?
>
>
Obviously not.
--
Work:- postmasterAThinwick.demon.co.uk
HAVING worked OK thus .
-
> What would this mean? The WHERE clause is what determines what rows
> will be used in the GROUP BY functions, e.g. MIN(). How do you know
> what rows to use when you need to know what rows to use before you
> can figure out the criteria for what rows to use?
> Tryin
> We are currently using MySQL for our database driven website. Currently,
> we have about 100,000 users. In January, we will be getting 2 million
> new registered users on our website.
Yes, but how many hits are you expecting, and what sort of queries will be
ran?
> We're buying a $50,000 Sun
Hi!
Look at the InnoDB/MySQL user stories at http://www.innodb.com
1200 queries per second on a single processor Intel box is easy to attain. A
terabyte of data is handled at an InnoDB/MySQL site.
InnoDB is close to Oracle in architecture.
Regards,
Heikki
http://www.innodb.com
--
Order commer
On Saturday 01 Dec 2001 10:41, Ovanes Manucharyan wrote:
> I have lots of text documents archived in a mysql database. I need
> to compare these documents to see which ones are similar (either they
> may have a small formatting difference or have a word or two different).
> Is there a function/met
MySQL is faster than any other database out there on small to medium
sized web sites, but when you are going into larger sites, like yours,
Oracle or MS SQL Server will be better suited for the task. Oracle does
have one major draw back Price... For your size, you will spend in
the neighborh
Hi Sinisa,
Sinisa Milivojevic wrote:
>
> There are several possibilities. You could be reaching some OS limits
> or haning user / group permission problems.
Don't think its permissions, since I had a similar process which ran fine, but I
had to change the schema to use the last insert id for ot
I looked that up and IN is an OR ... correct ?
Would be like saying:
Show me the records where departmentid = 142 OR departmentid = 368
I did however find this:
select * from departmentuser r1, departmentuser r2 where
r1.userid=r2.userid and r1.departmentid=368 and r2.departmentid=142;
Thanks
Chris Withers writes:
> Hi,
>
> I've got a problem with 3.23.44-max-nt on Windows 2000 using Berkley tables.
>
> I'm running an import process which inserts a big set of rows ('bout 27
> million), as part of a document indexing process. Each new row uses the
> AUTO_INCREMENT_ID from the previous
Corey Kaye writes:
> Looking though the docs. MySQL does not support nested selects but i'm looking for a
>way to speed up my PHP.
>
> This is what i have:
>
> CREATE TABLE departmentuser (
> userid int(10) unsigned zerofill default NULL,
> departmentid int(10) unsigned zerofill default NUL
[EMAIL PROTECTED] writes:
> >Description:
> It seems that that the use of LEFT JOIN when the joined table
> uses multiple primary key conditions fails to include rows which
> are clearly matching on those conditions.
>
> >How-To-Repeat:
> mysql> create table foo (fooID sma
Hi,
I've got a problem with 3.23.44-max-nt on Windows 2000 using Berkley tables.
I'm running an import process which inserts a big set of rows ('bout 27
million), as part of a document indexing process. Each new row uses the
AUTO_INCREMENT_ID from the previous row. So, I have a loop which basica
Michael writes:
> Umm does this mean there is no way to do what I need? Is it inappropiate
> to ask if it'd be difficult for such a function to be added into MySQL if
> it is the case that this is an impossible thing to do (or even just very
> challenging)? A median is a very common function to ne
Weaver, Walt writes:
> I knew it. Nobody bothered to read my post.
>
> The original problem involved running a lightweight version of mysqldump in
> a simulated nanokernel environment with reduced power resources. The
> ultimate result, we hope, is to use it to record Quidditch matches being
> pl
Looking though the docs. MySQL does not support nested selects but i'm looking for a
way to speed up my PHP.
This is what i have:
CREATE TABLE departmentuser (
userid int(10) unsigned zerofill default NULL,
departmentid int(10) unsigned zerofill default NULL,
KEY userid_departmentid(useri
Julio Faerman writes:
> Hi ... I am need the following query to work :
> SELECT
> min(my_colum) as MINIMAL_VALUE
> WHERE
> MINIMAL_VALUE > 10
>
> The query is not EXACTLY as this one, but i think it is enough to get you
> the idea of my problem...
What would this mean? The WHERE clause
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
>
With the errors corrected, like I wrote in my two previous mailings, I
could compile the CVS tree for my
Ok that was not too hard, I also solved this problem:
3. In subdirectory sql you try to include I could not find
this file. There is a problem with get_hash_symbol((const char
*)tok,len,function) in sql_lex.cc. Do I need another dependent software ?
where did you hide this function ?
I found th
System = Linux 2.5.1
ARCH:i686-pc-linux-gnu
1. I changed the global.h file to include since if signal.h is
included after global.h I get an error with __sighandler_t. You should
change your configuration.
2. I had to install autoconf 2.13 since your autoconf scripts dont work
with autoconf 2.52.
Hi!
MySQL 3.23.46 is now released.
This is a bug fix release that fixes some newly detected bugs in
MySQL.
If you haven't noticed any problems with your MySQL version and you
don't have a batch that automaticly does ANALYZE TABLE once in a while
there is need to upgrade.
This release should a
Hi!
i'm converting some database from windows mysql to freebsd. Program
wich uses this database is written very bad (not mine) and did not
correctly call querries.
Problem is with case sensitivity of unix. Is there any way to tell
mysql on unix that SELECT * FROM table is ste same as SELECT * FR
At 16:11 30/11/2001 +0100, [EMAIL PROTECTED] wrote:
Hi,
I don't understand very well your problem, anyway here some
informations:
Using the MySQL Server as Service
To start/stop options:
1- net start mysql/net stop mysql
2- using the SCM (Service Control Manager)
3- using the WinMySQLAdmin
Whe
I have lots of text documents archived in a mysql database. I need
to compare these documents to see which ones are similar (either they
may have a small formatting difference or have a word or two different).
Is there a function/method in mysql that will easily accomplish this?
If not could you s
Jason,
SELECT LAST_INSERT_ID() seemed to work from the mysql client. That is a
workaround. I forward this message to Sinisa and Venu, so that they can
check the Perl interface.
>From the manual page of mysql_insert_id() I found the following comment:
"
Charles Merriam: This may only work on mo
For reference, the version I'm using is:
mysql Ver 10.11 Distrib 3.23.23-beta, for pc-linux-gnu (i686)
(which I am not in a position to upgrade ,tho I could always ask)
I'm having some difficulties getting the REGEXP/RLIKE to work.
I'm trying to match on what is basically "$name[0-9]*" (the
na
48 matches
Mail list logo
