Starting a new project I'd like to use Hibernate annotations with MySQL instead of the configuration files I've used so far. And I can't seem to find the equivalent of: <id name="id" type="long" > <generator class="native"></generator> </id> I tried using: @Id @GeneratedValue(strategy = GenerationType.IDENTITY, generator = "nativ...
I just want to ask which out of the two ways of storing data would give my better results A. Storing data in a single table with over 20+ columns OR B. Distributing the data into two tables of 15 and 6 columns each one more thing, even if I distribute the data I still might have to access both the tables at the same time in 60% of c...
On one server I use mysql version 5.0.45 and when running the following query it returns 1 if boolvalue='True' AND 2.2 else, just as it should. SELECT Q.value FROM ( SELECT (CASE table.boolvalue='True' WHEN 1 THEN 1 ELSE 2.2 END) AS value FROM table ) Q; On another server (webhosting) I use mysql version 5.0.22 and when running the sa...
This is related to the queries I'm running from this question, namely: SELECT CONCAT_WS(', ', city, state) AS location, AVG(latitude), AVG(longitude) FROM places WHERE state='NY' AND city='New York' GROUP BY state, city I've been looking at phpMyAdmin and they have one value red-flagged, Handler_read_rnd_next. ...
Is there a way for a Java program to detect when the operating system is about to go to sleep, or failing that, at least detecting a wake up? The actual problem is that in a particular application a number of MySQL database operations are run in the background. In testing on a Windows machine these database transactions are interrupted ...
Hi All I am looking for world language & nationality/ethnic race list in sql format. Is there any resource which is importable into MySql ? Thanks in advance ...
Hello, I currently have the following query: SELECT group_concat(DISTINCT usrFirst, usrLast) as receiver_name //etc When using PHP, it outputs my list of names as follows: <?php echo $row['receiver_name']; //Outputs: JohnDoe,BillSmith,DaveJones //Desired ouput: John Doe, Bill Smith, and Dave Jones Basically, I nee...
How do I select the first character of a cell and use that to define what is returned? ...
I wrote a small app that relies heavily on a series of php pages in which mysql data is displayed and formatted, given the user's credentials. Rather than rolling a whole user management system from scratch, im debating putting these files into modx pages and utilizing its usermanagement features to secure and restrict those pages and t...
SELECT * FROM `thread` WHERE forumid NOT IN (1,2,3) AND IF( LEFT( title, 1) = '#', 1, 0) ORDER BY title ASC I have this query which will select something if it starts with a #. What I want to do is if # is given as a value it will look for numbers and special characters. Or anything that is not a normal letter. How would I do this? ...
I'm trying to use rsync to backup MySQL data. The tables use the MyISAM storage engine. My expectation was that after the first rsync, subsequent rsyncs would be very fast. It turns out, if the table data was changed at all, the operation slows way down. I did an experiment with a 989 MB MYD file containing real data: Test 1 - recop...
I'm trying to use Django transactions on MySQL with the commit_on_success decorator. According to the documentation, "If the function raises an exception, though, Django will roll back the transaction." However, this doesn't seem to work for me: >>> @transaction.commit_on_success ... def fails(): ... Site.objects.create(name="New ...
Here's what I've got so far- $awards_sql_1 = mysql_query('SELECT * FROM categories WHERE section_id = 1') or die(mysql_error()); $awards_sql_2 = mysql_query('SELECT * FROM categories WHERE section_id = 2') or die(mysql_error()); $awards_sql_3 = mysql_query('SELECT * FROM categories WHERE section_id = 3') or die(mysql_error()); $awards_s...
I'm trying to load some Rake Fixtures (rake db:fixtures:load) into a MySql database and I'm seeing some weird behaviour with AutoIncrement values. Normally this goes up by 1 for each insert which allows me to define/create tests. (BTW - normal create/insert from script works correctly). However when I load from fixtures the id field is ...
I'm tying to execute a query in phpMyAdmin. The query takes approximately two minutes to load, but at the top of the query results it says that the "Query took 0.2768 sec". How is this possible? ...
Hi friends, i want to get the column data type of mysql table. Though MYSQLFIELD structure but it was enumerated field types. then i tried with "mysql_real_query() " for me the error which i am getting is "query was empty" pls help to get the column data type thanks in advance krishna ...
Anyone Please help me in implementing Paging in my project. I have nearly hundred pictures in images folder. When the user clicks the gallery link, the page will be directed to gallery.php, where the pictures should be shown 10 by 10. Please help me i need solution soon. ...
I have been trying to make this search engine for a MySQL database. Taking in user input is no problem, database querying is also fine. One thing I need to figure out is this: I am a string in the database How do I match the input "AM", but keep the same case? There are PHP functions like str_ireplace or preg_replace/eregi_replace...
I just ran a simple MySQL CREATE TABLE statement that produced the line "Query OK, 0 rows affected, 1 warning (0.07 sec)." It didn't actually show me what the warning was, though. How can you see the contents of a warning that just occurred? I'm using MySQL 5.1, if it makes a difference. The only thing I found online was "SHOW...
I'm building a very basic CMS for a specific project that contains numerous functions such as get_menu(), get_title(), get_recent(), etc. However, I want to be able to store templates, which would be echoed during page load, that contain said functions in the MySQL database. Doing a str_replace for each possible function would be a pit...