Hi guys, i have an older test unix server with mysql 4.1 enterprise edition on it. i'm looking for a tool that i can use to automatically generate an erd? preferably free and easy to setup... i try to install workbench but i didn't have the know how and after checking with my server guys he told me that i can't install the latest versio...
Hello, I have a MySQL database with multiple tables, each of which have the same structure. The structure is: id INT(11) NOT NULL auto_increment, site VARCHAR(350) NOT NULL, votes_up BIGINT(9) NOT NULL, votes_down BIGINT(9) NOT NULL, PRIMARY KEY(id), UNIQUE (site) The PHP code below prints out each unique "site" from across all the ...
How can you find whether the SQL query type is DDL or DML? ...
Hi all, I have a PHP array with numbers of ID's in it. These numbers are already ordered. Now i would like to get my result via the IN() method, to get all of the ID's. However, these ID's should be ordered like in the IN method. For example: IN(4,7,3,8,9) Should give a result like: 4 - Article 4 7 - Article 7 3 - Article 3 ...
I have a list of categories on my webpage. They are stored on mysql and each category has an id number next to it. The categories are in divs that when selected change color and whatnot, and when not selected, another color. Only one can be selected at a time. I am trying to figure out how to tell the webpage, which cat has been selec...
Suppose, for illustrative purposes, you are running a library using a simple MySQL "books" table with three columns: (id, title, status) id is the primary key title is the title of the book status could be an enum describing the book's current state (e.g. AVAILABLE, CHECKEDOUT, PROCESSING, MISSING) A simple query to report how many...
I have a few test databases in some Unix SUSE 8 servers and initially the plan was to find some tools which can directly create the ERD straight from the server until someone told me that I can find tools to connect from the Windows PC straight to the Unix MySQL database. So I saw MySQL query analyzer which can do this but unfortunately...
Is there a way to configure a mysql table so that writting and reading is possible but not deleting ? Exampe is : a table that contains many log that are legally important and that must never be deleted ! ...
Hi there! My question is how can I be sure of a row that I'd like to return is exists? I don't want to suppress it with PHP's @ option or count rows before every query to find out the row is exists or not. So there's a simple query like this: "SELECT `title`, `id` FROM `event` WHERE `id` = '234'"; and the table cannot contain the ro...
When you open a MySQL connection with mysql_connect(), it returns a link identifier. But what if you want to get that link identifier again later in the script? (for example: A plug-in, that needs to open a new database connection, and still access the old one.) I'm looking for a way to return a link identifier to the last connection op...
So this was one of my very first questions here, but I have a slight variation: So I have two people whose schedules are in a database. The schedules simply record the start time, end time, and description of the various events/appointments for both users. PersonA wants to trade appointments with PersonB. I want a MySQL query that will...
All my development life I have only worked with MySQL for extended periods of time, and for a client we now need to work with an Oracle database for some performance testing and tuning. Any obvious pitfalls in moving from working with MySQL to Oracle I should watch out for? The things I discovered so far: There is only one database W...
Create table returns error Can't create table './Identity/Roles.frm, however it does create Roles.ibd file. CREATE TABLE IF NOT EXISTS `Roles` (`role` VARCHAR(25) NOT NULL , PRIMARY KEY (`role`) ) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 I can create table using MyISAM but not innodb. I also tryed to copy frm+ibd files from anoth...
I'm using geokit (acts_as_mappable) in a rails application, and the performance of radial or bounds searches degrades considerably when there is a large number of models (I've tried with 1-2million but the problem no doubt kicks in earlier than this). Geokit does all its calculations based on lat and lng columns in the table (latitude ...
I'm doing the following query and getting all rows returned, regardless of date: SELECT DISTINCT p.name, p.category, u.f_name, t.name FROM ( prizes p, tags t, results r ) LEFT JOIN users u ON (r.user_id = u.id) LEFT JOIN f_tag_lookup tl ON (tl.tag_id = t.id) WHERE r.tag_id = t.id ...
I've googled this and could'nt find anything new and useful for Apple's new OS SnowLeopard. I wonder if this is my mistake or I do need to do something? this is what I did: Downloaded from mysql site: http://dev.mysql.com/downloads/mysql/5.1.html#macosx-dmg I choose : Mac OS X 10.5 (x86_64) I run all the packages and installed all of ...
I have already posted a question about this, but the situation has changed sufficiently to warrant a new one. I have a MySQL table called aromaProducts in which there are 7 columns with the FULLTEXT index, and which has three records in it. When I make a query against it like: SELECT * FROM aromaProducts WHERE MATCH (title) AGAINST ('...
Using Java, Hibernate, and MySQL I persist instances of a class like this using the Hibernate support from Spring. @Entity public class MyEntity implements Serializable { private Long id; @Id @GeneratedValue(strategy = GenerationType.AUTO) public Long getId() { return id; } public void setId(Long id) { this.id = i...
It appears the class constants only cover PDO::PARAM_BOOL, PDO::PARAM_INT and PDO::PARAM_STR for binding. Do you just bind decimal / float / double values as strings or is there a better way to treat them? MySQLi allows the 'd' type for double, it's surprising that PDO doesn't have an equivalent when it seems better in so many other way...
I have a query for getting today's records from table. I have inserted the date field by using now(). select u.*,p.* from user_brands as u inner join products as p where u.parent_id = p.cat_id and date_format( p.date, '%Y-%m-%d' ) = curdate( ) By using this query every first time I am getting empty results, once if I refresh the page ...