Re: how to query for the primary key?

Hi, > This seems like a dumb question--sorry. Looking at my table it shows > 'MUL' instead of 'PRI' like the other tables. Did I forget to code > unit_id as primary? Thanks, Justin mysql> show index from property_units; Regards, Sasa »mysql, select, database« ---

Re: Query

It will be very easy if your records have timestamps (automatically set to the time when the row was created). Then you could just write something like this: SELECT * from yadda where yadda_timestamp < NOW(); Or, if resolution by date is enough (timestamp has MMDDHHMMSS), you could try

mysql row position

Hi I'm looking for a php function that will return the position of the pointer in a mysql recordset. I found mysql_data_seek, but this appears to only move the pointer, I need to get the equivalent row number for the pointer position before moving it, then return to the same position. Can anyon

Re: maybe a bug

* [EMAIL PROTECTED] > In order to remove the first character '0' of the field 'number', > I want to use the following sql query to select the field from my > database. > > select right(number, > if(locate('0',length(number))=1,length(number)-1,length(number))) > as 'no_zero' from mydatabase or

Use mysql binary or build my own ?

Hi list, I've got a mysql dedicated server. Some piece of hardware : SMP : 2 * Intel PIII 1 Ghz 1Go of ram Scsi - Raid 5 Hdds Linux red-hat 7.2 This system run mysql 3.23.49 (tar.gz binary from Mysql.com ). I only have one MyIsam table with around 5 Millions of records ( around 1.2 Go disk space

Re: mysql row position

Zac, what is your indicator of which row it is? If you have aprimary key for each row, why don't you just use that? You cant really determine the position of a row if you haven't determined the criteria that fixes the position, right? So, you just decide wether you will sort it alphabetically or

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

If you use "org.gjt.mm.mysql.Driver" of Mark Mathews and you have a TCP/IP based network: connection = DriverManager.getConnection("jdbc:mysql:///?user= &password="); can be: - ("localhost" or IP adress 127.0.0.1) for local machine; - a remote host identifier for a remote machine( ex name o

[PATCH] LOCK TABLES missing a needed check in 4.0.1

>Description: Any LOCK TABLES command (both READ and WRITE), executed from a non-root MySQL user, would fail, giving a 'select command denied' error message. This showed up as Bugzilla being unable to update a bug's state, since locking the necessary tables would fail every time. Unfortunately,

Re: mysql row position

Eivind, Thanks for your response, perhaps if I tell you more of the story then it'll make more sense. I'm afraid I seem to have an ability for asking cryptic questions. Below is the code I'm using, it is meant to check for a list of words in a table then return the key of the words found, for th

Replication problem

Hi, I used replication as a real-time backup for months and I'am now trying to configure a two-way replication between two MySQL servers (srv1 and srv2). So, srv1 replicates from srv2 and srv2 replicates from srv1 (They are both master and slave). The One-way replication is working fine from srv1

autoextend in 3.23.51 rpm not accepted

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: innodb_data_file_path = ibdata1:512M:autoextend;ibdata2:256M:autoextend; complaining of an unrecognized option. Thanks, Nico

Merge tables: unexpected behaviour and mysqld crash

Hi, I'm trying to make use of the new(ish) merge table type, and am running into two problems. The first is unexpected behaviour, the second is a straight MySQL server crash. I have tested 3.23.47, 3.23.49 and 3.23.51 with similar results. Details below refer to 3.23.51. I have also tested on Dar

Re: easy question

chad, Thursday, June 13, 2002, 4:59:13 PM, you wrote: ck> I am sure this is an easy question but I am not thinking clearly for some ck> reason. :^) ck> If you set a column to auto_Increment. You do not have to put the ck> auto_increment # in the insert statement to get it to be inse

Re: Core dump: date_format('%b') with corupted data

Radoslaw, Thursday, June 13, 2002, 4:03:08 PM, you wrote: RK> I run mysql3.23.49/myisam with linux 2.4.18/libc2.2.5. RK> Some time ago I've hardware crash. Myisamchk didn't report RK> any problems but after some time mysql got SIGSEGV. [skip] Can you send me binary files of your table for testi

Re: Help! 3.23.51 for Windows is completely broken

Richard, Friday, June 14, 2002, 10:02:18 AM, you wrote: RT> mysqld and msqladmin are completely nonfunctional. RT> mysqladmin does not parse ANY option (hence cannot run shutdown, RT> report status, etc.) RT> mysqld breaks on ALMOST EVERY option in my.cnf, and aborts with RT> "signal 11" when

Re: how to query for the primary key?

justin, Friday, June 14, 2002, 4:52:12 AM, you wrote: jc> This seems like a dumb question--sorry. Looking at my table it shows jc> 'MUL' instead of 'PRI' like the other tables. Did I forget to code jc> unit_id as primary? Thanks, Justin jc> mysql> desc property_units; jc> ++--

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.

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: 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: 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: 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

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: 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

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

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

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 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: 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.

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:/

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

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

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.

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:/

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

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: 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

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: 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: 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: 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: 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

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

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 -

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)

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

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: 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: > |

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

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

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.

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

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

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

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

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) >

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

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: 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

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

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

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

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

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: 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

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: 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, .

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: 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

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: 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? >[/

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

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

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

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

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: 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,

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: 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

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?

[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

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

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: 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

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

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

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: 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

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 # ?

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

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 # ?

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: 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: 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

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

[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

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

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

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

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

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

  1   2   >