Re: how to select the record with one sql statement?

Hello sea, On 8/13/2018 7:01 PM, sea wrote: helle, I have a table, like this: pigId dayweigt pig1 2018-1-121 pig2 2018-1-131 pig3 2018-1-141 pig1 2018-1-222 pig2 2018-1-2

Re: How to get the MySQL Command-Line Tool to display Unicode properly?

Probably the dumbest suggestion yet, but have you tried "set names utf8" in the client? On 20 March 2018 20:50:08 CET, Roger House wrote: > > >On 03/15/2018 02:06 PM, Roger House wrote: >> >> >> On 03/15/2018 11:30 AM, shawn l.green wrote: >>> Hi Roger, >>> >>> (please note, this is a bottom-pos

Re: How to get the MySQL Command-Line Tool to display Unicode properly?

On 03/15/2018 02:06 PM, Roger House wrote: On 03/15/2018 11:30 AM, shawn l.green wrote: Hi Roger, (please note, this is a bottom-post forum) On 3/13/2018 7:54 PM, Roger House wrote: > > On 03/13/2018 03:11 PM, Reindl Harald wrote: >> >> >> Am 13.03.2018 um 22:59 schrieb Roger House: >>> In

Re: How to get the MySQL Command-Line Tool to display Unicode properly?

On 03/15/2018 11:30 AM, shawn l.green wrote: Hi Roger, (please note, this is a bottom-post forum) On 3/13/2018 7:54 PM, Roger House wrote: > > On 03/13/2018 03:11 PM, Reindl Harald wrote: >> >> >> Am 13.03.2018 um 22:59 schrieb Roger House: >>> In all respects except one, the treatment of Uni

Re: How to get the MySQL Command-Line Tool to display Unicode properly?

Hi Roger, (please note, this is a bottom-post forum) On 3/13/2018 7:54 PM, Roger House wrote: > > On 03/13/2018 03:11 PM, Reindl Harald wrote: >> >> >> Am 13.03.2018 um 22:59 schrieb Roger House: >>> In all respects except one, the treatment of Unicode works just fine. >>> I can write Unicode to

Re: How to get the MySQL Command-Line Tool to display Unicode properly?

I am running Ubuntu MATE 16.04.  I have the problem also on Windows 7 and on Mac OS Version 10.11.6.  I do not think that the problem has to do with the operating system nor the terminal.  Everything about the Unicode text works fine in all tools such as editors, the cat command, etc.  It is on

Re: How to get the MySQL Command-Line Tool to display Unicode properly?

Am 13.03.2018 um 22:59 schrieb Roger House: In all respects except one, the treatment of Unicode works just fine. I can write Unicode to database tables, read it, display it, etc., with no problems. The exception is mysql, the MySQL Command-Line Tool. When I execute a SELECT statement to see

Re: How to get the MySQL Command-Line Tool to display Unicode properly

2017/10/18 18:32 ... Roger House: I get the same behavior with the MySQL Command Line Tool when I run it on Windows, Mac OS X, and Ubuntu, so I'm pretty sure the problem has to do with mysql itself. What do you know about the displays to which the client is writing? In the case of "cmd" under

Re: How to get auto Increment ID of INSERT?

LAST_INSERT_ID() returns the latest ID for the current connection. As long as you yourself can guarantee that no other queries are executed using that connection, you're fine. If another record others is inserted using another connection, that connection will return a different LAST_INSERT_ID()

Re: How to change character sets in InnoDB as fast as possible

Yes, normally convert from latin1 to binary, and from binary to utf8 (which would also be the recipe to convert actual utf8 data which accidentally ended up in latin1 columns to the proper definition without changing the content). I would not know why that would take overly long for you. An altern

Re: How to retrieve next record?

theless a good start, thanks. BR, Hans. Johan De Meersman schreef op 11-12-14 om 23:44: - Original Message - From: "Wm Mussatto" Subject: Re: How to retrieve next record? Related what is the form of the prmary key. If its numeric something like $sDBQuery1 = "SELECT *

Re: How to retrieve next record?

$con!=null Martin Gainty Date: Thu, 11 Dec 2014 14:07:33 -0800 Subject: Re: How to retrieve next record? From: mussa...@csz.com To: larry.mart...@gmail.com CC: mysql@lists.mysql.com On Thu, December 11, 2014

Re: How to retrieve next record?

- Original Message - > From: "Wm Mussatto" > Subject: Re: How to retrieve next record? > Related what is the form of the prmary key. If its numeric something like > $sDBQuery1 = "SELECT * FROM kentekenlogtest WHERE kenteken < > '$sActueelkenteken&#x

RE: How to retrieve next record?

l Martin Gainty > Date: Thu, 11 Dec 2014 14:07:33 -0800 > Subject: Re: How to retrieve next record? > From: mussa...@csz.com > To: larry.mart...@gmail.com > CC: mysql@lists.

Re: How to retrieve next record?

Trianon 33 schreef op 11-12-14 om 23:20: Wm Mussatto schreef op 11-12-14 om 23:07: On Thu, December 11, 2014 13:43, Larry Martell wrote: On Thu, Dec 11, 2014 at 4:34 PM, Trianon 33 wrote: Hi all, It seems like a simple question, however I'm not able to find the answer. Let me explain.

Re: How to retrieve next record?

Please reply to the list and not to me directly On Thu, Dec 11, 2014 at 5:10 PM, Trianon 33 wrote: > > Larry Martell schreef op 11-12-14 om 23:04: >> >> On Thu, Dec 11, 2014 at 4:58 PM, Trianon 33 wrote: >>> >>> Larry Martell schreef op 11-12-14 om 22:43: On Thu, Dec 11, 2014 at 4:34 P

Re: How to retrieve next record?

On Thu, December 11, 2014 13:43, Larry Martell wrote: > On Thu, Dec 11, 2014 at 4:34 PM, Trianon 33 wrote: >> Hi all, >> >> It seems like a simple question, however I'm not able to find the >> answer. >> >> Let me explain. I have a DB with lots of columns, one is labeled as >> 'kenteken' and i

Re: How to retrieve next record?

On Thu, Dec 11, 2014 at 4:34 PM, Trianon 33 wrote: > Hi all, > > It seems like a simple question, however I'm not able to find the > answer. > > Let me explain. I have a DB with lots of columns, one is labeled as > 'kenteken' and it is also the primary key in the DB. I poke into this DB > with

Re: how to access Synology's mysql (mariadb) on the command line

Yes, that worked - thank you very much! On 2014-08-20 22:51, shawn l.green wrote: Hello Wybo, I cleansed your reply and cc:'ed the list again to share the answer. On 8/20/2014 4:24 PM, Wybo wrote: Hi Shawn, Thanks for your prompt reply - I suppose I'll have to do that query via phpMysqlAdmin

Re: how to access Synology's mysql (mariadb) on the command line

Hello Wybo, I cleansed your reply and cc:'ed the list again to share the answer. On 8/20/2014 4:24 PM, Wybo wrote: Hi Shawn, Thanks for your prompt reply - I suppose I'll have to do that query via phpMysqlAdmin. When I do that, the only host that appears is localhost. However, when I browse th

Re: how to access Synology's mysql (mariadb) on the command line

Hi Wybo, On 8/20/2014 3:47 PM, Wybo wrote: My Synology station is on 192.168.178.27, the database listens to port 3306, on my FritzBox I forwarded port 3306 to 192.168.178.27, I /can/ connect to the database on http://192.168.178.27/phpMyAdmin/ But when I try: mysql --host=192.168.178.27 --pass

Re: How to write a multi query in mysqltest framework?

On Thu, Jul 10, 2014 at 10:33:04AM +0800, 娄帅 wrote: > In the C API, we can call mysql_query("select 1; select 2"); > which just send the command once to the server, and server > return two result sets, So i want to know if there is a command in the > mysqltest framework to do the job? > I want to w

Re: How to get all known bugs on specified mysql version?

Hello, On 7/6/2014 7:42 PM, 娄帅 wrote: Hi, all, I want to use MySQL 5.6.18 in production, so i want to get all known bugs on this version. Now i check the "bugfix" section in MySQL 5.6.19 and above version. Am i doing the right thing? Or Do you have a better method? Any input will be appreciate

Re: How to get all known bugs on specified mysql version?

Am 07.07.2014 12:37, schrieb wagnerbianchi.com: > Why do not use GTID? Just curious...WB just read the changelogs and endless count of bugreports it's a new feature and it works as buggy as replication years ago where you had the rebuild the slave all the time and maybe still if temporary table

Re: How to get all known bugs on specified mysql version?

Why do not use GTID? Just curious...WB 2014-07-07 3:18 GMT-03:00 louis liu : > don't use GTID is my suggestion :) > > > > 2014-07-07 7:42 GMT+08:00 娄帅 : > > > Hi, all, > > > > I want to use MySQL 5.6.18 in production, so i want to get all known bugs > > on this version. Now i check the "bugfix"

Re: How to get all known bugs on specified mysql version?

don't use GTID is my suggestion :) 2014-07-07 7:42 GMT+08:00 娄帅 : > Hi, all, > > I want to use MySQL 5.6.18 in production, so i want to get all known bugs > on this version. Now i check the "bugfix" section in MySQL 5.6.19 and above > version. Am i doing the right thing? Or Do you have a better

Re: how to set "SET SQL_BIG_SELECTS=1" ?

than that is no longer a MySQL question and you should consult the guy who wrote the code, there are reasons for such limits and blindly disable them may reuslt in the server going down because you disable a barrier for crap code Am 28.02.2014 12:53, schrieb Madan Thapa: > Thank you , however i am

Re: how to set "SET SQL_BIG_SELECTS=1" ?

Thank you , however i am newbie to mysql and not sure where to put that ( SET SQL_BIG_SELECTS=1;) : when i grep , i see following files for example that has query code: [root@server public_html]# grep -R "SELECT filename" . | grep -v error_lo ./sites/all/modules/views/includes/admin.inc:

Re: how to set "SET SQL_BIG_SELECTS=1" ?

Am 28.02.2014 12:17, schrieb Madan Thapa: > After upgrading from mysql 5.0 to mysql 5.1, i am getting the follwing > error: > > how to set "SET SQL_BIG_SELECTS=1"? just type it before your query in question? as you can see below if you try such things and they are not supported or you have a t

RE: How to make multiple master to single slave in mysql?

OK! Thank you very much! Zhigang. -Original Message- From: shawn l.green [mailto:shawn.l.gr...@oracle.com] Sent: Wednesday, February 26, 2014 11:57 AM To: mysql@lists.mysql.com Subject: Re: How to make multiple master to single slave in mysql? On 2/25/2014 9:55 PM, Zhigang Zhang

Re: How to make multiple master to single slave in mysql?

On 2/25/2014 9:55 PM, Zhigang Zhang wrote: > How to make multiple master replicate to single slave in mysql? > > > > Tell me some approaches? > > Put your masters in a replication ring, hang a slave from one of them (as suggested by Mr. Van der Westhuizen) Use an external product, such

Re: how to create unique key for long varchar?

I came up with a solution: using special "md5" to deal with conflicts steps to insert a url 1. insert into table(md5,url) values('md5 of url', url) 2. if get a duplicate entry for primary key 2.1 select md5,url from table where md5 like '%' for update 2.2 if url really exists, don't nee

Re: how to create unique key for long varchar?

The odds against the eventuality you are worried about are astronomically high. Much serious work on the internet would fall apart were that not true. Collision is simply not going to happen within the next several hundred thousand years. On Nov 5, 2013 9:59 PM, "Li Li" wrote: > I prefer your s

Re: how to create unique key for long varchar?

I prefer your solution in that it's something like Optimistic Locking. but the problem is that if I define md5 as unique key and there exists 2 different urls with the same md5. I can't insert the second url anymore On Tue, Nov 5, 2013 at 11:55 PM, Dan Nelson wrote: > In the last episode (Nov 05)

RE: how to create unique key for long varchar?

. > -Original Message- > From: Dan Nelson [mailto:dnel...@allantgroup.com] > Sent: Tuesday, November 05, 2013 7:56 AM > To: Li Li > Cc: mysql@lists.mysql.com > Subject: Re: how to create unique key for long varchar? > > In the last episode (Nov 05), Li Li said: > >

Re: how to create unique key for long varchar?

In the last episode (Nov 05), Li Li said: > I want to create a table with a long varchar column, maybe it's the url. > according to dns spec, the url's max length is fixed. but I have > to deal with url having long params such as > a.html?q=&fl=bb

Re: How to update MySQL table based on 3 other tables

Hello Neil, On 8/24/2013 5:21 AM, Neil Tompkins wrote: I have the following four MySQL tables Region RegionId City CityId RegionId Hotel HotelId CityId HotelRegion HotelId RegionId I'm struggling to write a UPDATE statement to update the City table's RegionId field from data in the HotelReg

RE: how to get the levels of a table or a index in Mysql 5.6?

Or maybe the number of levels in the BTree? Rule of Thumb: logarithm base 100 > -Original Message- > From: Hartmut Holzgraefe [mailto:hart...@skysql.com] > Sent: Monday, July 08, 2013 6:38 AM > To: mysql@lists.mysql.com > Subject: Re: how to get the levels of a table or a

Re: how to get the levels of a table or a index in Mysql 5.6?

On 08.07.2013 04:23, 李炜(平安科技数据库技术支持部) wrote: > how to get the levels of a table or a index in Mysql 5.6? Level? What is level supposed to be in that context? Cardinality? Or something completely different? /me confused ... -- Hartmut Holzgraefe Principal Support Engineer (EMEA) SkySQL AB - ht

RE: how to list record in column (instead of a row)

Or SELECT ... \G (replace ';' with '\G') > -Original Message- > From: h...@tbbs.net [mailto:h...@tbbs.net] > Sent: Wednesday, April 24, 2013 9:55 AM > To: mysql list > Subject: Re: how to list record in column (instead of a row) > > &

Re: how to list record in column (instead of a row)

you can do: select * from table\G 2013/4/24 > 2013/04/24 09:06 -0700, Rajeev Prasad > this table has many columns and only 1 record. select * from table; > generates an unreadable list. how can i list the record as in two columns? > (column name and its value)? i looked at UNPIVOT, b

Re: how to list record in column (instead of a row)

2013/04/24 09:06 -0700, Rajeev Prasad this table has many columns and only 1 record. select * from table; generates an unreadable list. how can i list the record as in two columns? (column name and its value)? i looked at UNPIVOT, but could not get it to work. SQL> select * from table U

Re: How to change max simultaneous connection parameter in mysql.

l refuse connections no, my db-layer is traing again for some times and the chance to get a free slot because other workers are serving images is proven in practice damned high > >> -Original Message- >> From: Reindl Harald [mailto:h.rei...@thelounge.net] >> Sent: Tu

Re: How to change max simultaneous connection parameter in mysql.

> > Sent: Tuesday, April 02, 2013 2:00 PM > > To: mysql@lists.mysql.com > > Subject: Re: How to change max simultaneous connection parameter in > > mysql. > > > > > > > > Am 02.04.2013 22:56, schrieb Rick James: > > > I hear that nginx is very fa

RE: How to change max simultaneous connection parameter in mysql.

e- > From: spameden [mailto:spame...@gmail.com] > Sent: Tuesday, April 02, 2013 7:10 AM > To: Reindl Harald > Cc: mysql@lists.mysql.com > Subject: Re: How to change max simultaneous connection parameter in > mysql. > > 2013/3/24 Reindl Harald > > > > > > &

RE: How to change max simultaneous connection parameter in mysql.

ld [mailto:h.rei...@thelounge.net] > Sent: Tuesday, April 02, 2013 2:00 PM > To: mysql@lists.mysql.com > Subject: Re: How to change max simultaneous connection parameter in > mysql. > > > > Am 02.04.2013 22:56, schrieb Rick James: > > I hear that nginx is very fas

Re: How to change max simultaneous connection parameter in mysql.

tell me something new >> -Original Message- >> From: Reindl Harald [mailto:h.rei...@thelounge.net] >> Sent: Tuesday, April 02, 2013 2:00 PM >> To: mysql@lists.mysql.com >> Subject: Re: How to change max simultaneous connection parameter in >> mysql. >

RE: How to change max simultaneous connection parameter in mysql.

ei...@thelounge.net] > Sent: Tuesday, April 02, 2013 8:29 AM > To: mysql@lists.mysql.com > Subject: Re: How to change max simultaneous connection parameter in > mysql. > > > > Am 02.04.2013 16:09, schrieb spameden: > > 2013/3/24 Reindl Harald > <mailto:h

