MySQL is an open-source, relational database management system.
0
votes
0answers
4 views
connecting to mssql from localhost when data is on server (cpanel)
I am trying to connect to mysql hosted on server. Panel used is cpanel. But i am not able to connect to the database. Running php code on local system using xamp.
Error is below.
Warning: ...
0
votes
2answers
21 views
how to insert all record from one table to another in mysql
I am beginner please help to copy all records from 'new_bill' table to 'todayssales' table.
mysql> select *from new_bill;
+---------+-----------+------+----------+------+-----------+
| Item_Id | ...
0
votes
0answers
7 views
mysql creating table with master part number that include sub part number
kits are encoded with a master part number that includes sub part numbers (services and/or products) that compose it... what would be my KIT entity/column
0
votes
0answers
13 views
Order by ignoring second criteria
I'm having problems with my query, basically what I'm trying to do here is to order first by
item_info.content_time desc
and then by
item_views.views desc
My intention is to get the most ...
0
votes
0answers
3 views
Saved GORM domain object not showing up in mysql
I have a Message object that has log entries that are added as the message is processed.
Domain class Message has:
SortedSet messageLogEntries
static hasMany = [messageLogEntries: MessageLogEntry]
...
2
votes
2answers
25 views
increase insertion speed in python
I have a script in django which i am running on terminal to update the field values in database ,
there is about 3000 records to be updated , it updated but it takes so much time.
Here is the code:
...
0
votes
0answers
9 views
Save Google Maps Markers onClick To Database
I want your guys' help on this. I wrote the code for allowing users to create markers(with infowindow) with a 'click' function that will save the lat/lan and other info to a MySQL database that will ...
google-maps
1
vote
0answers
16 views
Most performant way to convert a recursive hierarchy in MySQL to Core Data
I want to know if I'm better off using SQLite than Core Data for storing and querying a recursive hierarchy, simply to avoid time it takes to convert the sql rows to a Core Data store.
Here's a way I ...
-2
votes
2answers
50 views
Getting Query from Following
I have the following query that grabs all of the photos from everyone across the service (world feed):
SELECT IdPhoto, title, l.IdUser, username
FROM photos p
JOIN login l
ON (l.IdUser = p.IdUser) ...
0
votes
1answer
9 views
i need to understand phonegap mysql remote security
am running a phonegap app android where user can insert record into database via a form input.
question is during compilation and deployment of the app
1.will my database username,password,tables etc ...
0
votes
0answers
22 views
Which embedded functions slow down an SQL query the most?
I would think that aggregate functions are the costliest? How about NVL's, where do they rank in cost? Is there a list which shows each functions cost rankings?
0
votes
2answers
18 views
MySQL 5.6.10 installation error
I am getting this error while installing MySQL 5.6.10. I have other versions of MySQL (5.1 and 4.1) installed and there seems to be a conflict in the my.cnf.
Removing /etc/my.cnf is not an option.
...
2
votes
2answers
22 views
Combining two count queries from same source
I have two queries that return a list of service items with a count. One is for the entire database, and the other is for a specified period. They work great individually, but I would like to ...
0
votes
0answers
16 views
Table Structure for a User Feed with “Followed” items
I want to create a User Feed similar to Twitter where user can "Follow" specific blogs. But im stucked with the best table structure.
When they followed specific blog/s, all products and blog posts ...
0
votes
0answers
18 views
How do I limit the php code of a checkbox to a specific id in mysql database
I have installed xampp on my computer to use the mysql database with Dreamweaver. I am creating a form using mysql and php.
I have the form submitting checkbox values of 1 to the database when ...
