Bug using truncation in 4.0.4-beta

>Description: Special case: using SELECT with truncation doesn't return some records when the searched query appears at the end of the line. Note that the last record will be matched and returned because there is a space character at the end. I am using ft_min_word_

mysql update user

Hello there, I need your expert and slow guided assistance. I would like someone to explain to me the correct mysql commands monitor to achive the following correctly. It would greatly help if you work for a hosting company. The question is: User asks to be given access to mysql database for hi

Re: i almost hate queires, please help!!!

you have to include relations to all the tables you've selected from. select mgrname, pjname from managers, projects, pocs where pjid = 'x' and pmyid = 'x' and altid = 'x' AND POCs.PjID = PjStatus.PjID AND POCS.pmyid = Managers.PrimaryID AND POCS.altid = Managers.AlternateID i think that is how y

i almost hate queires, please help!!!

here's my table syntax: create table Projects ( PjID int unsigned auto_increment not null primary key, PjNumber varchar(40) not null, PjName tinytext not null, PjDesc tinytext, PJEcd varchar(30), PJCost varchar(30), LastUpdate char(30) ); create table Managers ( MgrID int unsi

su problems under linux.

I am having some difficulty with users using su and trying to access mysql, either through the command line (mysql) or via perl programs using DBD. Under normal circumstances users are able to use the command line tool mysql or run perl programs using DBD. They usually use $HOME/.my.cnf for pas

mysqld segfault

>Description: After upgrading mysql to 3.23.53, mysqld would segfault every time accessing a certain database. After running checks on the database and making sure everything was okay, I started mysqld up in gdb. Program received signal SIGSEGV, Segmentation fault. [Switching to Thread

4.0.5 estimate?

Hi folks, as I am building a new db-server right now and would like to know if I should wait ... when is 4.0.5 due to arrive? ;-) Thanks, Thomas filter-fodder: sql, query -- +++ GMX - Mail, Messaging & more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. sur

Re: Need a little query help

of course, you can get help here, but there is a free point and click query tool listed in the portals that may help you a lot. it lets you quickly create queries by just pointing and clicking, and when you get what you want, it shows you the sql code. i can't name it because i'll get fus

Re: backups without revealing password

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Gerald -- ...and then gerald_clark said... % % create a .my.cnf file in your home directory, and enter the useid and % password here. Ahhh... That's also not a bad idea. Between that and perhaps certificates I might be getting somewhere. Will th

Re: Connection problems

Steven Nakhla wrote: I recently installed Red Hat 7.3 on a box, and have been having difficulty connecting to my MySQL server. I can connect locally. That is, on the same machine as the server. However, if I try and connect from a remote machine with the following command: mysql -h -p I get

Re: backups without revealing password

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Iikka, et al -- ...and then Iikka Meriläinen said... % % On Mon, 28 Oct 2002, David T-G wrote: % ... % > % > What I need is a way to connect to the database from a cron job without % > exposing the password in the environment. What amazes me is tha

Connection problems

I recently installed Red Hat 7.3 on a box, and have been having difficulty connecting to my MySQL server. I can connect locally. That is, on the same machine as the server. However, if I try and connect from a remote machine with the following command: mysql -h -p I get the following error m

Re: secure replication

On Thu, 2002-10-24 at 20:26, Lists @ Apted Technologies Inc. wrote: > i am going to be setting up four mysql servers, three of which will > replicate data off of the primary. i know that in more recent versions of > mysql client/server communciations can be encrypted internally. but is > there any

RE: Replication and ALTER

The only thing that is not published to the replication logs are 'flush' statements. -Original Message- From: Jeremy Zawodny [mailto:Jeremy@;Zawodny.com] Sent: Monday, October 28, 2002 1:00 PM To: Michael T. Babcock Cc: '[EMAIL PROTECTED]' Subject: Re: Replication and ALTER On Mon, Oct

fs/table size ... cd

Hi ! i forgot to tell You (sorry !) that DB has to be run on linux. ps. sql,query - included for filter. greetz boka --- Tytus na Dzikim Zachodzie < http://tytus.wp.pl/ >

Building MySQL 4.0.4 with Borland 5.0.2