Re: How to change max simultaneous connection parameter in mysql.

il.com] >> Sent: Tuesday, April 02, 2013 7:10 AM >> To: Reindl Harald >> Cc: mysql@lists.mysql.com >> Subject: Re: How to change max simultaneous connection parameter in >> mysql. >> >> 2013/3/24 Reindl Harald >> >>> >>> >>>

Re: How to change max simultaneous connection parameter in mysql.

Am 02.04.2013 16:09, schrieb spameden: > 2013/3/24 Reindl Harald > > > Am 24.03.2013 05:20, schrieb spameden: > > 2013/3/19 Rick James >: > >>> you never have hosted a large site > >> Check my email address before sayin

Re: How to change max simultaneous connection parameter in mysql.

2013/3/24 Reindl Harald > > > Am 24.03.2013 05:20, schrieb spameden: > > 2013/3/19 Rick James : > >>> you never have hosted a large site > >> Check my email address before saying that. > > > > :D > > as said, big company does not have only geniusses > I do not judge only on 1 parameter, Rick has

Re: How to change max simultaneous connection parameter in mysql.

2013/3/24 Reindl Harald > > > Am 24.03.2013 05:20, schrieb spameden: > > 2013/3/19 Rick James : > >>> you never have hosted a large site > >> Check my email address before saying that. > > > > :D > > as said, big company does not have only geniusses > > >> 20 may be low, but 100 is rather high. >

