On 8/8/07, Brent Baisley <[EMAIL PROTECTED]> wrote:
> One thing to check is to make sure you are not quoting your NULL
> value for your insert statement. MySQL will try to convert that to a
> numeric value, which may end up as 0.
>
> On Aug 8, 2007, at 12:55 PM, Mahmoud Badreddine wrote:
>
> > Hell
If you are going to implement real security, it shouldn't matter if
someone nows the "unique id" of a record. You should be checking if
they have the right to see that record.
But regardless, there is an easy way to set random ids as your
"unique" identifier. Setup 2 fields, one being the r
One thing to check is to make sure you are not quoting your NULL
value for your insert statement. MySQL will try to convert that to a
numeric value, which may end up as 0.
On Aug 8, 2007, at 12:55 PM, Mahmoud Badreddine wrote:
Hello
I have a table which contain a few numerical values.
I set
I am new to MySQL administration, and must devise a backup plan, I have read
the manual but still want to know if I am understanding and applying the
principals correctly, please let me know if you have a better way, or if I
am wrong somewhere, my main question is regardng the locking of the databa
Jason Pruim wrote:
First line of my .csv file is:
First,Last,Add1,Add2,City,State,Zip,Date,Xcode,Reason
DESCRIBE is:
mysql> describe test;
++-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
++-+--+-+--
I believe that excel files generally terminate lines with '\r\n' and
if you use terminated by '\n' it will cause this behavior. so try it
with lines terminated by '\r\n' or get TextPad or a similar editor
that can save the file as unix platform that uses the same line
terminators that MySQL expects
[EMAIL PROTECTED] wrote:
Problems again with the survey design and functionality. Page 4 asks
questions about Falcon, and to be honest I don't know anything about
Falcon, but you've required answers to advance and only offered "yes' and
"no' as choices. Without a "Don't know" choice as an opti
First line of my .csv file is:
First,Last,Add1,Add2,City,State,Zip,Date,Xcode,Reason
DESCRIBE is:
mysql> describe test;
++-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
++-+--+-+-+---+
| First
Jason Pruim wrote:
Okay, so I have been going crazy trying to figure this out...
All I want to do is load a excel file (Which I can convert to just
about anything) into a MySQL database... Should be easy right?
Here is the command that I have tried: LOAD DATA LOCAL INFILE
'/volumes/raider/A
Hi.
On Wednesday 08 August 2007 18:39, Jason Pruim wrote:
> Did some more testing, made a new table and matched the field names,
> now it will load it without any errors, it's just only importing the
> first row... Not the rest of the 934 records...
You are using ENCLOSED BY '"' in your SQL, whic
Hi all,
Here I am, following up to my own post - available below and at
http://lists.mysql.com/mysql/208343 - with a solution (basically, a
"workaround").
To summarize: I couldn't enter Portuguese accented characters in
"MySQL monitor" (MySQL command line / console client), when I'm in a
SSH (Sec
A... the one thing I can't do... I don't have Access to well...
Access... :)
Did some more testing, made a new table and matched the field names,
now it will load it without any errors, it's just only importing the
first row... Not the rest of the 934 records...
On Aug 8, 2007, at 1:
That is MySQL, not PHP doing that to you. You need to set your
SQL_MODE to strict to get that kind of behavior.. there are other
implications to this mode so you should review:
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
- michael
On 8/8/07, Mahmoud Badreddine <[EMAIL PROTECTE
If you can import your excel doc into MS Access I'd suggest:
http://www.mysql.com/products/tools/migration-toolkit/
I just started using and love it - easy intutitive GUI tool for importing
data into nySQL databases.
Good luck.
-Original Message-
From: Jason Pruim [mailto:[EMAIL PROT
Okay, so I have been going crazy trying to figure this out...
All I want to do is load a excel file (Which I can convert to just
about anything) into a MySQL database... Should be easy right?
Here is the command that I have tried: LOAD DATA LOCAL INFILE '/
volumes/raider/AML.master.txt' INT
Hello
I have a table which contain a few numerical values.
I set the default values to be NULL.
When I insert values using phpMyAdmin, it sets the values to NULL correctly.
But when I insert using a PHP script that I wrote it sets the values
to 0.00or 0.
In my script I do test if the values are emp
Problems again with the survey design and functionality. Page 4 asks
questions about Falcon, and to be honest I don't know anything about
Falcon, but you've required answers to advance and only offered "yes' and
"no' as choices. Without a "Don't know" choice as an option, your results
will be
17 matches
Mail list logo