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
things,
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 estimatio
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
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 sa
on their website to keeping everyone up
to date about these same details and update it a couple times a month? This
would seem to me to be more effecient for both them and us.
Thanks again for your thoughtful response.
Will
-Original Message-
From: Joel Rees [mailto:[EMAIL PROTECTED]]
Se
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
How about cluing us 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
> 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
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 thr
From: Venu [mailto:[EMAIL PROTECTED]]
> Sent: 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 [mail
n the script
to build them now.
There are probably a million different ways to do this. This is the way I
did 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
ravi:> Or, use mysqldump to dump the entire database, edit the CREATE
ravi:> DATABASE line
ravi:> at the top to the new name and pipe it all back into mysql, then drop
the
ravi:> old one?
That's sort of taking the long way around the barn, isn't it?
Will
> -Original Message-
> From: Rav
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 f
design feature... call it
what 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
>
r 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, Septemb
nes do not seem 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
ty
(with the "/t" option which creates 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 Messa
ive) to just use:
>"FROM zipwork1 as z, pctwork1 as p WHERE z.run_id = 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:
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
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 (a
me
not-so-simple design challenges.
In closing, I offer a couple rhetorical questions:
1. Who 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 a
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 creati
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
sting 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
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
anges online and then replicate these changes back to the
> local copy e.g two way replication
>
> Thanks
> Neil
>
> - Original Message -
> From: "Will French" <[EMAIL PROTECTED]>
> To: "Neil Tompkins" <[EMAIL PROTECTED]>; <[EMAIL PROT
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 databa
Actually yes (if I read the documentation correctly - I have not tried
this).
In MySql Manual section "4.10.5 Replication Options in my.cnf", I find:
binlog-do-db=database_name
Tells the master it should log updates for the specified
database, and exclude al
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 dat
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]
> Subjec
perly account for its being embeded in a literal string.
> -Original Message-
> 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 s
There probably is a better way but the following should work:
"UPDATE tblCompany SET CoName=CONCAT('"', CHAR(59), 'tester', CHAR(59),
'"', 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. Until
hole table. 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.
Thank
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
> 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
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
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-
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 pic
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:
Main
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:
http://www.mysql.com/ma
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. Ny
al Message-----
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 yo
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 maxwu
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 D
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 (defaults to double-quote).
Optionally, you could prepend the text file
something like this (assuming vbscript):
Dim pos = 1
Dim cnt = 0
Do
pos = InStr(field, "", 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 y
47 matches
Mail list logo