Re: How to change max simultaneous connection parameter in mysql.

Am 24.03.2013 05:20, schrieb spameden: > 2013/3/19 Rick James : >>> you never have hosted a large site >> Check my email address before saying that. > > :D as said, big company does not have only geniusses >> 20 may be low, but 100 is rather high. > Never use apache2 it has so many problems un

Re: How to change max simultaneous connection parameter in mysql.

e if well tuned. > >> -Original Message- >> From: Reindl Harald [mailto:h.rei...@thelounge.net] >> Sent: Monday, March 18, 2013 1:36 PM >> To: mysql@lists.mysql.com >> Subject: Re: How to change max simultaneous connection parameter in >> mysql. >>

Re: How to change max simultaneous connection parameter in mysql.

mory and CPU so please get rid of your i386 and stop to explain me the world >> -Original Message- >> From: Reindl Harald [mailto:h.rei...@thelounge.net] >> Sent: Monday, March 18, 2013 1:36 PM >> To: mysql@lists.mysql.com >> Subject: Re: How to change max sim

RE: How to change max simultaneous connection parameter in mysql.

> you never have hosted a large site Check my email address before saying that. 20 may be low, but 100 is rather high. > -Original Message- > From: Reindl Harald [mailto:h.rei...@thelounge.net] > Sent: Monday, March 18, 2013 1:36 PM > To: mysql@lists.mysql.com > S