Has anyone had any luck building MySQL 4.0.4 from the win32 source using the Borland 5.0.2 Compiler? Please let me know if it is possible and where can I find some guidance as to what I have to do. Thank you, JFernando *** sql *** ---

mysql doesn't start with ./support-files/mysql.server script

Description: 1. I am running RedHat 7.2 with mysql-3.23.53a 2. If I go to mysql directory as a root and try to start mysql over there using ./support-files/mysql.server script it produces the error: cd /usr/local/mysql [root@jnikom mysql]# ./support-files/mysql.server ./support-files/mys

Re: mysqld bringing down server

universe wrote: Hi David, I've seen a similar behavior on our machine. We had someone re-write the code for a particular PHP site that was producing tons of slow queries (while the CPU was 100% idle the script would still take 15 seconds to run its queries) and the problem was (sort of) fixed.

RE: Altering Table errors

But after a while it does, cause I only have to wait a while with no activity on the database, and the command executes. So it's not permissions Alan > -Original Message- > From: gerald_clark [mailto:gerald_clark@;suppliersystems.com] > Sent: Tuesday, 29 October 2002 1:38 > To: Alan McDona

fs/table size ...

Hi ! This is my first posting to this group so: hello to everybody. I`m using snort (IDS) with logging to MySQL DB. Snort is little bit "noisy" and it inserts a lot of datas in DB - about 130MB/4h. I`m confused about: is it better to use fs with support more then 2GB files (ext3, ReiserFS (whic

Re: InnoDB and auto_increment fields

> > stored? Why isn't this done automatically as it is for [ISAM] tables? > As for the "why", I'm not a MySQL developer, but I believe the reason > goes something like this: When ISAM tables were implemented, they did > it the "wrong" way. When other table types came along, they fixed > this "bug

Re: InnoDB and auto_increment fields

> stored? Why isn't this done automatically as it is for [ISAM] tables? As for the "why", I'm not a MySQL developer, but I believe the reason goes something like this: When ISAM tables were implemented, they did it the "wrong" way. When other table types came along, they fixed this "bug" and do

C-API and multiple resultsets

Hi! If I use mysql_use_reult() of the C-API, I must use two connections to traverse two different result sets at the same time. Is that right? Thanx, Stefan sql, query - Before posting, please check: http://www.mysql.com/m

RE: mysql odbc bug? with centura application using bind variable

Hi !! > Hi, > > I'm using: > -- > > - W98 > - MySql ODBC (MyODBC-3.51.04.exe) / Tried also > (myodbc-2.50.39-win95.zip) > - Application with Centura Team Developer CTD 1.5.1 PTF6 > (Gupta Sqlwindows) > - MySql Server on Linux 3.23.48-19, (from Suse Linux 8.0) > > Problem: > -

Re: Replication and ALTER

On Mon, Oct 28, 2002 at 12:17:20PM -0500, Michael T. Babcock wrote: > Say I have a database that is being properly replicated to > another server and I want to alter it on both machines (say, add a new > column). Will this also be sent with the SQL update log to the second > server, or must I d

Re: hashref array loading

Ramon Hildreth wrote something about SQL: Does anyone know how to load a hashref into an array, and then display a html table using the contents of that array. Any help would be greatly appreciated. Sounds like there's more to your question than you're bothering to type. Please see http:/

Re: mysqld bringing down server

Hi David, I've seen a similar behavior on our machine. We had someone re-write the code for a particular PHP site that was producing tons of slow queries (while the CPU was 100% idle the script would still take 15 seconds to run its queries) and the problem was (sort of) fixed. Have a constant lo

RE: database corrupted after power switched off

>From: "Ed Carp" <[EMAIL PROTECTED]> > >> is it a normal behaviour that a sql databases gets corrupted if >> the power of >> the whole system will be switched off while an application is >> writing to the >> database ? > >Yes. > >> what can i do that this problem does no more appear ? > >Buy a UPS

RE: Hashref array loading

-Original Message- From: [EMAIL PROTECTED] [mailto:mysql@;lists.mysql.com] Sent: Monday, October 28, 2002 11:42 AM To: Ramon Hildreth Subject: Re: Hashref array loading Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the f

re: Free space in Database

Silmara, Monday, October 28, 2002, 3:58:18 PM, you wrote: S> How do I know how much free space I have in my database innodb? STABLE STATUS LIKE "table_name" shows you free InnoDB space. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ens

re: small bug in mysqlcheck

Guy, Saturday, October 26, 2002, 10:42:43 PM, you wrote: GC> When trying to check/repair/analaiz a table with a name like 'table-name' GC> mysqlcheck (from source package 3.23.53) fails with: GC> mysqlcheck: Got error: 1064: You have an error in your SQL syntax near '-name' GC> at line 1 when exec

re: re: Table-sizes, number of tables etc

M, Monday, October 28, 2002, 2:55:44 PM, you wrote: >>Monday, October 28, 2002, 2:00:28 PM, you wrote: >> >>MS> At 13:36 +0200 28-10-2002, Victoria Reznichenko wrote: >> >>MdB> 2) How many entries can one single table have? MdB> (The absolute maximum) There are no limits on number of

mysqld bringing down server

I now maintain a popular internet sports portal which runs mySQL. Last weekend, the server (x86 linux) started grinding to a halt. When I list the processes, there are many, many (much more than the number of webserver threads!) mysqld threads running at once, sitting on the CPU for long

using libmysqld - can't connect to remote DB as client.

Nobody answered my question, so I felt like I should ask again ... I'm using libmysqld to embed a mysql server in my C app. However, I'd also like to connect to other remote mysql databases as well, but the "mysql_real_connect" command doesn't seem to be working when trying to connect to a remote

Is BACKUP / RESTORE making my table corrupted

Greetings... I used BACKUP command to backup all the tables in a database which has only MyISAM tables ( since backup only works with MyISAM table ). Everything was OK. Then after some time I did the RESTORE COMMAND, but before that I deleted all the tables in the database...in two tables,,,i got

safe_mysqld bind-address

Hi all , I am trying to do the following : [root@xxx bin]# ./safe_mysqld --bind-address=192.168.1.222 Starting mysqld daemon with databases from /usr/local/mysql/var but when I telnet xxx 3306, the mysqld have the following response: ./safe_mysqld: line 1: 12325 Segmentation fault nice -

Replication and ALTER

Say I have a database that is being properly replicated to another server and I want to alter it on both machines (say, add a new column). Will this also be sent with the SQL update log to the second server, or must I do the altering on both machines myself? -- Michael T. Babcock C.T.O., Fibre

re: RE: What if binary log's suffix number exceeds 999?

alita, Monday, October 28, 2002, 3:13:54 PM, you wrote: a> Then, what's the limit of suffix numbering? Seems, there is no limit of numbering. >> -Original Message- >> From: Victoria Reznichenko [mailto:victoria.reznichenko@;ensita.net] >> Sent: Monday, October 28, 2002 10:01 PM >> To:

RE: self relation query help

This is probably going more into db design than pure mysql issues...on the other hand if performance is at stake with these different designs. After several inputs - which I am EXTREMELY thankful for - here are some of my thoughts. The solution using Joseph's table aliases works beautifully. Wi

Re: database corrupted after power switched off

Mark wrote: Again, make sure you check how your OS deals with >> write caching << and consider turning it off on the partition / disk you're using for DB storage. I would certainly not do that. In fact, disk caches (for non 4.04 users) are an excellent, be it a poor man's, way of having a

Re: database corrupted after power switched off

Thanks. You're right, of course. Nevertheless, I think the suggestions I made should help. (Context: There was a post asking how to avoid table corruption. There were several replies suggesting UPS. I suggested that, in addition to UPS, there were two other things that could be done.) (1) U

Re: database corrupted after power switched off

Original Message - From: "Michael T. Babcock" <[EMAIL PROTECTED]> To: "Bill Easton" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; "Tom Thurnherr" <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 4:18 PM Subject: Re: database corrupted after power switched off > Again, make sure you chec

Re: database corrupted after power switched off

Bill Easton wrote: ... which says "MyISAM table format is very reliable (all changes to a table is written before the SQL statements returns)" Evidently, this is NOT true. (Perhaps, it used to be true for ISAM tables. The documentation should be changed.) You are misinterpreting the stateme

re: database corrupted after power switched off

VR>Date: Mon, 28 Oct 2002 12:35:01 +0200 VR>From: Victoria Reznichenko <[EMAIL PROTECTED]> VR>Subject: re: database corrupted after power switched off VR>Tom, VR>Monday, October 28, 2002, 11:59:16 AM, you wrote: VR>TT> is it a normal behaviour that a sql databases gets corrupted if the power of V

mysql.h: no such file or directory

dear everybody, I tired to use mysqlhotcopy, but then I got the following error message: can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.6.1/i386-linux /usr/lib/perl5/5.6.1/ /usr/lib/perl5/site_perl/5.6.1/i386-linux

Free space in Database

How do I know how much free space I have in my database innodb? MySql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this th

Re: backups without revealing password

create a .my.cnf file in your home directory, and enter the useid and password here. David T-G wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all! I would like to dump my mysql databases to cold files for separate backups; we're too cheap to buy the database agent that will do it liv

Re: Altering Table errors

Error 13 is an operating system privilege violation error. the user 'mysql' does not own or have access to something in the database. Alan McDonald wrote: MySQL I asume that when I add a field or rename a field etc and get the errcode 13, that I must wait til a connection timeout has occurred

Re: Lost my socks...

[EMAIL PROTECTED] wrote: Try a "touch /var/lib/mysql/mysql.sock" NO. Do not do this. It will cause problems later when you try to start the server. Although it is a special file it may just work this way. Also make the permissions to "chmod 777 mysql.sock" and "chown mysql.mysql mysql.s

Problem with indexed joins

Hi, I'm relatively new to MySQL, and am having trouble with the optimization of some of the queries. I have two tables (T_PERSONNE and T_DEVIS) which are supposed to be linked by a foreign key (T_PERSONNE.PERS_ID = T_DEVIS.DEV_PERS). I've put an index on the foreign key (DEV_PERS), and even

Re: backups without revealing password

On Mon, 28 Oct 2002, David T-G wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi, all! > > I would like to dump my mysql databases to cold files for separate > backups; we're too cheap to buy the database agent that will do it live. > > I started with > > mysqldump --user=root --pa

Re: Shutting off power

Ed Carp wrote: Buy a UPS or shutdown the system normally. NEVER just turn off power to a computer. Or even, use a UPS _and_ shut down the system properly _and_ use sync'd writes to the partition your database is on (or at least the partition your recovery logs are on). PS, I hate this s

backups without revealing password

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all! I would like to dump my mysql databases to cold files for separate backups; we're too cheap to buy the database agent that will do it live. I started with mysqldump --user=root --password=showtheworld --all-databases > ... as I've seen i

RE: self relation query help

Yes, at first it may seem that groups are just another form of artist, and that your searches would be simpler, but if you put them both in a single table, how do you model someone like say Paul McCartney, who was in the Beatles and Wings? Or Yo Yo Ma, who has guested with every important symphony

Re: BLOB inserts vs. storing filepath

John Meyer wrote: Hi, I've got a client that I'm trying to convince to store the file path in the database rather than the file itself into the database. Is there any statistical data to show how much of a hit you take doing it as a BLOB vs. a filepath? Assuming MySQL is equally efficient to

Altering Table errors

MySQL I asume that when I add a field or rename a field etc and get the errcode 13, that I must wait til a connection timeout has occurred to be able to make this structural change. While I'm developing, is there a quicker way to do this? Stopping/starting the service is not that quick.. Is there

RE: What if binary log's suffix number exceeds 999?

Then, what's the limit of suffix numbering? -- Chung Ha-nyung SayClub NeoWiz > -Original Message- > From: Victoria Reznichenko [mailto:victoria.reznichenko@;ensita.net] > Sent: Monday, October 28, 2002 10:01 PM > To: [EMAIL PROTECTE

Re: Is it possible to replicate just a couple of tables insteadof the whole database

Ralf Koellner wrote: > Hi, > > Is it possible to replicate just some tables instead of a whole mysql > database? A replication of the whole database would be not necessary in > my case. It would be a one-way replication (means slave won't update > master). You can use 'replicate-do-table' on sla

re: What if binary log's suffix number exceeds 999?

Chung, Monday, October 28, 2002, 11:14:59 AM, you wrote: CHn> By default, binary log file uses 3-digit number suffix as its counter. CHn> Then, without reseting master logs suffix number may reach 999. If so, CHn> what happens? CHn> next suffix number is 1000 or 001? Otherwise error occurres?

re: SEGFAULT unless reverse...

jonfray, Friday, October 25, 2002, 5:19:24 PM, you wrote: jamtdc> Description: jamtdc> I have the same problem as a previous mail : jamtdc> # http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:107859 jamtdc> But I couldn't find the final issue (except adding every host in jamtdc

re: Re: Is it possible to replicate just a couple of tables instead of the whole database

Ralf, Monday, October 28, 2002, 11:48:22 PM, you wrote: RK> Is it possible to replicate just some tables instead of a whole mysql RK> database? A replication of the whole database would be not necessary in RK> my case. It would be a one-way replication (means slave won't update RK> master). R

re: Table-sizes, number of tables etc

>Monday, October 28, 2002, 2:00:28 PM, you wrote: > >MS> At 13:36 +0200 28-10-2002, Victoria Reznichenko wrote: > >>MdB> 2) How many entries can one single table have? >>>MdB> (The absolute maximum) >>> >>>There are no limits on number of rows. > >MS> What if the values for Primary Key run out? > >

mysql odbc bug? with centura application using bind variable

Hi, I'm using: -- - W98 - MySql ODBC (MyODBC-3.51.04.exe) / Tried also (myodbc-2.50.39-win95.zip) - Application with Centura Team Developer CTD 1.5.1 PTF6 (Gupta Sqlwindows) - MySql Server on Linux 3.23.48-19, (from Suse Linux 8.0) Problem: Using bind variable in selec

Re: Is it possible to replicate just a couple of tables insteadof the whole database

Hi, Is it possible to replicate just some tables instead of a whole mysql database? A replication of the whole database would be not necessary in my case. It would be a one-way replication (means slave won't update master). Furthermore: Is there a cheep tool taking care of that (without chang

gcc3

Hi to all, i can't compile sqlplus.hh with gcc3. do someone has tried this ? Thanks Yann Taillade-Carrière Services Techniques de la Navigation Aérienne, SubDivision 7VI tél 05 62 14 50 47 - Before posting, please check: ht

re: re: Table-sizes, number of tables etc

M, Monday, October 28, 2002, 2:00:28 PM, you wrote: MS> At 13:36 +0200 28-10-2002, Victoria Reznichenko wrote: >>MdB> 2) How many entries can one single table have? >>MdB> (The absolute maximum) >> >>There are no limits on number of rows. MS> What if the values for Primary Key run out? You get "

Performance degradation over time

I have a script written in python running on Suse linux using mySQL 3.23.32. There are two tables each with an auto-increment key and one index. Table 1 has a maximinum of 1,000,000 records and table 2 has a maxminum of 20,000,000 records. The script performs a mixture of inserts, updates, deletes

Need a little query help

I am trying to select some data from a hotel database I am putting on the web. Currently I am using two temporary tables and three queries to get the data, but I suspect it can be done in one query by a better knowledge of SQL. The tables are Hotels: ID, PostCode, ShowHotel AmenityLink: ID, Hotel

re: Table-sizes, number of tables etc

At 13:36 +0200 28-10-2002, Victoria Reznichenko wrote: >MdB> 2) How many entries can one single table have? >MdB> (The absolute maximum) > >There are no limits on number of rows. What if the values for Primary Key run out? Can you use a unsigned bigint as Primary Key? I mean, we /have/ to store

Re: MYSQL newbie :-)

