Go Premium for a chance to win a PS4. Enter to Win

x

MySQL Server

46K

Solutions

22K

Contributors

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

Share tech news, updates, or what's on your mind.

Sign up to Post

why we need junction table for many to many.

i am not clear on that concept. can you please elaborate with example tables with data?
i am going through below link but not completely clear
https://www.youtube.com/watch?v=P_nhBKs25DQ
please advise
0
Nothing ever in the clear!
LVL 1
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Dear Experts

We are having SugarCRM enterprise with good hardware very frequently users are getting httpd 500 server error this happens to all users at the same time, once restart the mysql server then works for some time like 30 mins to one hour approx and again the same issue httpd 500 server error just before this occurs very slow experience and then finally ends up with httpd 500 server error,  some times if users reload it works some times I have to restart the mysql service, I am running mysql 5.6.
my.cnf below posted
/etc/opt/rh/rh-mysql56/my.cnf
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# This group is read by the server
#
[mysqld]
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

#
#
#[mysqld]
max_connections=5000
# include all files from the config directory
#
!includedir /etc/opt/rh/rh-mysql56/my.cnf.d
-----------------------------------------------------------------------------------------------end--------------
just added max_connections=5000 as mentioned above but not sure this will resolve can you please suggest best practice performance steps setting up for mysql server , thanks in advance
0
hi,
What is normalization concept


if a table called Student as below with 4 columns and data as below

Student table

StudentName YearOfStudy Subject TeacherName
john                    10thGrade    Maths    Ashley

why it is better to move away Teacher information to separate table as below

Teacher Table

TeacherName TeachingSubject
Ashley                 Maths


what is various types of normalizations?
Please advise
0
Hi EE,

I need help in generating the Unique Number of 4 character length.

Criteria is as follows :
  1. String will always start with alphabet
  2. Another 3 characters will be a combination of alphabets (A-Z) and digits (0-9)
  3. Once the number generated it could not be repeat

Example
A001, A999, ZD01, DA9P, SXS8 etc...

I need to write a logic for the same in my ASP.NET (VB.NET) based web application.

Please provide a direction.

Regards,
D Patel
0
I'm preparing a user group presentation on database normalization.  I would like to show examples of different challenging 1NF conversions.

Tackling 1NF conversions of unstructured/delimited data is a different animal that I will tackle separately.  What I would like to see from you are different repeated group column names that you've encountered.

Sequential numbering is usually what the students see.  I'd like to show them more challenging examples from your real-world experiences.  Things that come to mind are year and quarter values, week values, month name values, and day name values.  Other challenges might be values that aren't at the end of a column name, capitalization, and no delimiter between the root column name and the serialization values.
0
Hi
i have a hibernate entity class
class task

private tasktemplate

class tasktemplate
private contactinfo

now when i fetch a task.
i do get the tasktemplate object.
but the contactinfo i get as null.

whereas if i fetch the tasktemplate directly then i do get the contactinfo object.
this contactinfo is a custom type which i am storing as json.
what could be the reason for this that when i am fetching it directly i get the proper data and when its inside as a reference a foreign key then i get it as null.
also this is only for custom types
there are other attributes in tasktemplate like normal string etc. they do get fetched.
i am using hibernate here

thanks
0
Thanks for reviewing this.

My server auto updated asp. Net framework and a bunch of other stuff KB4041681.

As. Net 2.0.50727.0 and myself 6.1.3601.17514 throws out errors consistent with client query activity..

Error [HY000] [MySQL] [ODBC 5.1 Driver] [mysqld-5.5.12] Deadlock found when trying to get lock; try restarting transaction

The windows apication error log references the application server and there are no other direct error references, though there are a few windows system errors in the log but it seems best to start with the obvious one.

As a direct or indirect result a legacy app using asp.net but coded over 5 years ago is running up errors in cost report totals other functions seem normal.

The timing of the error is consistence with the windows update.

Any advice or pointers greatly appreciated.. Specifically I'm wondering if it's possible to simply roll back that update, though there had been 3 minor ones since it doesn't necessary guarantee the libraries and other files will be restored to the same state prior to the error, so not sure if other problems might occur unless the specific files updated causing the error can be identified.

Once again thanks for reading..
0
hi,

in mysql table shows table colums as MySql SQL keys what is MUL vs PRI vs UNI

