MySQL Forums

Just saying Hello before I fully explore here... (no replies)

Alvin Revilas — Mon, 13 Feb 2012 22:44:15 +0000

Hi everyone,

Just thought I'd do a polite thing and just introduce myself as a noob in using Connector C++. I do have a pressing question, but I want to find out how to properly format my question before submitting it, by trying to first find as many relevant docs that say how to do so, then following their directions.

Hope to be able to contribute to this forum.

Sincerely,
Alvin

EndNote (no replies)

Colleen Boye — Mon, 13 Feb 2012 16:08:41 +0000

Has anyone ever interfaced EndNote with MySQL? How doable is it?

Modelo y consulta (no replies)

pablo pica — Mon, 13 Feb 2012 22:09:13 +0000

Hola. Es la primera vez que realizo una consulta en este foro. Realmente estoy agradecido de encontrar gente que pueda ayudarme, en especial cuando no tengo a quien recurrir.
Mi problema es el siguiente: Tengo que almacenar objetos con sus características(discretas, 0 ó 1), y estas son alrededor de unas 100, con posibilidad de crecer.
Cada elemento tiene atributos propios, tales como nombre y descripción, junto con otros similares. Además hay posee una colección de características, las cuales ya están definidas en otra tabla (porque son comunes a todos los elementos), pero solo se guarda si la cumple o no.
Mi dificultad radica en encontrar el modelo de datos correcto y la consulta pertinente para obtener los elementos que cumplan con una determinada combinación de características, fijadas por el usuario.

Probé, como modelo de datos, crear una tabla aparte en donde relaciono elementoID con caracteristicaID. La relación ya daría por sentado que la cumple. Esto me permite que si crecen el número de características no se vea limitado por el número máximo de campos que soporta mysql para las tablas.
Lo que encontré imposible es una consulta que me devuelva los elementos que cumplen con determinadas características.

También probé de guardar la colección de características que cumple como una colección de '1' y '0', correspondiendo cada característica a una potencia de 2, pero al ser la cantidad de caract. elevadas, se rebaza el límite de enteros de mysql.
Gracias por la ayuda que me puedan brindar. Pablo.

Mysql Expert Consultant required (no replies)

Shaun Thomson — Mon, 13 Feb 2012 21:03:47 +0000

Hi

I have some software and a website that work together using a Mysql DB -they are in beta.

I'd like to hire someone to look over the logic of the database, my php queries, and make suggestions on how sound they are, how to improve them, and if required, complete the changes.

I would like someone with solid credentials, or at least a very good reputation here on these forums.

Payments would be via Paypal.

Thanks

Shaun Thomson
SongbookDB

Data files on CIFS Share (no replies)

Randolf Julian — Mon, 13 Feb 2012 20:55:44 +0000

We were told to move our data files to a CIFS share. So, I did the following:

a. Shutdown MySQL
b. Mapped the CIFS share drive as Z:
c. Copied "F:\MySQL Datafiles" (which includes all data files and log files) to the Z:
d. Modified the my.ini to reflect the new drive letter.
e. Start MySQL

However, I got an error saying "Can't create test file F:\MySQL Datafiles\data\machine-name.lower-test"

I was able to create the test file manually but MySQL can't seem to create one.

Thanks for the help.

- randolf

MySQL finding missing number (2 replies)

Davor Ergotic — Mon, 13 Feb 2012 22:42:49 +0000

Hi all,

I have a problem with missing numbers in a table.
So..

I have fields:

id (unique, AI) and prod_num (int).
Product numbers goes from 1 to 60.000 and I need to know which ones are missing.
Prod_num are sequenced.. 1,2,3,4,5,6,7,8,9,10,11...
Lets say that I have the case in which 3 is missing.. so - 1,2,4,5,6,7,8,9,10,11..
How can I find out which is missing?

Thanks for help in advance!

Regards,
Davor

Inserting php code into table (5 replies)

Ray Feliciano — Mon, 13 Feb 2012 22:27:31 +0000

I just wanted to know if I can insert a php conditional statement into a table. What I have is a login form saved into the table if I removed all php code the form will display as normal but if I left the code in the table the form does not display correctly and it show the actual php code. The field I am storing the data in has the data type of TEXT. Should I use a different data type or is this not possible to do?

5.5.17 Community slower on RHEL6 and RHEL55 (no replies)

Jobe Bittman — Mon, 13 Feb 2012 19:32:30 +0000

I have a very strange issue with mysql on redhat. It seems to be slower on redhat6 than redhat 5 no matter what I do.

