mysql

Folder permissions based on users and groups

Hey Im working on a folder tree and need to be able to limit the visibility of certain folder based on the user and the group they belong to. I already have a database representation of all the folders in the tree and the hierarchy of the folders. My question now is how to best represent the permissions. If I have to possibly look up p...

grabbing first row in a mysql query only

if i had a query such as select * from tbl_foo where name = 'sarmen' and this table has multiple instances of name = sarmen how can i virtually assign row numbers to each row without having to create a column that auto incriments? i have a reason for what im doing and dont need an auto_incrimented col in my example. so if each row is...

Can I select insert to mysql but modify values manually?

insert into keyword_history ( keyword_id, searchengine, location, "4", curdate() ) select keyword_id, searchengine, location from keyword_history where history_id = 21 Basically, what I'm trying to do is : select a row from a table insert it again but this time with current date and the ...

How to create a simple CMS with PHP?

I want to create a simple CMS with PHP and MySql, I use wamp as a server. Currently I just want it on my localhost. What I want is to have a front page, where are normal posts like on wordpress, just simple posts, currently I don't want comments maybe later if it works cool :). And a very simple admin panel where I can manage the posts...

Django DecimalField lookups with MySQL not working

I'm migrating data from a legacy database that has many tables with primary keys defined like: `id` decimal(26,0) The id column will contain values that look like: 20080313154354198004 20081217165552136057 2008080416222952067 20060510151423191000 20060510151423191000 20070710143455874025 200806239353171091 Doing queries like: Rel...

Convert SQL Server database to MySQL

I have an application database on SQL Server 2008 Express on my dedicated server. It's not enough for my web app. Are there any good free conversion tools that will enable me to convert my current SQL Server database to MySQL on my server. Will my web app be able to work the same? ...

Hibernate, MySQL and table named "Repeat" - strange behaviour.

I am having a strange problem. But first the orm.xml: <entity class="de.test.businessobjects.Repeat"> <table name="repeat"/> <attributes> <id name="id"> <generated-value strategy="TABLE"/> </id> <many-to-one name="repeatType" fetch="LAZY"> <join-column name="id_repeatType"/> ...

is there any site for broadcasting live shows?

hi, please delete the question if this site is not the right place to post this question I am looking for a site where I can log in and create events that I can broadcast. broadcast will be live and users who come to the site can watch it . And when an user logs on to watch my broadcast I can see the list of users and then have chat op...

LOAD DATA INFILE REPLACE doesn't seem to work with multiple fields?

I'm loading a file into a table with php. I create a table like this: CREATE TABLE IF NOT EXISTS $table ( `id` INT AUTO_INCREMENT PRIMARY KEY, `order` INT DEFAULT 0, `data` VARCHAR(200) UNIQUE, `cur_timestamp` TIMESTAMP DEFAULT NOW())"; And fill it from a text file like this: LOAD DATA LOCAL INFILE '".$file ."' REPLACE INTO TABLE $...

mysql query - select distinct value where it has a specific values , group by

I currently have SELECT * FROM bidders WHERE status='0' AND email IS NOT NULL GROUP BY `bid_user` ORDER BY 'bid_price' DESC The problem that I have is that "bid_user" may exist in different rows with different status ( status=1 or status=0). I would like to know if it's possible to select only the * rows where status=0 and whe...

Dynamic Table creation in Hibernate Template

I am importing stock quotes data using HibernateTemplate + SpringFramework Format of the data AAPL,09-Jun-2010 09:00,251.47,251.47,251.39,251.39,640 AAPL,09-Jun-2010 09:01,251.4,251.4,251.05,251.26,6844 INTC,09-Jun-2010 09:00,251.47,251.47,251.39,251.39,640 INTC,09-Jun-2010 09:01,251.4,251.4,251.05,251.26,6844 MSFT,09-Jun-2010 09:00,25...

MySQL or Oracle ?

As I know these two databases are the most popular and the best, but which one is the best? And what are the benefits to use one or other? Currently I use MySQL and I don't really have any experiences with Oracle, but I want to know what's the best choice and why? I mean how fast they are, what kind of features they have, how easy is t...

anyone get mysql workbench 5.2 to work with mamp?

i cannot get mysql workbench 5.2 to work. i have mamp and mamp pro installed and running and no matter what type of connection i try it just wont connect. what can i do? i have a mac with snow leopard ...

naming tables in cakephp

Hi In my app I have 2 tables that have a many to many relationship. Let us say these are table students and table courses. Each course can have many students and each student can also enroll in many courses. Now I want to create a associative table which according to cakephp should be named courses_students. However for various reason...

MySQL query error.

Can someone help me correct the following error I keep getting when trying to run my MySQL query. Here is my error. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE user_id = '3' AND id = '3' AND friendship_status = '0'' at line 2 Here is my m...

multiroom video chat

So I am learning to develop a video chat with multirooms/groups and I know basically what to do for a simple live video chat application. For example: public function setupconnection () { youRtmp ="the URL for your rtmp"; nc=new NetConnection(); nc.connect (rtmpNow); nc.addEventListener (NetStatusEvent.NET_STATUS,Con...

Differences between build and make?

Recently, I downloaded a copy of mysql source code from their source tree. but i am not sure how can i compile the code. i do not quite understand the different processes involved in c++ software building. after i have built the code, how can i install it? or do i need to make? or how do i even know if the 'build' is successful, it print...

MySql sever instance configuration wizard help

I have uninstalled mysql from my system long ago and i have forgot the passowrd i have set to mysql now when i tried to install it its asking for the old password to set the new password in MySql sever instance configuration wizard i am not getting access to mysql command line client. ...

Database design with millions of entry

Suppose there is a messaging system. This system has millions of entry to be sent and get reported and the count is growing by 100K every hour. 2 service accesses db, one is sender, one is reporter. So what would you suggest in order to get maximum performance? How could the db be designed? Also what open source RDBMS would you suggest ...

mysql_connect taking long time to execute

i have following script in php to login to mysql $db_host="localhost"; $db_user="root"; $db_pass="123"; $dbc=mysql_connect($db_host,$db_user,$db_pass) OR DIE (mysql_error()); $dbs=mysql_select_db($db_name) OR DIE (mysql_error()); this script was working fine, now i reinstall the O.S now i have windows 7 and iis7 and PHP...