I have run across a problem with differences in the mysql.tables_priv
table and the INFORMATION_SCHEMA.TABLE_PRIVILEGES tables. My
application is currently written to query the information schema for
privileges before allowing users to insert or update. The problem is
that for some users and some
I have a table that includes a date and a scale reading like
datescale_reading
2007-08-01 150
2007-08-02 125
these reading may or may not be taken everyday. I need to develop a
query that will subtract the scale reading on one day from the scale
reading on the next
On 8/14/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi,
Christian High wrote:
I have a table that includes a date and a scale reading like
datescale_reading
2007-08-01 150
2007-08-02 125
these reading may or may not be taken everyday. I need to develop
On 8/14/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi,
Christian High wrote:
On 8/14/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi,
Christian High wrote:
I have a table that includes a date and a scale reading like
datescale_reading
2007-08-01 150
2007
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
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:
Hello
I
set these options in the option file under the [mysqld] section
log-slow-queries=
log=
log= is the general query log
i am not sure what you mean by the mysql log. if you mean the error
log than that would be
log-error=
if you mean the binary log that would be
log-bin=
if you don't enter
of course you'll need to restart the server after making the changes
to the options file..
On 7/30/07, Christian High [EMAIL PROTECTED] wrote:
set these options in the option file under the [mysqld] section
log-slow-queries=
log=
log= is the general query log
i am not sure what
if you are using MySQL 5 you could use a stored procedure
On 7/27/07, Samrat Kar [EMAIL PROTECTED] wrote:
I want to execute three sql statements in single query which will perform
following task...
1. select a particular row
2. insert that row to another table
3. delete that row from 1st
On 4/23/07, Andreas Iwanowski [EMAIL PROTECTED] wrote:
Hello MySQL experts,
I am trying to create a view whose access is based on a User ID that
need to be looked up in a different table.
Here is an example of what I'm trying to do:
CREATE OR REPLACE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL
On 4/22/07, YL [EMAIL PROTECTED] wrote:
I have a contact table looks like
id type owner_idowner_type value
11email21 person [EMAIL PROTECTED]
12phone 21 person 303-777-
13PO Box18
On 4/22/07, Christian High [EMAIL PROTECTED] wrote:
On 4/22/07, YL [EMAIL PROTECTED] wrote:
I have a contact table looks like
id type owner_idowner_type value
11email21 person [EMAIL PROTECTED]
12phone 21
Is it possible to restrict the range that can be put in a floating point, or
other data type that allows decimal numbers. The data being stored will be
that of the result of chemical analysis. The result could very well be
2.41however it would never be
24.1 so i want to ensure that a simple typo
13 matches
Mail list logo