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: 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 lenght (so many

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. I'm trying to compile the

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 message in

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 ( SUM(

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 to

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 this ??

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' ) And I

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

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. -- Once a

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 question is a