text fields isolation

Hi. For example one have a table with some fields including text(blob). Is it faster at all with SELECTs that doesn't use this(those) text fields if they are moved into another table and linked using primary key or it does not signify? Best regards Evgeny.

Re: Interface

Pada Wed, 31 Jul 2002 09:41:45 +0300 "Dogaru Dragos" <[EMAIL PROTECTED]> menulis : > Hi, > > I was wondering if it's posible to make mysql listen on only one interface > (eth0, eth1 etC)? just add on your mysqld options --bind-address=IP -> Ip address to bind to -- Write clearly - don

Interface

Hi I was wondering if it's posible to make mysql listen on only one interface (eth0, eth1 etC)? Goja - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the l

Interface

Hi, I was wondering if it's posible to make mysql listen on only one interface (eth0, eth1 etC)? Goja - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Re: Visio-mysql driver question

Try using myODBC from mySQL, it is an ODBC driver. Use Generic ODBC driver in listing of visio drivers, then choose the setup option to pick the specific driver for myODBC. It will work for reverse engineering but have been unsuccessful in getting it to work generating a database. David -

Re: OR replaced by REGEXP?

At 21:57 -0700 7/30/02, Erick Papadakis wrote: >thanks for those who helped about my OR query in the join, if the sql >containes "IN (something)" it is much faster. but i have a similar >question relating to regexp. sorry i am not too good with regexp so >wouldapprecite some help. > >my sql is lik

OR replaced by REGEXP?

thanks for those who helped about my OR query in the join, if the sql containes "IN (something)" it is much faster. but i have a similar question relating to regexp. sorry i am not too good with regexp so wouldapprecite some help. my sql is like this: where col1 like '%abc%' or col1 like '%

Best way to backup DB

Hello, I am hosted on a shared/virtual hosting plan and would like to backup the one of the mysql tables on a daily basis. mysqldump is not available. I attempted to run the query - SELECT * INTO OUTFILE '/path/to/my/file/file.sql' FROM items and got the folowing error: DBD::mysql::st execute f

mysql 3.23.49 code

I'm using 3.23.49, and trying to load the menagerie database (online examples) by executing the example: LOAD DATA LOCAL INFILE 'pet.txt' INTO TABLE pet; This is the error I get: ERROR 1148: The used command is not allowed with this MySQL version Is this not compatible with 3.23.49? -Pushkar S. P

Re: error running