I'm running 5.5.17 community RPMs on both servers. One is an older PE2970 server runnign RHEL55. One is newer R710 running RHEL6. The hardware specs on new server are close by slightly better. All iozone tests show new box has 30% faster io.

Here's issue: I run a test script with "250K INSERT INTO .. ON DUPLICATE KEY UPDATE" inserts on rhel55 and it takes 38 seconds. On RHEL6, 58 seconds. They have almost the same my.cnf and very similar sysctl tuning parameters.

Anyone else run into a similar issue? I realize this might be better addressed to a redhat mailing list but I'm hoping someone else might have seen this here.

MYSQL install on redhat5 cluster (no replies)

Alan Mckeown — Mon, 13 Feb 2012 18:50:00 +0000

Hi,
I have an RH5 cluster comprising 2 servers and a shared storage. Is it possible to install mysql in an active/passive mode onto these servers. MYSQL will be enterprise edition.

regards

Alan

error 2002 en mysql (1 reply)

ramon gonzalez — Mon, 13 Feb 2012 19:37:30 +0000

estoy instalando mysql por consola y me da el siguiente error:

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Me pueden decir como arreglo este problema? Gracias por su ayuda.

Need help with LOAD DATA INFILE with repeat fields in CSV file (no replies)

Joe Sharpe — Mon, 13 Feb 2012 12:36:01 +0000

I have a unique problem that needs some expert assistance as I have yet been able to locate any documentation on the issue that can help me.

I have a CSV file containing a modest data set exported by a proprietary system. Each row contains, say: "A", "B", "C", "D" fields per record and I want to use LOAD DATA INFILE to import them into MySQL.

Problem is, the structure of the data export for those records contains repeated (not duplicate) fields delimited with an |. This reorders the output somewhat randomly. In short, if the record is "A", "B", "C", "D" and "C" has a repeated field, "D" will also be repeated. For example, my CSV file looks like this:

1. "A", "B", "C", "D"
2. "A", "B", "C", "D"
3. "A", "B", |"B"|, "C", |"C"|,"D", |"D"|
4. "A", |"A"|, "B", |"B"|, "C", |"C"|,"D", |"D"|

So, if we are to use the above as an example, I want to use this logic to create a new row based on repeated column entries:

//Find the 1st repeated field (occurring at Row 3, Field "|"B"|
//Create new row by duplicating Row 3, Field "A"
//Cut |"B"|,|"C"|,|"D"| from Row 3 and insert into new line.

But I have no idea how to implement this logic. Can anyone out there help?

error 2002 en mysql (no replies)

ramon gonzalez — Mon, 13 Feb 2012 18:29:19 +0000

Estoy tratando abrir mysql y me sale el siguiente error:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Me pueden decir como arreglo este problema.
Gracias por su ayuda.

Password :$ (1 reply)

Alaya Francis — Mon, 13 Feb 2012 19:41:42 +0000

I recently downloaded mySQl,
and when i open it shows :
" Could not open required defaults file: C:\Program Files\MySQL\MySQL Server 5.1\m
y.ini
Fatal error in defaults handling. Program aborted
Enter password:_ "

i dont know what the error is, nor the password.
how do i find the password?
please reply
xox

Password :$ (-1 replies)

Alaya Francis — Mon, 13 Feb 2012 19:41:42 +0000

-- moved topic --

RAID 5 suitablility for Mysql (no replies)

newbie Shai — Mon, 13 Feb 2012 12:16:52 +0000

Dear All,
I would like to know is RAID 5 suitable for Mysql? Thank you.

bind-address (1 reply)

man max — Mon, 13 Feb 2012 13:30:33 +0000

i installed mysql in windows 2008

and i have specified bind-address=192.168.2.100 (my server ip address)

Does it means mysql connect using the ip:192.168.2.100

what if i want to listen both 127.0.0.1 and the ip:ip:192.168.2.100

please help

Mysql Certification (no replies)

omar sarabia — Mon, 13 Feb 2012 18:07:10 +0000

Hello guys, I want to be a mysql dba , but I don't know where should I start,can somebody help me

Inconvenientes con la BD (no replies)

Miguel Samper — Mon, 13 Feb 2012 17:37:27 +0000

Buenos Dias a Todos.

