From: "David Blomstrom" <[EMAIL PROTECTED]>
> --- Chris W <[EMAIL PROTECTED]> wrote:
> > If you plan on using this process again, you may
> > want to track down the
> > source of the problem, but if you aren't going to
The "source of the problem" is the fact that it is common in a CSV file to
rep
--- Chris W <[EMAIL PROTECTED]> wrote:
> If you plan on using this process again, you may
> want to track down the
> source of the problem, but if you aren't going to
> be exporting this way
> again and you just want to fix it, I would just open
> the csv file in a
> text editor and do a search
David Blomstrom wrote:
I just saved a spreadsheet (Microsoft Works) as a csv
file and imported it into a database. It worked fine,
except for some links, which acquired double quotes
when I saved the file as a csv file. In other words,
they now look like this:
Geobop
Do you have any idea what might
This isn't directly related to MySQL, but I thought
someone might have an answer - or maybe there's a way
MySQL can deal with it.
I just saved a spreadsheet (Microsoft Works) as a csv
file and imported it into a database. It worked fine,
except for some links, which acquired double quotes
when I s
At 14:40 -0400 on 06/07/2004, Jack Tanner wrote about "not unique table/alias":
I have two complex subqueries that I need to join. I suspect this
problem is due to using aliases instead of table names, but I don't
know how to work around it (temporary tables?). Please help.
SELECT col FROM (subquer
Hello, I'm new to the list and need help of course.
My problems are in connecting to MySQL. I am running Panther 10.38. , MySQL
4.018.
I have removed all old files before reinstalling MySQL. I have installed
the MySQL Startup Item and it is correctly located.
Output from the Terminal is as follows:
Your last row attempts to declare a column named NB of type TEXT with size
of 5. TEXT columns don't take a size specifier. Either drop the size of 5
or change NB to type CHAR or VARCHAR.
Michael
David Blomstrom wrote:
I'm trying to create a new table in my database. I
patterned it after anothe
I'm trying to create a new table in my database. I
patterned it after another table, so I didn't expect
any errors. Yet I get this error:
#1064 - You have an error in your SQL syntax. Check
the manual that corresponds to your MySQL server
version for the right syntax to use near '(5) DEFAULT
NULL
Hi, just wondering if anyone knows if using back ticks to quote indentifiers
is in the SQL standard. I understand double quotes are meant to quote
identifiers in the standard, but does the standard also say that back ticks
can be used as well? I'm asking this to know if my back tick infested
qu
TK wrote:
At 05:02 PM 6/12/2004 +0200, Harald Fuchs wrote:
Other DBMSs like PostgreSQL grok indexes on functional expressions;
MySQL doesn't. Thus your only choice seems to be storing the
uppercased initial in a separate column and putting an index on that
column.
As I indicated, I already tried
Emmanuel van der Meulen wrote:
On Monday, June 07, 2004 19:09, Michael Stassen wrote;
This doesn't quite make sense. You seem to say that several rows
will match but then you say only one will. It must be one or the
other. Perhaps I've misunderstood you.
Firstly, Michael thank you for your assi
At 05:02 PM 6/12/2004 +0200, Harald Fuchs wrote:
>Other DBMSs like PostgreSQL grok indexes on functional expressions;
>MySQL doesn't. Thus your only choice seems to be storing the
>uppercased initial in a separate column and putting an index on that
>column.
As I indicated, I already tried that i
> I have a table that has a few short text fields [text(4000), text(1000)]
> I would like to index. Do you think it is a good idea to index them
> "simply", or is it better if I create auxilary fields which hold the MD5
> for the text fields and index those? Would that be faster?
Try 'Fulltext
On Fri, 2004-06-11 at 08:50, Egor Egorov wrote:
> Wendell Dingus <[EMAIL PROTECTED]> wrote:
>
> > RedHat Enterprise 3WS, fully up2date. MySQL binary RPMs for AMD64 won't even
> > start for me, what were they built on?. I installed the .src.rpm and built one
> > myself (-bb --target amd64). Install
In article <[EMAIL PROTECTED]>,
TK <[EMAIL PROTECTED]> writes:
> I'm still trying to come up with an efficient way to query my table of names for all
> first initials. Seems to have stumped everyone.
> I.e. There are 50,000 names, and I want the final result to be:
> A, B, C, F, H, I, J, K..
David Blomstrom wrote:
Talk about lousy timing! I planned on staying up all
night to get my database squared away so I can launch
my websites in the next couple days. But the 30-day
trial expired on all the MySQL GUI's I downloaded, and
I can't import comma delimited files with phpMyAdmin.
Can you
Hi
I am running into an interesting issue with replication speed. The
setup I have is very simple, one master and one slave. The master
processes a lot of inserts and updates all the time and these are
replicated to the slave. The slave is read from all the time.
The odd thing is that since I s
On Friday 11 June 2004 06:59 pm, Robert Paulsen wrote:
> I must be missing something about "create temporary table". Here are two
> sql commands. The first works the second fails:
>
> CREATE TABLE mytable (id int(10) NOT NULL auto_increment, data
> varchar(255), PRIMARY KEY (id) ); CRE
For your problem, you need to create a table with a pool of availables
key, and when you use one, you delete from this table and when you don't
need it, return it here.
Osvaldo Sommmer
-Original Message-
From: Nitin [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 12, 2004 3:44 AM
To: MySQ
First of all, thanks for replying.
but, u didnt get my point. I want to use numeric field only as the key
field, but not the normal auto increment..
- Original Message -
From: "Daniel Kasak" <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; "MySQL Mailing List"
<[EMAIL PROTECTED]>
Se
Nitin wrote:
Hi all,
What will be the best way to implement auto increment field. I dont want to use auto
increment feature, as it only appends the numbers but doesn't check for the values
deleted. Suppose, following are the values in table
1abc
2bcd
3cde
..
..
..
9xyz
On 12.06.2004 09:36 (+0200), Ron Gilbert wrote:
CREATE TABLE `Comments` (
`ID` int(10) unsigned NOT NULL auto_increment,
`ArticleID` int(10) unsigned default '0',
`ParentID` int(10) unsigned default '0',
`DateAdded` datetime default '-00-00 00:00:00',
`Body` mediumtest,
you mean
Hi all,
What will be the best way to implement auto increment field. I dont want to use auto
increment feature, as it only appends the numbers but doesn't check for the values
deleted. Suppose, following are the values in table
1abc
2bcd
3cde
..
..
..
9xyz
now if 2n
Talk about lousy timing! I planned on staying up all
night to get my database squared away so I can launch
my websites in the next couple days. But the 30-day
trial expired on all the MySQL GUI's I downloaded, and
I can't import comma delimited files with phpMyAdmin.
So I just wondered what strate
I'm still trying to come up with an efficient way to query my table of names for all
first initials. Seems to have stumped everyone.
I.e. There are 50,000 names, and I want the final result to be:
A, B, C, F, H, I, J, K...
That is, a list of all first initials that are actually present i
Here is my problem. I want to create a simple message posting system so
users can post comments to news stories. I would like the comments to
be nested, and not appear as a single long list.
Is there away to retrived all the comments from a table order by the
date the parents were added, but n
26 matches
Mail list logo