>check for ur permissions and ownership on that file. The ownership on the directory but the ownership on the files was incorrect. The script fooled me into assuming everything under the directory was correct since the directory was. >- Original Message - >From: "Bob Lockie" <[EMAIL PR

Re: error running

check for ur permissions and ownership on that file. - Original Message - From: "Bob Lockie" <[EMAIL PROTECTED]> To: "mysql mailing list" <[EMAIL PROTECTED]> Sent: Tuesday, July 30, 2002 7:49 PM Subject: error running > > I haven't used mysql yet. > How do I fix this error when starting

error running

I haven't used mysql yet. How do I fix this error when starting it? #/d2/usr2/local/mysql-3.23.51/bin/safe_mysqld Starting mysqld daemon with databases from /d2/mysql_db 020730 21:36:23 mysqld ended # more /d2/mysql_db/host.err 020730 21:36:23 mysqld started 020730 21:36:23 /d2/usr2/local/my

Replication Circle

Hello, Is there a way to have DB-A and DB-B such that DB-A is the master and DB-B is the slave. However, I also want to make DB-B the master and DB-A it's slave so that if I have to fail over to DB-B then DB-A is automatically following the changes. It doesn't seem probable that this is possible,

How to "download" a mssql db to mysql once a day

Hi! Does anyone know how to copy/download a mssql db running on winnt to a mysql db once a day. I have had a mssql db for some while and want to continue using it. Now I am about to create a website (using php/mysql) that will pull data from the mysql db. Therefor I need the mysql db to either

RE: getting the maximum value

SELECT name FROM myTable order by amount DESC limit 1 Would show all records sort them by amount desc and limit it to 1 record This help... --- Chris Kay Technical Support - Techex Communications Website: www.techex.com.

Re: Bit XOR not working

At 19:59 -0300 7/30/02, [EMAIL PROTECTED] wrote: > >Description: >The bit xor operand (^) don't seem to work on 3.23.51 on both >Windows and Linux. >A simple query like this (taken from the MySQL manual) will fail: From the same manual: http://www.mysql.com/doc/N/e/News-4.0.2.html It's good

Re: InnoDB, replication and create table w/3.23.51?

> I can reproduce the problem with (on the master): > > create table foo (a int); > rename table foo to foobar; > > Then the slave dies. Is this a known problem? I couldn't find > anything at google or the list archives, but I've been off the list > for a while. Is there a workar

Re: Bit XOR not working

In the last episode (Jul 30), [EMAIL PROTECTED] said: > >Description: > The bit xor operand (^) don't seem to work on 3.23.51 on both Windows > and Linux. A simple query like this (taken from the MySQL manual) > will fail: > > SELECT 1 ^ 1 > > MySQL said: > > You have an error in your SQL syn

RE: removing duplicate records

Vivian - Im just curious as to why I shouldnt trust group by? Is there a bug or something within Mysql regarding the group by clause? Walt - you could also create a compound primary key that consists of all columns, then create a unique constraint on the Primary key. I've used this many tim

Bit XOR not working

>Description: The bit xor operand (^) don't seem to work on 3.23.51 on both Windows and Linux. A simple query like this (taken from the MySQL manual) will fail: SELECT 1 ^ 1 MySQL said: You have an error in your SQL syntax near '^ 1' at line 1 >How-To-Repeat: SELECT 1 ^ 1 >Fix: ... >Submit

AIX 4.3 Installation of Binary file does not work because libz. (Still unresolved).

Hi, I wanted to summarize my problem again so if somebody had the same issue can help me. O.S. IBM AIX 4.3.3 MySQL Binary Distribution: 3.23.46 When I run ./scripts/mysql_install_db, I got this error: exec(): 0509-036 Cannot load program ./bin/mysqld because of the following errors: 0509-150

InnoDB, replication and create table w/3.23.51?

I just switched to using InnoDB tables (Linux, using binary mysql mysql-max-3.23.51, autocommit on), and now my replication dies when I rename a table, with: ERROR: 1192 Can't execute the given command because you have active locked tables

Re: removing duplicate records

Walt, Don't trust group by. I am using mysqldump and sort -u on *nix for duplicate. Try both ways, let me know your result. Thanks At 04:11 PM 7/30/2002 -0400, walt wrote: >Thanks David! > >The entire row, not just one or two columns, is a duplicate which makes life >fun.. >:-) > >I can key or

RE: Key in reverse order

SELECT key FROM table ORDER BY key DESC; -Original Message- From: DonPro [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 4:49 PM To: [EMAIL PROTECTED] Subject: Key in reverse order Hi, I have a MySQL table key on a 7 character VarChar field. Th efile contains numeric character

Key in reverse order

Hi, I have a MySQL table key on a 7 character VarChar field. Th efile contains numeric characters only which I've inserted right justified. Is there any way to travres the table/key in reverse order so that it displays highest to lowest? I wish to use this in a SELECT query. Thanks, Don ---

Re: getting the maximum value

select name, amount from myTable order by amount desc limit 1; destr0 wrote: > If I hav a table "myTable": > > id nameamount > 1john2 2joel 15 > > I want to get the name of the person with the largest amount.. but I > can't see

getting the maximum value

If I hav a table "myTable": id nameamount 1john2 2joel 15 I want to get the name of the person with the largest amount.. but I can't seem to come up with a good query for this. I tried SELECT name FROM myTable WHERE amount =

Re: removing duplicate records

Thanks David! The entire row, not just one or two columns, is a duplicate which makes life fun.. :-) I can key or unique index only a few columns once the data is cleaned up to prevent this problem. If I create an identical table and include either a key or unique index (innodb seems to lik

RE: removing duplicate records

You could always use an insert statement into a second table, when performing the insert use a GROUP BY clause to consalidate your records something along these lines but this isnt 100% accurate, I would need the table DDL and business rules behind the DEDUP Insert into tableB ( column n

Re: removing duplicate records

If the columns are defined as not null, just add a unique index on all the fields. alter table ignore add unique(col1.col2.col#); walt wrote: >Does anyone know a good way find and remove duplicate records from a table? >I can create an identical table structure and use a script to pull records

removing duplicate records

Does anyone know a good way find and remove duplicate records from a table? I can create an identical table structure and use a script to pull records from the existing table and insert them into the new table if they are not duplicates, but I'd rather not do it that way. Here is an example of a

RE: a newserver would be better than this mailing list

I'll try not to extend this thread any more than it needs (it's gone pretty far now). If you want to view the list via Usenet newsgroup, just do it. It's been available on my service provider for several months at mailing.database.mysql. If you prefer via email, fine. Rik Forgo JIST3 Army Test

can mysql push eventsto clients based on new inserts?

example; i have a flash movie connected to a socket, and its waiting for new databases inserts. when there is a new insert, this flash movie has to receive this info and do a query based on this latest insert. now i use a poll method, every 10 seconds the flash movie connects to a php script wic

Triggers

Is there any option to substitute Triggers or Stored Procedures on MySQL? sql, query Thanx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: a newserver would be better than this mailing list

Bart Burkhardt wrote: > > hello list, > > i think it would be better to have a mysql news server instead of this email > list. i will name some reasons that i think of, correct me if i am wrong. Not everyone has access to usenet > - with a newsgroup you only select the messages that you wa

Re: a newserver would be better than this mailing list

At 18:38 30-7-02 +0200, Bart Burkhardt wrote: >I am not going to give my replys to every yours reply, because.. > >i just know and feel that i gave fair reasons, and i find your replys not >strong enough. Exactly why I don't spend much time on this. Your arguments aren't good enough. Consider th

Re: currency type

At 10:57 -0700 7/30/02, Desmond Lee wrote: >Hi Mike > >Thanks for your reply > >Just to check the decimal(6, 2) means show 6 digits to the 2 >decimals of percision. Thus you get a numbers like: >1.34 >30.00 >3344.92 > >Is that correct? That is not correct. DECIMAL(6,2) means 6 digits *total

MySQL 3.23.51 compile problems with SuSE 8.0 (fwd)

I posted a message last Wednesday about compile problems I was having with MySQL 3.23.51 and SuSE 8.0 (copied below). I notice that there is another user (Dennis Daupert) having the same problem as I am. Does anyone have a solution, or know where I might be able to find more information that might

Re: change MySQL dir

At 13:45 -0400 7/30/02, Rahadul Kabir wrote: >hi all, > I'm running mysql 3.22 on my RaQ2 system. mysql was installed >and configured on /var dir. but now that the databases are growing >system is running out of disk space. So I decided to change the >datadir=/home/mysql >then I tried to

changing mysql dir

hi all, I'm running mysql 3.22 on my RaQ2 system. mysql was installed and configured on /var dir. but now that the databases are growing system is running out of disk space. So I decided to change the datadir=/home/mysql then I tried to move the mysql databases using following command bei

change mysql dir

hi all, I'm running mysql 3.22 on my RaQ2 system. mysql was installed and configured on /var dir. but now that the databases are growing system is running out of disk space. So I decided to change the datadir=/home/mysql then I tried to move the mysql databases using following command bei

Re: currency type

Hi Mike Thanks for your reply Just to check the decimal(6, 2) means show 6 digits to the 2 decimals of percision. Thus you get a numbers like: 1.34 30.00 3344.92 Is that correct? Why do you not use a float and a decmial type? Thanks Desmond >From: "Mike(mickako)Blezien" <[EMAIL PROTECT

Re: One-to-one relationship

What you probably want to do is go to amazon, and get these two books: "The Practical SQL Handbook" "The Practical SQL Handbook: The Sequel." These two books are on general DB design issues, and discuss normalization in depth. I have them, and enjoy them very much. And as for

change MySQL dir

hi all, I'm running mysql 3.22 on my RaQ2 system. mysql was installed and configured on /var dir. but now that the databases are growing system is running out of disk space. So I decided to change the datadir=/home/mysql then I tried to move the mysql databases using following command bei

change mysql dir

hi all, I'm running mysql 3.22 on my RaQ2 system. mysql was installed and configured on /var dir. but now that the databases are growing system is running out of disk space. So I decided to change the datadir=/home/mysql then I tried to move the mysql databases using following command bei

Re: 4.0.1 to 4.0.2 and Windows symbolic links

At 09:38 30/7/2002 -0400, Ray Elenteny wrote: Hi, >I just moved from 4.0.1 to 4.0.2 on Windows 2000 and my databases that >had been accessed through "Windows symbolic links" could no longer be >accessed. I had to add the use-symbolic-links directive back to my >my.ini file to get them to work? >

One-to-one relationship

Hope this isn't a repost - mysql,query,sql -- Forwarded message -- Hi, I'm not sure that this is the best forum, as it is more of a database design question, but I hope that someone can help me. I am creating a billing system. Each customer can pay via several methods, and ove

Re: currency type

>>Desmond Lee wrote: > > Hi there > > Does mysql have a currency type, or is it best to just use a varchar or a > float? > > Thanks > > Desmond I normally use the DECIMAL(6,2) data type, works very for currency values. -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder R

Re: question about cached result

In the last episode (Jul 30), xuefer tinys said: > i'm using mysql 4.x > > it is said the query result is cached by mysql for next query > > i have a forum, having "post" table post: postid, title, content, > postdate, clickcount and clickcount is increased when the post is > viewed > > and a p

FW: Install MySQL from the command line

> -Original Message- > From: Simon Hester > Sent: Tuesday, July 30, 2002 4:31 PM > To: '[EMAIL PROTECTED]' > Subject: Install MySQL from the command line > > > Hello > > OS= Windows 2000 Professional > Mysql Version = Mysql servers and clients 3.2.51 > > I would li

Re: a newserver would be better than this mailing list

I am not going to give my replys to every yours reply, because.. i just know and feel that i gave fair reasons, and i find your replys not strong enough. what i just would like to say is that a newsserver in my opinion would benefit the users, developers, and not to forget the software. i thin

Re: Mysql and Variable Length Records

I wonder if you use REPLACE instead of UPDATE if this would work around this issue, or at least make it less noticeable. On Tuesday, July 30, 2002, at 10:27 AM, Daniel Brockhaus wrote: > Hi there, > > here's something everyone using variable length records (varchar, text, > blob) should know:

return row count from "show processlist"

hello everyone, i'm a newbie so please excuse the probably dumb question. i'm using monitoring software to record the number of processes at a current time. currently, i'm just sending a show processlist and my monitoring software returns something like this: "0.06 sec, 4 rows, 1629, [user],

One-to-one relationship

Hi, I'm not sure that this is the best forum, as it is more of a database design question, but I hope that someone can help me. I am creating a billing system. Each customer can pay via several methods, and over time methods of payment might be deleted or added. So, I use the one-to-one relation

Re: Multi-terabyte mysql databases?

Hi Andrew, We have a catalog database with 147 Million records, but size is only about 8.5G. It is a read only application and is extremely fast under mysql. Only have about 200 users hitting it, as it is a special database for a point of sale application. I think the biggest problem you will

Re: a newserver would be better than this mailing list

On Tue, Jul 30, 2002 at 11:11:34AM +0200, Bart Burkhardt wrote: > hello list, > > i think it would be better to have a mysql news server instead of this email > list. i will name some reasons that i think of, correct me if i am wrong.. > > - with a newsgroup you only select the messages that you

question about cached result

i'm using mysql 4.x it is said the query result is cached by mysql for next query i have a forum, having "post" table post: postid, title, content, postdate, clickcount and clickcount is increased when the post is viewed and a page to search post select * from post where title like "%word to ma

Re: a newserver would be better than this mailing list

As it may be for others, I don't have access to a news feed, so it would be good-by for me. Bart Burkhardt wrote: >hello list, > >i think it would be better to have a mysql news server instead of this email >list. i will name some reasons that i think of, correct me if i am wrong.. > >- with a n

Re: subquery syntax

It would, BUT if you have just spent months developing and debugging a generic SQL compatible application, capable of running on MS SQL, Interbase, Access etc and wanted to port it to MySQL, what would you bother rewriting all your queries and go through all the testing again? Jeff - Origina

currency type

Hi there Does mysql have a currency type, or is it best to just use a varchar or a float? Thanks Desmond _ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com -

Re: subquery syntax

Wouldn't SELECT Contacts.FirstName, Contacts.LastName FROM Contacts, Users WHERE Users.UserName = 'Doug' AND Users.UserPassword = 'Crock' AND Contacts.ContactId = Users.ContactId; work? Daniel At 16:28 30.07.02 +0100, you wrote: >Forget it (at least for the forseeable future) > >Th

Re: subquery syntax

Is the idea, then, to string queries together, the result of one feeding the next? Thanks David On Tuesday, July 30, 2002, at 11:28 AM, Jeff Dyer wrote: > Forget it (at least for the forseeable future) > > This is the well known MySQL feature that means that MySQL is not even > SQL > compati

RE: subquery syntax

Try this: SELECT Contacts.FirstName, Contacts.LastName FROM Users,Contacts WHERE Contacts.ContactId = Users.ContactId AND Users.UserName = 'Doug' AND Users.UserPassword = 'Crock'); -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 10:56

Multi-Table Delete with MySQL 3.23.51

Guys, I know that version 3.23.51 of MySQL does not handle deleting data from multiple tables directly. I am in a situation where i have to delete millions of records from a dozen tables. The delete logic is not simple, i have to check a number of tables before i can actually delete a row from a

RE: MySQL hardware concerns

Having a separate slave server separate from everything else just seems like the clean way. Having a slave on every web machine will add a load to each web server necessitating better physical machines (since every change to the db has to replicate to N machines rather than just 1 machine). Both

Install MySQL from the command line

Hello OS= Windows 2000 Professional Mysql Version = Mysql servers and clients 3.2.51 I would like to be able to install and unistall Mysql from the command line using the command: msiexec from the command line, windows installer needs a msi file to be able to execute the installation, rather

Re: subquery syntax

Forget it (at least for the forseeable future) This is the well known MySQL feature that means that MySQL is not even SQL compatible. Argg. Apparently you will have to wait for version 4.1. Subqueries are not supported Jeff - Original Message - From: <[EMAIL PROTECTED]> To: <[

RE: MySQL hardware concerns

On Tue, 30 Jul 2002, Adam Nelson wrote: > Seems to me like a better architecture might be: > > N apache servers with mysql clients > 1 Master Mysql Server > 1 Slave Mysql Server/admin/backup server > > If you have 5 slave servers (one on each apache server), that would > cause much more traffic o

Re: Mysql and Variable Length Records

At 15:56 30.07.02 +0100, you wrote: > > Yes. Of course. But that's just another way to work around the problem, > you > > know? I mean, who wants to have to take a database down for an hour at > > least once a week? > >You have to take it down ?I run optimize table on every tbale at >midnight eve

RE: MySQL hardware concerns

Seems to me like a better architecture might be: N apache servers with mysql clients 1 Master Mysql Server 1 Slave Mysql Server/admin/backup server If you have 5 slave servers (one on each apache server), that would cause much more traffic on the internal network than each apache machine just b

subquery syntax

Hello: I am new to this and am having trouble with subqueries. Using MySQL 3.23 I have a Contacts table, and a Users table each with a ContactId field. I want to retrieve the ContactID from the Users table where UserName and UserPassword are such and such, I then want to get the FirstName and

Re: Benchmark

EWeek did a comparison review a few months back comparing MySQL, DB2, Oracle, MS SQL, and SyBase. Although it compared using a Java front end, so a lot of performance relied on JDBC support in the databases. Anyway, here is the URL: http://www.eweek.com/article2/0,3959,293,00.asp On Tuesday, J

Re: Mysql and Variable Length Records

At 09:43 30.07.02 -0500, you wrote: >At 16:27 +0200 7/30/02, Daniel Brockhaus wrote: >[...] >> >>Whoa. Each record has been split into 1000 (one thousand!) blocks. >>Reading one of these records would require 1000 reads from your harddisk. >>That's about 14 seconds to read a record of 16K length

Re: Mysql and Variable Length Records

At 16:27 +0200 7/30/02, Daniel Brockhaus wrote: >Hi there, > >here's something everyone using variable length records (varchar, >text, blob) should know: > > >Create a table containing at least one blob: > >> create table db_test ( >> ID int not null, >> vara blob, >> primary key

Mysql and Variable Length Records

Hi there, here's something everyone using variable length records (varchar, text, blob) should know: Create a table containing at least one blob: > create table db_test ( > ID int not null, > vara blob, > primary key (ID) > ); Insert two records: > insert db_test values

Re: Changing existing column data type question

Pada Tue, 30 Jul 2002 15:54:07 +0200 Ralf Narozny <[EMAIL PROTECTED]> menulis : > Hello > > CREATE TABLE mytable_bak SELECT * FROM mytable; > ALTER TABLE mytable MODIFY mycol1 VARCHAR(20)...; > > Paul Maine wrote: > > >What SQL command can I use to change an existing column in a table with an

Re: Changing existing column data type question

Hello CREATE TABLE mytable_bak SELECT * FROM mytable; ALTER TABLE mytable MODIFY mycol1 VARCHAR(20)...; Paul Maine wrote: >What SQL command can I use to change an existing column in a table with an >integer data type to a varchar data type. This is a production table with >about 3,000 records.

Which binary should I use on HP 11.x?

Is it possible to use the binary for HP 10.20 (mysql-3.23.51-hp-hpux10.20-hppa1) on HP 11.x? I know there is a later one for HP 11 on sourceforge, but the one for HP 10.20 is listed as 'stable', which is what I need. In a more general sense, can I use the stable binaries on platforms that are lat

Changing existing column data type question

What SQL command can I use to change an existing column in a table with an integer data type to a varchar data type. This is a production table with about 3,000 records. I don't want to loose any of my current data in this column. Thank You Paul -

Re: Benchmark

Daniel, Tuesday, July 30, 2002, 4:09:00 PM, you wrote: DK> Where can I find some benchmark test result documentation. DK> First of all, I'm interested in comparing MySQL, Oracle and MSSQL speed in DK> different situations. Check some links in the manual: http://www.mysql.com/doc/M/y/MySQL

Re: MySQL logo

Daniel, Tuesday, July 30, 2002, 4:15:45 PM, you wrote: DK> I'm planning to develop a commercial application with MySQL database engine. DK> I would like to include the logo of MySQL on the splash screen and about DK> box of the software. DK> Do I need any permission to use the logos of MySQL. C

RE: How to get timestamp of inserted record

> suppose I have added one field time_stamp of type > timestamp in any existing table. it will show the > current timestamp of all records. If i update any > record after sometime It will also update the > timestamp of updated record with current timestamp. > > but for insertion of any record...w

MySQL logo

Hi, I'm planning to develop a commercial application with MySQL database engine. I would like to include the logo of MySQL on the splash screen and about box of the software. Do I need any permission to use the logos of MySQL. Thanks, Daniel ---

Benchmark

Hi, Where can I find some benchmark test result documentation. First of all, I'm interested in comparing MySQL, Oracle and MSSQL speed in different situations. Thanks, Daniel - Before posting, please check: http://

mySQL max connections

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi I have a mySQL database thats taking a bit of a hammering - enough so that the number of connections spirals up and out of control. max_connections was originally at the default of 100 - but rising above 50 or so meant actual throughput dropped s

4.0.1 to 4.0.2 and Windows symbolic links

I just moved from 4.0.1 to 4.0.2 on Windows 2000 and my databases that had been accessed through "Windows symbolic links" could no longer be accessed. I had to add the use-symbolic-links directive back to my my.ini file to get them to work? The docs still state that in MySQL 4.0 this will no lon

Re: memory decay ..

linux, in cobalt raq4 - Original Message - From: "walt" <[EMAIL PROTECTED]> To: "SandraR" <[EMAIL PROTECTED]> Sent: Monday, July 29, 2002 5:29 PM Subject: Re: memory decay .. > SandraR wrote: > > > Hi!! > > Is ok that when I do a dump the memory utilized it is not released. > >

RE: [PHP-DB] time field query problems.

Thanks, I wasn't sure what kind of field to use, I'll give the timestamp a try and set 0 as default. Regards, Steve. -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 6:34 PM To: Steve Bradwell; [EMAIL PROTECTED]; Php-Db (E-mail) Subject: Re: [PHP-D

BUG report (CREATE TEMPORARY TABLES problem) 4.0.2/4.0.3-bk snapshot

>Description: Any grant at a tables level make 'CREATE TEMPORARY TABLE' privilege not working ERROR 1142 >How-To-Repeat: 1) (under root) mysql> GRANT CREATE TEMPORARY TABLES ON *.* TO test_user@localhost IDENTIFIED BY 'test_pass'; Query OK, 0 rows affected

Re: groupadd

Triffic Just what I was after. Many thanks On Tue, 30 Jul 2002, Pete French wrote: > > You need to create a new user and group for mysql. > > Open your OSX manuals and start reading. > > Additional hint - nidump and niload will do the trick (assuming > it works like alll other NeXT systems,

Re: Table Locking + Timeout

I had put a similar question (that unfortunately never got answered) on this mailing list and so I have pondered about this problem also. The way I see it, delayed_insert_timeout doesn't do any good here because it only determines how long an idle (with no pending jobs) insert delayed thread will

AW: Sql Create a column the multiple of two other columns

You don't need another column. SQL can calculate: select a, b, c, b * c as WhatEverYouWant from [WhatEverYouWant contains the product of column b and c] -Ursprüngliche Nachricht- Von: James Foley [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 30. Juli 2002 13:34 An: [EMAIL PROTECTE

RE: How to get timestamp of inserted record

jenny >suppose I have added one field time_stamp of type >timestamp in any existing table. it will show the >current timestamp of all records. If i update any >record after sometime It will also update the >timestamp of updated record with current timestamp. > >but for insertion of any recor

Re: Sql Create a column the multiple of two other columns

Hello! James Foley wrote: >Hi, > >If this is trivial, please bare with me: > >How do I alter a table in Sql to add a column >which is the multiple of two existing >columns: >A Table has columns a,b,c and I want to >add column d which will be b*c > > > AFAIK there is no way to automaically set

Recoverey

Hallo all I have a database that corrupted. I managed to save the radacct.frm radacct.MYD radacct.MYI radacct.TMD files and recreate the table.This is just a logging file so no real crisis if I lose some data. How do I import the info in the .MYD file back into the database? I have another mac

Re: Sql Create a column the multiple of two other columns

[in order to avoid the spam filter] mysql mysql sql [end avoid] (this is a test, I've got the pips with the spam filter when I'm not a spammer -- especially when MOST of the messages from this list register above 3 on http://www.spamassassin.org/) GRUMBLE James Foley wrote: > > Hi, > > If

Sql Create a column the multiple of two other columns

Hi, If this is trivial, please bare with me: How do I alter a table in Sql to add a column which is the multiple of two existing columns: A Table has columns a,b,c and I want to add column d which will be b*c Many Thanks Beginner --

RE: How to get timestamp of inserted record

Hi Jenny, I believe that the timestamp field will automatically be set to NOW() when you INSERT a record... In other words, you can disregard the timestamp field in the INSERT query Peter Normann -Original Message- From: Jenny Christy [mailto:[EMAIL PROTECTED]] Sent: 30. juli 2002

How to get timestamp of inserted record

Hello all, suppose I have added one field time_stamp of type timestamp in any existing table. it will show the current timestamp of all records. If i update any record after sometime It will also update the timestamp of updated record with current timestamp. but for insertion of any record...wha

RE: Bug in FLOOR() function

I tried the following in 3.23.49: SELECT FLOOR((25*9.54)+0.5); -> 238 SELECT FLOOR(238.5+0.5); -> 239 SELECT FLOOR((25*9.54)+0.50001); -> 239 SELECT FLOOR((25*9.54)+0.51); -> 238 Isn't the world a funny place? Peter Normann -Original Message- From: Andrea Forghi

  1   2   >