Actualmente tengo instalada la version BETA del Query Browser 1.2.4 MySql, y la Version de la BD MySQL Server 5.1, montada sobre Windows 2008 server a 64 bits, hace un tiempo presento muchos inconvenientes y por ende se realizo la migracion e incluso cambio de servidor, pero lo lios persisten y es que durante mi operacion comienza ponerse lenta mi maquina y de unmomento a otro comienza a reventarse y presentar errores de no poder actualizar o grabar productos en las tablas. Tampoco permite realizar procesos de anulaciones, comienza a mostrar errores de Time Out para las operaciones, obtando por reiniciar el server y asi solamente se soluciona. Alguien tiene algun comentario que me pueda dar una luz de como solucionar esto.

Muchas Gracias a todos.

Problem with my database in query browser (no replies)

Rick Broekaart — Mon, 13 Feb 2012 17:21:29 +0000

Deare people,

I have a problem with Mysql query browser which i can't solve on my own.
The case is I wanted to create a view table, when i tried it didn't work. After that i typed a query in order to be able to create view tables. The query was:

CREATE USER root@....... IDENTIFIED BY ..........;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE VIEW ON products.* TO root@........

The result was that i couldn't produce any query's anymore. So, i closed query browser. But then i couldn't acces query browser any more with my old password. Only with the new 'password' which i filled in after IDENTIFIED BY. But when i am in query browser now by filling in the new password i don't have any acces to my databases, only to 1 information_schema database.

So my question is: How can i get back to my databases? Does anyone know what i did by filling in that query and how to solve my problem? I hope so!

Kind regards,

Rick

What causes a table to be marked crashed? (no replies)

Jason West — Mon, 13 Feb 2012 15:23:08 +0000

Hi all,

I appreciate that this is probably a pretty open ended topic of conversation and that there's no 'right' answer per se, but please allow me to explain my situation.

I've just developed a script that inserts data from an external programme into a mySQL database; I've extensively tested this programme on my home computers and those of friends that I've been able to use and found no problems or errors with the script. However I have just sent a first draft off to my customer and they are getting the following error:

Pool could not be updated, Died with this error: Table ‘tblinteraction’ is marked as crashed and should be repaired :

Obviously 'Pool' & 'tblinteraction' are database specific. I'm aware that I could run a repair script in an attempt to correct the error, but even if this works I'm more concerned as to what caused the problem and how I could fix that and prevent the error from occurring in future.

I have briefly seen a few hints that the error may be memory related. Presumably it's no co-incidence that tblInteraction is the table with the most data in in my db if this is the case?

Any ideas would be appreciated

Jason

Triggers & Encoding (no replies)

Stian Brattland — Mon, 13 Feb 2012 15:05:13 +0000

Hi,

I've got a database which is set up with 'utf8_general_ci' collation. Furthermore, the collation for all tables are also set up with 'utf8_general_ci', and the same are all fields.

Now, I've set up a trigger on one of the tables to capture old data whenever an update takes place. The old data is then simply inserted into a log table.

However, whenever special characters occur, the trigger fails because a variable in the trigger is unable to handle the special character. It complains about invalid characters, and it appears to be related to the encoding. After much back and forth, I specifically set the trigger variable's encoding and things work.

My question is : what encoding does a trigger variable use by default? Is there a way to determine this without having to specifically define the encoding? It would be great if the trigger could somehow "adapt" to the encoding on the field it captures data from.

IT Technical Engineer (m/w) Microsoft Dynamics NAV – IT-Fachkräfte, (Wirtschafts-)Informatiker mit Erfahrungen in MS SQL – (no replies)

Barbara Biedermann — Mon, 13 Feb 2012 14:56:24 +0000

Vorsprung braucht Weitblick.
Und Köpfe, die weiter denken.

Seit 1993 geben wir Unternehmen weltweit entscheidende Impulse für nachhaltige ERP-Lösungen auf Basis neuester Microsoft-Technologien. Als zertifizierter Microsoft Gold Partner bieten wir ein breites Kompetenzspektrum, wenn es um Geschäftsprozesse in mittelständischen und großen Unternehmen geht. Unsere Kunden profitieren von erfolgreichen, gewinnbringenden IT-Lösungen, die nachhaltig den Wettbewerbsvorsprung am Markt sichern.

Es sind die Leistungen unserer Mitarbeiter, die maßgeblich dazu beitragen, dass wir seit Jahren äußerst erfolgreich für internationale Kunden tätig sind. Unterstützen Sie unser Team am Standort Nürnberg als

IT Technical Engineer (m/w) Microsoft Dynamics NAV
– IT-Fachkräfte, (Wirtschafts-)Informatiker mit Erfahrungen in MS SQL –

