Re: Importing fields of constant length [solved]

My tounge spoke too early, sorry! Sebastian Haag said: > Hello, > > is it possible to import data into a MySQL-DB from a text-file which does > not have separating characters (like a comma, semicolon or tab)? > > I have a .csv-file in which each column has a different constant

Importing fields of constant length

Hello, is it possible to import data into a MySQL-DB from a text-file which does not have separating characters (like a comma, semicolon or tab)? I have a .csv-file in which each column has a different constant lenght (so many characters or digits) that I need to import. For example: 00721617

Re: How to get previous and next result

Maria, Maria Garcia Suarez sagte: > Hi there! > > I'm currently developing a web where we let users > create their own forums. All the messages (wherever > they are posted) are stored in the same mysql table. > > When users read a certain message I would like to > display the previous and next mes

Re: mysql.h errors

Steve, Steve Davies sagte: > Sinisa Milivojevic wrote: > >>On Mon, 08 Sep 2003 19:57:25 +0100 >>Steve Davies <[EMAIL PROTECTED]> wrote: >> >> >> >>>Hi All >>> >>>I'm currently trying to learn C so that I can recode some php/mysql apps >>> >>>I've got but I've run into probs right at the start. >>

Re: Help with #1111 - Invalid use of group function

Hi, Paul DuBois said: > At 11:24 -0500 9/3/03, Cory Hicks wrote: >>Hey folks, >> >>I am trying to run the following sql query in mysql: >> >>SELECT TD.project_id, P.project_manager >>FROM time_daily TD >>INNER JOIN projects P ON P.project_id = TD.time_project_id >>WHERE TD.time_user_id = 'xpt' AND

Re: Help with #1111 - Invalid use of group function

Sorry, I think it should be GROUP BY TD.project_id, P.project_manager Cory Hicks said: > Hey folks, > > I am trying to run the following sql query in mysql: > > SELECT TD.project_id, P.project_manager > FROM time_daily TD > INNER JOIN projects P ON P.project_id = TD.time_project_id > WHERE TD.

Re: Help with #1111 - Invalid use of group function

Cory, Cory Hicks said: > Hey folks, > > I am trying to run the following sql query in mysql: > > SELECT TD.project_id, P.project_manager > FROM time_daily TD > INNER JOIN projects P ON P.project_id = TD.time_project_id > WHERE TD.time_user_id = 'xpt' AND ( > SUM( TD.time_hours_worked ) <> '0.00' >

Re: Abt mysqldatabase

Uma, Uma Shankari T. said: > > > Hello , > > >I need to copy the database contents from one operating system to > another operating system..if i copy the entire database folder it is > coping only the table structure..contents is not getting copied..can > anyone please tell me how do i go do t

Re: mysqlcc 0.9.2 no connections...

John, John Dangler said: > I installed and linked 0.9.2 on RH9 as instructed, and when I start > mysqlcc, I get the server registration dialog. When I attempt to > connect, I get a message in the message dialog which says "connecting." > and that's it! It never actually connects. I have checked

Re: database from win to lin

Dan, Dan J. Rychlik said: > Hey, > > I have a question about copying a database that was developed on a windows > os and moving it to a Linux server os. Will this work ? Has it been > done before ? > > Thanks, > > -Dan Yes, I have done it just recently. Just use the mysqldump-command. -- O

Re: user types

Andrew, Andrew Simpson said: > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > > > can anyone tell me the difference between the above 3. These are for the > root user. > > i need to create a newuser and im not sure which of the above they are > supposed to have > > thanks > Your ques