wAtcH Barclays Premier League between Aston Villa vs Manchester City live stream
Are you looking for Aston Villa vs Manchester City Free live streaming link? Then you have come to the correct place. You can watch a live online stream of Aston Villa vs Manchester City right here. The is no need to look anywhere else. The links for the event appear above.

<a href="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html" title="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html">http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs...</a>

<a href="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html" title="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html">http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs...</a>

I'm using postgresql-odbc-09.01.0200 with postgresl-9.2.4

According to the documention for SQLSetCursorName
(<a href="http://msdn.microsoft.com/en-us/library/windows/desktop/ms711707%28v=vs.85%29.aspx" title="http://msdn.microsoft.com/en-us/library/windows/desktop/ms711707%28v=vs.85%29.aspx">http://msdn.microsoft.com/en-us/library/windows/desktop/ms711707%28v=vs....</a>)
I don't really need to use it, and ODBC will use a default name.

With unixODBC and a Postgresql connection handle, SQLGetInfo() shows
SQL_CA1_POS_UPDATE capability for SQL_STATIC_CURSOR_ATTRIBUTES1, and
SQL_KEYSET_CURSOR_ATTRIBUTES1.

I tried using both a static and a keyset cursor, by setting
SQL_ATTR_CURSOR_TYPE accordingly, on a new statement handle; then executing
a "SELECT [..] FOR UPDATE"

Hi,

I've just created some tables that I designed using the MySQL Workbench
Model. However, the database type BOOLEAN which was in my models has been
converted to TINYINT(1); I'm currently running MySQL Version 5.6.2-m5 on
Windows 2008 server.

Any ideas why this has been removed ?

Neil

It seems the ODBC driver does not deal well with a WITH clause in a
statement:

8<----------------------------------
SQL> select id from generate_series(1,2) as t(id)
+------------+
| id |
+------------+
| 1 |
| 2 |
+------------+
SQLRowCount returns -1
2 rows fetched
SQL> select w.id from (select id from generate_series(1,2) as t(id)) as w
+------------+
| id |
+------------+
| 1 |
| 2 |
+------------+
SQLRowCount returns -1
2 rows fetched
SQL> with w as (select id from generate_series(1,2) as t(id)) select
w.id from w
SQLRowCount returns 0

Hello to all,

I'm having trouble returning a backup made by mysqldump into a two-node
cluster.
The dumpfile size is 177M and execute the command for its restoration
received the error "ERROR 1297 (HY000) at line 251: Got temporary error
1234 'REDO log files overloaded (Increase disk hardware)' from NDBCLUSTER."

The cluster contains two nodes each with two cores and Xeon 2.0Ghz 2Gb RAM
on a VMware Storage SATA disks in Raid 5.

Already changed NoOfFragmentLogFiles, RedoBuffer, LongMessageBuffer and
error persists.

Cluster configuration was made with the tool Severalnines.

Visual Studio 2012 Supported in dbForge Fusion for MySQL, v.6.0

Devart Team is glad to present the release of dbForge Fusion for MySQL v.6.0 - powerful Visual Studio plugin designed to simplify MySQL database development and enhance data management capabilities. Now includes support for Visual Studio 2012! All users can now benefit from the Devart add-in in the latest version of the IDE.

We recently upgraded from MySQL 5.0.24a to 5.6.10 CE on Oracle Linux 5.
Everything appears to be functioning OK, however I have an ODBC related
issue which is creating problems in regard to generating reports through
it via Crystal Reports. This problem did not exist under 5.0.24a using
the ODBC 3.5 driver.

Hey sir thanks for adding me to the list but if I want to send a
question where do i send it to? <a href="mailto:mysql- ... at lists dot mysql.com">mysql- ... at lists dot mysql.com</a> or
<a href="mailto: ... at lists dot mysql.com"> ... at lists dot mysql.com</a>

Does anyone know of an setting in the ODBC driver that will convert a blank date to a null?

Thanks
Barry

Hello everyone,

I'm sending a COM_EXECUTE_STMT message and the server returns an:

Error 1048 - #23000 - Column 'number_tinyint' cannot be null

The query is like this:

insert into numbers (
number_tinyint,
number_smallint,
number_mediumint,
number_int,
number_bigint,
number_decimal,
number_float,
number_double
) values
(
?, 679, 778, 875468, 100007654, 198.657809, 432.8, ?)

And what I send in is:

0: 18 00 00 00 17 01 00 00 . . . . . . . .
1: 00 00 01 00 00 00 00 00 . . . . . . . .
2: 01 01 05 0a 29 5c 8f c2 . . . . ) \ . .
3: f5 b0 58 40 . .