Im Detail heißt das für Sie:
- Sie beraten unsere Kunden bei der Erstellung von Microsoft Dynamics NAV Lösungen.
- Sie erstellen technische Spezifikationen nach der Microsoft-SureStep-Methodik.
- Die Entwicklung von Lösungen und Prototypen in Microsoft Dynamics NAV sowie deren Dokumentation und Test gehören ebenso zu Ihren Aufgaben.
- Sie führen Code Reviews durch und nehmen an Workshops zur Beratung unserer Kunden teil.

Sie bringen folgende Eigenschaften mit:
- Sie haben ein Studium der (Wirtschafts-)Informatik oder eine vergleichbare Berufsausbildung (z. B. als Fachinformatiker/-in) abgeschlossen.
- Sie verfügen über fundierte Kenntnisse in den Bereichen Microsoft Dynamics NAV und in C/AL.
- Sie können auf Erfahrungen im Umgang mit Microsoft SQL-Server unter Dynamics NAV zurückblicken.
- Eine hohe Qualitätsorientierung, schnelle Auffassungsgabe sowie tiefgehendes Verständnis für betriebswirtschaftliche Prozesse zeichnen Sie aus.
- Sie überzeugen mit einer eigenständigen, effizienten, lösungs- und vor allem kundenorientierten Arbeitsweise.
- Gute Englischkenntnisse runden Ihr Profil ab.

Ihre Perspektive bei impuls – Wir bieten Ihnen
- Einen attraktiven Arbeitsplatz in einem motivierten Team, das gern zusammenarbeitet.
- Individuelle Weiterbildung im technischen, fachlichen Bereich und Soft-Skills-Trainings.
- Ein dynamisches Unternehmen mit kurzen Entscheidungswegen und Reaktionszeiten.
- Die Möglichkeit, bei namhaften Kunden mit zukunftsweisenden Technologien in anspruchsvollen Projekten mitzuarbeiten.
- Raum, sich in einem wachstumsstarken Umfeld zu verwirklichen, das Ihnen erfolgreiches und selbstständiges Arbeiten ermöglicht.

Werden Sie Teil eines hoch motivierten Teams und unterstützen Sie uns als IT Technical Engineer. Senden Sie uns Ihre vollständigen Bewerbungsunterlagen mit Angaben zu Ihren Gehaltsvorstellungen und dem frühestmöglichen Eintrittstermin.

impuls Informationsmanagement GmbH
Barbara Biedermann
Deutschherrnstraße 15 – 19
90429 Nürnberg
jobs@impuls-solutions.com
www.impuls-solutions.com

My Snippets (no replies)

Steve Sloan — Mon, 13 Feb 2012 14:27:37 +0000

I have created several SQL snippets that are specific to our architecture for maintenance, special ETL processes and the like. Sorry to say, that the titles of my snippets are not stored or presented in alphabetical order. I have almost 100 of the snippets. Some are over 1000 lines long. Searching for a snippet can be a pain.

Where are the snippets stored? Way not present them alphabetically be title?

Temporary error 20016 (no replies)

Jarek ?mietanka — Mon, 13 Feb 2012 13:13:14 +0000

Hi,

I have cluster with 4 data nodes (mysql-5.5.16 ndb-7.2.2), one schema (about 200 tables).

Some of queries ends up with an error:

ERROR 1297 (HY000): Got temporary error 20016 'Query aborted due to node failure' from NDBCLUSTER

This happens with join queries but not in every combination, for example:
A join B works
A join C doesn't work

In mysql api logs i can find something like this:
120213 13:57:45 [ERROR] Got error 20016 when reading table './/'

Most of configuration parameters was taken from examples provided with MySQL Cluster binaries.

Any ideas how to solve it?

Pass Java object to stored Procedure (-1 replies)

sanjeev M — Mon, 13 Feb 2012 06:25:38 +0000

-- moved topic --

Pass Java object to stored Procedure (1 reply)

sanjeev M — Mon, 13 Feb 2012 20:05:10 +0000

I am using My Sql WorkBench 5.2.36 CE .
I want to pass a java object to My Sql stored procedure as a parameter .
I need help regarding this.Thank you..

Error 1005: Can't create table 'mydb.course_offered' (errno: 150) (no replies)

Chitlada Kullapanich — Mon, 13 Feb 2012 06:00:29 +0000

I'm new to mysql workbench
Can anyone solve this problem?

Executing SQL script in server

ERROR: Error 1005: Can't create table 'mydb.course_offered' (errno: 150)

-- -----------------------------------------------------

-- Table `mydb`.`Course_Offered`

-- -----------------------------------------------------

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