the manual is a very good place to start , its very organized , and its complete reference , better than any book . trial and error is good , but try to get a graphical user interface beter than the shell . there are many . --- [EMAIL PROTECTED] wrote: >This has probably been asked a thousand ti

re: Date as field default

Jerry, Monday, October 28, 2002, 12:24:05 PM, you wrote: J> What do I put in a date field's default value if I want J> the MySQL database to insert the current date in the J> field when J> a new record is inserted? What about TIMESTAMP column type? http://www.mysql.com/doc/en/DATETIME.html

re: re: ERROR 2013: Lost connection to MySQL server during query

Davide, Monday, October 28, 2002, 9:56:46 AM, you wrote: DP> Thanks for your help, we have installed MySQL 2.23.53a on Red Hat 8.0. DP> The problem seems to be the version of RedHat. We have now installed the DP> same version of MySql on RedHat 7.3 and it seems to work fine. Can you DP> give me a

re: Inserting value from other table in query

Michael, Saturday, October 26, 2002, 6:42:41 PM, you wrote: MTB> I want to do: MTB> SELECT @Rate:=Rate FROM Project WHERE ProjectID = 'x'; MTB> INSERT INTO BillingTime (Start, End, ProjectID, Rate) values (a, b, x, MTB> @Rate); MTB> ... but I'm sure its doable in a single query, even if I have

