Hello,
A new question has been asked in "MariaDB Connector/ODBC" by Redman Companies.
Please answer it at
http://mariadb.com/kb/en/how-do-i-install-the-odbc-connectordriver-on-linux-mint-173/
as the person asking the question may not be subscribed to the mailing list.
-
Oops. PRIMARY KEY should be just KEY on that second example with RANGE
COLUMNS. :)
Sent from my iPhone
> On Mar 12, 2016, at 11:01 AM, Justin Swanhart wrote:
>
> You can use no primary key, and just put a regular key (not unique key) on
> the auto_increment column. You must make sure that
You can use no primary key, and just put a regular key (not unique key) on the
auto_increment column. You must make sure that manual insertions don't create
a duplicate if value.
>> CREATE TABLE new (
>> id INT NOT NULL AUTO_INCREMENT,
>> name VARCHAR(50),
>> added DATE,
>> KEY (id),
>> )
>>
Hi,
There is no programmatic way to read a file line by line and write a file line
by line. You could write a udf to do so.
You can take a look at http://github.com/Fastbit_UDF if you like. fb_query()
writes to CSV files and fb_inlist reads a one column file and turns it into an
CSV list for
The only solution is to make (id, added) a PK, because the partitioning
column must always belong to unique key, if there is such.
In your case I would change added type to DATETIME to avoid collision.
Regards
On Sat, Mar 12, 2016 at 2:10 PM Ghazi Btissam
wrote:
> Hi,
>
> 1- I have a table with
Hi, Ghazi!
On Mar 12, Ghazi Btissam wrote:
> Hi,
>
> How to read/write a text file from a MariaDb routine ? Is this possible
> only via tables (loading via Load data infile or using connect engine..)?
No, there is also LOAD_FILE function:
https://mariadb.com/kb/en/mariadb/load_file/
Regards,
Se
Hi,
I saw an article about the equivalent of the Oracle DbLink feature in
MariaDb, I found that the connect engine with the ODBC table type can do an
insert+select on an Oracle remote table ,but the update of the remote data
is it possible?
Thanks
___
M
Hi,
1- I have a table with a unique key which is calculated by the
AUTO_INCREMENT feature, and I need to range partition it using a date field
, is it possible and/or how to do it?
2- Is there a way to implement sequences for the primary key (like it
exists in Oracle) or the AUTO_INCREMENT is the
Hi,
How to read/write a text file from a MariaDb routine ? Is this possible
only via tables (loading via Load data infile or using connect engine..)?
Thanks
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchp
9 matches
Mail list logo