`Year` INT NOT NULL ,

`Trimester` INT NOT NULL ,

`Course_ID` VARCHAR(10) NOT NULL ,

`Section` INT NOT NULL ,

`Instructor_ID` CHAR(10) NOT NULL COMMENT 'FK from instructors table' ,

`Room` VARCHAR(10) NULL ,

`Class_Capacity` INT NULL ,

`Grade_A` INT NULL ,

`Grade_B_P` INT NULL ,

`Grade_B` INT NULL ,

`Grade_C_P` INT NULL ,

`Grade_C` INT NULL ,

`Grade_D_P` INT NULL ,

`Grade_D` INT NULL ,

`Grade_W` INT NULL ,

`Grade_S` INT NULL ,

`Grade_U` INT NULL ,

`User_ID` INT NULL ,

`Last_Updated` DATETIME NULL ,

`Status` CHAR(1) NULL ,

PRIMARY KEY (`Year`, `Trimester`, `Course_ID`, `Section`) ,

INDEX `fk_Course Offered_Instructors1` (`Instructor_ID` ASC) ,

INDEX `fk_Course Offered_Courses3` (`Course_ID` ASC) ,

INDEX `fk_Course Offered_Year Trimester1` (`Year` ASC, `Trimester` ASC) ,

CONSTRAINT `fk_Course Offered_Instructors1`

FOREIGN KEY (`Instructor_ID` )

REFERENCES `mydb`.`Instructors` (`Instructor_ID` )

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `fk_Course Offered_Courses3`

FOREIGN KEY (`Course_ID` )

REFERENCES `mydb`.`Courses` (`Course_ID` )

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `fk_Course Offered_Year Trimester1`

FOREIGN KEY (`Year` , `Trimester` )

REFERENCES `mydb`.`Year Trimester` (`year` , `Trimester` )

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB

SQL script execution finished: statements: 13 succeeded, 1 failed

Setting up a connection with a database (1 reply)

Susanna Karlsson — Mon, 13 Feb 2012 10:44:26 +0000

I want to set up a connection with a database I've created on my computer using a file looking like this:

$hostname = "hostname";
$username = "username";
$password = "password";
$connection = mysql_connect($hostname, $username, $password)
or die("Could not open connection to database");
mysql_select_db("db_name", $connection)
or die("Could not select database");
?>

But I'm not quite sure about how to repalce "hostname". Is a host something I need to create myself and if so how do I do that? I run mysql on ubuntu and use the terminal to work with it.
Or is the host something that already exist and if so how do I find out what it's name is?

Also, how do I create a user? Do I use mysqladmin or do I log in to mysql as root and use create user?

Getting an access violation .. Suggestion?? (no replies)

Rajesh khan — Mon, 13 Feb 2012 11:58:18 +0000

I am using Visual studi 2010 and added "MySQL Connector C++ 1.0.5" header and library files to it. The code i am using is below. The problem is I get the error

"Unhandled exception at 0x5bcdad4a (msvcp100d.dll) in mysqlite.exe: 0xC0000005: Access violation reading location 0xccccccd0"

at the line while (res->next()) the first result gets displayed then the error shows up Why is that

My code is
#include
#include

#include
#include
#include
#include
#include

int main(){

sql::Driver *driver;
sql::Connection *con;
sql::Statement *stmt;
sql::ResultSet *res;
sql::PreparedStatement *pstmt;

try{
driver = get_driver_instance();
con = driver->connect("tcp://127.0.0.1:3306", "root", "admin");
con->setSchema("test");

stmt = con->createStatement();
stmt->execute("insert into example values(4,'four'),(5, 'five')");
delete stmt;

pstmt = con->prepareStatement("select * from example");
res = pstmt->executeQuery();
while (res->next())
std::cout<getInt("id")<<" "<getString("data")< delete res;
delete pstmt;

pstmt = con->prepareStatement("delete from example where id=?");
pstmt->setInt(1,4);
pstmt->executeUpdate();
pstmt->setInt(1,5);
pstmt->executeUpdate();

delete pstmt;

delete con;
}catch(sql::SQLException &e){
std::cout< }
}

insert variables into MYSQL (no replies)

jason chan — Mon, 13 Feb 2012 11:42:52 +0000

int f = 23;
mysql_query(connect,"INSERT INTO t(d) VALUES(%d)",f);

lets say f for the above case is an unknown integer obtained from another function, How do i insert the value f into mysql. The above statement gives me an error of:

error C2660: 'mysql_query' : function does not take 3 arguments