mysql

How do I reload a Roo project without clearing the database?

I've been learning how to build projects using Roo and am making good progress. I have the nucleus of a project which correctly displays my defined entities and allows me to create, edit, and delete the representative objects. I am using mysql at the database and I see that objects entered using the UI correctly appear in the mysql dat...

How do I start a program from VB.Net and pass it arguments?

Is possible? I plan to backup mysql database using vb.net. If you know any beginner tutorial on how to do this, then please let me know. ...

how to create mysql database backups by using a query in phpmyadmin

Is it possible to create a backup using phpmyadmin and not the mysql console.exe? ...

incrementing data type in phpmyadmin

Is there a certain data type on phpmyadmin that works like in ms access that if you don't specify a primary key, ms access will prompt to create a primary key named 'ID' which will then be incrementing(1,2,3..) as you are adding more records to the database. ...

error in backing up mysql database through php

What's wrong with this code?I'm currently calling the code below using a link. Is there anything else needed for this to work? The error is specifically in this line: $backupdir = 'C:\wampbackup\x.sql'; What might be a possible solution to this. I'm a beginner so please bear with my lack of knowledge. $host= 'localhost'...

Select * from table with where and order by clause problem

I need to get the number of items that have a comment but I cant get this SQL statement to work for me........any advice? Select count(Name) as TotalComments from TableName where comment <> '' order by ID Error Message: Column "TableName.ID" is invalid in the ORDER BY clause because it is not contained in either an aggregate f...

How to distinguish rows from each other in a database table?

I have some records that I need to store in a database table and I want to distinguish one record from other records on the basis of name field. But as the datatype of name field is varchar, it will effect the performance because comparing varchar data with each other is time consuming process in comparision to a numeric field. So I wa...

what datatype to use for a field that can contain a value from pre-defined values in a database table?

I have one field named type in a database table. I want this field to contain a value from a list of pre-defined values. If I use set as the datatype of this field, then it can contain more than one values from the list. What datatype to use, so that It can contain only one value from the list of values (pre-defined)? ...

MySQL reverse order without DESC

SELECT id FROM table LIMIT 8, 3 results in 8,9,10 but I need 10,9,8 How can you do this? If you add "ORDER BY id DESC" it gets 3,2,1 ...

Database Table design problem

Scenario: There is a hierarchy of PROCESS. Like PR-2, PR-3 are children of Pr-1, PR-4, PR-5 are children of PR-2 Now the leaf processes (in our case PR-3, PR-4 and PR-5 can be described in terms of series of ACTIVITY Now, ACTIVITY is just a child of PROCESS but has some extra attributes, so Should I make two diff. tables in the d...

Should there be 2 datatables for a Parent and Child class in Java?

I have two classes Parent and Child. class Child extends Parent { private String extraField1; private String extraField2; ... } Child class has 2 extra fields extraField1 and extraField2. Q1. Should I make two diff. tables in the databse: one for Child and other for Parent? or Q1. Should I add two columns in the Parent ...

Django Longint in Mysql

Hi there, my project was not working properly when switching from my local development (sqlite3) to mysql. After some inspection, I found that Django seems to use 32-bit-ints for IntegerField on mysql, but I need 64 bit. Is there any way to achieve this? ...

how to get the value of form input box in codeigniter

value of FORM INPUT Help!! //this is just a refrence of $nm and $fid from test_model// $data['fid']['value'] = 0; $data['nm'] = array('name'=>'fname', 'id'=>'id'); say i have one form_view with <?=form_label('Insert Your Name :')?> <?=form_input($nm)?> and a function to get single row function get($id...

Loading MySQL dump file with bin extension

I know how to restore MySQL DB with *.sql files. But i don't know how to import *.bin files. Content in this file is: 123456789|www.site-name.com 123789456|www.go.com 123987456|www.g1.net 987865432|www.site.org Please help! ...

how to backup my sql from a remote server

Hi All I have My SQL running on my remote webserver. What is the best way to back this up every night to my windows home server? Thanks ...

How to integrate Flash and MySQL

Hi all - tutorials (e.g. ) show how to integrate Flash and MySQL. Also Flash can manipulate and sent this back to server (http://www.kirupa.com/developer/actionscript/create_edit_xml.htm). To integrate flash and MySQL one can do the following: (1) MySQL -> php -> Flash (e.g. (http://)library.creativecow.net/articles/brimelow_lee/php_my...

normalizing accented characters in MySQL queries

I'd like to be able to do queries that normalize accented characters, so that for example: é, è, and ê are all treated as 'e', in queries using '=' and 'like'. I have a row with username field set to 'rené', and I'd like to be able to match on it with both 'rene' and 'rené'. I'm attempting to do this with the 'collate' clause in MyS...

SQL: Syntax error with intersect?

This is my query: -- Sids of suppliers who supply a green part AND a red part (SELECT Suppliers.sid FROM Suppliers JOIN Catalog ON Catalog.sid = Suppliers.sid JOIN Parts ON Parts.pid = Catalog.pid WHERE Parts.color = "red") INTERSECT (SELECT Suppliers.sid FROM Suppliers JOIN Catalog ON Catalog.sid = Suppliers.sid JOIN Parts ON Parts.pid...

Hibernate / MySQL Bulk insert problem

I'm having trouble getting Hibernate to perform a bulk insert on MySQL. I'm using Hibernate 3.3 and MySQL 5.1 At a high level, this is what's happening: @Transactional public Set<Long> doUpdate(Project project, IRepository externalSource) { List<IEntity> entities = externalSource.loadEntites(); buildEntities(entities, project)...

MySQL, two columns both set to the primary key.

For the sake of simplicity lets say I have a table with 3 columns; id, parent_id and name. In this table id is my auto-incrementing primary key. I want to group multiple names together in this table, to do this all names in a group will share the same parent_id. If I am inserting the the first name in the group I want the id=parent_i...