what is difference between each. what is MUL is it same as foreign key? is it same across all databases?
please advise
0
Hello experts, I have a few DBA questions that I need checking out, and I don't have access to a sample Oracle and SQL/Server Database.

Question 1: Assuming table t1 has the following columns:

userid (primary key), name, phone_num_home, phone_num_work, phone_num_cell, phone_num_pager

Redesign t1, create a table t2 to join to table t1, and normalize the database by eliminating the “repeating group” of phone number columns in t1.

Ans.
  • The goal is to  "Create table t2 and copy the contents of table t1 into table t2 and join table t1 using userid (primary key),       ".
  • This achieved with the use of a SQL "Create table t2 (select * from t1);"
  • Then you will need to maintain referential integrigty by using a SQL "Alter table t2 adding a (t2.userid) Foreign Key from table t2 restraint that references (t1.userid) Primary Key field from table t1.
  • You should will make a backup copy of table t1. Then finally you should do a SQL "Alter table t1 drop (  phone_num_home, phone_num_work, phone_num_cell, phone_num_pager)

Please let me know if steps are correct or if I missed something.
     
Question 2: Assuming a character column named [title] in table t1 with the following values:

The Day Of The Jackal
Sleepless In Seattle
Point Blank
Gone With The Wind

What is the result set of the following SQL statement?

SELECT LOWER(SUBSTR(title,1,7)) FROM t1