re: Table-sizes, number of tables etc

Michelle, Saturday, October 26, 2002, 6:59:28 PM, you wrote: MdB> I am trying a "worst-case-scenario" of my databse. MdB> I have, so far, come up with some numbers to do the MdB> calculations with and perhaps a way of splitting one MdB> big table into smaller, yet structured, tables. MdB> (These

re: Security question

Daniel, Monday, October 28, 2002, 1:06:10 AM, you wrote: DLS> In my mysql.db file, I have some lines like: DLS> %.private | somedb | someuser | Y | Y | Y | Y | Y | Y | N | Y | Y | Y DLS> So, I have an internal domain called private, those hosts are in an DLS> internal DNS, and can be reverse

re: re: Re: problem upgrading

Hello Lance, Wednesday, October 23, 2002, 4:16:16 PM, you wrote: >>LU> I have /tmp symlinked to /var/tmp, and /var is a writable partition, >>while / >>LU> is readonly. When / is readonly mysqld is not able to run. >> >>LU> I've tracked down the problem to the safe_mysqld script. The problem is

re: RE: large amount of aborted_connects

Hello Jennifer, Thursday, October 24, 2002, 12:29:25 AM, you wrote: >> I'm having trouble with a an obscene amount of aborted_connects on my >> MySQL database servers. I have 3 dedicated database servers, one >> of them is >> a master database with 2 slaves, and the other 2 are stand-alone >> d

Using a query as a source for another query?

G'day all, Is it possible to use a query as a source for another query? For example... Query 1: SELECT COUNT(*) AS TotalSurveys, SurveyDate FROM Surveys GROUP BY SurveyDate; Query 2: SELECT MIN(TotalSurveys) AS MinSurveys, MAX(TotalSurveys) AS MaxSurveys FROM ; I am using 3.23.53 on a Windows

Re: MYSQL newbie :-)