Sorry I failed to specify ghatna is only applicable when the database is quiet large.

Vikas

Am 16.05.2013 11:01, schrieb Vikas Shukla:
hwo would a innodb_buffer_pool larger than the whole database
make anything better?

Hi All.

I am trying to set the best value for innodb_buffer_pool_size.

Hey,

We have a table with a column and index that we don't need anymore, so we are trying to find the best way to get rid of them

Path 1) Create a new table with the updated schema (excluding that column and index), and insert from the old table into the new table
Path 2) Alter the original table to drop the column and index

The problem with either of these is that when we are done, the table size has grown significantly (~15%).

size of orig table: 2026.5G
size of new table after inserting all of the data or running the alter: 2473.5M
~~flush the table~~
size of orig table: 2026.5G
size of

Hi,

I made a new mysql binding for LuaJIT, here it is:

<a href="https://code.google.com/p/lua-files/wiki/mysql" title="https://code.google.com/p/lua-files/wiki/mysql">https://code.google.com/p/lua-files/wiki/mysql</a>

Features:

- covers all of the functionality provided by the mysql Connector/C 6.1 API
- all data types are supported with multiple options for conversion
- prepared statements, avoiding dynamic allocation and type
conversions when fetching rows
- all C calls are checked for errors and Lua errors are raised
- all C objects are tied to Lua's garbage collector
- lightweight OOP-style API via ffi.metatype
- no external dependencies

Only tested with Windows for now but more tests

<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Hello,</div>

<div>&nbsp;</div>

<div>it seems when using the Unicode version of the driver it crashes when:
<pre class="bz_comment_text" id="comment_text_80" style="word-wrap: break-word;">log_statement = &#39;all&#39;

client_min_messages &lt; notice</pre>
</div>

<div>and a long query ( e.g. create function ) is sent to the server.</div>

<div>&nbsp;</div>

<div>Did not test it with a long erronous query sent to the server without using the settings above.

I have connected MySql to Base. I created some relationships in MySql. They
are properly visible in the Relationships chart in Base. See image.
<a href="http://imgur.com/qtM8fVN,jwvJpen" title="http://imgur.com/qtM8fVN,jwvJpen">http://imgur.com/qtM8fVN,jwvJpen</a>

Other than that, they are non-existent. For example, while I try to create
a sub-form, I see that the option to create subform via existing
relationship is disabled. See image.
<a href="http://imgur.com/qtM8fVN,jwvJpen#1" title="http://imgur.com/qtM8fVN,jwvJpen#1">http://imgur.com/qtM8fVN,jwvJpen#1</a>

Kindly guide me.

I want to start the mysql from command prompt using "NET START MYSQL"BUT the server not started. It display an error message.
C:\Users\PC> NET START MySQLSystem error 5 has occurred.
Access is denied.
could you please help me, how to start the Mysql service FROM command prompt?
SIVASUTHAN- Consultant Trainer

I've seen conflicting information on this:
<a href="http://postgresql.1045698.n5.nabble.com/Improve-ODBC-Throughput-tp2189601p2189614.html" title="http://postgresql.1045698.n5.nabble.com/Improve-ODBC-Throughput-tp2189601p2189614.html">http://postgresql.1045698.n5.nabble.com/Improve-ODBC-Throughput-tp218960...</a>
<http://postgresql.1045698.n5.nabble.com/Improve-ODBC-Throughput-tp2189601p2189614.html>

What I see with the latest source tree in my test environment of two windows
workstations, each using the latest compiled odbc drivers (09.01.02??) to
connect to PostgreSQL 9.2.4 (Windows):

1. With UserDeclareFetch=1 and UseServerSidePrepare=0, works as it always
has for me.
2. With UserDeclareFetch=0 and UseServerSidePrepare=1, works as it always
has for me.
3.

We have a situation where users complain that the system periodically freezes for 30-90 seconds. We check the slow query logs and find that one user issued a complex query that did indeed take 30-90 seconds to complete. However, NO slow queries are recorded for the other 50 users, before, during, or after the freeze.

Hello,

Please grant me access to post in myodbc list.

Thanks,
Hemant Dangi
Senior Member Techical Staff
Mysql Connector/ODBC developer

Dear MySQL users,