RE: How to change max simultaneous connection parameter in mysql.

6, 2013 1:45 AM > To: mysql@lists.mysql.com > Subject: Re: How to change max simultaneous connection parameter in > mysql. > > Hi Kevin, > In your MySQL client pls execute: > SET GLOBAL max_connections = 200; > To Make the change permanent you can edit /etc/my.cnf or whatev

Re: How to change max simultaneous connection parameter in mysql.

On Mon, 2013-03-18 at 21:35 +0100, Reindl Harald wrote: > > Am 18.03.2013 21:01, schrieb Rick James: > > 20 is plenty if your pages run fast enough > > if your server can not serve more than 20 simultaionous > requests you are not doing any serious things > or he's using a 286 signatu

Re: How to change max simultaneous connection parameter in mysql.

o:h.rei...@thelounge.net] >> Sent: Monday, March 18, 2013 12:15 PM >> To: mysql@lists.mysql.com >> Subject: Re: How to change max simultaneous connection parameter in >> mysql. >> >> >> >> Am 18.03.2013 19:26, schrieb Rick James: >>> If you are r

RE: How to change max simultaneous connection parameter in mysql.

error. > -Original Message- > From: Reindl Harald [mailto:h.rei...@thelounge.net] > Sent: Monday, March 18, 2013 12:15 PM > To: mysql@lists.mysql.com > Subject: Re: How to change max simultaneous connection parameter in > mysql. > > > > Am 18.03.2013 19:26,