>This has probably been asked a thousand times before but only once from me. >I am able to programme in MS Access to quite a high level to which I have now >realised its limitations, where is the best place to start learning and reading up on >MYSQL, I am not really a book reader as I prefer to d

Re: MYSQL newbie :-)

On Mon, 28 Oct 2002 [EMAIL PROTECTED] wrote: > This has probably been asked a thousand times before but only once from me. > I am able to programme in MS Access to quite a high level to which I have now >realised its limitations, where is the best place to start learning and reading up on >MYSQL

MYSQL newbie :-)

This has probably been asked a thousand times before but only once from me. I am able to programme in MS Access to quite a high level to which I have now realised its limitations, where is the best place to start learning and reading up on MYSQL, I am not really a book reader as I prefer to do th

re: database corrupted after power switched off

Tom, Monday, October 28, 2002, 11:59:16 AM, you wrote: TT> is it a normal behaviour that a sql databases gets corrupted if the power of TT> the whole system will be switched off while an application is writing to the TT> database ? Yes. Other situations when tables may become corrupted are listed

Re: date_sub, must use a datetime column type?

> >Is it true that the date_sub function(s) will only work on datetime column >>types? > > >>SELECT count(id) as id FROM messages WHERE client_id = '2' AND datetime_col >> > date_sub(NOW(),interval 1 day) >> >>To get the above query to work, I had to change my datetime_col column from >>timestamp t