Ans.
0
I have a website that runs xenforo forum software. I basically have a donations user group and those users have the ability to download some software. I want to add a login form to my application that checks if that user is in that group and if he / she is then it will open the main form. I want to know how I can make such a login form?
0
[Webinar] Cloud Security
LVL 11
[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

hi,

any one use any tools for MySQL or use MySQL built in tools for brute force protection ?
0
I've read a few tutorials online for sending a blank image in an html email in order to log when the email is opened, but none of them seem to work in my system.  I don't need anymore information than the date/time an email was opened to log in my MySQL database.  Any help would be appreciated!
0
I have an existing MSSQL blob field that I would like to "export" to a MySQL database.  I have a script that will display the existing blob field, but I am guessing that I need to "save" the image and then "import" them into the MySQL database.

I tried to use the display script to just insert, but I get a "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 '' at line 2".
If I remove the blob fields from the insert(`STI_Image`&`STI_Large_Image`), it inserts the rest of the information into the table.

Any help would be appreciated.
InsertBlob.php
DisplayImages.php
0
HI All, trying to figure out how to use data from two tables in Domo.

This is what I'm trying and it is not working.

SELECT id, jobsite, status FROM application UNION SELECT client, id, nickname FROM jobsites

Open in new window


It's only showing the first part, however I do not get any errors.

Any help is greatly appreciated.
0
I have a query that pulls meta data currently like:

SELECT order_id, meta_key, meta_value
FROM wp_woocommerce_order_items i
INNER JOIN wp_woocommerce_order_itemmeta im ON i.order_item_id = im.order_item_id
where meta_key like '%Name - %'
or meta_key like '%Job Title - %'
or meta_key like '%Company - %'
or meta_key like '%Email - %'

Open in new window


The output is:
2668 Name - 1 Nathan Riley
2668 Email - 1 nathan@domain.com
2800 Name - 1 John Smith
2800 Email - 1 john@domain2.com
2800 Name - 2 Jane Doe
2800 Email - 2 jane@domain2.com

How can I modify so the output would be:
2668 Nathan Riley nathan@domain.com
2800 John Smith john@domain2.com
2800 Jane Doe jane@domain2.com

Thanks!
0
can't connect to mysql database on godaddy server may be mistake in syntax or understanding environment please help ,and you should know that localhost on pc work good with (appserv 8.6.0) nearby
0
I have the following query on table fila

SELECT * 
FROM fila f
JOIN meta m
ON m.link = f.idlinks
WHERE m.meta2 < m.meta

Open in new window

It works, but I need something more ...
I need the query to get into the FILA table values that are no longer in the activity table, for example:
If the activity table already exists in the URL column and in the ACAO column, that data is disregarded and I get the next item in the row table

Example:
Table Fila
Table fila
Table Atividade

atividade2.pngAs already exists in the activity table at URL 976 and USER 92, that record has to be disregarded and the query move to the next record in the FILA table
0
In a Drupal 7 site, we have a node entity type for stored documents.  This type has two custom fields - year and reference - which uniquely identify the node.  These values look something like shown below, with the format being "<reference><hyphen><year>".
S123-2015
S456-2013
S1145-2015

Open in new window

I'm receiving a list of these document references (perhaps hundreds at a time) and need an efficient way to find the corresponding node IDs.  What's the best way to do this?
0
hi,
i have been trying configure master to master replication between two servers that are connected on LAN. the two servers are running xampp and has the following ip address 192.168.0.2 and 192.168.0.4

basically, i want any change in a database on one server should replicate to the other.  I am actually new to mysql replication and want try it out on my LAN. can you please give me step by step procedure?
0
NEW Veeam Agent for Microsoft Windows
LVL 1
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

We are looking at deploying SuiteCRM Company wide.  We have a development environment which we are testing all the required features and modules that we will required, and at the same time demoing to the management teams what the system will eventually look like.

We have a problem in that at current we have around 6 different websites/microsites that are hosted and designed by 6 different companies (all sadly managed by our marketing department, hence 6 companies!)

At current the contact form comes in to an email address (webenquires@) and then gets routed via our ancient mailserver.

We will be migrating to office 365 the same time as we roll out the new CRM.

I am looking for a solution to automatically create a lead from an inbound email in SuiteCRM.
Yes I am aware of doing it via campaigns and forms, however trying to get all 6 companies to make the correct changes at go live the same time will fail.  

Also we need to demo this system for a few weeks to various management teams, and would like to implement the form changes 1 site and company at a time allowing for problems.

What I need is a temporary solution to do this via:

Either MySQL or inner Join
PHP coding
Or some kind of workflow

The correct inbound email address (webenquiries) is already configured and working in SuiteCRM.

I tried the following inner join from the example above which is based on Sugar CE6.5 failed.  I modified it to work with SuiteCRM and it now generates a Lead, …
0
I am using jxDatePicker to accept date data in my java project but MySql is not recognizing it as Date despite setting the Table Data as DATE and formatting the jxDatePicker value to "yyyy-mm-dd" format in the code.
I will appreciate your help to fix this problem.
0
I'm working on a project that requires capturing the biometrics of my target users, I'm trying to store the captured fingerprint template (.ftp) file in a database and need guidance on implementation.
I will also need to have a verification button that will capture a users fingerprint, compare with database records and return a match.
0
Dim ds As DataSet = dbc.data("CALL sv_Int_months_final1 ();")
0
I tried to Run but DB not connected i am using Xampp mysql server,  any idea for this?

Send Querys like

#!/usr/bin/python
from Tkinter import *
import MySQLdb
#-----------------------------------------------------------
## Connect to DB
conn = MySQLdb.connect(host='localhost', user='root', db='mind0')
##Create a cursor
curs = conn.cursor()
## *****************************************************
# Root level form
class MyApp:
  def __init__(self):
    window = Tk()
    window.title('Data Entry Form')  
    frame = Frame(window)
    frame.pack()
## BEGIN Fields ***********************************************    
    self.fields = {}
#--------------    
    l = Label(frame, text="vendID:")
    l.grid(row=0, column=0)    
    self.fields['vendID'] = Entry(frame)
    self.fields['vendID'].grid(row=0, column=1)    
#--------------      
    l = Label(frame, text="vendName:")
    l.grid(row=2, column=0)  
    self.fields['vendName'] = Entry(frame)
    self.fields['vendName'].grid(row=2, column=1)
## END Fields ************************************************    
 
## BEGIN Buttons ########
    clearbtn = Button(frame, text="Clear", command=self.do_clear)
    clearbtn.grid(row=11, column=0)
       
    submitbtn = Button(frame, text="Submit", command=self.do_insert)
    submitbtn.grid(row=11, column=1)
 
    updatebtn = Button(frame, text="Update", command=self.do_update)
    updatebtn.grid(row=11, column=2)
## END Buttons ##########…
0
Hi,

I am curious what is the most efficient way to join the last entry (row) of a dataset that meets particular criterion

Ordering the whole statement as DESC would not work in this case

thanks
0

MySQL Server

46K

Solutions

22K

Contributors

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.