Re: How to change max simultaneous connection parameter in mysql.

Am 18.03.2013 19:26, schrieb Rick James: > If you are running Apache with MaxClients set too high, that can cause the > problem. "too high" is relative > That Apache setting should be something like 20. (Other web servers have > similar settings.) 20 is a laughable value as long you are n

Re: How to change max simultaneous connection parameter in mysql.

Hi Kevin, In your MySQL client pls execute: SET GLOBAL max_connections = 200; To Make the change permanent you can edit /etc/my.cnf or whatever MySQL config file you you've got in your system Look for this line max_connections under [mysqld] secction, add it if it's not in the config. make sure

Re: How to change max simultaneous connection parameter in mysql.

2013/3/16 Kevin Peterson > I am using PHP along with mysql. Mysql default configuration allows to > have 100 simultaneous connection which I want to chane to 200. Please help. > If you're reaching too many connections quite often, this change can imply memory problems in your server. If you are

RE: How to return resultset from MySQL Stored Procedure using prepared statement?

What language are you using? In Perl, there is $sth->more_results; > -Original Message- > From: Girish Talluru [mailto:girish.dev1...@gmail.com] > Sent: Wednesday, March 13, 2013 5:24 AM > To: mysql@lists.mysql.com > Subject: How to return resultset from MySQL Stored Procedure using > p

