> When I create a table, one colum contains a space, how can I caeate it
> correctly?
>
> like:
>
> CREATE TABLE mytable(
> name CHAR(60) NOT NULL,
> Email VARCHAR(50) NOT NULL,
> Thrid colum CHAR(60), ///Here there is a
> space?
> PRIMARY KEY (Email)
New Riders),
is the bible as far as I'm concerned, and I think alot of people here would
agree.
Jay Fesco
Magical Mystery Words: database,sql,query,table
-
Before posting, please check:
http://www.mysql.com/manual.
er to this... (besides 'upgrade' -
I'm running 3.22 on one of my servers and don't intend to upgrade anytime
soon because of complications with ChiliSoft...)
Jay Fesco
Magical Mystery Words: database,sql,query,table
> > select count(distinct(email)) from subscribes;
> >
> > But that's not legal. Any thoughts/ideas you all could send in would be
> > great. TIA!
> >
> > Chris Blessing
> > [EMAIL PROTECTED]
> > http://www.330i.net
> >
Try:
select
>From page 620 in MySQL...
* -t or --no-create-info
Does not write CREATE TABLE statements
Since DROPs are off by default, this should give you just the insert
statements.
The other option (as already suggested) is SELECT INTO OUTFILE.
Jay Fesco
> -Original Message-
>
lt I'd be better off recreating the database from
scratch. The sheer volume of data (and the extremely denormalized structure
of the original db) kept me from doing just that. There is no clear-cut
yes or no here. You will have to look closely at the code and the original
database. Yes, it
ws the answer to, assumes the
> asker is an idiot?
Never did I assume that you were an idiot. What I assumed (and still do) is
that you are overcomplicating the question.
> 2. Does your condescending attitude win you as many points with your users
> a
DELETE. I have to
deal with the same situation Phil describes quite often, but I've never
missed the 'join in update' function. Not that it wouldn't be nice, but the
workaround is not rocket surgery.
Jay Fesco
---
k well. A RegExp replace on the fly just before the update
is how I usually handle it in ASP.
Jay Fesco
"Confusing issues since 1963"
Magical Mystery Words: database,sql,query,table
-
Before posting, please check:
ase I misunderstood the intent:
If 'Column A in Table 1' has space-delimited words in each record such as:
abc def ghi
I believe you could use a combination of CONCAT and REPLACE. The WHERE
clause would look something like:
WHERE Table2.ColumnA IN (CONCAT('"',REPLACE(Table1.C
le 1 may contain a list of words that need to be matched
> not just one
> single entry.
>
> If someone could point me in the right direction for some code or
> a solution
> I would be very appreciative.
>
select Table2.ColumnB
from Table1, Table2
WHERE Table1.ColumnA = Table2.Co
ments
from
customers, mariacust
where custmers.tele = mariacust.tele
GROUP BY customers.company;
Or something like that...
Jay Fesco
Magical Mystery Words: database,sql,query,table
-
Before posting, please check:
http://www.
mp is what you need, and is quite well documented (many examples
exist in the list archives as well.) Good luck!
Jay Fesco
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
> Can someone tell me how to reset a column's auto_increment starting point
> back to 0 in mysql ?
>
> Thanks
>
> Paul
>
According to Paul DuBois on page 169 of MySQL by New Riders (which you
should buy):
ALTER TABLE t
DROP i,
ADD i INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY
Ja
ame;
before trying to create a table.
Jay Fesco
Magical Mystery Words: database,sql,query,table
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
ASP but the solution is the
approximately the same for IIS ASP:
Syntax for a function to return filesize (in JScript/ASP) is:
function ShowFileSize(filespec)
{
var fs, f, s;
fs = new ActiveXObject("Scripting.FileSystemObject");
f = fs.GetFile(filespec);
s = f.Name + " uses " +
my case, but I have a fixed IP):
c:/mysql/bin/mysqldump -h www.mydomain.com -u
UserID -pPassword --add-drop-table MyDBName > c:/ServerDumps/MyDBName.sql
I run a batch job with one of these for every database every day.
Hope that gets you started!
Jay Fesco
-
Calvin,
Maybe I'm just confused (fairly likely), but it appears that you are
confusing 'null' with zero. If you actually want to count all values
including nulls, COUNT(*) will do it. If you want to count NON nulls,
COUNT(a_field_name) does it. SUM(a_field_name) returns the sum of all
non-null
> i think this is jeremy's not-so-subtle way of bashing your choice of email
> client.
> check this link:
> http://www.rodos.net/outlook/#messageflag
>
> -ravi.
>
Yeah, yeah - I got it. Only problem is that I DON'T have a choice (company
policy et al)...
> > --
> > Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> > Technical Yahoo - Yahoo Finance
> > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
> >
>
Is anyone else getting a strange flag associated with Jeremy's
email, or is it just me? Every one of his posts comes in flagged
x27;NOT IN' clause, quoted
as appropriate. It works reasonably well, but I haven't benchmarked the
speed issues with large results from the inner query. Hope that helps.
If MySQL asks me, my TOP priority is INNER SELECTs. But that's probably
just me...
Jay Fesco
-Origina
Anyone can tell me how can i import an access db to mysql.
Go to http://www.mysql.com/downloads/contrib.html. Many contributed tools
plus a couple of macros that are run from within Access.
Jay Fesco
-
Before posting
fishbowls and you didn't? I think Douglas Adams
had it right on the mark...
(If you don't get the reference, you will need to read the inappropriately
named Hitchhikers Guide to the Galaxy trilogy)
\:^) (We need a 'Sorry for the emoticon' emoticon)
Jay F
Give me a break. Every time I think perhaps The Dilbert Principal is
fading, the Pointy-Haired-One rears his pointy head...
Thanks for the laugh, Chris! Good luck!
Jay Fesco
-
Before posting, please check:
http://www.mysq
Or you can just use the whereclause option in MySQLDump.
(i.e. -w'RecordID<200')
http://www.mysql.com/doc/m/y/mysqldump.html
Jay
-Original Message-
From: Stefan Hinz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 11:47 AM
To: Kevin; [EMAIL PROTECTED]
Subject: Re: WANTED: Util
se option in mysqldump.
Syntax is:
-w 'where_clause'
-or-
--where='where_clause'.
Of course, 'where_clause' would be something like 'id<200' or whatever's
appropriate.
It's on page 620 of 'MySQL' by Paul DuBois (New Riders). Invaluabl
Hello!
I'm a newbie at mysql and i'm looking for a client program for win23 that
can accsess a mysql database and create and alter tables.
The mysql database is placed on a linux box in my lan, and im not too keen
of sitting in console. The linux box also holds the apache server,with php
but
i e
any places it lives, then verify that the one
giving the error (/var/lib/mysql/mysql.sock) is linked to the 'real' one.
This may NOT be your issue, but it happened on our box after a reload of
MySQL. Good luck!
Jay Fesco
---
28 matches
Mail list logo
