Setting up InnoDB

Hi I tried setting up MySQl 3.23.50 Max I had installed and when i tried to start , it throws up the error message .But i need InnoDb to be started.. The error message when i start mysql is C:\mysql\bin>mysqld-max --standalone --console Cannot initialize InnoDB as 'innodb_data_file_path' is not

Problem with PHP, but I know it MySQL

Hi, I am working on a movie database I have two database that I am calling from but the problem I am having when I ask it to go and fetch all the movies with the same title, it stops and only shows one. Here is a basic layout... if($videoid) { $result = mysql_query("SELECT * FROM library WHER

unable to start msyql after installing from binary (Slackware 8.0)

>Description: I have just completed the installation of the mysql binaries (mysql-3.23.49-pc-linux-gnu-i686.tar.gz) per the installation instructions, and am unable to start the mysql server--I receive the message "mysql ended", and a ps -e or ps -aux fails to show an entry for mysql.

Re: Problem with load data infile and user's privileges

At 20:23 -0400 6/14/02, Sergey wrote: >OS Linux Red Hat 7.2 >MySql 3.23.41 > >Hi All! >That is my steps. > >With root privileges >I doing: >GRANT ALL ON mydb.* TO client@localhost identified by "pwd"; >I got: >OK > >With client privileges !!! >I doing: >mysql -u client -p >passwd >CREATE DATAB

Re: Problem with load data infile and user's privileges

On Fri, 14 Jun 2002, Sergey wrote: > With root privileges > I doing: > GRANT ALL ON mydb.* TO client@localhost identified by "pwd"; > I got: > OK > > > Then I doing: > LOAD DATA INFILE "/usr/data/myfile" INTO TABLE tab01; > I got: > ERROR 1045 Access denied fot user: 'client@localhost' (Using

Problem with load data infile and user's privileges

OS Linux Red Hat 7.2 MySql 3.23.41 Hi All! That is my steps. With root privileges I doing: GRANT ALL ON mydb.* TO client@localhost identified by "pwd"; I got: OK With client privileges !!! I doing: mysql -u client -p passwd CREATE DATABASE mydb; I got: OK CREATE TABLE mytable ( col01 CHAR(

Re: varchar to char ...

well, no, a Char field certainly won't take less space than Varchar but it helps in optimizing space since mysql can manage space better when it knows the exact length of the row. Hence, if you delete a record, instead of leaving a hole on the disk (in Varchar), it will fill it up with another rec

Re: Mysql Replication

On Fri, Jun 14, 2002 at 03:09:49PM -0700, David McInnis wrote: > I am having a problem with replication. > > I had a master / slave environment set up and running successfully. I > then took the slave offline for a while and made substantial changes to > the master. > > Then I master copied t

RE: varchar to char ...

What do you mean by optimization of the column? Are you saying that char takes less space than varchar or the performance on char is better in queries compared with varchar ? The whole concept of "CREATE AS" is that you want target table to inherit all the properties with the data of the s

Re: alter column without dropping

If you aren't good with sql commands you could try one of the many gui interfaces that are out that, I use phpMysqlAdmin and Kmysqladmin (KDE) they work really great at alter tables. Chuck Payne On 6/14/02 6:51 PM, "Peak Digital Productions" <[EMAIL PROTECTED]> wrote: > Thank you - I'd already

Where can I get libmysql.so

Hi, I'm looking for the libmysql.so library. Does anyone know where I can get this? -Hoa _ Chat with friends online, try MSN Messenger: http://messenger.msn.com --

Re: FileMaker Pro -> MySQL

On Fri, 2002-06-14 at 20:57, Chris Garaffa wrote: > So my Linux server machine (Pentium MMX 225, RedHat 7.1) is up and running > with Apache and MySQL... I'm going to stop using my iMac (Mac OS X) for > database stuff. I have a very large database in FileMaker Pro, though, and > I'd love to know i

Re: alter column without dropping

Thank you - I'd already looked there but somehow overlooked it. TGIF. Paul > From: "William R. Mussatto" <[EMAIL PROTECTED]> > Date: Fri, 14 Jun 2002 15:28:19 -0700 (PDT) > To: Peak Digital Productions <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: alter column without dropping > >

Re: varchar to char ...

Mysql optimizes the column type while creating the table. Regards, Bhavn. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 14, 2002 2:26 PM Subject: varchar to char ... > Hi guys, > > I have a query.I am not sure if this is a bug or a feature (ha

Re: Mysql Replication

Stop master and slave remove binary logs (hostname.001, hostname.002...) from master remove log index (hostname.index) from master remove master.info from the slave tar data on master untar on slave start master and slave The directories of where the files reside would depend on the method of ins

Re: alter column without dropping

On Fri, 14 Jun 2002, Peak Digital Productions wrote: > Date: Fri, 14 Jun 2002 16:33:05 -0600 > From: Peak Digital Productions <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: alter column without dropping > > The data going into one of my mySQL columns has suddenly changed, so I need > to

RE: Is the order same?

On Fri, 14 Jun 2002, Francisco Reinaldo wrote: > Date: Fri, 14 Jun 2002 12:52:15 -0700 (PDT) > From: Francisco Reinaldo <[EMAIL PROTECTED]> > To: Steve Edberg <[EMAIL PROTECTED]>, Vandana <[EMAIL PROTECTED]> > Cc: Jay Blanchard <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] > Subject: RE: Is the or

alter column without dropping

The data going into one of my mySQL columns has suddenly changed, so I need to change the parameters of the column. Currently, it is varchar(32), I need to change it to varchar(128). Can I do that without dropping the column? Thanks, Paul

Mysql Replication

I am having a problem with replication. I had a master / slave environment set up and running successfully. I then took the slave offline for a while and made substantial changes to the master. Then I master copied the new database environment to the slave server by taring the tables and copy

Re: Increasing an Integer field with SQL statement

At 17:29 -0400 6/14/02, Tab Alleman wrote: >Hi, can I do a sql query in MySQL that would do something like this: > >UPDATE table SET SomeInteger=SomeInteger+1 WHERE (Some Condition) > >I know that this exact syntax doesn't work, but is there a way to do >what I'm trying to do, which is to do a mat

varchar to char ...

Hi guys, I have a query.I am not sure if this is a bug or a feature (ha ha ha...). Table - abc name varchar(30), address varchar(50) Then I run this sql. create table temp_abc as select * from abc; datatypes of the columns changes: Table - temp_abc name char(30

[JDBC / MySQL] Access Denied for User ?

I am not sure if a Java JDBC error is appropriate for this list or not. If not, I apologize in advance. I'm getting the error below that I'm trying figure out where to start researching... "Invalid authorization- access denied for user"... This seems strange b/c I'm using "root" as username, "s

Increasing an Integer field with SQL statement

Hi, can I do a sql query in MySQL that would do something like this: UPDATE table SET SomeInteger=SomeInteger+1 WHERE (Some Condition) I know that this exact syntax doesn't work, but is there a way to do what I'm trying to do, which is to do a math function on an integer in the table with a SQL

RE: Reconstructing SQL create table statements

There's also the SHOW CREATE TABLE sql command: http://www.mysql.com/doc/S/H/SHOW_CREATE_TABLE.html According to http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News-3.23.x this command is available from 3.23.20 on. -steve At 4:39 PM -0400 6/14/0

Re: newbie - start (innodb)

WHAT is not starting? MySQL or innodb? Is there another directive in your my.ini under [mysqld] like: skip-innodb? If so, delete it or comment it out. - Original Message - From: "Silmara Cristina Basso" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 14, 2002 5:12 PM Su

Re: MySQL port # ?

On 14/6/02 at 16:44, [EMAIL PROTECTED] (Laura Findley) wrote: > Does anyone know how to determine what port MySQL is using? > > I need to know the port so that I can use it in a JDBC connection URL. > > Any suggestions on how to get this info? I believe `\s' is the command you need (without t

Re: MySQL port # ?

At 16:44 -0400 6/14/02, Laura Findley wrote: >Does anyone know how to determine what port MySQL is using? > >I need to know the port so that I can use it in a JDBC connection URL. > >Any suggestions on how to get this info? mysql> SHOW VARIABLES LIKE 'port'; +---+---+ | Variable_n

Re: MySQL port # ?

default port is 3306, or look in the my.cnf and if that doesn't work, since your using outlook, i'm guessing your on windows, you can goto a command line and type >netstat -a and see what ports are being used, and try those. On Friday 14 June 2002 3:44, Laura Findley wrote: > Does anyone know

newbie - start (innodb)

This is the configuratin My.ini: [WinMySQLAdmin] Server=C:/MYSQL/bin/mysqld-max.exe user=root [mysqld] basedir=C:/MYSQL #bind-address=192.168.10.10 datadir=C:\mydata innodb_data_home_dir = c:\mydata innodb_data_file_path =sami_d1:100M innodb_log_group_home_dir =c:\mylogs innodb_log_arch_dir =c:\

RE: MySQL port # ?

Take a look in the my.cnf file. -Original Message- From: Laura Findley [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:45 PM To: MySQL List Subject: MySQL port # ? Does anyone know how to determine what port MySQL is using? I need to know the port so that I can use it in a JD

Re: MySQL port # ?

'status' will show that. - Original Message - From: "Laura Findley" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Friday, June 14, 2002 1:44 PM Subject: MySQL port # ? > Does anyone know how to determine what port MySQL is using? > > I need to know the port so that I can

RE: Reconstructing SQL create table statements

if you do mysqldump -d -p -u > then it will pipe only the CREATE TABLE statements and no insert statements into . -Don -Original Message- From: Erik Price [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 4:39 PM To: Hihn Jason Cc: [EMAIL PROTECTED] Subject: Re: Reconstructing S

MySQL port # ?

Does anyone know how to determine what port MySQL is using? I need to know the port so that I can use it in a JDBC connection URL. Any suggestions on how to get this info? Thanks, in advance- Laura - Before posting, please

Re: Reconstructing SQL create table statements

On Friday, June 14, 2002, at 04:06 PM, Hihn Jason wrote: > I have a large number of tables that have been created through the > years, > and I wish to obtain the SQL statements used to create them. I can go > through and do it all by hand, but that would take forever. Is there a > way > to ru

Multi-table deletes

Just wanted to make sure before I proceed to write a script, Muti-table deletes as such: delete from Keyname_Keyvalue,Keyvalue WHERE Keyvalue.KeyvalueKey=Keyname_Keyvalue.KeyvalueKey AND Keyname_Keyvalue.KeynameKey='100'; ERROR 1064: You have an error in your SQL syntax near 'Keyvalue WHERE Keyv

Re: is this query possible?

Hey, that's exactly what I needed! And I can still use WHERE clauses to further limit my results. That's great, thank you! I have one question though. In this LEFT JOIN syntax, you used the following format: LEFT JOIN secondary_table ON primary_table.col = secondary_table.col Is this optim

RE: is this query possible?

[snip] I have a query that I have in mind, but am not sure of how I can actually write it. It might not even be possible. I was hoping someone could tell me if I will have to use two queries instead, or if this will actually work: (In simplified form:) ++ +---+| m

Reconstructing SQL create table statements

I have a large number of tables that have been created through the years, and I wish to obtain the SQL statements used to create them. I can go through and do it all by hand, but that would take forever. Is there a way to run a script against the database that will generate them for me? If it miss

RE: is this query possible?

How bout SELECT main.id, sub1.other, sub2.other FROM main LEFT JOIN sub1 ON main.sub1fk = sub1.id LEFT JOIN sub2 ON main.sub2fk = sub2.id Luc mysql,sql > -Original Message- > From: Erik Price [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 14, 2002 3:54 PM > To: [EMAIL PROTECTED] > Su

Re: MySQL not starting ?

On Friday, June 14, 2002, at 03:48 PM, Laura Findley wrote: > > Normally, I issue the command: > > [root@localhost root]# safe_mysqld -user=root & > [1] 1781 > [root@localhost root]# Starting mysqld daemon with databases from > /var/lib/mysql > 020614 02:09:36 mysqld ended Are you really only

Re: Creating Tables/Keys from PowerDesigner Sql

Well, that would depend if the SQL script generated by your designer is compatible with MySQL, some type names may be different. Good Luck! --- [EMAIL PROTECTED] wrote: > I generated an SQL script of my datamodel in > PowerDesigner which I'd like > to import into mySql to create my tables, keys,

is this query possible?

I have a query that I have in mind, but am not sure of how I can actually write it. It might not even be possible. I was hoping someone could tell me if I will have to use two queries instead, or if this will actually work: (In simplified form:) ++ +---+| main

RE: Is the order same?

Hi, I would not rely on the "insertion order" if I were you. Honestly, I don't know how MySQL deals with it but servers such as Microsoft SQL Server or even Access won't provide a deterministic order unless you sort using sort by. I recomend you to use sort by anyways if you need the result sets

MySQL not starting ?

All- Good afternoon. I was able to get MySQL started this morning but it will not start now. I'm hoping someone may be able to offer a suggestion or insight... Normally, I issue the command: [root@localhost root]# safe_mysqld -user=root & [1] 1781 [root@localhost root]# Starting mysqld daemon

mysql perl query question

I am trying to execute the following mysql query in a perl script... my $sth = $dbh->prepare("select * from servers"); $sth->execute(); my @row; while ( @row = $sth->fetchrow_arrayref()) { foreach $row(@row) { push @SelectedArray, "$row\n\n"; } } print "@SelectedArray"; And I am getting t

obscure mySQLGUI error

Hi, I have just installed the mySQLGUI linux binary. Upon running it, I receive the error "Can't connect to local MySQL server through socket '' (111)". The help file does not address this sort of error. Can you please interpret this error for me and suggest how I may fix it? I just installed

RE: Is the order same?

At 12:00 PM -0500 6/14/02, Jay Blanchard wrote: >[snip] >When I say 'select * from table', can I always be assured of the >order in which the results are retrieved. If I issue the query a second >time, (assuming no new insertions on the table), will I get the results in >the same order, again? >[/

FileMaker Pro -> MySQL

So my Linux server machine (Pentium MMX 225, RedHat 7.1) is up and running with Apache and MySQL... I'm going to stop using my iMac (Mac OS X) for database stuff. I have a very large database in FileMaker Pro, though, and I'd love to know if there's a way to import my FMP database into MySQL 3.23.

Re: replication

The master information should be present in my.cnf on the slave. What does your my.cnf look like? Regards, Bhavin. - Original Message - From: "Pierre Baridon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 14, 2002 7:07 AM Subject: replication > > i am trying to setup a

Re: C API row data not matching database data

At 19:54 +0200 6/14/02, Hihn Jason wrote: >I'm using the C API to return a record which has a field that contains >(somewhat) binary data. It's been properly mysql_escape_string()ed. I'm >using a 3.23.4x server & client. > >When I do a: >select data into outfile 'out' from table where id='1'; >fro

Re: undefined symbol: _dig_vec

use .bash_profile. - Original Message - From: "Hoa Doan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, June 14, 2002 10:13 AM Subject: Re: undefined symbol: _dig_vec > I'm sorry for bugging you, but I don't have the .profile file. I have > the .bashrc, .

C API row data not matching database data

I'm using the C API to return a record which has a field that contains (somewhat) binary data. It's been properly mysql_escape_string()ed. I'm using a 3.23.4x server & client. When I do a: select data into outfile 'out' from table where id='1'; from the mysql client, I get what I expect in the

Re: Syntax dilemma

On Wed, 1969-12-31 at 21:59, Ricardo Fitzgerald wrote: > Hi, > > I'm having trouble trying to insert form data into a mysql db, the > thing is my client wants table data to be splitted, I mean some data > comes from the first form, and the rest from another form. Hi Ricardo! Why not use a

run-all-tests time

Just a quick question on how long this bench mark usually runs for. Started it a while ago and its still kicking away. Know its working because the Questions number keeps on going up.Thanks for the info. -Nick p.s. System is w2k 2gig Intel 4 with 512 ram filter fodder: sql, query

Re: help with query

I think the best way to do this is to set up two tables. One for the main topic list, then one for each sub topic. You may already have this but I cant see it here. Anyways to get your selection order correct you could do something like:SELECT * FROM forum ORDER BY parent_id, id Have any exampls

Re: undefined symbol: _dig_vec

I'm sorry for bugging you, but I don't have the .profile file. I have the .bashrc, .bash_profile, .bash_logout files. My shell is bash. What do I do now? Hoa >From: Bhavin Vyas <[EMAIL PROTECTED]> >To: Hoa Doan <[EMAIL PROTECTED]>, [EMAIL PROTECTED] >Subject: Re: undefined symbol: _dig_vec >D

Creating Tables/Keys from PowerDesigner Sql

I generated an SQL script of my datamodel in PowerDesigner which I'd like to import into mySql to create my tables, keys, etc. How do I accomplish this? Thanks, Jason E. Brawner - Before posting, please check: http://www

Romanian translation of error messages

This is the full romanian translation of the error messages from the MySQL version included in RedHat 7.2. I belive the version is: Ver 11.15 Distrib 3.23.41 from the Linux RedHat 7.2 RedHat put the file "errmsg.txt" in the folder /usr/share/mysql/romanian/ The messages were translated in romania

RE: Is the order same?

[snip] When I say 'select * from table', can I always be assured of the order in which the results are retrieved. If I issue the query a second time, (assuming no new insertions on the table), will I get the results in the same order, again? [/snip] Yes. Data is always sorted from first entered t

Is the order same?

When I say 'select * from table', can I always be assured of the order in which the results are retrieved. If I issue the query a second time, (assuming no new insertions on the table), will I get the results in the same order, again?

Re: A simple query, please help (solved)

Thanks a lot, it worked with the double datatype! On Fri, 14 Jun 2002, Michael Ivanyo wrote: > I've had similar problems with this in my career and > have come to the conclusion that one should always use > double floats. The problem is typically due to round > off errors of the float

Re: A simple query, please help

"select version();" "show create table ...;" - Original Message - From: "Vandana" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 14, 2002 7:01 PM Subject: A simple query, please help > > My table is as follows: > > Value Distance >(float) (float) >

Foreign Key Question

I am using MySql-3.23.51. Even though this version doesn't support foreign keys, the foreign key declarations can be entered without getting an error message. I would like to write CREATE TABLE statements that include foreign key declarations that would be compatible with future releases that wi

help with query

I am trying to get something like the following: Title - topic #1 sub topic #1.1 topic #2 sub topic #2.1 sub topic #2.2 from the following table (I am using php for scripting). forum id int parent_id

executemany & UPDATE (MySQL & Python)

Can anyone confirm that it is *not* possible to pass a list to the Python MySQLdb module in UPDATE operations? In other words, this kind of thing works: self.dbh.execute("INSERT INTO Foo (blah, blorg,snork) VALUES (%s,%s,%s)",myList) ... But this kind doesn't appear to work for me: self.dbh.ex

A simple query, please help

My table is as follows: Value Distance (float) (float) 2.0 42.3 1.0 56.9 3.2 20.0 1.3 18.5 I issued a query, 'update ta

Creating Tables/Keys from PowerDesigner Sql

I generated an SQL script of my datamodel in PowerDesigner which I'd like to import into mySql to create my tables, keys, etc. How do I accomplish this? Thanks, Jason E. Brawner - Before posting, please check: http://www.

changing column to auto-increment

I have a table whose key is currently a regular int. I am manually incrementing it using a second table. If I alter the column type to auto-increment will the next insert find the current highest number and increment that or do I need to do something more? [mysql - sql] -- "Pollution is a resul

Re: MySql version 4.1?

"Remy Dufour" <[EMAIL PROTECTED]> wrote: > Anyone here got a hint about release date of My sql version 4.1 ? It was metioned on the mysql-bugs list today: "Alpha version of 4.1 should come out this year." -- Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> -- ./ premax ./ [EMAIL PROTECTED] ./ ko

Re: pointless question (Pointless Answer)

It's easier (as in less typing) to sort by one field than two. =C= * * Cal Evans * Techno-Mage * http://www.calevans.com * - Original Message - From: "Ray" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 14, 2002 9:23 AM Subject: pointless question > > in the manual: > |

Seem to be short

Sorry, but I had a problem with my e-mail. Anybody can help me?? please Alexander I am using the component Zeos, and when I execute the sql "show create table" the resultset came like that: CREATE TABLE `clientes` ( `cli codigo ID` int(11) NOT NULL auto increment, `cli nome` varchar(50) d

RE: Max in query

[snip] Is there a way to obtain max (or min) value in a query? Example: i want to know the last id in mytable table is there a way to do this query? something like select id from mytable where id = max; or something else? [/snip] Try -- select MAX(id) from mytable; HTH! Jay sql, mysql, query ca

Re: How do i connect my Java Program to a remote MYSQL

Arul wrote: >Hi All > >How do i connect to mysql on a remote machine.. >Is there any client tools available > >Regards, >-Arul > >sql,query > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual)

Max in query

Is there a way to obtain max (or min) value in a query? Example: i want to know the last id in mytable table is there a way to do this query? something like select id from mytable where id = max; or something else? The one i wrote i tried it but it does not work. Thank you Claudio -

pointless question

in the manual: |6.2.6.2 Storage requirements for date and time types | |Column type Storage required |DATE 3 bytes |DATETIME 8 bytes |TIMESTAMP 4 bytes |TIME 3 bytes |YEAR 1 byte so, does datetime do more then date + time? datetime = 8 bytes, date + time = 6 bytes its really a point

RE: timestamp problem ..

whow, this list is so very powerfull .. just give me your address and I'll send you the beer .. what kind of it would you like? -Oorspronkelijk bericht- Van: Luc Foisy [mailto:[EMAIL PROTECTED]] Verzonden: June 14, 2002 16:04 Aan: Wouter van Vliet; MYSQL-List (E-mail) Onderwerp: RE: times

Re: timestamp problem ..

This is exactly what timestamp columns are supposed to do - see http://www.mysql.com/doc/D/A/DATETIME.html The first timestamp column in the table will be automatically updated upon insert/update. Your choices are: (1) Change to datetime type. Then, on insert, insert the current date

Re: MySql version 4.1?

Remy, Friday, June 14, 2002, 4:14:54 PM, you wrote: RD> Anyone here got a hint about release date of My sql version 4.1 ? RD> Gracias ! There is no exact date of 4.1 release. It will suddenly come before then end of the year. :) -- For technical support contracts, goto https://order.mysql

Re: Create database in other location ...

Silmara, Friday, June 14, 2002, 4:59:15 PM, you wrote: SCB> I'm using MySQL 4.0.1 ( Innodb) and I want to create a database SCB> 'c:\mydata\sami_d0' and log file 'c:\mylogs\sami_l0', How can i do that? Set up options in my.cnf. Look at: http://www.mysql.com/doc/I/n/InnoDB_start.html --

Re: update query confusion

Nick, Friday, June 14, 2002, 3:40:23 PM, you wrote: NW> I can't work out why this query is also updating a TIMESTAMP col? It's a paticular feature of TIMESTAMP column. Read the manual: http://www.mysql.com/doc/D/A/DATETIME.html NW> UPDATE news SET title = 'new title', text = 'new text' WHE

Re: timestamp problem ..

Wouter, Friday, June 14, 2002, 4:53:20 PM, you wrote: WvV> I'm having a slight problem with the timestamp column format. When I alter a WvV> table and, add a column of type timestamp all records get the current WvV> timestamp, that's ok. When i insert a new row, all records get the current WvV> t

replication

i am trying to setup a slave server (3.23.50) on solaris 2.7 i follow the manual to set it up but when i start this slave server, i have the following error message from mysqld : bin/mysqld: option `--master' is ambiguous where does this --master come from thanks, Pierre -- sql, que

Re: update query confusion

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Jay Blanchard declared > other column changes value. (Note that an UPDATE that sets a column to the > value it already has will not cause the TIMESTAMP column to be updated, > because if you set a column to its current value, MySQL ign

RE: timestamp problem ..

The first timestamp in any table is automatically updated by mysql every time you modify that record. It is the modify timestamp If you wish to use the timestamp in your table, you should create two timestamps at least and use the second one Modstamp timestamp Usable timestamp See here http:/

Obscure replication error message

>Description: Replication stopped on our MySQL 4.0.1-alpha distribution with the error: Error executing query '%': got error 127 from table handler. (This may not be the exact text). Note the '%', which is what this bug report is referring to. Presumably the text of the query should be there.

timestamp problem ..

Heey Folks, I'm having a slight problem with the timestamp column format. When I alter a table and, add a column of type timestamp all records get the current timestamp, that's ok. When i insert a new row, all records get the current timestamp. That too is ok. But now, when I update one row of th

String seem to be short

I am using the component Zeos, and when I execute the sql "show create table" the resultset came like that: CREATE TABLE `clientes` ( `cli_codigo_ID` int(11) NOT NULL auto_increment, `cli_nome` varchar(50) default NULL, `cli_endereco` varchar(70) default NULL, `cli_bairro` varchar(20) def

Create database in other location ...

I'm using MySQL 4.0.1 ( Innodb) and I want to create a database 'c:\mydata\sami_d0' and log file 'c:\mylogs\sami_l0', How can i do that? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http:/

RE: Replication problem >> Timeout in MySQL

Ok. So i'm a bit confused with all the timeout values. My replication process is killed because of a net_read_timeout which is 30 secondes . I think there's at least three different timeouts : net_read_timeout : The process will be killed if it doesn't receive data during net_read_timeout secs.

MySql version 4.1?

Hi All, Anyone here got a hint about release date of My sql version 4.1 ? Gracias ! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To r

Re: load data infile and warnings

At 12:52 +0200 6/14/02, Harald Fuchs wrote: >In article , >Paul DuBois <[EMAIL PROTECTED]> writes: > >>> I imported a text file and got following results: >>> >mysql> load data local infile 'update.txt' into table PLZV lines >>> terminated by '\r\n' ignore 2

MySQL start fail - signal 11

Hi, I have a problem. I run Debian (libc6 2.2.5-6) and I am not able to start MySQL 4.0.1 I got this error log: - 020613 12:49:06 mysqld started mysqld got signal 11; This could be because you hit a bug. It is also possi

Memlock with a none root user?

Hi, we want to lock the Memory which the MySQL allocs. We use the memlock option in the my.cnf file but it wont work so we expected. Now we run the MySQL as user root (user entry in the my.cnf) and it works. In the documentation stood that running the MySQL under the root user is not good, but

RE: update query confusion

{snip] I can't work out why this query is also updating a TIMESTAMP col? UPDATE news SET title = 'new title', text = 'new text' WHERE id = '4' [/snip] Because, according to TFM; (http://www.mysql.com/doc/D/A/DATETIME.html) Automatic updating of the first TIMESTAMP column occurs under any of the

update query confusion

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all I can't work out why this query is also updating a TIMESTAMP col? UPDATE news SET title = 'new title', text = 'new text' WHERE id = '4' The table is very simple: * id INT * date TIMESTAMP // this is current date when 'updating'? * ti

Re: Re[2]: counting rows ...

Victoria Reznichenko writes: > Hi! > > SM> Are you using our binaries ?? > > Yes. > > SM> If yes, send me a dump of the table and exact queries ... > > It's a strange... > > Seems, troubles occur when there is a fulltext index and the text > column is NOT NULL. Besides, when I do CREATE .. SE

Re: load data infile and warnings

Oliver, Thursday, June 13, 2002, 5:39:52 PM, you wrote: OV> I imported a text file and got following results: OV> mysql> load data local infile 'update.txt' into table PLZV lines OV> terminated by '\r\n' ignore 2 lines; OV> Query OK, 46658 rows affected (0.66 sec) OV> Records: 46658 Deleted: 0

Re: Is this an FAQ?

Phil, Friday, June 14, 2002, 6:14:49 AM, you wrote: PR> I've been trying to "select * table" as a way to review a large table in PR> mysql. But only 1000 rows are returned, whereas there should be about 1200 PR> rows in all. Is this a limitation in mysql? Is there a configuration file PR> w

Re: autoextend in 3.23.51 rpm not accepted

Nico, Friday, June 14, 2002, 1:05:13 PM, you wrote: NS> Hi, I just installed mysql-max 3.23.51, hoping to use innodb autoextend feature, but mysql dies when run with the following row in my.cnf: NS> innodb_data_file_path = ibdata1:512M:autoextend;ibdata2:256M:autoextend; NS> complaining of

Re: Date format

Chuck, Friday, June 14, 2002, 3:01:58 AM, you wrote: CPP> If you have mutli-date fields, can you set one date format in mysql sql CPP> statement for all fields? I have 9 date fields, that like to have the same CPP> format. What do you mean one date format? MySQL stores data in certain format, f.

  1   2   >