Re: How to verify if backup is ok?

- Original Message - > From: "Rafał Radecki" > > pt-table-checksum performs an online replication consistency check by > executing checksum queries on the master, which produces >different results on replicas that are inconsistent with the > master. -> It should be used for verifi

Re: How to verify if backup is ok?

Thanks, I will use this tool :) 2013/2/19 Johan De Meersman : > - Original Message - >> From: "Rafał Radecki" >> >> pt-table-checksum performs an online replication consistency check by >> executing checksum queries on the master, which produces >>different results on replicas tha

Re: How to verify if backup is ok?

Thanks for the reply. pt-table-checksum performs an online replication consistency check by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master. -> It should be used for verifing mysql replication, not for my problem.

Re: How to verify if backup is ok?

- Original Message - > From: "Rafał Radecki" > > 3) drop mysql and app databases; > 4) restore them from backup; Instead of dropping the DBs, simply restore to another database or server. That will also allow you to perform a comparison using some graphical tool, or if that fails mysql

RE: How to verify mysqldump files

Wednesday, November 07, 2012 7:09 AM > To: 'Gary'; mysql@lists.mysql.com > Subject: RE: How to verify mysqldump files > > In the past when I used mysqldump, I used a slave database for backups and > periodically testing restores. > > My process for testing: > -

RE: How to verify mysqldump files

