>Date: Mon, 17 Nov 2008 10:16:16 +
>From: "Tompkins Neil" <[EMAIL PROTECTED]>
>Subject: Using Replication in mySQL version 5
>We are looking to upgrade our version of mySQL to the latest version of
>mySQL 5. One of the main features we are going to think about using is
>replication for our we
xt?
3. What precautions can one take to avoid a table crash? Are there any
symptoms that show up when a table crash is about to happen? (like: out
of swap memory, disk full, too much system load, ...?)
Any comments/hints/links appreciated,
thanks in advance,
regards,
Roman
--
MySQL Gene
hello everybody
anybody had to deal with this?
i have a windows form created on VB.net to get a report on embbeded crystal
reports develop program
im trying to customize the fields to show by using the CR form via Sql Sintax
option for the fields
but the formula editor seems does not underst
hello .
anybody knows how to export from excel to mysql in order to create or fill a
database table??
tanks for your help and patience
cheers
hello
i'm developing a program on visual.net 2003 where i need to extract data from a
date time format column
working with mysql.net component for extract via mysqlcommands and dataadapters
im fillin datagrills but the column displayed only presents the date but not
the time
im still analiz
# [EMAIL PROTECTED] / 2004-01-08 13:26:26 +0200:
> Lähettäjä: "Roman Neuhauser" <[EMAIL PROTECTED]>
> > # [EMAIL PROTECTED] / 2004-01-06 10:57:52 +0200:
> > > From: "Roman Neuhauser" <[EMAIL PROTECTED]>
> > > > My first question is: wha
# [EMAIL PROTECTED] / 2004-01-06 10:57:52 +0200:
> From: "Roman Neuhauser" <[EMAIL PROTECTED]>
> > My first question is: what is the interaction between MySQL's
> > *_buffer_size and InnoDB's innodb_buffer_pool_size?
> > IOW, are *_buffer_size
This'll probably show my ignorance, but can someone explain why this
select uses index on ob_vl_parametry.info_cs when that column is not
used anywhere in the query?
mysql> EXPLAIN SELECT vp.id
-> FROM ob_vl_parametry_zbozi zp, ob_vl_parametry vp,
-> ob_vl_parametry_kategorie vpk
-
# [EMAIL PROTECTED] / 2004-01-05 13:49:17 +0200:
> I'm running MySQL 4.0.17 on FreeBSD machine. i have one process which rarely
> uses Mysql DB, and few postfix processes which uses db for authorizaton. In
> `top` i see that mysql process usually eats 40-50% +/-20. `mytop` show ~5
> sleeping proces
I've been trying to tune a MySQL installation a bit, and have a few
questions regarding relations/interactions between InnoDB and MySQL
when it comes to the various buffers... I wanted this mail to be more
specific, but given the lack of info in the manual, I basically don't
have much cannon fodder
# [EMAIL PROTECTED] / 2003-09-26 15:12:03 -0700:
> --- Harald Fuchs <[EMAIL PROTECTED]> wrote:
> > Ed Smith <[EMAIL PROTECTED]> writes:
> > > Greetings. When I execute the SQL script below in
> > > mySQL 4.1, I get
> >
> > > ERROR 1216: Cannot add or update a child row: a foreign key
> > > constr
# [EMAIL PROTECTED] / 2003-09-25 14:59:33 +0100:
> CREATE TABLE `pheno` (
> `id` smallint(5) unsigned NOT NULL auto_increment,
> `relevant` enum('y','n') default NULL,
> `phenotype` varchar(50) NOT NULL default '',
> PRIMARY KEY (`id`,`phenotype`),
> KEY `id` (`id`),
> CONSTRAINT `0_12
# [EMAIL PROTECTED] / 2003-09-25 08:58:09 +0300:
> From: "Roman Neuhauser" <[EMAIL PROTECTED]>
> > > > Also, is there a way to *measure* the fragmentation of a table?
> > > > If there is, how should the info be interpreted?
>
> Sorry, no. But addin
# [EMAIL PROTECTED] / 2003-09-24 17:41:29 +0300:
> the row count in SHOW TABLE STATUS is only an estimate based on 8
> dives into the index tree.
ok.
> You had a typical symptom of a fragmented table: space usage much bigger
> than you would expect.
that doesn't answer my questions :) n
# [EMAIL PROTECTED] / 2003-09-23 21:56:55 +0300:
> From: "Roman Neuhauser" <[EMAIL PROTECTED]>
> > A simple question regarding storage allocated / reported by MySQL/InnoDB.
> > If BIGINT takes 8 bytes, and a table has exactly four BIGINT columns,
> > why is t
# [EMAIL PROTECTED] / 2003-09-24 02:32:10 -0600:
> According to documentation, in MySQL version 4.0, it is possible to use
> sub-selects
According to what documentation?
--
If you cc me or remove the list(s) completely I'll most likely ignore
your message.see http://www.eyrie.org./~eagl
A simple question regarding storage allocated / reported by MySQL/InnoDB.
If BIGINT takes 8 bytes, and a table has exactly four BIGINT columns,
why is the reported avg. row length 148 bytes?
mysql> show table status from pmsystem2 like 'editor_competence_product'\G
*** 1. r
nable get useful logs for the developers?
any help is appreciated.
--
Kind regards,
Roman Hochuli
CCNP, CQS Cable
GPS-Technik AG
Zürcherstrasse 139
8952 Schlieren
Switzerland
Tel +41-1-7329977
Fax +41-1-7311840
X-NCC-RegID: ch.gps
While talking a little bit annoyed about taxes:
"...at lea
# [EMAIL PROTECTED] / 2003-06-29 23:24:58 -0500:
>
> > # [EMAIL PROTECTED] / 2003-06-29 13:09:03 -0500:
> > > CREATE TABLE extraFieldOptions (
> > > fieldID tinyint(3) unsigned NOT NULL default '0',
> > > fieldOption varchar(16) NOT NULL default '',
> > > fieldValue varchar(16) NOT NULL defa
# [EMAIL PROTECTED] / 2003-06-29 13:09:03 -0500:
> CREATE TABLE extraFieldOptions (
> fieldID tinyint(3) unsigned NOT NULL default '0',
> fieldOption varchar(16) NOT NULL default '',
> fieldValue varchar(16) NOT NULL default '',
> PRIMARY KEY (fieldID,fieldOption)
> ) TYPE=MyISAM;
> mysq
# [EMAIL PROTECTED] / 2003-06-28 16:56:13 +0200:
> I use mySQL on HP/UX 11.i - unfortunateley I am unable to lookup the
> used version. What is the command to do that? (according to mysql.info
> it is Version 3.23.42. )
SELECT VERSION();
--
If you cc me or remove the list(s) completely I'll
# [EMAIL PROTECTED] / 2003-06-29 08:14:28 +0100:
> The table customer_basket contains the products_id which is no good
> for my routine. What I need to check is the categories_id but there
> is no reference in the customers_basket.
>
> Presumably I need to do a join on the table that holds the ca
# [EMAIL PROTECTED] / 2003-06-17 11:44:46 -0400:
> At 05:14 PM 6/16/2003, Roman Neuhauser wrote:
> ># [EMAIL PROTECTED] / 2003-06-16 15:15:31 -0400:
> >> I can use:
> >>
> >> SELECT sum(if(voidreason>0,0,amt)) as sales FROM sdtik where acctno=1234
> &
please don't top-post.
# [EMAIL PROTECTED] / 2003-06-27 14:01:58 -0400:
> On Fri, 27 Jun 2003, Roman Neuhauser wrote:
> > # [EMAIL PROTECTED] / 2003-06-20 11:07:09 -0400:
> > > I am trying to compile MySQL 3.23.57 on NetBSD 1.6.1. I downloadded
> > > pthre
# [EMAIL PROTECTED] / 2003-06-27 14:44:55 +0200:
> I have a question regarding mysqlhotcopy's use.
> I'd like to use the --flushlog option in order to have a nice backup &
> synchronized log for my replication slave in case of recover need
> (without stopping the master).
> But the lock used by m
# [EMAIL PROTECTED] / 2003-06-20 11:07:09 -0400:
> Hello,
> I am trying to compile MySQL 3.23.57 on NetBSD 1.6.1. I downloadded
> pthreads-1_60_beta6-mysql.tar.gz from your site and extracted it to
> mysql-3.23.57/ I ran ./configure --with-mit-threads in mysql-3.23.57 and
> everything went fine.
# [EMAIL PROTECTED] / 2003-06-27 09:45:06 +0200:
> how can i delete an foreign key between two tables? Is there a drop foreign
> key - command available?
yes, read:
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
--
If you cc me or remove the list(s) completely I'll most likely ign
your MUA doesn't properly represent quotation marks, breaking them
in other MUAs.
# [EMAIL PROTECTED] / 2003-06-25 04:51:49 -0700:
> This follows on a previous mail from me:
>
> When using
> GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
> ?password?
>
> I could not get the passwor
# [EMAIL PROTECTED] / 2003-06-25 14:03:17 +0100:
> Im altering a number of table from MyISAM to innoDb and adding foreign
> keys.
>
> The alteration of the table type works.
> Adding the row as an index works.
> Adding the foreign key fails, generating the error:
>
> alter table project add FORE
# [EMAIL PROTECTED] / 2003-06-24 20:32:48 -0700:
> insert into table1 select * from table2;
>
> Table2 has some 10,000 records while table1 has around
> 11,00,000 records. The time reqd. to execute the above
> query is round about 80- 90 secs.
>
> The table1 has 7 columns out of which 5 are comp
# [EMAIL PROTECTED] / 2003-06-25 02:11:05 -0400:
> I needed to add a new, autoincrementing, primary key column
> to a table and have been struggling to figure out how to
> assign an initial, unique value to each row.
>
> I finally accomplished my task, but feel sure there's an
> easier way.
>
# [EMAIL PROTECTED] / 2003-06-25 07:10:46 +0100:
> Sometime recently Roman Neuhauser said:
> > # [EMAIL PROTECTED] / 2003-06-25 06:18:04 +0100:
> > > alter table p_asset add mydate datetime default 'now()';
> > >
> > > - you need the '' ar
# [EMAIL PROTECTED] / 2003-06-25 06:18:04 +0100:
> Sometime recently MaFai said:
> > A table contains a column named "mydate".
> >
> > //Wrong sql statement
> > alter table p_asset add mydate datetime default now();
> > alter table p_asset add mydate datetime default time();
>
# [EMAIL PROTECTED] / 2003-06-25 15:18:09 +1000:
> From: "Roman Neuhauser" <[EMAIL PROTECTED]>
> > please don't piggyback on other people's threads. you can start your
> > own for free.
>
> Although it was the first time for me to send the
# [EMAIL PROTECTED] / 2003-06-25 12:05:49 +0800:
> //Wrong sql statement
> alter table p_asset add mydate datetime default now();
> alter table p_asset add mydate datetime default time();
> alter table p_asset add mydate datetime default now;
> alter table p_asset add myda
# [EMAIL PROTECTED] / 2003-06-23 11:11:28 -0400:
> I have updated mySQL to the 4.0.13-standard and had no problems UNTIL I
> attempted to run mysql_fix_privileges. This is the error I get:
>
> ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)
>
> /tmp is
# [EMAIL PROTECTED] / 2003-06-23 16:16:50 -0400:
> I installed MySQL (mysql-standard-4.0.13-apple-darwin6.4-powerpc) ...
> but now I get this error in the log file and I am unable to still start
> the MySQL Server.
> 030623 15:59:05 Fatal error: Can't open privilege tables: Can't find file:
# [EMAIL PROTECTED] / 2003-06-24 01:02:17 -0600:
> But, I need to know which rows were modified, not simply how many. So
> far this is the best that I have come up with
>
> LOCK TABLES MyTable WRITE
> SELECT * FROM MyTable WHERE SomeRecord = OldValue
> UPDATE MyTable SET SomeRecord = NewValue WHER
OTECTED] / 2003-06-24 04:00:02 -0700:
> Roman Neuhauser wrote:
> ># [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530:
> >> Does MYSQL support transaction concept, which includes issues
> >>like commiting data , rollbacking etc???
> >
> > Did you know
# [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530:
> Does MYSQL support transaction concept, which includes issues
> like commiting data , rollbacking etc???
Did you know MySQL has documentation?
--
If you cc me or remove the list(s) completely I'll most likely ignore
your message.s
# [EMAIL PROTECTED] / 2003-06-24 16:48:24 +0800:
> After I create this table,and add foreign key tno to this table.
> If I delete "tno" in "p_program_type" table,it would alarm that some
> data still in "p_schedule".
> How can I define the "p_schedule" or "p_program_type" table to make
> sure that
please don't piggyback on other people's threads. you can start your
own for free.
# [EMAIL PROTECTED] / 2003-06-24 09:46:24 +1000:
> I am using LOAD DATA INFILE to import some data to MySQL. I would like to
> leave some fields blank and use the default value set in the tables. I have
>
don't piggyback on other people's threads. you can start your own
for free.
# [EMAIL PROTECTED] / 2003-06-19 13:23:04 -0700:
> I ran a command which was part of the installation process for some php
> accounting software.
>
> update user set host='%' where host='localhost' and user='roo
# [EMAIL PROTECTED] / 2003-06-21 12:35:04 -0700:
> I'm trying to load a couple tons of data into a shopping cart system
> and for some reason it keeps kicking back with an error. I'm too dumb
> to figure out why. Can anyone tell me what's wrong with this code and
> why it doesn't work?
I can
Hello,
I have installed mysql 4.0.13 but suddenly all users can see names of all
databases on the server in phpmyadmin (show databases command afaik)
Is there something to avoid it ???
Sincerely,
Roman
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
# [EMAIL PROTECTED] / 2003-06-18 12:24:06 -0400:
> [psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_safe &
> [5] 703
> [psg:/usr/local/mysql] psgarcha% Starting mysqld daemon with databases
> from /usr/local/mysql/data
> 030618 11:50:09 mysqld ended
>
>
> [5]Done
# [EMAIL PROTECTED] / 2003-06-17 21:28:12 +0300:
> From: "Kerry Colligan" <[EMAIL PROTECTED]>
> > I see that 5.x will support triggers. Does anyone have any advice for
> > implementation of triggers on the DB? I will need to be able to utilize
> > them from web applications AND from command-line ty
# [EMAIL PROTECTED] / 2003-06-17 10:59:13 +0200:
> On Mon, Jun 16, 2003 at 11:56:59PM +0200, Roman Neuhauser wrote:
> > # [EMAIL PROTECTED] / 2003-06-16 15:27:21 +0200:
> > > mysql> select * from unitest WHERE t LIKE 'A%';
> > > ERROR 1210: Wrong ar
# [EMAIL PROTECTED] / 2003-06-17 11:25:36 +0900:
> Hi Roman,
>
> just saw this by chance.
>
> >sockstat -4l | grep 3306.
>
> I never heard of such a tool , also I did not find any info on the
> internet. I assume you dont mean sock, of course.
>
> Could you
# [EMAIL PROTECTED] / 2003-06-16 15:27:21 +0200:
>
> I'm trying to use 4.1.0-alpha's "extensive unicode support".
[...]
> Now I try to read the data, this time from the commandline client:
>
> mysql> select * from unitest WHERE ID=72;
> ++---+---+
> | ID | vc
# [EMAIL PROTECTED] / 2003-06-16 12:01:57 +:
> I installed the mysql 4.0 pkg on Mac OS 10.2, then I followed the
> installation instruction. It works fine. I then tried to create
> database, but is says"Access denied". I checked "Show database" ,
> there is only one database in, which is 't
# [EMAIL PROTECTED] / 2003-06-16 15:15:31 -0400:
> I have two tables...
> Table 1 newdata contains a lot of statistical data on our customers,
> including last 12months sales amt.
> table 2 sdtik contains all ticket information for all customers.
> Both tables have acctno as primary key.
>
> I ca
# [EMAIL PROTECTED] / 2003-06-16 21:09:14 +0200:
> In AUTO_INCREMENT fields, inserting a 0 into the field requests a new
> sequence number.
>
> Is it possible to turn off this behaviour?
I doubt that.
> (without messing with the code, of course)
I doubt that some more.
> Using NULL to
# [EMAIL PROTECTED] / 2003-06-16 15:23:21 -0500:
> I thought it was written in EnglishIt wasn't?
It was written in English, but your MUA labeled it as being encoded
with ks_c_5601-1987. Is that a Korean charset? Non-broken MUA will
obey the header, and display it as though it was e
# [EMAIL PROTECTED] / 2003-06-16 14:47:19 -0500:
> Content-Type: text/plain; charset="ks_c_5601-1987"
>
> ?...
posting in english would yield more replies.
--
If you cc me or remove the list(s) com
lines as long as 380 characters are hard to read.
hit enter every now and then, please.
# [EMAIL PROTECTED] / 2003-06-15 17:47:39 -0700:
> I created the following function to move a record from one table to
> another. The only difference in the table structures are the
> auto-incremented
# [EMAIL PROTECTED] / 2003-06-10 14:11:39 +0100:
> (...) lack of commercial support company means you are unlikely to get
> the same level of support.
unlikely? perhaps. but...
how many OS programs do you use, how many of them have commercial
support, and how do those that have co
# [EMAIL PROTECTED] / 2003-06-10 14:38:49 +0300:
> I am fairly new to databases, but my boss has assigned me to choose a
> database system for our company. I know of Oracle databases but they are
> way too expensive so it's not an option for us. I did some research and
> came up with two free da
# [EMAIL PROTECTED] / 2003-06-06 09:21:32 -0400:
> Heikki Tuuri wrote:
>
> >InnoDB is totally C, MySQL half C++ and half C, with a few hundred lines of
> >x86 Assembler.
> Oh? I thought that MySQL ran on Mac OSX as well as various Intel platforms.
the parts that are written in assembler are
# [EMAIL PROTECTED] / 2003-06-04 17:11:19 +0300:
> Roman,
>
> looks like your application fails to commit this transaction:
>
> "
> 030604 13:52:21 INNODB MONITOR OUTPUT
> ...
> LIST OF TRANSACTIONS FOR EACH SESSION:
> ---TRANSACTION 0 407759, ACTIVE 2090 sec, OS
# [EMAIL PROTECTED] / 2003-06-04 17:11:19 +0300:
> Roman,
>
> looks like your application fails to commit this transaction:
>
> "
> 030604 13:52:21 INNODB MONITOR OUTPUT
> ...
> LIST OF TRANSACTIONS FOR EACH SESSION:
> ---TRANSACTION 0 407759, ACTIVE 2090 sec, OS
# [EMAIL PROTECTED] / 2003-06-04 16:37:08 +0300:
> I have a program that runs a loop,in every loop I execute a query.
> the query itself is very efficient, the result of the query is 4 rows at
> most but...
> after a while I get the following error:
> Out of memory!
> Bus error (core dumped)
>
>
# [EMAIL PROTECTED] / 2003-06-04 09:17:01 -0400:
> acc.name, acc.phone, acc.acctno, sales1.amt as mo1sales, sales2.amt as
> mo2sales, (sales1.amt - sales2.amt) as diff SORT by diff
>
> I need all data in sales1 and sales2, but only for records from acc that
> are in either/both sales1, sales2.
>
# [EMAIL PROTECTED] / 2003-06-03 22:59:47 +0300:
> you can use SHOW INNODB STATUS to look what active transactions you have and
> how many lock structs they have.
>
> Also innodb_lock_monitor helps.
Hi Heikki,
thanks for the reply. I have dropped the database, recreated it,
stopped t
keep the lines at or under 72 characters, please.
# [EMAIL PROTECTED] / 2003-06-03 19:20:17 +0100:
> To display in my web page im using:
>
>
>
> This displays the above images in my html page
>
> The problem i have is where the field in my table is left blank
> (null), a web browser shows
# [EMAIL PROTECTED] / 2003-06-03 18:45:31 +0200:
> Executing gcc.exe...
> gcc.exe "U:\mep\Dev\abr.c" -o "U:\mep\Dev\abr.exe"
> -I"C:\Dev-Cpp\include" -I"C:\mysql\include" -L"C:\Dev-Cpp\lib"
> C:\DOCUME~1\badier1\LOCALS~1\Temp/ccW8.o(.text+0x1d2):abr.c: undefined
> reference to [EMAIL PROTEC
Hi there,
I have a problem with LOCKs. I use InnoDB tables and transactions.
[EMAIL PROTECTED] ~ 1001:0 > /usr/local/libexec/mysqld --version
/usr/local/libexec/mysqld Ver 4.0.13 for portbld-freebsd4.8 on i386
[EMAIL PROTECTED] ~ 1002:0 > uname -sr
FreeBSD 4.8-RC
[EMAIL PROTECTED] ~ 1003:0 > htt
I don't enjoy being a PITA but could you teach your MUA to create
proper attributions? This makes it really hard to tell who said
what, leads to confusion, and may piss of quite a few people if a
debate gets somewhat heated...
# [EMAIL PROTECTED] / 2003-04-02 18:18:17 +0200:
> > #
# [EMAIL PROTECTED] / 2003-04-02 17:37:26 +0200:
> And from this page:
> http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html
> I understand it is rather recommended NOT to use foreign keys, at least
> until mysql integrates it more fully.
which part of that page makes you say that?
--
Fr
X-Mailer: Microsoft Outlook, Build 10.0.2616
your MUA wrap-mutilates quoted text.
# [EMAIL PROTECTED] / 2003-04-02 02:34:01 +0200:
> > 1. If a column is a primary key, there is no need to declare it a
> > unique.
>
> Thank you, I was doing that for every table sinc
# [EMAIL PROTECTED] / 2003-03-31 07:38:44 -0500:
> Uttam wrote:
>
> >u can use highly customizabe MySQL DATE_FORMAT() function for retrieving
> >date in desired format.
> >
> Thanks for the detailed information.
>
> >For manipulating date in php, u can use the MySQL UNIX_TIMESTAMP(date)
> >funct
forgot to cc the list...
# [EMAIL PROTECTED] / 2003-03-18 08:06:37 -0700:
> On Sunday, March 16, 2003, at 03:33 AM, Roman Neuhauser wrote:
> ># [EMAIL PROTECTED] / 2003-03-15 08:29:51 -0700:
> >>On Thursday, March 13, 2003, at 12:46 PM, Roman Neuhauser wrote:
> >>
# [EMAIL PROTECTED] / 2003-03-30 17:49:27 +0200:
> Hello, I was starting a php/mysql project in december and seeked for help on
> this mailing list, it has been a great help for solving problems.
> My application is a website where you can order meals from restaurants that
> are within your postcod
# [EMAIL PROTECTED] / 2003-03-29 21:52:18 -0500:
> I just downloaded and installed the "mysql-max-4.0.12.pkg", ran
>
> cd /usr/local/mysql
> sudo ./bin/mysqld_safe
> (Enter your password)
> (Press CTRL+Z)
> (Press CTRL+D to exit the shell)
> bg
>
> as specified in the readme. When attem
# [EMAIL PROTECTED] / 2003-03-28 21:47:28 -0500:
> I'm experienced with SQL, but new to MySql and PHP, which I'm using
> together to create a dynamic web site. Right now, I'm having minor
> difficulties with date formatting. It seems that when I retrieve a date
> from MySQL into PHP, it shows
# [EMAIL PROTECTED] / 2003-03-24 21:15:46 +0100:
> i've got MySQL installed from RPM.
> when i try to run the MySQL server, this happens:
> [EMAIL PROTECTED] root]# /usr/bin/safe_mysqld
> Starting mysqld daemon with databases from /var/lib/mysql
> 030324 21:09:10 mysqld ended
>
> why does it sto
# [EMAIL PROTECTED] / 2003-03-24 23:49:59 +0100:
> this is what Mysql Reference Manual tells me about creating foreign
> keys.
> I understood how to use them, except for the restrict here ---\
> |
> [CONSTRAINT symbol] FOREIGN KE
# [EMAIL PROTECTED] / 2003-03-24 16:51:25 +0800:
> I have a mysql+php+apache server,It must have some program to call
> another informix database,I don't know how to configure my php,anyone
> have good resource help me??
yes. http://www.php.net/manual/, and if that fails,
http://www.php.ne
# [EMAIL PROTECTED] / 2003-03-13 11:51:52 -0700:
> This is not proper syntax, but I would think it is close...
> select replace(contact_phone, REGEXP "^[1234567890]",'') from
> individual;
I don't use REs in MySQL, but inverse classes are written [^spec],
not ^[spec].
--
If you cc me or
> Here's a nice MySQL simple returning records query question!
>
> I want to return a staement saying 'number of records shave been found'
for your
> selection.
>
> so presumably this is a simple row count based on the the returning
recordset?
>
> Andrew
Either with PHP or C you can use mysql_num_
0 |
| 4 | 2040 | 1020 |
| 5 | 0 | 0 |
+-+---+----+
See the difference in the 3rd columns???
--
Best regards,
Roman mailto:[EMAIL PROTECTED]
-
When mysqld-max-nt.exe is started with options
--console --standalone
and after issuing "mysqladmin -u root shutdown"
mysqld reports a shutdown, but does not exit.
mysqld-max don't have this problem.
OS Windows 2000.
Roman Vorobiev.
e-mail: [
set (0.00 sec)
some columns (dsg, nt, wot, k, drt, cr, wat) declared as char in script are
varchar in database...
whats is going on?
mysql ver 3.23.41
Roman
-
Before posting, please check:
http://www.mysql.com/manual.php (
t way to change each of
these variables, because I'm moving the server to a different directory.
Thanks,
-Roman
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
mysql fails to start i get msg starting mysqld with database /var/lib/mysql
and then it terminates
please advice
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
> o max_user_connections The maximum number of active connections for a single
> user (0 = no limit).
>
> so this feature is readily available depending on which version of mysql you
> are using.
>
> thanks,
>
> -- Andrew
>
>
> - Original Message ---
Hi All.
Does anybody know how can I limit maximun connections number to mysqd for
individual user, not for all users in sum, as it done by the variable
max_connection ?
I suppose it is nonstandard feature, and may be a patch for mysql is available ?
--
regards
Roman
com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Roman
thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Roman Festchook
Network Engineer
ISP ORTA Polesye
http://www.polesye.net
---
p://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.p
ich table? I would assume the
> users table?
>
> -Original Message-
> From: Roman Festchook [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 29, 2001 10:05
> To: Peter Moscatt; MySQL List
> Subject: Re: Setting User Privilges ? Confused !!
>
>
> By default
---
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL
c/mysql-3.23.41/client'
> make[1]: *** [all-recursive] Error 1
> make[1]: Leaving directory `/usr/src/mysql-3.23.41'
> make: *** [all-recursive-am] Error 2
--
Roman Festchook
Network Engineer
ISP ORTA Polesye
http://www.polesye.net
-
When I try to telnet MySQL which uses port 3030 as
below:
telnet grdmss57 3030
I get :
Trying 163.143.156.38...
Connected to grdmss57.u-aizu.ac.jp.
Escape character is '^]'.
(
3.23.38jN(xIDWiConnection closed by foreign host.
What is the possible reason? Is it normal?
't understand how to solve the problem. Could you
possibly tell me?
Thank you in advance.
Roman.
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
I have a problem running MySQL on Solaris. I downloaded the source and compiled it
following all the instructions and made mysql directory in my home directory. When I
enter "mysqladmin version" I get:
mysqladmin Ver 6.9 Distrib 3.21.33b, for sun-solaris2.8 on sparc
TCX Datakonsult AB, by Mont
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator: Rolando Roman
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
ectly.
I've read all docs about MySql, but I couldn't find the same function in
MySql.
If it is difficult to you, can you supply me with the exact SQL-query (for
this example).
Thanx a lot,
sorry for my English,
Roman Arefiev
rward to hear from you.
Regards,
Roman
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECT
/charsets folder with Index and cp1251.conf. I checked
Index - records are OK. Should I add something to /etc/my.cnf file?
Looking forward to hear from you.
Regards,
Roman
--
-
Please check "http://www.mysql.com/documentatio
100 matches
Mail list logo