MySQL Connector/ODBC 5.2.5, a new version of the ODBC driver for the
MySQL database management system, has been released.

The available downloads include both a Unicode driver and an ANSI
driver based on the same modern codebase. Please select driver type
you need based on the type of your application - Unicode or ANSI.
Server-side prepared statements are enabled by default.

I am using the MySQL ODBC 5.2w Driver (5.2.3) and it appears that it does not follow the rules for SQLConfigDataSource. The specification for the SQLConfigDataSource function says that the attributes should be separated using a null byte and the list of attributes terminated with a 2 null byte sequence, however the MySQL ODBC driver only uses the supplied attributes if they are separated using semi-colons.

Hi,

I've the following database structure of 4 tables for geographical
information

CREATE TABLE IF NOT EXISTS `mydb`.`country` (

`country_id` INT NOT NULL ,

`country_code` CHAR(2) NOT NULL ,

`name` VARCHAR(255) NOT NULL ,

PRIMARY KEY (`country_id`) ,

UNIQUE INDEX `country_code_UNIQUE` (`country_code` ASC) )

ENGINE = ndbcluster

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `mydb`.`region` (

`region_id` INT NOT NULL ,

`name` VARCHAR(255) NOT NULL ,

`country_code` CHAR(2) NOT NULL ,

PRIMARY KEY (`region_id`) ,

INDEX

Hi List

I have a table with a primary key with type binary(16) and a few columns.
I'd trying to create a view that looks up all rows with a particular key,
i.e. something like

CREATE OR REPLACE VIEW foo AS
SELECT *
FROM mytable
WHERE id = X'36a461c81cab40169791f49ad65a3728';

I use the mysql command line client to create the view.

Hello

The connector also works with 4D, a relation database management system from 4d.com!

Best regards

Dan Röthlisberger

Verantwortlicher IT-Applikationsmanagement

CRB

Steinstrasse 21, Postfach

CH-8036 Zürich

Tel: +41 44 456 45 65 (direkt)

Fax: +41 44 456 45 66

Email: ... at crb dot ch

<a href="http://www.crb.ch" title="http://www.crb.ch">http://www.crb.ch</a> <http://www.crb.ch>

I have a table that has 2.5 million rows and 9 columns that are all
int except for 2 varchar(255) - i.e. not that big of a table. I am
executing a delete from that table like this:

delete from cdsem_event_message_idx where event_id in (....)

The in clause has around 1,500 items in it. event_id is an int, and
there is an index on event_id. This statement is taking 1 hour and 5
minutes to run. There is nothing else hitting the database at that
time, and the machine it's running on is 97% idle and has plenty of
free memory. This seems extremely excessive to me.

I cleaned up and pushed the regression test suite that I wrote a while
back. Two of the test cases are currently failing because of the bug
discussed here:
<a href="http://www.postgresql.org/message-id/51479445. ... at vmware dot com" title="http://www.postgresql.org/message-id/51479445. ... at vmware dot com">http://www.postgresql.org/message-id/51479445. ... at vmware dot com</a>. Once
that's fixed, let's keep it green!

I tried to write a nmake makefile for running the tests on Windows, but
failed. If someone who has more experience with Windows has the time to
do that, that would be great, but a Unix-only suite is already better
than nothing.

- Heikki

Ladies, gentlemen,

Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:

" Database Workbench 4.4.0 Pro "

This release includes new features and fixes several bugs as reported by the
users.

For more information, see <a href="http://www.upscene.com/go/?go=news&amp;id=20130423" title="http://www.upscene.com/go/?go=news&amp;id=20130423">http://www.upscene.com/go/?go=news&amp;id=20130423</a>

The FREE Lite Editions will follow later.

Database Workbench supports:
- Borland InterBase ( 6.x and up )
- Firebird ( 1.x and up )
- MS SQL Server/MSDE ( 7 and up )
- MySQL 4.x and up
- Oracle Database ( 8i and up )
- Sybase SQL Anywhere ( 9 and up )
- NexusDB (

Dear MySQL users,

MySQL Server 5.7.1 (Milestone Release) is a new version of the world's
most popular open source database. This is the first milestone release
of MySQL 5.7.

<a href="http://dev.mysql.com/doc/mysql-development-cycle/en/development-milestone-releases.html" title="http://dev.mysql.com/doc/mysql-development-cycle/en/development-milestone-releases.html">http://dev.mysql.com/doc/mysql-development-cycle/en/development-mileston...</a>

The new features in these releases are of Beta quality.