(or unique key) be established on two columns (eg
primary key = client_id + post id)?
Can an auto-increment column only increment in relation to the client
id?
Or am I expecting *way* too much out of MySQL and relational data
design?
---
Justin French
http://indent.com.au
--
MySQL General Mailing
one lend a hand?
My guess is maybe something like
SELECT article.title, article.user_id, user.username
FROM article, user
WHERE user.id = article.user_id
---
Justin French
http://indent.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Can someone give me a quick/clear explanation about why you would
create a table with columns of NULL / NOT NULL?
I clicked around the MySQL manual last night I *think* I know what's
what, but it'd be great to read one clear paragraph that summarises it
all.
---
Justin French
http
articles in one table, with
a indexed `siteID` column identifying which site each article belongs
to, as opposed to 100 tables (one for each site) holding only their own
data??
Should I worry at 40,000? 100,000? Or will the indexing of the siteID
keep everything extensible?
---
Justin French
http
? in earlier versions? and finally, is mysql 4.1 stable
enough to use in a production environment, or is that ill-advised?
thank you very much in advance,
--bill french
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
is I have no idea where to look next. Hours of Googling
has returned very little.
Any hints on where to look next would be great.
---
Justin French
http://indent.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
On Wednesday, February 11, 2004, at 03:29 PM, Keith Warren wrote:
I want to be able to track how many times any particular record is
returned from a search, and I have two ideas about how to do this. But
because I have little experience with MySQL, I may be totally off base.
This database is
Hi,
Can someone please calrify when I would use VARCHAR 255, and when I
would use TINYTEXT (which also has a length of 255)?
Thanks,
Justin French
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I noticed in the changelog for the upcoming 4.1.1 alpha release that
CONCAT_WS is being changed to NOT skip empty strings. I am sure that this
must have been done in response to feedback but I wonder if there are others
who like me have relied on the skipping of empty strings. Among other
affect their
primary keys, scattered across many tables... it will just affect how
they log in.
Any comments?
Justin French
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ben,
You can also access MySQL databases from PHP, FYI.
I've learned a lot from the book:
PHP and MySQL Web Development By Luke Welling Laura Thomson
ISBN: 0-672-31784-2
Hope that helps!
Len
--
Len French
Technical Applications Specialist
Lutron Electronics, Inc.
[EMAIL PROTECTED]
1-800-523
Hi all,
I'm currently logging page requests with the following table:
CREATE TABLE counters_hits (
pid tinyint(3) unsigned NOT NULL default '0',
stamp varchar(30) NOT NULL default ''
) TYPE=MyISAM;
In other words, for ever page hit on my site, I'm recording the unix
timestamp page ID.
I have a 2.7meg dump of SQL created by phpMyAdmin [1], however when I try to
import this data back into mysql through phpMyAdmin, it times out
(understandably), so I guess I need to do this from the command line, but
have no idea how to go about this AT ALL... can anyone point me in the right
Hi all,
On my LAN server (FreeBSD, MySQL 3.32) the following query works fine, and
seems to return 2 random rows from the table:
SELECT * FROM disc ORDER BY RAND() LIMIT 2
However, when I upload the scripts to the live server (Linux, MySQL 3.32),
the results are VERY un-random -- only very
Hi,
I'm trying to dig a bit deeper into mysql queries... I've come across an
application that i'm building which requires (it would seem on the surface)
many queries, do to the relational nature of the data.
The actual app is way too complex to explain, but I've come up with a
reasonably simple
sorry for the ambiguos subject, but not sure what terms to use!
I have four (relevant) tables:
category
partner(pid,pname,etc)
service(sid,sname,cid)
sid2pid(sid,pid)
This works fine, listing all services available within a category:
SELECT service.sid,service.sname
FROM service
WHERE
getting Unknown table 'partners' in field list.
Any advice warmly received :)
Justin French
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Hi all,
I'm encountering some problems with code on a PHP/MySQL driven site. It's a
long story to document, but the end result is that I have to look at my
entire code library looking for problems :)
One area that I'm seeking further knowledge about is how MySQL behaves under
load. I have a
Hi all,
I'm encountering some problems with code on a PHP/MySQL driven site. It's a
long story to document, but the end result is that I have to look at my
entire code library looking for problems :)
One area that I'm seeking further knowledge about is how MySQL behaves under
load. I have a
, but i'm
assuming the worst.
Does MySQL remember anything itself? Does it have any back-up mechanisms?
Justin French
http://Indent.com.au
Web Development
Graphic Design
-
Before posting
:
There is data in the logs. So you mite be able you use them to recreate the
data?
Simon
-Original Message-
From: Justin French [mailto:[EMAIL PROTECTED]]
Sent: 09 December 2002 09:05
To: MySQL
Subject: total idiot
Okay,
Let's just say I made a stupid mistake, and deleted
already exists
b) quickly inserting the row if it doesn't
I'm not worried about how long reporting the stats takes.
Or am I worried about nothing?
sql,query
Justin French
http://Indent.com.au
Web Development
Graphic Design
for myself :)
Thanks,
Justin French
http://Indent.com.au
Web Developent
Graphic Design
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
with.
Justin French
http://Indent.com.au
Web Developent
Graphic Design
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
is easy in PHP, more trying to figure
out the logic of the query...
Many thanks,
Justin French
http://Indent.com.au
Web Developent
Graphic Design
-
Before posting, please check
French ([EMAIL PROTECTED]) wrote:
Hi all,
Not sure if I should be using distinct, or some sort of complex WHERE query,
so here goes:
I have two related tables:
threads
id,udi,message,stamp
replies
id,thread_id,uid,message,stamp
(the stamps are unix timestamps)
What I'd like
, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Justin French
http://Indent.com.au
Web Developent
Graphic Design
for the count of both tables,
'select count(*) from table_name'. After the query, performance went
up to 700/sec degrading after an hour or so the aroung 500/sec.
Can anyone offer an explanation to this interesting result.
Dave French.
NOTICE DISCLAIMER
This email including attachments (this Document
This get asked every couple of days. Check the archives.
FWIW, I host with Experhost.com
Justin
on 12/09/02 3:34 PM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
Hello All,
Can any one suggest a good company to host a MySQL+PHP website ?
Thanks
I think the only filters on this list are that it must contain 'sql' or
'query'... The message starts with 'Attn: mysql', so I guess it got thru.
Justin
on 10/09/02 11:55 PM, Clive Smart ([EMAIL PROTECTED]) wrote:
How did this get past the filters?
Ocita Gabriel wrote:
Attn: mysql ,
insensitive.
Many thanks in advance.
Justin French
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
, not be ignored just
because he's popular :)
I'd rather strip out some noise words like 'a' 'the' BEFORE using the
search term in a query, in order to maintain control.
Any ideas?
Justin
on 09/09/02 4:35 PM, Justin French ([EMAIL PROTECTED]) wrote:
Hi all, I'm a bit of a searching newbie,
What sql
hi all,
given a certain id # (eg 4), how would i query the value either side of it
(usually 3 and 5). In theory, yes, it'd be 3 + 5, but in the case of the
following table:
1
4
5
it'd be 1 + 5, and this:
3
4
7
it'd be 3 + 7.
Even more interesting would be obtaining some sort of an error
complex in the WHERE,
or am I way off track?
Any links to articles, FAQs, etc etc, or query snippets would be greatly
appreciated... I'm using MySQL in conjunction with PHP if that helps...
Justin French
-
Before posting
again for your thoughtful response.
Will
-Original Message-
From: Joel Rees [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 12:42 AM
To: Will French
Cc: [EMAIL PROTECTED]
Subject: Re: Info on 4.0.x release date
I know I'm not really involved here, but I would like to suggest
I wrote Ironically, the fact that I pay no license fees to MySQL AB is
based upon...
Dean Ellis wrote Ahhh, I see. So, you are _completely irrelevant_.
My relevance stems from the fact that I am a very good prospect to a company
that has a stated interest in growing their community of
If I understand you correctly, then you are trying to figure out how to
distinguish between an empty result set vs. no result set (i.e. an error if
statement was a SELECT).
In the case of an error (or a not result set returning statement like
INSERT), mysql_store_result will return null.
In the
sql query
Benjamin Pflugmann wrote:
Do you (all) realize you can only complain about this (falling so far
from their prediction), because they happened to give out some
estimate in the first place?
Sounds only reasonable to me to try to avoid the same situation by not
giving out estimations to
in on what's left to do, what progress has been
made and a best-guess as to what the release schedule might look like. I
wouldn't worry too much if your dates slip over time (I think you will find
a sympathetic group), but just keep us updated so we can adjust our own
plans.
Thanks
Will French
Obviously you don't agree with me and that is something I readily accept. I
do have difficulty with the fact that you clearly spent more time typing
your response than considering my points, which were intended to be
constructive.
You got the truth. Would you prefer someone lie to you about
p.s. PLEASE can you put a [mysql] tag on the list???
Please not, it wastes space on the screen.
not a lot of space - and does have the great advantage that we
can then filter out the mysql stuff into a separate mailbox whihc
(on standard UNIX mail) isnt possible without it.
-pcf.
You need to create a new user and group for mysql.
Open your OSX manuals and start reading.
Additional hint - nidump and niload will do the trick (assuming
it works like alll other NeXT systems, which it seems to).
-pcf.
-
am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show
characters of language such as hebrew/arabic?
My best suggestion would be to store all your test in Unicode UTF-8 format
and use the type BLOB in the table in order to store it. We do this
and can quite happily mix
We are discussing the 'mysql' client which is often used to write
scripts that run under the
UNIX shell.
...
If you write a script that has two semi-colons in a row, the second one
is ignored and no error message is given.
Err, not true (in amysql script anyway)
I think you are trying
mysql show databases;
+-+
| Database|
+-+
| CarbonUFSVolumeInfo |
| mnta|
| mntb|
| vi.recover |
+-+
4 rows in set (0.04 sec)
Umm, those look very much like files from a
Yeah, just go with InnoDB. :-)
any good ? I took a look at the documentation, but it all seemed somewhat
heavyweight for my liking...
I have an application that runs very nicely at the moment - we have one minor
problem which is that we have one insert into two tables which may not hapen
If I have amast/salve pair where the slave is replicating from
the master then do the table types have to be the same ?
Specifically can I have a myisam table on the master and replicate to
a bdb table on the slave ?
The reasoning behind this is to try and find a *fast* was to convert
a MYISAM
CREATE TABLE new_table (all like your current one, besides indexes)
TYPE=BDB;
INSERT INTO new_table SELECT * FROM old_table;
CREATE INDEX ... ON new_table;...
ALTER TABLE new_table ADD PRIMARY KEY (...);...
RENAME old_table TO old_table_bak;
RENAME new_table TO old_table;
That should
Hi all,
I'm a total newbie when it comes to windows set-ups... I've managed to get
Apache and PHP4 running nicely on an old Pentium laptop running Win95, and
have managed to install MySQL with ease.
However, I'm not all that sure how to set up users (or even what the default
user root's
hey, i'm having trouble installing MySQL-3.23.45-1.i386.rpm
already installed
MySQL-client-3.23.45-1.i386.rpm
MySQL-devel-3.23.45-1.i386.rpm
when i try to install MySQL-3.23.45-1.i386.rpm i get the following:
[root@localhost rpms]#rpm -U --force --replacefiles MySQL-3.23.45-1.i386.rpm
error:
Carl Troein: Yes, but only if you don't include 8 kilobytes worth of
Carl Troein: redundant irrelevance when you post.
Wow, pretty harsh there Carl -- there are some really good decaffeinated
brands available now. Although you are correct in pointing out that
continuing to carry the entire
Error: 1062 - Duplicate entry '2147483647' for key 1
That number is the largest number which can be stored in a signed 32-bit
(INT) field.
As I rather doubt that your table contains 2 billion rows, I am betting
that your auto-numbers are starting at 1. My advice would be to create a
new table
Error: 1062 - Duplicate entry '2147483647' for key 1
That number is the largest number which can be stored in a signed 32-bit
(INT) field.
As I rather doubt that your table contains 2 billion rows, I am betting
that your auto-numbers are starting at 1. My advice would be to create a
new table
it and it worked well for me. Since I have huge amounts of data, the
fact that both BCP and load data infile are very quick was a deciding
factor.
Hope this helps.
Will French
-Original Message-
From: Pavel Hant [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 2:59 PM
: Wednesday, October 03, 2001 4:00 PM
To: [EMAIL PROTECTED]; Pavel Hant; [EMAIL PROTECTED]
Subject: RE: Migration to mysql from MS SQL Server
Hi !!!
-Original Message-
From: Will French [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 12:28 PM
To: Pavel Hant; [EMAIL
check the command line option -d (or --no-data)
-Original Message-
From: Barry McClure [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 1:45 AM
To: [EMAIL PROTECTED]
Subject: --How to dump only table structure with MySQLDump?
I would like to extract the DDL for the
tab-delimited output) and the load data
infile command to load it into mysql.
It is possible that someone has created a more automated way of doing this
and if so that would be worth checking out.
Will French
-Original Message-
From: --- [mailto:[EMAIL PROTECTED]]
Sent: Sunday
to be networkable, I am
assuming that you have some means (cd-burner, etc.) of moving data from your
windows machine to your linux machine at home. Both the generate sql
scripts function and bcp create text files which can be copied to the
medium of your choice.
Will French
-Original Message-
From
for the index. If the character set you are
using is case sensitive (and I assume it is or you wouldn't need the LOWER),
then the hashing algorithm would also be case sensitive.
Will French
-Original Message-
From: Joe Kaiping [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 30, 2001 4:14 PM
ever... it doesn't change the fact that the behavior is
counter-intuitive and could cause problems with some designs (at the very
least, having gaps in the sequence could result in minor performance
degradation due to uneven key distribution).
Will French
-Original Message-
From: Paul
= p.run_id
to join the tables if they are 1-1 related.
Andrew Murphy
-Original Message-
From: Will French [mailto:[EMAIL PROTECTED]]
Sent: 26 September 2001 7:23 am
To: [EMAIL PROTECTED]
Subject: Disk-bound joins
Hi all,
I have two very large tables (4 million recs each) where
I searched pretty thoroughly for a way to access mysql data in their native
field types (e.g. an int field I wouldn't have to use atoi()/itoa() on) and
came up with nothing. If you are processing large amounts of data you may
want to do what I did which was to make my program build a load file
tables, I had to kill it
after 100 minutes and it had not even begun writing to the result table yet.
Anyone have any ideas... anyone?
Thanks in advance for your help
Will French
-
Before posting, please check:
http
is the bigger idiot... The person who asks a naive question or the
person who, upon hearing a question he knows the answer to, assumes the
asker is an idiot?
2. Does your condescending attitude win you as many points with your users
as it did with me?
Will French
-Original Message-
From
The message you are getting indicates that it cannot find the executable
file. You are getting this because you are not putting a space between the
executable name mysqld and your command-line option --standalone.
Unless you have some reason to not want to run mysql as a service, I
reccommend
arrangement.
Good luck.
Will French
-Original Message-
From: Iain Lang [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 23, 2001 12:34 PM
To: [EMAIL PROTECTED]
Subject: Newbie - PWS SQL. Some VSQs (Very Silly Questions)
.
Dear List-Members,
As I am EXTREMELY new to mysql and my
rtfm.
Excerpt from mySQL manual.
=
6.5.1 CREATE DATABASE Syntax
CREATE DATABASE [IF NOT EXISTS] db_name
CREATE DATABASE creates a database with the given name. Rules for allowable
database
names are given in Section 6.1.2 [Legal
In answer to your question - your statement does not work becuase mysql does
not allow joins in update statements.
imho, the fact that mysql does not support joins in UPDATE and DELETE
statements is by far its greatest weakness. I have posted a couple of
messages to this group to see what
There are two methods that I commonly use to move data from mySql into
Access.
The first is to use a myODBC connection and simply import the tables. Given
the size of your database (small that is) this would be quite quick assuming
that you are able to establish an ODBC connection to your
Thanks
Neil
- Original Message -
From: Will French [EMAIL PROTECTED]
To: Neil Tompkins [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, September 22, 2001 6:45 PM
Subject: RE: Backup Data
There are two methods that I commonly use to move data from mySql into
Access.
The first
What platform are you running on? Must... Have... Details...
database
-Original Message-
From: Pavel Popov [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 6:57 AM
To: [EMAIL PROTECTED]
Subject: UDF
Hi, All.
I have tried to add UDF, but has received a error
Can someone give me a quick *complete* example code of setting up a
connection, performing a small query, and reading back the result?
In windows install, there is an examples directory which contains mytest.c.
I can't say if this exists for Linux but I bet it does in some form. Why
don't
Sorry, I hit send before I was done...
examples, sadly, just aren't very good. And there is no example for
mysql_use_result(). (the example code uses mysql_store_result())
The syntax and proceedure for mysql_use_result is very very similar. My
advice: get it working with *store* and then
. Why
doesn't it just extract the columns it needs along with something like a
unique record or page pointer and sort that?
Any light that can be shed will be much appreciated - even if it just points
me to some reference material that is relevant.
Thanks,
Will French
There probably is a better way but the following should work:
UPDATE tblCompany SET CoName=CONCAT('quot', CHAR(59), 'tester', CHAR(59),
'quot', CHAR(59)) WHERE CoID=109
Like you, I believe there probably is an escape sequence for the semi-colon
but I'll be damned if I can find it documented.
-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 2:15 PM
To: [EMAIL PROTECTED]; johnlucas-Arluna; [EMAIL PROTECTED]
Subject: RE: Semi colons in text fields in update statement
At 2:00 PM -0400 9/20/01, Will French wrote:
There probably is a better way
Ok, an accidental double posting I can understand... but this is the 4th
time in an hour that you have posted the same message...
Chill out!
-Original Message-
From: phani krishna [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 2:42 PM
To: [EMAIL PROTECTED]
Subject:
Try this:
CREATE TEMPORARY TABLE tmp_avldate (date datetime, nadate datetime);
INSERT INTO tmp_avldate (date, nadate)
SELECT DISTINCT schedule.date, nonavailable.date
FROMschedule LEFT JOIN nonavailable ON schedule.date = nonavailable.date;
SELECT
I am pretty new to mysql, and have been studying the feesibility of offering
a mysql version of my product (currently uses ms sql server).
Reading a post to this list yesterday, it came to my attention that there is
no FROM clause allowed in either the UPDATE or DELETE statements (actually,
the
I am not possitive that I completely follow what you are trying to do...
but, here goes:
What if you create a temporary table first:
CREATE TEMPORARY TABLE tu (
usernamevarchar(255),
maxwucount bigint,
maxrank int
) SELECT username, max(wucount) as
-
From: Will French [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 9:59 AM
To: Solsberry, Glendon; [EMAIL PROTECTED]
Subject: RE: Simple SELECT query (or so I thought)
I am not possitive that I completely follow what you are trying to do...
but, here goes:
What if you create
I assume that you have already scanned the MySQL manual section 4.10.4
Replication Features and Known Problems to see if anything listed there as
a problem is relevant to your situation. I found a couple of gotchas there
that caused me some problems.
-Original Message-
From: Gabe E.
database, sql, query, table
Sorry about that. Here's the answer:
[EMAIL PROTECTED]
And this means what? A little less criptic, please, for use simpletons.
-
Before posting, please check:
I am struggling with this myself right now. I posted a similar question to
this group earlier in the day and it must be a poser because no one has
responded.
I fear that the only way to do this with a single sql statement is using the
replace command:
Let's say you have 2 tables like this:
See MySQL Manual section 6.4.1
SELECT INTO OUTFILE
database - to satisfy mailer-daemon
-Original Message-
From: Jason Kwok [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 10:21 PM
To: [EMAIL PROTECTED]
Subject: Load_File
Load_File is used to read a picture (or
I looked but could not find any reference in the docs regarding limits on
the number of columns a table may have. I can say for certain that at 50
you are at no risk (I have tables with 140+). The only db that I know the
limit on is MS Sql Server and it allows 255.
-Original Message-
Try this:
SELECT *
INTO OUTFILE 'mytable.txt' FIELDS DELIMITED BY '\t' LINES DELIMITED BY
'\r\n'
FROM mytable;
Then, in Access, use the Import wizard and specify tabs as your field
delimiter and set your field qualifier to none (defaults to double-quote).
Optionally, you could prepend the text
something like this (assuming vbscript):
Dim pos = 1
Dim cnt = 0
Do
pos = InStr(field, br, pos)
If pos 0 Then
cnt = cnt + 1
pos = pos + 3 'get past the current one
Else
break
End If
Loop
'at this point, cnt holds
88 matches
Mail list logo