Refer http://kb.askmonty.org/v/virtual-columns - the example
CREATE TABLE table1 (
a INT NOT NULL,
b VARCHAR(32),
c INT AS (a MOD 10) virtual,
d VARCHAR(5) AS (LEFT(b,5)) persistent);
now
SHOW FULL FIELDS FROM table1;
Field Type Collation Null Key Default Extra Privileges Comment
-- --
Hi Peter, all
> From: "Peter Laursen"
>
> Refer http://kb.askmonty.org/v/virtual-columns - the example
>
> CREATE TABLE table1 (
> a INT NOT NULL,
> b VARCHAR(32),
> c INT AS (a MOD 10) virtual,
> d VARCHAR(5) AS (LEFT(b,5)) persistent);
>
> now
>
> SHOW FULL FIELDS FROM table1;
>
> Field Ty
I have a few more points to consider:
CREATE TABLE table1 (as before);
SET SQL_MODE = 'strict_all_tables';
INSERT INTO `test`.`table1`(`a`,`b`,`c`,`d`) VALUES ( '1','a',NULL,NULL); --
success
SHOW WARNINGS -- empty set
-- this is actually good, even a little inconsistent with what comes next.
Bu
Hello everyone, there's a new question in the Knowledgebase:
http://kb.askmonty.org/v/mariadb-xtradb-installation-problem
Thanks.
--
Daniel Bartholomew
MariaDB - http://mariadb.org
Monty Program - http://montyprogram.com
AskMonty Knowledgebase - http://kb.askmonty.org
Hi!
> "Paul" == Paul McCullagh writes:
Paul> The intension of this code was to set the priority of the current
Paul> running thread only, not the entire program.
Paul> If the code is not working in this manner, then there is no better
Paul> solution that to disable it.
Paul> However i
Hi!
> "Peter" == Peter Laursen writes:
Peter> Refer http://kb.askmonty.org/v/virtual-columns - the example
Peter> CREATE TABLE table1 (
Peter> a INT NOT NULL,
Peter> b VARCHAR(32),
Peter> c INT AS (a MOD 10) virtual,
Peter> d VARCHAR(5) AS (LEFT(b,5)) persistent);
Peter> now
Peter> SHOW
Hi!
> "Peter" == Peter Laursen writes:
Peter> I have a few more points to consider:
Peter> CREATE TABLE table1 (as before);
Peter> SET SQL_MODE = 'strict_all_tables';
Peter> INSERT INTO `test`.`table1`(`a`,`b`,`c`,`d`) VALUES (
'1','a',NULL,NULL); --
Peter> success
Peter> SHOW WARNINGS -
*Hello, *
*
*
*I have recently been doing some capacity planning exercises for a new
database we are developing in MariaDB. One of the exercises I completed was
to create a database with all tables loaded with maximum width records at
100,000, 500,000, and 1,000,000 records. I noticed that when I
Hi!
> "Peter" == Peter Laursen writes:
Peter> SHOW ENGINES;
Peter> or
Peter> SELECT * FROM information_schema.ENGINES;
Peter> You will see "YES" in the 'support' column of the output for 'InnoDB.
It is
Peter> actually XtraDB, but it identifies itself as InnoDB (for portability and
Pete
On Jun 6, 2011, at 11:23 AM, Michael Widenius wrote:
Hi!
"Paul" == Paul McCullagh writes:
Paul> The intension of this code was to set the priority of the
current
Paul> running thread only, not the entire program.
Paul> If the code is not working in this manner, then there is no
bett
Hi!
> "Paul" == Paul McCullagh writes:
>> Do you know of any system, except old obsolete linux systems, where
>> one should
>> use setpriority() to set the priority for a thread?
Paul> I have done no research on this, so I think we should simply change
Paul> the code to:
Paul> if
11 matches
Mail list logo