What is that option? Never saw it before.
If this is the case indeed, how do you change its value?
Thanks again.
Noor
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 4:52 PM
To: Noor Dawod
Cc: MySQL List
Subject: Re: Unknown auto ROLLBA
Hi!
> "Michael" == Michael J Fuhrman <[EMAIL PROTECTED]> writes:
Michael> Hello All,
Michael> Suggestions Feedback Requested:
Michael> I'm looking for a solution that will not lock a table, yet allow me to
Michael> retrieve the:
Michael>field name, field type as integer, field size
Hi!
> "Michael" == Michael J Fuhrman <[EMAIL PROTECTED]> writes:
Michael> Hello All,
Michael> Suggestions Feedback Requested:
Michael> I'm looking for a solution that will not lock a table, yet allow me to
Michael> retrieve the:
Michael>field name, field type as integer, field size
On Mon, Sep 30, 2002 at 10:24:42AM -0400, Bill Leonard wrote:
> on 9/30/02 9:47 AM, Victoria Reznichenko at [EMAIL PROTECTED]
> wrote:
>
> > It's not a so good decision and not suitable if database contains
> > InnoDB tables, but you can't limit database size only with MySQL.
>
> Is this a plann
Found solution, the right syntax is:
SELECT hl7incom.id
FROM hl7incom, pid_segment
LEFT JOIN pid_segment
ON hl7incom.id = pid_segment.id
WHERE hl7incom.msg LIKE '%PID%'
AND pid_segment.id IS NULL;
Cheers for try of help,
Karsten
Same result, also if I do not define unique index.
Just a sug
Greetings..
Even the MySQLGui does not work for me. It is not getting downloaded. What
should I do ?
Insane
SQLyog ( http://www.webyog.com/sqlyog )
The Definative GUI for MySQL
- Original Message -
From: "Pavel Hloušek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September
Same result, also if I do not define unique index.
Just a suggestion:
SELECT hl7incom.id
FROM hl7incom, pid_segment
WHERE hl7incom.msg LIKE '%PID%'
AND not(pid_segment.id = hl7incom.id)
GROUP BY hl7incom.id;
Otherwise my only other suggestion would involve using the 'NOT IN'
logic, but I think
Just a suggestion:
SELECT hl7incom.id
FROM hl7incom, pid_segment
WHERE hl7incom.msg LIKE '%PID%'
AND not(pid_segment.id = hl7incom.id)
GROUP BY hl7incom.id;
Otherwise my only other suggestion would involve using the 'NOT IN'
logic, but I think that might be too convoluted for your needs.
-
No way, I've already tried this.
> I have two tables
>
> CREATE TABLE pid_segment (
> id INT NOT NULL UNIQUE PRIMARY KEY,
> msg TEXT)
> TYPE=INNODB
>
> CREATE TABLE hl7incom(
> id INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY REFERENCES pid_segment
> (id).
> msg TEXT,
> time TIMESTAMP NOT NULL
On Mon, 2002-09-30 at 23:44, Gebhardt, Karsten wrote:
> I have two tables
>
> CREATE TABLE pid_segment (
> id INT NOT NULL UNIQUE PRIMARY KEY,
> msg TEXT)
> TYPE=INNODB
>
> CREATE TABLE hl7incom(
> id INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY REFERENCES pid_segment
> (id).
> msg TEXT,
> tim
I have two tables
CREATE TABLE pid_segment (
id INT NOT NULL UNIQUE PRIMARY KEY,
msg TEXT)
TYPE=INNODB
CREATE TABLE hl7incom(
id INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY REFERENCES pid_segment
(id).
msg TEXT,
time TIMESTAMP NOT NULL)
TYPE=INNODB
There are few data stored in both tables. N
the answer to your question is yes.
however, what you're considering is a complex
technical exercise while it's being set up. after
you get it going, it'll work like a charm, but your
technical people will need to know what they are
doing.
corereader is a ms. windows app and one of its
pu
> I found a solution!!!
Hooray!
> ***Replace all backlashes with two backslashes.***
You probably want to consider whether you want to replace all quotes
with backslash-quote, as well. Backslashes in the English text would
only show up for something like file paths on MS OSses, but your
custome
> > Multiple databases on multiple servers?
> That is what I thought...which I assume means multiple machines (not an
> option).
For future reference, MySQL can actually run multiple servers with
different configurations on a single machine in Linux. (*BSD and Mac OS
X, too, I think.) They are wo
On Monday, September 30, 2002, at 03:53 24h, Slava Imeshev wrote:
> Hello All,
>
> Could anyone help me with this issue? Is it
> possible to create/drop database using mySQL
> JDBC driver?
>
Yes.
--
Clayburn W. Juniel, III -- Effective Software Solutions
Phone: (602) 326-7707Mobile: (602)3
On Monday 30 September 2002 10:13, Drulli B wrote:
> Hi,
>
> I have a grand total of two very important but possibly humiliatingly daft
> questions, that I hope some kind soul will patiently solve:
>
> 1. Can I run a mySQL server on a Linux computer, and query it through
> myODBC running on a Wind
What does your VB code look like?
Mike Hillyer
-Original Message-
From: Bruno Batarelo [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 3:42 PM
To: [EMAIL PROTECTED]
Subject: MySQL BLOB & Visual Basic
Greetings. I try to save 7MB large binary string to mysql blob field in th
Is MySQL running?
Use Process Viewer to see if there is an entry for mysqld.
If not, I would ask if you issued the "install_db" command and then
started mysql.
Ted
On Monday, September 30, 2002, at 06:03 PM, Palash Mohanlal Kasodhan
wrote:
> Hi everyone,
> I am just starting to
On Monday, September 30, 2002, at 03:03 24h, Palash Mohanlal Kasodhan
wrote:
> Hi everyone,
> I am just starting to work with MySql on MAC OS X.When i
> installed mysql i got the following message :
>
> PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is
> done with
Thanks to all who responded.
It seems that my problem was two fold.
1) I needed the my.cnf file in the root on C:/ for one.
2) I had install it the first time to my D drive. When I couldn't get it to
work I uninstalled and reinstalled it to the C: drive. For some reason, the
"services" command to
Hi everyone,
I am just starting to work with MySql on MAC OS X.When i
installed mysql i got the following message :
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is
done with: /usr/local/bin/mysqladmin -u root -p password 'new-password'
/usr/local/bin/mysqladmin -u
On Mon, Sep 30, 2002 at 03:45:20PM -0400, Brian Safford wrote:
>
> Which DB type will provide the best performance? We're currently
> using MyISAM, but I'm curious if switching to InnoDB will provide
> any performance improvements.
It depends.
There are cases when MyISAM is the clear winner and
Greetings. I try to save 7MB large binary string to mysql blob field in the
latest mysql server. I use innodb tables. Error I receive from myodbc driver
says: Memory allocation error. Here is my.ini extract:
set-variable=max_allowed_packet=30M
set-variable=wait_timeout=10
set-variable = innod
Brian Safford wrote:
> Which DB type will provide the best performance? We're currently using
> MyISAM, but I'm curious if switching to InnoDB will provide any performance
>improvements.
>
> Regards,
> Brian Safford
> EDS Messaging
>
> Note: The following was added to get this posting through t
I found a solution!!! ***Replace all backlashes with two backslashes.***
(The hex value of the backslash is 0x5c, see Joel Rees' previous emails
for an explanation on how multibyte Japanese characters contain the hex
value 0x5c and that MySQL uses that value as an escape character.)
VBscript used
"William R. Mussatto" <[EMAIL PROTECTED]>
> On Mon, 30 Sep 2002, Drulli B wrote:
>> 1. Can I run a mySQL server on a Linux computer, and query it through
myODBC
>> running on a Windows computer?
>Why not query it directly on its std port? What language are you using?
>Perl (including ISAPI versio
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 6:21 PM
To: Tewfic Kidess
Subject: Re: RE: date column
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you
hi!
The application is a password-username-location-type store. The types are web,mysql,
and entries for different computers to I can see all usernames/passwords on certain
computers
I would like to make myIsam tables into innodb to provide foreign keys, but I have a
'missing link'
I
Hello all,
I am currently creating a table per hour for some data I have. Each table has
502 fields (yeah, I knownothing I can do about it, this is a very
special situation) and about 100,000 records.
A few hours worth of data creates a 2GB table, and I don't really want
to increase the siz
Your webform application must call the appropriate mysql escape string
function for the language
in which it is written.
Dawn Friedland wrote:
>>CREATE TABLE Customers ( Name VARCHAR(100) );
>>
>>Now ... if your customers have names in Japanese, Russian and German,
>>how do you compile MySQL s
Which DB type will provide the best performance? We're currently using
MyISAM, but I'm curious if switching to InnoDB will provide any performance
improvements.
Regards,
Brian Safford
EDS Messaging
Note: The following was added to get this posting through the spam
filters: sql query
--
> CREATE TABLE Customers ( Name VARCHAR(100) );
>
> Now ... if your customers have names in Japanese, Russian and German,
> how do you compile MySQL so it can store them all in
> Customers? You use
> Unicode with a binary field and do post-processing work (like
> ORDER BY)
> yourself.
I ha
Question are you want to take your data from Filemaker to Excel? Because
what I had to do was re-create the tables in MySQL then out putting the data
to cvs table. Making sure the data was divide by a command, then I use
mysqladmin or you can use phpMyAdmin import it into you MySQL.
If that what
I welcome the pedantics!
> Multiple databases on multiple servers?
That is what I thought...which I assume means multiple machines (not an
option). And I'm glad you pointed it out that it still wouldn't solve
the problem.
> Go re-read the section of the manual on string literals. Ask
> yoursel
JMichael
"William R. Mussatto" <[EMAIL PROTECTED]>
09/30/2002 02:23 PM
To: Drulli B <[EMAIL PROTECTED]>
cc: [EMAIL PROTECTED]
Subject:Re: Mixing Linux and Windows and paying for it
On Mon, 30 Sep 2002, Drulli B wrote:
> Date: Mon, 30 Sep 2002 18:13
I never actually looked into it. There are so many "work arounds" I need
to do in FileMaker that I just redesign the tables in MySQL.
If there isn't a FileMaker converter, I'm sure there is a DBF converter.
You can just save you FileMaker databases as DBF and then convert them.
On Monday, Sept
I am a MySQL newbie and i am somewhat confused. Firstly did I make a mistake running
mysql_install_db and afterwards running the commands;
/usr/bin/mysqladmin -u root password 'new-password'
mysqladmin -u pazin1 sqlpass
and;
/usr/bin/mysqladmin -u root -h cords-orj86jfje password 'new-pass
On Monday, September 30, 2002, at 04:34 24h, Stéphane Pinel wrote:
>
> I've just installed MySQL on a MacOS X 10.2 system. Everything is OK
> but I
> can't find how I can login as a master to create users and give
> privileges ?
>
> Thanks.
With the server running you first need to give "roo
Ryan Fox wrote:
>I think you mean asp2php. I don't know any reason that someone would
>want to convert from php to asp. :)
>
Thanks for that; I'm sure the clarification would be obvious to anyone
reading the thread; my mind must have been fried from so much MFC
programming today ... instead of
On Mon, 30 Sep 2002, Drulli B wrote:
> Date: Mon, 30 Sep 2002 18:13:51 -
> From: Drulli B <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Mixing Linux and Windows and paying for it
>
> Hi,
>
> I have a grand total of two very important but possibly humiliatingly daft
> questions, tha
Hi,
I have a grand total of two very important but possibly humiliatingly daft
questions, that I hope some kind soul will patiently solve:
1. Can I run a mySQL server on a Linux computer, and query it through myODBC
running on a Windows computer?
2. The licensing info seems only relevant to peo
Hi,
I've just tried to download the Win32 binaries of the MySQLGUI tool.
I recieved about 50kB. When I tried to unpack the archive,
WinCommander told me, that the zip archive is corrupted.
Hope it helps, thanx guys for wonderfull MySQL.
Pavel
___
> Its called Sun ONE from SUN.
>
> http://www.chilisoft.com/
Don't most people who use ASP want to use Visual Basic? So the
problem isn't really lack of ASP on Linux but lack of VB. Somehow I
doubt that Microsoft (at least in its current incarnation) is going
to come out with VB for Linux.
Chuck,
ChiliSoft ASP is actually a Linux port of ASP 3 (I think). On the whole
we've found it to run OK but there are a few features that are not included
in the more recent Microsoft releases. While it makes it easy for IIS users
to port their sites to a Linux server I personally wouldn't depe
<< IMPORTANT INFORMATION! >>
This is an automated message.
The message you sent (attached below) requires confirmation
before it can be delivered. To confirm that you sent the
message below, just hit the "R"eply button and send this
message back (you don't need to edit anything). Once this is
d
Chuck Payne wrote:
>>There is a package called Chilisoft that will let you take your ASP pages
>>and change them to PHP, I am not sure how well it works. I had a client that
>>want to run ASP on linux and told I didn't think you could but PHP works and
>>to me is better. But the price of Chiliso
On 9/30/2002 12:14 AM, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
> Mac OS XS 10.2
>
> when you install the OS you have the oppt'y to put in a machine name
> (not the AppleTalk, Sharing name).
>
> i almost always put in a name. that name (mbase), it is also my
> default web host; that name
There is a package called Chilisoft that will let you take your ASP pages
and change them to PHP, I am not sure how well it works. I had a client that
want to run ASP on linux and told I didn't think you could but PHP works and
to me is better. But the price of Chilisoft was a little hight. I thin
[.snip.]
> ? How do you intend to run .ASP on linux?
[.snip.]
Its called Sun ONE from SUN.
http://www.chilisoft.com/
Dan
> -Original Message-
> From: William R. Mussatto [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 30, 2002 10:29 AM
> To: Insanely Great
> Cc: Ibrahim Al-Tawil
William R. Mussatto wrote:
> On Sun, 29 Sep 2002, Insanely Great wrote:
>
>
>>Date: Sun, 29 Sep 2002 22:43:43 +0530
>>From: Insanely Great <[EMAIL PROTECTED]>
>>To: Ibrahim Al-Tawil <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>>Subject: Re: Urgent!!
>>
>>Greetings...
>>
>>I believe that ASP works wel
On Sun, 29 Sep 2002, Insanely Great wrote:
> Date: Sun, 29 Sep 2002 22:43:43 +0530
> From: Insanely Great <[EMAIL PROTECTED]>
> To: Ibrahim Al-Tawil <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Subject: Re: Urgent!!
>
> Greetings...
>
> I believe that ASP works well with MySQL thru ODBC. As of lear
http://www.mysql.com/doc/en/Control_flow_functions.html
top of the page
> -Original Message-
> From: Gramos Brestovci [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 30, 2002 11:47 AM
> To: [EMAIL PROTECTED]
> Subject: IFNULL || NULLIF
>
>
> Does MySQL 3.23.39(version) support IFNU
Does MySQL 3.23.39(version) support IFNULL(NULL,0) || NULLIF(0,NULL)
Thanks,
Gramos
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
You need to grant privileges on the master to the new slave machine.
Eric Frazier wrote:
>Hi,
>
>I didn't have a new mysql master, just the slave name was changed. Yes on
>the second question too.
>
>Thanks,
>
>Eric
>
>At 09:09 AM 9/30/02 -0500, gerald_clark wrote:
>
>
>>Did you make the cha
+-+
| Grants for [EMAIL PROTECTED]
| |
+---
Because you did not set autocommit on?
Noor Dawod wrote:
>Hi all,
>
>I found out today that MySQL is adding a 'ROLLBACK' command to each
>session connecting to it, without explicitly ordering this.
>This is new since we never had this behavior before. Why is this
>happening, and how can I revert
CP,
Monday, September 30, 2002, 3:48:31 AM, you wrote:
C> The Master's server id is 1 while the slave's server id was set to 5. There
C> is no problem for the slave to establish connection to the master. However,
C> the slave complains that error reading packet from server, the reason is
C> misco
Mmm.. filter goodness. Trying again with the required words: sql query
> ... along the lines of using the database as a pointer to the real file in
a
> normal filesystem that others have suggested.. may I add the idea of using
a
> 'hashed' directory structure such that you don't end up with an ob
on 9/30/02 9:47 AM, Victoria Reznichenko at [EMAIL PROTECTED]
wrote:
> It's not a so good decision and not suitable if database contains
> InnoDB tables, but you can't limit database size only with MySQL.
Is this a planned feature anywhere on the MySQL roadmap for 4.x? A database
size quota?
Victoria Reznichenko wrote:
> Cyril,
> Monday, September 30, 2002, 3:35:40 PM, you wrote:
>
>
>>>Cyril,
>>>Friday, September 27, 2002, 4:19:25 PM, you wrote:
>>>
>>>CZ> if I build mysql with
>>>CZ> ./configure --with-charset=koi8_ru
>>>CZ> then check (make; make check; make test) failed!
>>>
>>>
Hi,
I didn't have a new mysql master, just the slave name was changed. Yes on
the second question too.
Thanks,
Eric
At 09:09 AM 9/30/02 -0500, gerald_clark wrote:
>Did you make the changes to master.onfo to point to the new master?
>Did mysql own master.info when you were through?
>
>
>Eric
Did you make the changes to master.onfo to point to the new master?
Did mysql own master.info when you were through?
Eric Frazier wrote:
> Hi,
>
> I changed my hostname(The DNS change was taken care of elseware) in
> FreeBSD 4.6 in the rc.conf file, rebooted. Mysql had no problems
> starting,
Iikka,
Monday, September 30, 2002, 2:40:32 PM, you wrote:
>> Jiri,
>> Sunday, September 29, 2002, 11:18:51 PM, you wrote:
>>
>> JM> I'm solving problem how to set up quota on MySQL db. I've look for that
>> JM> in mailing lists and docummentation but with no success.
>>
>> JM> Can someone help me
You know that process would be much easier if you used the GRANT syntax
http://www.mysql.com/doc/search.php?q=GRANT&from=%2Fdoc%2Fen%2Findex.html
> -Original Message-
> From: Insanely Great [mailto:[EMAIL PROTECTED]]
> Subject: Setting Permission For Column Level Only
>
>
> Greetings..
Maybe try one line...
I got this tons of warnings this morning making an import from Excel.
But it was apparently successful...but all decimal value where store
truncated like 128.00 , the reason is I'm in France and Excel exports
decimal with coma 128,34 but MySQL expects 128.34 so I just replac
> -Original Message-
> From: Paul Darius [mailto:[EMAIL PROTECTED]]
> Subject: Database Replication
>
>
> 'lock database with read lock' command already done before the above
> replication started and followed by 'unlock all' when finished.
>
> Question, how to sync an unsync table o
Cyril,
Monday, September 30, 2002, 3:35:40 PM, you wrote:
>> Cyril,
>> Friday, September 27, 2002, 4:19:25 PM, you wrote:
>>
>> CZ> if I build mysql with
>> CZ> ./configure --with-charset=koi8_ru
>> CZ> then check (make; make check; make test) failed!
>>
>> Because MySQL by default uses latin1
That would be a great way to keep your website up to date.
The slave can handle loss of connection (though some data may not make sense if part
of it is missing), and resume where it has left of previously.
Or you could also manually start and stop the slave process when you know there is a
li
Before I go and write one, does anyone know of any tools to create MySQL tables from
FMP databases?
All that I've seen are commercial products that synch the two, but the MySQL tables
have to already exist. (I have hundreds of columns that I'd rather not key in
manually!)
--
: Jan Steinman --
David,
Saturday, September 28, 2002, 2:37:00 AM, you wrote:
DY> Hi all. I'm trying to load a file into mysql using "load data infile" and
DY> got a ton of warnings. Is there any way to see what the warnings are?
MySQL doesn't store warnings anywhere.
--
For technical support contracts, got
Victoria Reznichenko wrote:
> Cyril,
> Friday, September 27, 2002, 4:19:25 PM, you wrote:
>
> CZ> if I build mysql with
> CZ> ./configure --with-charset=koi8_ru
> CZ> then check (make; make check; make test) failed!
>
> Because MySQL by default uses latin1 character set and you have compiled onl
Joel Rees wrote:
>>If I compile MySQL using --with-charset=sjis , how will it handle the
>>Latin, Chinese, and Korean characters?
>>
>>
>
>Multiple databases on multiple servers?
>
Try this one on for size:
CREATE TABLE Customers ( Name VARCHAR(100) );
Now ... if your customers have names
Lawrence,
Monday, September 30, 2002, 2:47:44 PM, you wrote:
LS> I am trying to set up a mail server using Postfix, Web-cyradm and mysql
LS> on SusE 8. I have followed all the steps in Luc de Louw's documentation
LS> so far and MySQL server is running. When I try to use the scripts that
LS> came
Stéphane,
Monday, September 30, 2002, 2:34:17 PM, you wrote:
SP> I've just installed MySQL on a MacOS X 10.2 system. Everything is OK but I
SP> can't find how I can login as a master to create users and give privileges ?
It's not so difficult. You should connect to the MySQL server as
root:
Odhiambo,
Saturday, September 28, 2002, 9:05:00 AM, you wrote:
OW> I have some problems with my database and not being quite profficient in SQL,
OW> I did myisamcheck and posted the data on the site below:
OW> http://ns2.wananchi.com/~wash/RT2/myisamcheck.txt
OW> I am wondering if someone can t
Hi,
I am trying to set up a mail server using Postfix, Web-cyradm and mysql
on SusE 8. I have followed all the steps in Luc de Louw's documentation
so far and MySQL server is running. When I try to use the scripts that
came with Web-Cyradm to create the databases and tables I get the
folowing erro
On Mon, 30 Sep 2002, Victoria Reznichenko wrote:
> Jiri,
> Sunday, September 29, 2002, 11:18:51 PM, you wrote:
>
> JM> I'm solving problem how to set up quota on MySQL db. I've look for that
> JM> in mailing lists and docummentation but with no success.
>
> JM> Can someone help me with this probl
I've just installed MySQL on a MacOS X 10.2 system. Everything is OK but I
can't find how I can login as a master to create users and give privileges ?
Thanks.
--
S.PINEL
-
Before posting, please check:
http://www.mysql.c
ÀÌö¿ì(õ¸®¾È),
Saturday, September 28, 2002, 9:42:24 AM, you wrote:
ÀÃ> I'm new to MySQL.
ÀÃ> Anyway...
ÀÃ> My O/S is FreeBSD 4.6.
ÀÃ> In /etc/hosts there are only two line.
ÀÃ> 127.0.0.1localhostlocalhost.paldal.com
ÀÃ> 192.168.0.88unix.paldal.comunix
ÀÃ> And in /et
Alexander,
Saturday, September 28, 2002, 12:47:19 PM, you wrote:
AS> Is it feasible to use replication to keep the database which powers my
AS> website up-to-date? The database itself is on the hosting companies server
AS> and contacted via dialup so the connection isn't there all of the time.
AS
Jiri,
Sunday, September 29, 2002, 11:18:51 PM, you wrote:
JM> I'm solving problem how to set up quota on MySQL db. I've look for that
JM> in mailing lists and docummentation but with no success.
JM> Can someone help me with this problem?
You can do it using disk quotas.
--
For technical supp
mailto,
Friday, September 27, 2002, 8:52:25 PM, you wrote:
majdd> i am a mysql newbie (my first time i install it)
majdd> i give up, i can't solve the problem without help.
majdd> all the time i try to start the mysqld, it ends up instantly with a shutdown
majdd> of mysqld, i cant run the prog: i
Daya,
Friday, September 28, 2001, 10:36:30 AM, you wrote:
DKD> Can anybody tell me is it possible in the my sql to set the function as
DKD> default value, for example can i set the now() function for the date column
DKD> field.
No, you can't:
http://www.mysql.com/doc/en/CREATE_TABLE.html
David,
Monday, September 30, 2002, 4:44:19 AM, you wrote:
DG> I am attempting to use mysql 3.23.52 on win2000pro. I have installed
DG> it and I believe everything went okay for that. At least I did get any
DG> errors.
DG> When I open services, mysql is set for automatic but it is
DeNewbie,
Sunday, September 29, 2002, 12:46:29 AM, you wrote:
D> I am a newbie and I have just recently installed MySQL. I am somewhat confused as
to why the tests that I am running from my command prompt are not showing any results
yet I believe that my MySQL
D> server is running;
D> mike@co
Mark,
Saturday, September 28, 2002, 12:16:31 AM, you wrote:
MH> I keep trying to grant file privileges to a user, but no matter what I do,
MH> it seems that the customer keeps getting access denied errors.
MH> They are trying to execute the following:
MH> select * into outfile '/tmp/list.txt' fi
Hi,
I have now been able to solve this problem.
I used MySQL 3.23, but when I installed MySQL 4.0.3 it worked fine.
Great
Tobias
Tobias Eriksson
ComOpt AB
Michael Löfmans gata 6
254 38 Helsingborg, Sweden
Direct: +46 42 389918
Phone: +46 42 389900
e-mail: [EMAIL PROTECTED]
Hi
How do I fi
From: [EMAIL PROTECTED]
Date: Tue, 24 Sep 2002 13:41:23 +0800 (WST)
I've got a problem with HEAP tables (undoubtedly the way
that I'm using them).
I'm running MySQL v.3.23.51 under Debian Linux with a
2.4.17 kernel.
If anyone can help clear some of the fog, I'd app
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
tel. 0121-242-1473
---
-Original Message-
From: Paul Romanic [mailto:[EMAIL
Hi,
Can anybody tell me is it possible in the my sql to set the function as
default value, for example can i set the now() function for the date column
field.
Thanks in advance.
Regards
Daya Krishan Dubey
Core Solucomm Ltd
423 B, Hamilton court
DLF phase IV
Gurgaon, India
Ph# 91-124-6392896/7 (
90 matches
Mail list logo
