Stack Overflow
Stack Overflow

Questions tagged [mysql-connector]

MySQL provides standards-based drivers for JDBC, ODBC, and .NET enabling developers to build database applications in their language of choice. In addition, a native C library allows developers to embed MySQL directly into their applications.

MySQL provides standards-based drivers for JDBC, ODBC, and .NET enabling developers to build database applications in their language of choice. In addition, a native C library allows developers to embed MySQL directly into their applications.

Related tags:

2367 questions
158
votes
5 answers

What's the difference between MySQLdb, mysqlclient and MySQL connector/Python?

So I've been trying to do some database update with python and while setting up the whole dev environment, I came across these three things which made me dizzy. There's MySQLdb There's mysqlclient And then there's a mysql connector python What's…
आनंद
  • 2,472
  • 4
  • 21
  • 25
115
votes
21 answers

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver MySQLConnector/J

What is wrong with the code there are lots of error while debugging. I am writing a code for a singleton class to connect with the database MySQL. Here is my code package com.glomindz.mercuri.util; import java.sql.Connection; import…
atikul hussain
  • 1,227
  • 5
  • 14
  • 10
105
votes
6 answers

How to connect to MySQL Database?

New to C# programming, I'd like to be able to access MySQL Databases. I know MySQL connector/NET and MySQL for Visual Studio are required for C# development. Do I need to install them into my app? Is it possible I can just release the connector…
user3282097
  • 1,059
  • 2
  • 8
  • 4
56
votes
4 answers

Writing to MySQL database with pandas using SQLAlchemy, to_sql

trying to write pandas dataframe to MySQL table using to_sql. Previously been using flavor='mysql', however it will be depreciated in the future and wanted to start the transition to using SQLAlchemy engine. sample code: import pandas as pd import…
AsAP_Sherb
  • 1,661
  • 1
  • 13
  • 16
54
votes
6 answers

Connect to remote MySQL database through SSH using Java

How can I connect to remote MySQL database through SSH from java application? Small code example is helpful for me and I'd appreciate this.
Alex
  • 16,409
  • 6
  • 40
  • 56
43
votes
9 answers

mysql.h file can't be found

i'm trying to install connection between c++ and mysql in ubuntu 12.04. i've installed mysql-client, mysql-server, libmysqlclient15-dev, libmysql++-dev. but when i try to compile the code i got the error: mysql.h there is no such file. i looked in…
Begayim Muratalina
  • 621
  • 1
  • 6
  • 12
39
votes
13 answers

How to connect to a MySQL Data Source in Visual Studio

I use the MySQL Connector/Net to connect to my database by referencing the assembly (MySql.Data.dll) and passing in a connection string to MySqlConnection. I like that because I don't have to install anything. Is there some way to "Choose Data…
JohnB
  • 18,046
  • 16
  • 98
  • 110
34
votes
6 answers

How to install mysql-connector via pip

I use sqlalchemy to access MySQL in my Python project. sqlalchemy's conf is like this: dialect=mysql driver=mysqlconnector So I need to install the Python module mysql connector via pip. Any help?
Codefor
  • 1,318
  • 2
  • 13
  • 22
28
votes
13 answers

Can't Create Entity Data Model - using MySql and EF6

I'm trying to add an edmx Entity model to my C#/Web Project in Visual Studio 2013. My problem is that the file is not created. I do the following steps: Give the item a name Choose 'EF Designer from database' Choose the connection from the drop…
Liron Harel
  • 10,819
  • 26
  • 118
  • 217
27
votes
2 answers

How do I setup ASP.NET MVC 2 with MySQL?

Is it possible to setup ASP.NET MVC 2 to work with a MySQL database?
NovaJoe
  • 4,595
  • 6
  • 29
  • 43
25
votes
5 answers

Create Spark Dataframe from SQL Query

I'm sure this is a simple SQLContext question, but I can't find any answer in the Spark docs or Stackoverflow I want to create a Spark Dataframe from a SQL Query on MySQL For example, I have a complicated MySQL query like SELECT a.X,b.Y,c.Z FROM FOO…
opus111
  • 2,744
  • 4
  • 25
  • 41
25
votes
5 answers

How can I transfer data between 2 MySQL databases?

I want to do that using a code and not using a tool like "MySQL Migration Toolkit". The easiest way I know is to open a connection (using MySQL connectors) to DB1 and read its data. Open connection to DB2 and write the data to it. Is there a…
Morano88
  • 2,047
  • 4
  • 25
  • 44
24
votes
1 answer

Python how to know if a record inserted successfully or not

I'm using Python MySQL Connector, I inserted a record into database, and it was successful. But in Python code, how can I know if it is inserted or not? My Table does not have a primary key. def insert(params) : db_connection =…
Gia Duong Duc Minh
  • 1,319
  • 5
  • 15
  • 30
22
votes
2 answers

.NET MySQL Connector Conflicting DbProviderFactories

I'm using the .NET MySQL Connector with Entity Framework 4, and everything worked great but I wanted to package the MySQL client DLL files with my application when deployed on servers so we don't have to worry about installing mysql on each server,…
Kekoa
  • 27,892
  • 14
  • 72
  • 91
21
votes
9 answers

Add List to a mysql parameter

I have this question about the MySqlParameter from the .NET connector. I have this query: SELECT * FROM table WHERE id IN (@parameter) And the MySqlParameter is: intArray = new…
Phoenix_uy
  • 3,173
  • 9
  • 53
  • 100
1
2 3
…
99 100