In the past when I used mysqldump, I used a slave database for backups and periodically testing restores. My process for testing: - Stop the slave process (so the db doesn't get updated). - Run the backup. - Create restore_test database. - Restore the backup to the restore_test database. - Use my

Re: How to verify mysqldump files

2012/11/7 Ananda Kumar > you can use checksum to make sure there are not corruption in the file That would work for the file integrity itself not for the data integrity _in_ the file. As Claudio suggested, probably going thru the whole recovery process from time to time is the best way to mak

Re: How to verify mysqldump files

you can use checksum to make sure there are not corruption in the file On Wed, Nov 7, 2012 at 6:39 PM, Claudio Nanni wrote: > Gary, > > It is always a good practice to test the whole solution backup/restore. > So nothing is better than testing a restore, actually it should be a > periodic procedu

Re: How to verify mysqldump files

Gary, It is always a good practice to test the whole solution backup/restore. So nothing is better than testing a restore, actually it should be a periodic procedure. As for the validity of the file usually is delegated to the operating system. If you want to check it yourself you may create an al

RE: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;

real_ problem, which I guess is "performance". > -Original Message- > From: Arthur Fuller [mailto:fuller.art...@gmail.com] > Sent: Sunday, September 23, 2012 3:39 PM > To: Tim Pownall > Cc: mysql@lists.mysql.com > Subject: Re: How to block SELECT * FROM table; but

RE: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;

age- > From: Martin Gainty [mailto:mgai...@hotmail.com] > Sent: 24 September 2012 04:58 > To: fuller.art...@gmail.com; pownall...@gmail.com > Cc: mysql@lists.mysql.com > Subject: RE: How to block SELECT * FROM table; but not SELECT * FROMT > table WHERE...; > > > Possi

RE: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;

Possibly run your constructed query thru a regex expression e.g. String mydata = "SELECT * from table WHERE a Date: Sun, 23 Sep 2012 18:38:58 -0400 > Subject: Re: How to block SELECT * FROM table; but not SELECT * FROMT table > WHERE...; > From: fuller.art...@gmail.com > To: pow

Re: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;

Tim, I think you misunderstood the question. Daniel wants to block Select queries that ask for all rwows, and permit only queries that ask for some rows, as restricted by the Where clause. Unfortunately, I don't think that can be done. But I'm not certain of that; there might be a trick. Arthur

Re: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;

that does not change the fact that it is valid to NOT have a where statement and for me it sound plain stupid to think about blocking queries without where-statements - the application developers will hopefully kill any admin who finds a solution for this... * i maintain a cms-system sinc

Re: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;

select * from table where column=value means it will return only rows that match. as long as you have proper indexing there should not be any issues. On Sun, Sep 23, 2012 at 1:23 PM, Luis Daniel Lucio Quiroz < luis.daniel.lu...@gmail.com> wrote: > Helo, > > Just wondering if is possible to bloc

Re: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;

Am 23.09.2012 20:23, schrieb Luis Daniel Lucio Quiroz: > Just wondering if is possible to block SELECT queries that doesnt have > a WHERE statement within. no and the idea is broken by design what is wrong with a "select * from table" with small tbales having only a handful of records? how wil

Re: How to loop a query that is only able to handle 1 ROW at a time?

Hi Incarus, You don't need a loop just a correlated subquery on the update: UPDATE TB1 SET Ivet=PREG_REPLACE('/TeXT/', '', Ivet); Example: mysql> CREATE TABLE blah(value INTEGER, square INTEGER); Query OK, 0 rows affected (0.17 sec) mysql> INSERT INTO blah(value) VALUES (1),(2),(3),(4),(5); Q

RE: how to replace this data in a complex field?

inal Message- > From: Johan De Meersman [mailto:vegiv...@tuxera.be] > Sent: Tuesday, July 31, 2012 1:39 AM > To: Incarus Derp > Cc: mysql@lists.mysql.com > Subject: Re: how to replace this data in a complex field? > > > > - Original Message - > > From: &qu

Re: how to replace this data in a complex field?

- Original Message - > From: "Incarus Derp" > > I have a complex field named Inventory in a table named Table1 that > can be different every time and is not guaranteed to contain what I need to > replace. > > [["Thing1","Thing4","thing8","thing1","thing942","ACRE_PRC119_ID_29"],[["thin

Re: how to replace this data in a complex field?

On 07/31/2012 09:07 AM, Incarus Derp wrote: I need to replace ACRE_PRC119_ID_29 with ACRE_PRC119 and I cannot do this externally. I have PREG_REPLACE but I'm not sure how I would apply this to the database because it only SELECT's as far as I know. You could CREATE a TABLE from the SELECT. Isn'

RE: How to quickly detect if there are any crashed tables

Much faster: SHOW TABLE STATUS -- It will have NULLs for the tables that really need REPAIR. (Those that were "not properly closed" don't have to be REPAIRed.) If you system is new enough, you can find the list of databases (TABLE_SCHEMA) from `information_schema`. In the long run, consider

Re: How to quickly detect if there are any crashed tables

On Thu, May 10, 2012 at 10:26 PM, Steven Staples wrote: > I think you can scan the syslog for the mysql daemon, and it will show you > any crashed, or problematic tables? > > If this is in fact the case, you could try that, and then run though the > tables to check them later? Indeed, I was think

RE: How to quickly detect if there are any crashed tables

> AFAIK the tables will be locked one by one until checked/repaired. > > On May 10, 2012, at 3:07 PM, Adrian Fita wrote: > > > On 10/05/12 21:51, Mihail Manolov wrote: > >> You can enable check/recovery automatically by using > >> "myisam_recover". Look it up in the documentation. > >> > >> There

Re: How to quickly detect if there are any crashed tables

AFAIK the tables will be locked one by one until checked/repaired. On May 10, 2012, at 3:07 PM, Adrian Fita wrote: > On 10/05/12 21:51, Mihail Manolov wrote: >> You can enable check/recovery automatically by using >> "myisam_recover". Look it up in the documentation. >> >> There is no way to rep

Re: How to quickly detect if there are any crashed tables

On 10/05/12 21:51, Mihail Manolov wrote: > You can enable check/recovery automatically by using > "myisam_recover". Look it up in the documentation. > > There is no way to repair them "faster", though. Thanks for the quick response. This definetly looks like a useable solution. Do you know if dur

Re: How to quickly detect if there are any crashed tables

You can enable check/recovery automatically by using "myisam_recover". Look it up in the documentation. There is no way to repair them "faster", though. On May 10, 2012, at 2:40 PM, Adrian Fita wrote: > Hi. > > I have several hundreds of databases with MyISAM tables in a server and > after a p

RE: how to sync mysql.user table between to two mysql instances

Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Friday, March 16, 2012 5:00 PM To: Baron Schwartz Cc: MySql Subject: Re: how to sync mysql.user table between to two mysql instances - Original Message - > From: "Baron Schwartz" > > 1. With mysqldump. mysqldump -hm

Re: how to sync mysql.user table between to two mysql instances

- Original Message - > From: "Baron Schwartz" > > 1. With mysqldump. mysqldump -hmysql-inst1 mysql | mysql > -hmysql-inst2 mysql And then, of course, issue a FLUSH PRIVILEGES on mysql-inst2 :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't dri

RE: how to sync mysql.user table between to two mysql instances

6, 2012 2:59 PM To: David Lerer; Baron Schwartz; MySql Subject: RE: how to sync mysql.user table between to two mysql instances Hello David, Precisely, that's what my problem is. The users found in mysqlinst1 are not in mysqlinst2. There are about 30 users defined in inst1 and only 4 in ins

RE: how to sync mysql.user table between to two mysql instances

dious. Help me I'm running out of time. -Original Message- From: David Lerer [mailto:dle...@us.univision.com] Sent: Friday, March 16, 2012 1:36 PM To: Baron Schwartz; MySql; Brown, Charles Subject: RE: how to sync mysql.user table between to two mysql instances As a follow up ques

RE: how to sync mysql.user table between to two mysql instances

, users, passwords, etc (Assuming of course that the schemas are identical on the two instances). Thanks, David. -Original Message- From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On Behalf Of Baron Schwartz Sent: Friday, March 16, 2012 2:20 PM To: MySql Subject: Re: how to

Re: how to sync mysql.user table between to two mysql instances

Charles, 1. With mysqldump. mysqldump -hmysql-inst1 mysql | mysql -hmysql-inst2 mysql 2. With pt-table-sync from Percona Toolkit if you need something more sophisticated. On Fri, Mar 16, 2012 at 1:27 PM, Brown, Charles wrote: > Can someone instruct me on how to sync mysql.user table between to t

Re: how to read existing databases copied from somewhere else

Am 27.02.2012 09:05, schrieb Pengkui Luo: > Hi, I am new to mysql and have a question regarding how to read/import > existing mysql databases (i.e. binaries, not sql dumps) copied from > somewhere. > > However, the "show databases;" command did not give me the "foo" database; > and the "use foo;

Re: how to changing default '-' character in Datetime in MySQL?

2012/02/05 21:56 -0800, Peter Brawley On 2/5/2012 9:21 PM, Michael Dykman wrote: >You are right. It seems to have fallen into disuse since I used it last. AFAIK it has never been used. One use occurred to me, and I was thinking of this, to set "date_format" in the configuratio

Re: how to changing default '-' character in Datetime in MySQL?

unused. *datetime_format This variable is unused. - Original Message - From: Michael Dykman To: mysql mailing list Cc: Sent: Sunday, February 5, 2012 9:24 PM Subject: Re: how to changing default '-' character in Datetime in MySQL? To clarify, what we are discussing is

Re: how to changing default '-' character in Datetime in MySQL?

This variable is unused. > > > - Original Message - > From: Michael Dykman > To: mysql mailing list > Cc: > Sent: Sunday, February 5, 2012 9:24 PM > Subject: Re: how to changing default '-' character in Datetime in MySQL? > > To clarify, what we are discus

  1   2   3   4   5   6   7   8   9   10   >