首页 \ 问答 \ 使用Visio生成MySQL DDL(Using Visio to generate MySQL DDL)

使用Visio生成MySQL DDL(Using Visio to generate MySQL DDL)

 我有一个在MS Visio中创建的数据库模型图，我想导出到DDL文件以创建MySQL数据库。 我已经安装了MySQL ODBC驱动程序，我可以成功地使用它来生成DDL文件，但无论如何我都有一些问题。  
 Visio在表名周围加上引号，也是保留字（如用户）。 这不行，因为MySQL为此目的使用反引号（`）而不是引号（“）。  
 MySQL ODBC驱动程序还将BLOB数据类型更改为LONGVARBINARY，因此在创建数据库时不能直接与MySQL一起使用。  
 有没有人有任何建议如何处理这两个问题？ 

I have a database model diagram created in MS Visio which I would like to export to DDL file to create a MySQL database. I've already installed the MySQL ODBC driver, which I can successfully use to generate DDL file, but I have some problems anyway. 
Visio puts quotation marks around the table names which are also reserved words (like user). This is not OK, since MySQL uses backticks (`) and not quotation marks (") for this purpose. 
MySQL ODBC driver also changes the BLOB data type to LONGVARBINARY, so it cannot be used directly with MySQL when creating the database. 
Does anyone have any suggestion how to deal with these two problems?

原文：https://stackoverflow.com/questions/752434

更新时间：2023-07-01 17:07

最满意答案

 看一下PHP文档中的示例 ，看起来您可以添加CC头（如果您愿意，可以添加BCC ）。 特别是在该页面上的示例＃4中查看标题，您应该能够执行以下操作：  
// ... previous code
$headers = "From: $email" . PHP_EOL;
$headers .= "CC: $email" . PHP_EOL;
$headers .= "Reply-To: $email" . PHP_EOL;
// ... later code

Taking a look at the examples in the PHP docs, it looks like you can just add CC headers (or BCC if you prefer). Specifically looking at the headers in Example #4 on that page, you should be able to just do something like this: 
// ... previous code
$headers = "From: $email" . PHP_EOL;
$headers .= "CC: $email" . PHP_EOL;
$headers .= "Reply-To: $email" . PHP_EOL;
// ... later code

相关问答

将电子邮件收件人添加到php脚本中(add e-mail recipient into php script)[2023-08-17]

使用Joomla的内置邮件程序方法： $msg = "This is my email message."; $subject = "Database Update Email"; $to = (string)$this->db->get('email'); $config = JFactory::getConfig(); $fromemail = $config->get('mailfrom'); $fromname = $config->get('fromname'); $from = array($f ...
是否可以从.msg文件中提取收件人电子邮件地址？(Is it possible to extract recipient email address from a .msg file? [duplicate])[2023-09-14]

感谢Palle Due： https ： //stackoverflow.com/a/47264921/361842 $outlook = New-Object -ComObject Outlook.Application $namespace = $outlook.GetNameSpace("MAPI") Get-ChildItem $msgPath -Filter *.msg | ForEach-Object{ $msg = $outlook.Session.OpenShare ...
如何解析电子邮件以获取电子邮件的原始收件人？(How I can parse email to get original recipient of an email?)[2022-03-03]

获取此信息的最佳方法可能是解析Received标头以查看邮件的发送者。换句话说，查找具有for token后跟x@x.com的Received标头（其中x@x.com将是收件人）。 The best way to get this information is probably to parse the Received headers to see who the message was delivered for. In other words, look for a Received header ...
将$ email条目添加到电子邮件收件人[关闭](add $email entry to email recipient [closed])[2022-12-24]

看一下PHP文档中的示例，看起来您可以添加CC头（如果您愿意，可以添加BCC ）。特别是在该页面上的示例＃4中查看标题，您应该能够执行以下操作： // ... previous code $headers = "From: $email" . PHP_EOL; $headers .= "CC: $email" . PHP_EOL; $headers .= "Reply-To: $email" . PHP_EOL; // ... later code Taking a look at the examp ...
MeetingItem收件人。(MeetingItem Recipient. How to get email)[2022-07-22]

如果Recipient.AddressEntry.Type <> "EX" ，只需使用Recipient.Adddress 。否则使用Recipient.AddressEntry.GetExchangeUser().PrimarySmtpAddress If Recipient.AddressEntry.Type <> "EX", just use Recipient.Adddress. Otherwise use Recipient.AddressEntry.GetExchangeUser().Prim ...
向在文本框中输入的收件人发送电子邮件[关闭](send an email to a recipient entered in a textbox [closed])[2022-04-26]

通过将电子邮件推送到默认邮件客户端Process.Start('mailto:xxx')发送电子邮件不是一个好主意。可能没有定义默认电子邮件客户端，或者可能无法配置默认应用程序。无论哪种方式，用户都会收到来自您的应用程序但来自外部应用程序的消息。更好的想法是为您的应用程序配置明确的电子邮件客户端配置，甚至更好 - 允许用户配置电子邮件客户端。电子邮件客户端我的意思是 SMTP服务器端口（默认值：25）用户名密码有了这些，您的应用程序可以轻松地通过中继SMTP服务器发送电子邮件： http:/ ...
如何从电子邮件中提取收件人(How to extract recipient from email)[2023-12-19]

< 你为什么要这样做？例如审计，数据泄漏等在目标收件人收到的邮件中将不会显示BCC，因此您将无法从中提取该邮件。在发送邮件的源服务器上（或者它传递的第一个集线器/ mta），如果它的Exchange可以接收邮件的Internet邮件标识并搜索Exchange邮件跟踪日志以确定邮件发送给谁，然后将其与Message的收件人进行比较，并在Message上推断BCC（或转发）。传输代理可以从应用程序角度执行此操作，您可以在EnvelopeRecipient https://msdn.microsoft.c ...
PHP MAILER向一个收件人发送多封电子邮件(PHP MAILER sending multiple email to one recipient)[2021-07-05]

你的代码没什么意义，而且你的代码变得不必要了。 @RamRaider的评论是对的。你也在做很多不必要的工作来构建你从未使用过的字符串。这是一个更优雅的实现，应该按预期工作： $q = Yii::app()->db->createcommand("select user_other_email from user_account LIMIT 6")->queryall(); foreach ($q as $to) { $this->mailsend2( $to['user_othe ...
PHPMailer：您必须至少提供一个收件人电子邮件地址(PHPMailer: You must provide at least one recipient email address)[2023-05-12]

您尚未添加收件人地址。你需要这样做： $m->addAddress('email@email.com'); 看看PHPMailer的例子： https://github.com/PHPMailer/PHPMailer#a-simple-example You haven't added a recipient address. You need to do this: $m->addAddress('email@email.com'); Take a look at PHPMailer's examp ...
返回收件人的电子邮件地址(Return email address of recipient)[2021-09-21]

您似乎在MS Outlook和Active Inspector中运行，因此可能： Sub CheckAddresses() Dim oEmail As Outlook.MailItem Dim r As Recipient Dim rList As Recipients Set oEmail = Application.ActiveInspector.CurrentItem Set rList = oEmail.Recipients rList.ResolveAll For Each r In rLis ...

mysql问题

关于netbeans和mysql的问题

广州Java培训MySQL数据库视频教程

关于mysql 的 sql

Solr连接MYSQL导入源数据生成索引

Setting up Nutch 2.1 with MySQL to handle UTF-8

MySQL用户与授权

shell操作mysql初步

Mysql删除binlog(安全清理)

Solr与Mysql集成指南

使用Visio生成MySQL DDL(Using Visio to generate MySQL DDL)

最满意答案

相关问答

将电子邮件收件人添加到php脚本中(add e-mail recipient into php script)[2023-08-17]

是否可以从.msg文件中提取收件人电子邮件地址？(Is it possible to extract recipient email address from a .msg file? [duplicate])[2023-09-14]

如何解析电子邮件以获取电子邮件的原始收件人？(How I can parse email to get original recipient of an email?)[2022-03-03]

将$ email条目添加到电子邮件收件人[关闭](add $email entry to email recipient [closed])[2022-12-24]

MeetingItem收件人。(MeetingItem Recipient. How to get email)[2022-07-22]

向在文本框中输入的收件人发送电子邮件[关闭](send an email to a recipient entered in a textbox [closed])[2022-04-26]

如何从电子邮件中提取收件人(How to extract recipient from email)[2023-12-19]

PHP MAILER向一个收件人发送多封电子邮件(PHP MAILER sending multiple email to one recipient)[2021-07-05]

PHPMailer：您必须至少提供一个收件人电子邮件地址(PHPMailer: You must provide at least one recipient email address)[2023-05-12]

返回收件人的电子邮件地址(Return email address of recipient)[2021-09-21]

相关文章

最新问答