Date as field default

What do I put in a date field's default value if I want the MySQL database to insert the current date in the field when a new record is inserted? TIA, Jerry - Before posting, please check: http://www.mysql.com/manual.php (

Re: date_sub, must use a datetime column type?

>Hello List, > >Is it true that the date_sub function(s) will only work on datetime column >types? > >SELECT count(id) as id FROM messages WHERE client_id = '2' AND datetime_col > > date_sub(NOW(),interval 1 day) > >To get the above query to work, I had to change my datetime_col column from >timest

RE: database corrupted after power switched off

> is it a normal behaviour that a sql databases gets corrupted if > the power of > the whole system will be switched off while an application is > writing to the > database ? Yes. > what can i do that this problem does no more appear ? Buy a UPS or shutdown the system normally. NEVER just turn

re: LEFT JOIN selects with ORDER BY and WHERE and LIMIT missing results

toasty, Sunday, October 27, 2002, 11:17:53 PM, you wrote: taddc> Under some pretty specific conditions, adding a "LIMIT" clause to a query taddc> will cause incorrect results. taddc> How-To-Repeat: taddc> This bug is NOT present in 4.0.3. taddc> CREATE TABLE `history` ( taddc> `id_pic` int(11

re: date_sub, must use a datetime column type?

Qmail, Monday, October 28, 2002, 11:48:14 AM, you wrote: QL> Is it true that the date_sub function(s) will only work on datetime column QL> types? QL> SELECT count(id) as id FROM messages WHERE client_id = '2' AND datetime_col > date_sub(NOW(),interval 1 day) QL> To get the above query to work,

re: plz help...tables getting corrupted...

Akash, Sunday, October 27, 2002, 10:49:55 AM, you wrote: A> I came across a strange problem in MySQL. Some of the tables are getting A> corrupted. The most common error messages which I encountered are : "Can't A> open file: 'tablename.MYD'. (errno: 145)" and "Got error 127 from table A> handl

database corrupted after power switched off

hello. is it a normal behaviour that a sql databases gets corrupted if the power of the whole system will be switched off while an application is writing to the database ? what can i do that this problem does no more appear ? thanx tom --- bbv Software Services Tom Thur

date_sub, must use a datetime column type?

Hello List, Is it true that the date_sub function(s) will only work on datetime column types? SELECT count(id) as id FROM messages WHERE client_id = '2' AND datetime_col > date_sub(NOW(),interval 1 day) To get the above query to work, I had to change my datetime_col column from timestamp to date

What if binary log's suffix number exceeds 999?

Dear, By default, binary log file uses 3-digit number suffix as its counter. Then, without reseting master logs suffix number may reach 999. If so, what happens? next suffix number is 1000 or 001? Otherwise error occurres? sql. query. :( Regards, -- Chung Ha-nyung Sayclub

Re: root password

On Sat, 26 Oct 2002 [EMAIL PROTECTED] wrote: > Hi, > > I am learning MySql and was going through the manual.html in the > /usr/share/doc/mysql.../Docs/ I know SQL already and made some > changes to the user table of mysql database. The server is running but I > cant get a privileged access.

root password

Hi, I am learning MySql and was going through the manual.html in the /usr/share/doc/mysql.../Docs/ I know SQL already and made some changes to the user table of mysql database. The server is running but I cant get a privileged access. I changed password=y for root user. Now the ho

can't find messagefile errmsg.sys

10/27/02 Your [EMAIL PROTECTED] spit me out in a very nasty manner, eventhough I DID follow your guidelines to the best of my ability and this error is about the mysql daemon not starting. I'm not exactly encouraged by this and I'm wondering how much good it is going to do me that I spent a lot

re: ERROR 2013: Lost connection to MySQL server during query

Thanks for your help, we have installed MySQL 2.23.53a on Red Hat 8.0. The problem seems to be the version of RedHat. We have now installed the same version of MySql on RedHat 7.3 and it seems to work fine. Can you give me a confirmation of this problem? Thanks Davide On Fri, 2002-10-25 at 15