> >> > Basics of database design: store what you know.
> >> >
> >> > Given that NULLs basically means the absence of a value
> >> > (eg: unknown), you shouldn't be storing NULLs.
> >> >
> >> Nonsense!!
> >
> > That's a bold statement ...
> >
> >> That's simply wrong. A null means "unknown or not ap
> At 7:48 pm -0500 14/3/06, Rhino wrote:
> >>Ah, so now things become clear, a NULL actually can mean
> >>two things? So much for clarity then...
> >
> >Come on; that's not fair. "Unknown" and "not applicable" are more like
different senses of the same thing, not two opposite things.
>
>
> IIRC (
In the last episode (Mar 15), said:
> Hello,everyone!
>
> My table has a bigint column which needs store 8bytes integer.
>
> I looked up in Mysql Menual. It seems that , if I use C API I can
> only use preapared statement functions to insert bigint values.
>
> I can not use mysql_real_query
Hello,everyone!
My table has a bigint column which needs store 8bytes integer.
I looked up in Mysql Menual. It seems that , if I use C API I can only use
preapared statement functions to insert bigint values.
I can not use mysql_real_query or mysql_query to insert bigint values because I
do not
At 7:48 pm -0500 14/3/06, Rhino wrote:
>>Ah, so now things become clear, a NULL actually can mean
>>two things? So much for clarity then...
>
>Come on; that's not fair. "Unknown" and "not applicable" are more like
>different senses of the same thing, not two opposite things.
IIRC (but please don'
- Original Message -
From: "Martijn Tonies" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>;
Sent: Tuesday, March 14, 2006 2:16 PM
Subject: Re: Accountability with MySQL
> >Should you have a flag for the status "movement complete" ? I would
> >say
>>yes but instead of a simple
- Original Message -
From: "Bruno B B Magalháes" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, March 14, 2006 2:07 PM
Subject: Re: Accountability with MySQL
I am designing a simple accountability system so all the partners can
have
direct access to it by intranet.
I was designing the da
At 4:24 pm -0500 14/3/06, fbsd_user wrote:
>user has to use the power bar to move deeper into the form
Out of curiosity, what's "the power bar"?
>From a db perspective one single insert is preferable, IMO. Firstly you don't
>have to declare as NULL required fields that will be entered in the sec
Hello List,
I am restoring a MySQL backup (about 40MB), and its taking well over 2 hours
to restore.
the area where its really hanging is when its importing the "BLOB"
There are about 1200 records, totaling about 10mb in size for these blobs.
I am running MyISAM, my current memory settings read
Well not wanting to be rude back. But the question is dealing with
how best to control the writing of data to mysql. No where do I say
anything about using php. I could be using perl for all you know.
But I respect your right to state your thoughts, but just don't
agree with it. I think this is a b
I understand the save the page form data into the session. But I
don't know what you mean by just pass it from page to page. Would
that mean having all the fields in regular form fields to accept the
entered data and also hidden corresponding fields to hide page 1
data in as page 2 is entered and f
On Tuesday 14 March 2006 22:24, fbsd_user wrote:
> Have to develop form with over 100 input fields plus 40 different
> drop downs. Seeking advice on technique to use. Thinking about
> single form where user has to use the power bar to move deeper into
> the form. This has benefit that every thing i
No crons that would delete the tmp directory.. In fact, all the other files
stay there... Just mysql.sock goes away...
|-Original Message-
|From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
|Sent: Tuesday, March 14, 2006 3:15 PM
|To: Anton Krall; mysql@lists.mysql.com
|Subje
Not wanting to be rude but this question would probably be answered
better in a php group. I realise there are many users of php that
subscribe to this list, but this is a mysql list not php.
If you go to http://www.php.net/support.php you will find a large number
of resources (including lists
[EMAIL PROTECTED] wrote:
Yes, a ranged query should respond faster than a negation. In some cases
you can seriously improve query performance for a negation query if you
split it into two range queries unioned together. Here is a pseudo
example:
This query should be slow due to the table scan
Both methods are "commonly" used.
Another method used is to have multiple pages like you've mentioned
but save all the data into a session (of just pass it from page to
page) until all 3 pages are complete and then write all the data at
once
The question to ask yourself is, do you want just
Have to develop form with over 100 input fields plus 40 different
drop downs. Seeking advice on technique to use. Thinking about
single form where user has to use the power bar to move deeper into
the form. This has benefit that every thing is written to the
database at one time, but the draw back
Do you have any cron jobs that clear the /tmp directory during the day?
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard
Guys.
I just started having a problem, Im running
mysql-standard-4.1.12-pc-linux-gnu-i686 binaries under Fedora Core 3 and Ive
been having problem where during some parts of the day, /tmp/mysql.oskc goes
away, I can still see mysql running when I do a ps ax but when I try to
connect to it, it says
Sara Woglom wrote:
Thanks Shawn!!
You should be thanking Mladen Adamovic for pointing you to:
http://dev.mysql.com/doc/mysql/en/grant.html
This page holds your answer. From the error message you got
Telnet to port 3306: Host 'my-machine-name' is not allowed to connect to
this MySQL serv
Hi,
I have figured out a way to get this to work. I am just posting what
I did in case anyone else stumbles across my original message. I am
sure there are other ways to get this to work, but this is the way
that worked for me:
###
# My HOW
On 3/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> "Jake Peavy" <[EMAIL PROTECTED]> wrote on 03/14/2006 01:52:28 PM:
>
>
> > On 3/10/06, Jake Peavy <[EMAIL PROTECTED]> wrote:
> > >
> > > On 3/7/06, C.R.Vegelin <[EMAIL PROTECTED]> wrote:
> > >
> > > > Hi Ariel,
> > > >
> > > > Maybe th
> > >Should you have a flag for the status "movement complete" ? I would say
> >>yes but instead of a simple checkbox, you could store a date value. That
> >>gives you two pieces of information
> >>
> >>a) if the date is null then the movement is not complete.
> >>b) if the date is NOT null then t
>>I am designing a simple accountability system so all the partners can
>> have
>> direct access to it by intranet.
>>
>> I was designing the data model, and came up with this:
>>
>> CREATE TABLE `moviments` (
>> `moviment_id` int(20) NOT NULL auto_increment,
>> `moviment_date` date NOT NULL def
"Jake Peavy" <[EMAIL PROTECTED]> wrote on 03/14/2006 01:52:28 PM:
> On 3/10/06, Jake Peavy <[EMAIL PROTECTED]> wrote:
> >
> > On 3/7/06, C.R.Vegelin <[EMAIL PROTECTED]> wrote:
> >
> > > Hi Ariel,
> > >
> > > Maybe this example helps you to create CSV output from MySQL.
> > > The first SELECT gene
"Neil Tompkins" <[EMAIL PROTECTED]> wrote on 03/14/2006 01:42:32
PM:
> Apart from this are there any other known issues. When trialing mySQL
on my
> XP machine, I noticed all the tables were created in lower case ? Is
this
> normal ?
>
> Cheers
> Neil
>
>
> >From: Mark Leith <[EMAIL PROT
On 3/10/06, Jake Peavy <[EMAIL PROTECTED]> wrote:
>
> On 3/7/06, C.R.Vegelin <[EMAIL PROTECTED]> wrote:
>
> > Hi Ariel,
> >
> > Maybe this example helps you to create CSV output from MySQL.
> > The first SELECT generates the headerline; the second the data.
> > ( SELECT 'FieldA','FieldB','FieldC',
- Original Message -
From: "Martijn Tonies" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, March 14, 2006 1:28 PM
Subject: Re: Accountability with MySQL
>Should you have a flag for the status "movement complete" ? I would say
yes but instead of a simple checkbox, you could store a date val
Apart from this are there any other known issues. When trialing mySQL on my
XP machine, I noticed all the tables were created in lower case ? Is this
normal ?
Cheers
Neil
From: Mark Leith <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Neil Tompkins <[EMAIL PROTECTED]>
CC: mysql@lists.
- Original Message -
From: "Martijn Tonies" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, March 14, 2006 1:16 PM
Subject: Re: Accountability with MySQL
Hello Bruno,
well about the date default value being invalid, well it´s working here
in
my system (MySQL 4.1.16, Mac OS X 10.4.5), and
Hello Shawn,
> > well about the date default value being invalid, well it´s working here
in
> > my system (MySQL 4.1.16, Mac OS X 10.4.5), and all my systens work with
> > this...
>
> Yes, it's a valid value in MySQL, but it's an invalid date,
> that's what I'm trying to say. Why have an invalid d
I use Tomcat 5.0.28 on both Fedora and FreeBSD, MySQL 4.1.14,
J/Connector JDBC driver for MySQL 3.1.11 and JOTM 2.0.10. From time to
time I get the MySQL JDBC driver exception "No operations allowed after
connection closed", after which DB calls from my application keep
failing. The stack trac
- Original Message -
From: "Bruno B B Magalháes" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, March 14, 2006 12:41 PM
Subject: Accountability with MySQL
I am designing a simple accountability system so all the partners can have
direct access to it by intranet.
I was designing the data mo
>Should you have a flag for the status "movement complete" ? I would say
>yes but instead of a simple checkbox, you could store a date value. That
>gives you two pieces of information
>
>a) if the date is null then the movement is not complete.
>b) if the date is NOT null then the movement is compl
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 03/14/2006 01:16:11 PM:
> Hello Bruno,
>
> > well about the date default value being invalid, well it´s working
here in
> > my system (MySQL 4.1.16, Mac OS X 10.4.5), and all my systens work
with
> > this...
>
> Yes, it's a valid value in MySQL, bu
Hello Bruno,
> well about the date default value being invalid, well it´s working here in
> my system (MySQL 4.1.16, Mac OS X 10.4.5), and all my systens work with
> this...
Yes, it's a valid value in MySQL, but it's an invalid date,
that's what I'm trying to say. Why have an invalid date
as the
Bruno B B Magalháes <[EMAIL PROTECTED]> wrote on 03/14/2006 12:41:35
PM:
> I am designing a simple accountability system so all the partners can
have
> direct access to it by intranet.
>
> I was designing the data model, and came up with this:
>
> CREATE TABLE `moviments` (
> `moviment_id` i
Hi Martijn,
well about the date default value being invalid, well it´s working here in
my system (MySQL 4.1.16, Mac OS X 10.4.5), and all my systens work with
this...
About the business logic I was thinking about showing the current month by
default, and if the user wants he can select diferent d
Hello Bruno,
> I am designing a simple accountability system so all the partners can have
> direct access to it by intranet.
>
> I was designing the data model, and came up with this:
>
> CREATE TABLE `moviments` (
> `moviment_id` int(20) NOT NULL auto_increment,
> `moviment_date` date NOT NUL
Further, your reporting will skew the data -- let's say once a day you
want to know the last time that row was read. Well, the first day,
you'll get accurate numbers. The second day, though, you'll end up
seeing that each row was read at latest the day before, because you
read it searching for th
I am designing a simple accountability system so all the partners can have
direct access to it by intranet.
I was designing the data model, and came up with this:
CREATE TABLE `moviments` (
`moviment_id` int(20) NOT NULL auto_increment,
`moviment_date` date NOT NULL default '-00-00',
`m
Hi, Jon.
mysqld.sock is a unix socket. mysqld creates it while starting and
removes it when you stop the server.
Jon Miller wrote:
Is there a way to recreate the mysqld.sock file, it has gone missing from
:/var/run/mysqld . Now MySQL will not run.
Thanks
Jon L. Miller, ASE, CNS, CLS, MCN
So did I Jim, on SuSE 9.2 pro.
So I downloaded the windows versions to my laptop instead.
Keith
In theory, theory and practice are the same;
In practice they are not.
On Tue, 14 Mar 2006, Jim Douglas wrote:
> To: [EMAIL PROTECTED]
> From: Jim Douglas <[EMAIL PROTECTED]>
> Subject: Re: E/R To
User ''@'localhost' just hasn't enough privileges to create databases.
http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html
Doug Pinkerton wrote:
I'm a total newbie working through the tutorial in DuBois's _MySQL_.
I've got MySQL running on my PowerBook. In Terminal, I can use the mysq
You need to set GRANTs to create on the host.
http://dev.mysql.com/doc/refman/5.0/en/grant.html
-Original Message-
From: Doug Pinkerton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 14, 2006 1:26 PM
To: mysql@lists.mysql.com
Subject: Permissions block database creation
I'm a total new
I'm a total newbie working through the tutorial in DuBois's _MySQL_.
I've got MySQL running on my PowerBook. In Terminal, I can use the
mysql client to get responses to things like SELECT NOW(). But the
command CREATE DATABASE sampdb; results in the following error.
ERROR 1044 (42000): Acce
ElkinFernando Ortiz wrote:
How i calculate for union the other 14
register in the same Query?
...
SELECT e.Plant,e.Date,e.Hour,e.Consuption From Energy Where
e.Plant=Var_Plant AND e.Date=Var_Date GROUP BY e.Plant,e.Date,e.H
By having an hours table (hour tinyint) which you join to your energy
Hi,
I am having character set problems while trying to migrate my data
from a server running 4.0.25-standard to a server running 4.1.16. I
believe that the orginal database was using the latin1 character set
(not sure, is there any way to tell? show full column doesn't seem to
be supporte
did u try restarting mysqld
Kishore Jalleda
On 3/14/06, Jon Miller <[EMAIL PROTECTED]> wrote:
>
> Is there a way to recreate the mysqld.sock file, it has gone missing from
> :/var/run/mysqld . Now MySQL will not run.
>
>
> Thanks
>
> Jon L. Miller, ASE, CNS, CLS, MCNE, CCNA
> Director/S
"ElkinFernando Ortiz" <[EMAIL PROTECTED]> wrote on 03/10/2006 12:26:57
AM:
> I will explain my problem in spanish and english.
>
> Se deben Presentar los consumos por 24 horas de energia para su ingreso.
Si
> el usuario ha digitado 10 registros, se deben presentar estos mas los
otros
> 14 corr
Hi Neil,
Neil Tompkins wrote:
Is anyone running mySQL on Windows 2003 server platform. Are there
any known problems ?
There is a known bug for Windows 2003 - bug #12071:
http://bugs.mysql.com/bug.php?id=12071
You should use 4.0.19 or 5.0.19.
Best regards
Mark
--
Mark Leith, Support Engi
Is there a way to recreate the mysqld.sock file, it has gone missing from
:/var/run/mysqld . Now MySQL will not run.
Thanks
Jon L. Miller, ASE, CNS, CLS, MCNE, CCNA
Director/Sr Systems Consultant
MMT Networks Pty Ltd
http://www.mmtnetworks.com.au
Resellers for: Novell Gold Partner, Cisco Part
[snip]
Is anyone running mySQL on Windows 2003 server platform. Are there any
known problems ?
{/snip]
The operating system? Yuck yuck! :)
It ran fine for me on 2k3 before I cam back to a *nix shop
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Is anyone running mySQL on Windows 2003 server platform. Are there any
known problems ?
Cheers
Neil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
nigel wood <[EMAIL PROTECTED]> wrote on 14/03/2006 13:09:08:
> [EMAIL PROTECTED] wrote:
>
> >"Paul Halliday" <[EMAIL PROTECTED]> wrote on 14/03/2006 12:09:10:
> >
> >
> >
> >
> >>As an example:
> >>
> >>There was a table called event.
> >>
> >>This table is now broken up like this:
> >>
> >>even
Are you using the --quick option?
--quick, -q
This option is useful for dumping large tables. It forces mysqldump to
retrieve rows for a table from the server a row at a time rather than
retrieving the entire row set and buffering it in memory before writing
it out.
thanks both - that did t
[EMAIL PROTECTED] wrote:
"Paul Halliday" <[EMAIL PROTECTED]> wrote on 14/03/2006 12:09:10:
As an example:
There was a table called event.
This table is now broken up like this:
event __.
So for every sensor, and every day, there is now a new table. So if I
have 20 sensors, every day I
"Paul Halliday" <[EMAIL PROTECTED]> wrote on 14/03/2006 12:09:10:
> As an example:
>
> There was a table called event.
>
> This table is now broken up like this:
>
> event __.
>
> So for every sensor, and every day, there is now a new table. So if I
> have 20 sensors, every day I will have 20
> > > The developer insists that for scalability issues, this was the
> > > answer. It is likely, for example in my deployment, that these tables
> > > would see upwards of 10 million records or more.
> >
> > Well, if there are problems with scalability, I guess you could
> > split it up in a few
On 3/14/06, Martijn Tonies <[EMAIL PROTECTED]> wrote:
> Hello Paul,
>
> I suggest you reply to the mailinglist :-) ...
>
> > The developer insists that for scalability issues, this was the
> > answer. It is likely, for example in my deployment, that these tables
> > would see upwards of 10 million
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 14/03/2006 11:32:10:
> Hello Paul,
>
> I suggest you reply to the mailinglist :-) ...
>
> > The developer insists that for scalability issues, this was the
> > answer. It is likely, for example in my deployment, that these tables
> > would see upward
Hi Tom,
Are you using the --quick option?
--quick, -q
This option is useful for dumping large tables. It forces mysqldump to
retrieve rows for a table from the server a row at a time rather than
retrieving the entire row set and buffering it in memory before writing
it out.
>From the manual at
Hi Tom,
Use -q option on mysqldump ;)
-q Won't buffer query, It will dump directly to stdout.
--Praj
On Tue, 14 Mar 2006 11:56:42 +
Tom Brown <[EMAIL PROTECTED]> wrote:
> Hi
>
> Trying to dump a complete db where 1 of the tables contains about 88
> million rows - When the dump runs o
Hi
Trying to dump a complete db where 1 of the tables contains about 88
million rows - When the dump runs on the command line the following
error is thrown
mysqldump: Out of memory (Needed 3543176 bytes)
mysqldump: Got error: 2008: MySQL client run out of memory when
retrieving data from ser
Hi
Iam not sure about the answer correct me if iam wrong :(
Dont use single quotes in count_of_logons ..
Try : $sql = "UPDATE members
SET count_of_logons = count_of_logons + 1
WHERE logon_id = '$logonid'
AND logon_pw= '$logonpw'
AND email_verifi
Hello Paul,
I suggest you reply to the mailinglist :-) ...
> The developer insists that for scalability issues, this was the
> answer. It is likely, for example in my deployment, that these tables
> would see upwards of 10 million records or more.
Well, if there are problems with scalability, I
I guess u had 2.5 million records splited into 1600 tables if iam not wrong :)
Why you split the tables to 1600 is there any specific count ?
Why you moved to merge table reason behind ?
Since 2.5 million records to 1600 is a huge count on nos of tables :( instead
of one ;)
--Praj
On Tue
Paul,
> One of the databases I use just switched to using merge tables and now
> my queries are painfully slow. One table, initially had about 2.5
> million records and now with the change this information is spread
> across about 1600 tables. A simple query, say select count(*) has gone
> from .0
Hi,
One of the databases I use just switched to using merge tables and now
my queries are painfully slow. One table, initially had about 2.5
million records and now with the change this information is spread
across about 1600 tables. A simple query, say select count(*) has gone
from .04 to about 3
I will explain my problem in spanish and english.
Se deben Presentar los consumos por 24 horas de energia para su ingreso. Si
el usuario ha digitado 10 registros, se deben presentar estos mas los otros
14 correspondientes desde la hora 11 hasta la 24 con los consumos en cero.
Siempre un conjunto d
Dear Sir,
The status of mysql:
mysql>show status;
+---+--+
| Variable_name | Value|
+---+--+
| Aborted_clients | 0|
| Aborted_connects | 0|
|
71 matches
Mail list logo